-
kbmandirAsked on March 24, 2021 at 6:06 AM
This is a great feature but we would like to check if we can have search based on two columns rather just one like email id + last name. Is this possible?
-
roneetReplied on March 24, 2021 at 10:12 AM
To clarify further, do you want to input the email and last name field in the Spreadsheet to the Form widget and then populate field data on the form?
or do you want to input a unique field on the widget and then populate email + last name on one of the fields on the form?
Looking forward to your response.
Thanks.
-
kbmandirReplied on March 26, 2021 at 12:34 PM
we want to populate the form based on the input email + first/last name in the widget
-
Amin_NReplied on March 26, 2021 at 8:40 PM
Hi again,
Please note that this is possible using Dynamic Dropdown (searchable) + Conditional Logic.
1) Add the Dynamic Dropdown and insert your option.
2) Add a basic dropdown to populate automatically.
3) Create the condition below.
Result: The email domain dropdown got automatically populated once I selected the Yahoo email address in the Dynamic Dropdown.
The widget: https://www.jotform.com/widgets/dynamic-dropdowns
My demo form: https://form.jotform.com/210847921347055
Related guide: How-to-send-email-based-on-users-answer
Should you have any further inquiries, we will be more than happy to help.
-
kbmandirReplied on April 5, 2021 at 12:08 AM
Thanks! We are looking for this feature with Spreadsheet to Form Widget is that a possible option to combine all these features together?
-
Vanessa_TReplied on April 5, 2021 at 12:32 AM
Just to confirm, will the user always put in their email address, first name and last name then you want the form to search within your Spreadsheet to Form widget using all those 3 values?
Or will the user only enter one of those 3 and the search should find results based on one of those 3 values?
If it is the first, then we might be able to give you a workaround.
If it is the latter, unfortunately, no, that is not possible.
Do let us know.