How to prepopulate form fields with email address

Kazza

I have a form where in two different places it asks the user to populate the field with someone elses' email address. Rather than the user having to type the full email address for every submission, i would like the field to prepopulate from a list. I understand that creating a contact list in the relevant fields in the Sheet, will not be presented in the form. Is this correct? So is my only option to change the form field to a drop down list and enter all the email addresses in that list? if so, how do i get this list to sort alphabetically, and secondly, how do i provide the user with the option to enter an email address that is not in the list, ensuring, that the email that they entered manually, ends up in the correct field in the sheet. Also, how can i automatically update and sort the list (alphabetically) each time a user adds a new email address.

Thanks

Karen

Andrée Starå

https://community.smartsheet.com/discussion/138424/how-to-prepopulate-form-fields-with-email-address

Hi,

I hope you're well and safe!

Have you explored using the URL-Query feature, maybe sharing a list of the URLs or including them in an alert?

Another option could be to use the Update Request feature instead.

Would that work/help?

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Awesome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

Kazza

Hi, thanks for your response, but i am unsure how either of those features can assist me. Can you please expand on your thinking?

thanks

Karen

MarceHolzhauzen

Hi @Kazza

Have you tried adding the contacts to the dropdown options of the actual contact column? This will populate the options in your form automatically. If you do not restrict to list values only, the person will be able to add an email manually.

In terms of automatically adding contacts to the list, you'll need an additional application like Bridge, DataShuttle or a custom built API solution.