VoiceGuide IVR Software Main Page
Jump to content

Db/excel Choosing Between Duplicates

Recommended Posts

I have a DB/ Excel Spreadsheet where I have duplicate entries based on search parameters...

 

Say I have a list of school closings--

 

User queries the DB based on a zip code (Get Numbers) say the input is 94303

 

Under the search I have several schools- a Junior High and a High school an elem ( I could have as many schools, or only one depending on the Zip)

 

How can I make voice guide ( after the search) read back the school names, and confirm which school the parent wants to listen to info on? "Press 1 for (Say school name) Press 2 for (Says School name) and so on for as many schools in that Zipcode?

From there the VG would read the info for that row.

 

 

i.e. my table might be something like ( In CSV)

 

 

Zip, School name, Info

 

94303, Gunn High, Closed

94303, Paly High, Open

94303, JLS Middle School, Open

94303 Palo Verde Elem, Closed

 

So after the caller enters 94303, VG reads back the selections matching that search, the caller decides which school they want,(Paly High) and then VG reads back the info. (Paly HS) is (Open)

 

I'm sure this is real basic, but I'm the kind of guy that can understand how to split atoms, but can't figure out my way out of a paper bag.

 

Thanks!

Share this post


Link to post

You really should put this info in a database (eg: MS Access), and then reading back all entries matching a certain ZIP code is much easier...

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×