Forms: Auto-populate requester's email address rather than manual entry?

Carey Smith

Hello! The SmartSheet request form set up for my team within my company requires the requester to manually enter their email address into the form rather than using auto-population based on each associate's email used to set up their SmartSheet login account. Is there a way to do this? The person maintaining the request sheet/forms says there is not, but since each user is required to create a SmartSheet login, it seems plausible that there has to be a solution. We're experiencing issues with requesters entering incorrect email addresses. Thanks for your help!

Andrée Starå

Hi @Carey Smith

I hope you're well and safe!

Yes, you'd add the Created By System Column in the sheet, and because they have to be logged in to see/submit the form, it will register the submitter.

Make sense?

Would that work/help?

I hope that helps!

Have a fantastic week & Happy New Year!

Best,

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

✅Did my post(s) help or answer your question or solve your problem? Please support the Community 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!

Carey Smith

yes - thank you. this is very helpful. i will forward this on to the forms/request sheet owner.

Andrée Starå

@Carey Smith

Excellent!

Happy to help!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community 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!

Kayla V.

@Andrée Starå Thank you for the recommendation on adding the Created by System column to the sheet. I only have the option of a Created By column. I added this column, and all columns populate with web-form@smartsheet.com. I've been on multiple calls with Smartsheet Tech Support and am being told this capability to automatically capture a requestor's email address is not a current solution offered. Thoughts on this?

Andrée Starå

@Kayla V.

Happy to help!

You'd have to enable the feature on the form that the user has to be logged in.

Did that work?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community 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!