Forms - Intake sheet
I created a new form for my intake sheet, it is now populating the "Submitter" column with "web-form@smartsheet" and not the submitter email address. What am I missing?
Best Answers
-
This is a simple setting change, that you should be able to do with very little time. Click on the Forms menu, then click "Manage Forms." Find your new form, and click to modify the form. On the top center of the screen, click "Settings." Turn on the little toggle for "Require Smartsheet login to access this form" and save.
Moving forward, anyone who uses the form will need to be signed in to Smartsheet. That will capture the email and load it into your Submitter column.
If you need to make this form available to ANYONE (even people who do not have a Smartsheet account) you may need to modify your form to require people to enter their email address manually.
Here's a great FAQ about Forms:
Good luck!
If this answer resolves your question, please help the Community by marking it as an accepted answer. I'd also be grateful for your response - "Insightful"or "Awesome" reactions are much appreciated. Thanks!
-
Hi @Tanya B
In the form settings, you will need to toggle the setting "Require Smartsheet login to access this form". This way, the field will auto capture the email address of the user submitting the form. If you expect people who do not have a Smartsheet account to fill the form, leave this untoggled and have a separate column in the sheet/field in the form to capture the email address of the submitter.
Thanks,
Aravind GP| Principal Consultant
Atturra Data & Integration
M: +61493337445
E:Aravind.GP@atturra.com
W: www.atturra.com
Answers
-
This is a simple setting change, that you should be able to do with very little time. Click on the Forms menu, then click "Manage Forms." Find your new form, and click to modify the form. On the top center of the screen, click "Settings." Turn on the little toggle for "Require Smartsheet login to access this form" and save.
Moving forward, anyone who uses the form will need to be signed in to Smartsheet. That will capture the email and load it into your Submitter column.
If you need to make this form available to ANYONE (even people who do not have a Smartsheet account) you may need to modify your form to require people to enter their email address manually.
Here's a great FAQ about Forms:
Good luck!
If this answer resolves your question, please help the Community by marking it as an accepted answer. I'd also be grateful for your response - "Insightful"or "Awesome" reactions are much appreciated. Thanks!
-
Hi @Tanya B
In the form settings, you will need to toggle the setting "Require Smartsheet login to access this form". This way, the field will auto capture the email address of the user submitting the form. If you expect people who do not have a Smartsheet account to fill the form, leave this untoggled and have a separate column in the sheet/field in the form to capture the email address of the submitter.
Thanks,
Aravind GP| Principal Consultant
Atturra Data & Integration
M: +61493337445
E:Aravind.GP@atturra.com
W: www.atturra.com
-
It answers my question, however, I did try to add a new column adding submitters email, tried to modify my automation "send to contacts in a cell" but the new field "submitter email" does not come up as an option.
-
okay figured that one out and have asked the sys admin to un-restrict if they want anyone to be able to submit a request and receive notification.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 143 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!