Dropdown with fixed result

gigiograndi 02 Mar, 2015
Hy (and sorry for my english

I need ti biuld a forum with a simple option:

One dropdown with a list of Cities of my Region: when a visitor select one of this cities in the dropdown list, will appear The name, email address and phone number of commercial account working in this Zone. We don't want any other condition. A dropdown that shows a person. We have all data fixed (the cities and the accounts of any cities of our region)

How we coulf do that?
GreyHead 02 Mar, 2015
Hi gigiograndi,

The simplest way to do this is to Submit the form after the city is selected then use a DB Read action to get the related data ans display it.

You could also do it without submitting the form by using JavaScript and Ajax to get the information from the server.

Bob
gigiograndi 09 Mar, 2015
Hy

we don't have the db table with cities, could you help us to build that? Only the basical passages.
GreyHead 10 Mar, 2015
Hi gigiograndi,

Where is the city data now? What does it look like?

Bob
gigiograndi 12 Mar, 2015
Answer
We nave ah excel file or a txt file with online the nemes of towns. Nothing else but a simple list
gigiograndi 12 Mar, 2015
Sorry. I'm not english and the corrector do some errors
GreyHead 13 Mar, 2015
Hi gigiograndi,

If it is a long list then I suggest that you add it to a database table so that you can look up the cities from there. If it's a short list then this FAQ may help

Bob
This topic is locked and no more replies can be posted.