Aug 19th, 2015, 5:47 AM
Newer to form tools, question:
I have a mysql table with customer names (not an option list under formtools).
I'd like to find the point at which a dropdown (<select>) table is being populated on a new blank form within formtools and figure out which hook to use to properly populate a listbox (before the form is displayed for the end-user to interact with). Once the list box item is selected, I'd like to use the submission pre-parser to take the customer name that was selected from the customer table and populate a field in FT's table (perhaps one that's defined but not visible to the end-user).
Is this logical or is there a better way to accomplish this task? I'd really rather not have to maintain two tables if possible.
Thoughts?
Thanks in advance.
I have a mysql table with customer names (not an option list under formtools).
I'd like to find the point at which a dropdown (<select>) table is being populated on a new blank form within formtools and figure out which hook to use to properly populate a listbox (before the form is displayed for the end-user to interact with). Once the list box item is selected, I'd like to use the submission pre-parser to take the customer name that was selected from the customer table and populate a field in FT's table (perhaps one that's defined but not visible to the end-user).
Is this logical or is there a better way to accomplish this task? I'd really rather not have to maintain two tables if possible.
Thoughts?
Thanks in advance.