+- Form Tools (https://forums.formtools.org)
+-- Forum: Form Tools (https://forums.formtools.org/forumdisplay.php?fid=1)
+--- Forum: General Discussion (https://forums.formtools.org/forumdisplay.php?fid=5)
+--- Thread: dropdownbox internal form populated from database table? (/showthread.php?tid=4981)
dropdownbox internal form populated from database table? - Mservices - Jan 6th, 2015
Hi,
Found a similar question, but without a reply.
I want to have a dropdownbox in my internal form with all the cities in my region. There are 139 cities, do i have to write them myself or is there a way to populate this dropdownbox from a database table where I've already stored them with the corresponding provinces?
Thanks for any reply/help
RE: dropdownbox internal form populated from database table? - bill09 - Jan 12th, 2015
You could just create another form and import* the cities into it, then connect it to the original form under Fields, Dropdown Settings, Option List / Contents, then select the city form/field from the options under Form Field Contents.
* Import something like this:
ft_form_4 = your city form table name in FormTools
my_cities = your existing table of city names
INSERT INTO ft_form_4 (city_field) SELECT city FROM my_cities;