-
KelseyReadAsked on October 15, 2018 at 4:42 PM
I have a form with a drop down that has a list of 'entities' to chose from (100+ options).
Based on the value selected from the dropdown i would like to pre-populate another field (Email address). We have the list of entities and their corresponding email addresses as an excel.
That way an applicant could make the selection from the dropdown and email address would be populated for use in communications. Minimizing typos if we had applicants type in an email.
All the articles i found seem to point towards using hidden fields and the Jotform conditions, but that's just not feasible for a list of this size.
Is there anyway to do this in bulk?
-
AdrianReplied on October 15, 2018 at 6:47 PM
Did you try to use the Spreadsheet to Form Widget?
The Spreadsheet to Form Widget allows you to upload a spreadsheet to your form and use the values you have on the spreadsheet to pre-populate the form. By using a unique code present on each row of your spreadsheet, you can access that specific row when it matches the unique code entered on the form. Think of it as querying a database using the Unique Code as the key index.
Complete Guide: How-to-Use-the-Spreadsheet-to-Form-Widget
However, the users will have to manually enter the item from the list (it is a text input field rather than a dropdown).
To make it easier for the users, you can add the Auto Complete Widget and add the entities in the widget.
DEMO: https://form.jotform.com/82876985430976
For the value to be copied from the Auto Complete Widget to the Spreadsheet to Form Widget, the Auto Complete Widget must be on a separate page and a condition to copy the field must be added.
Condition:
Let us know if you need further assistance.
-
KelseyReadReplied on October 16, 2018 at 2:21 PM
Thanks! i had seen that widget, but the having to type in the initial field wasn't going to work given the complexity of my list.
But i hadnt thought of using another field (could be the autofill or just a drop down) and then a condition to copy that value into the spreadsheet-form widget might actually be a good solution.
Its a little clunky cause of the multi page requirement but i think might be able to do about what we want!