Is it possible to filter out submissions from a form based on if the email field?
Hello,
I am learning smartsheets and am unable to find a way to do this.
We have a form for one of our sheets so people can submit requests to my team. However, we want the requests to only come from our organization. The form obviously has an option to only allow submissions if they have a smartsheets login but that doesn't mean that the requestor is from our organization.
Is there a way to create a workflow that looks a new field on the form called "Submitter Email Address" (for example) and if the address doesn't end in @companyname.com, then it either doesn't post the request to our sheet or posts it somewhere else and sends them an email that says something like "Only internal people can submit using this form".
Is this kind of workflow possible? I'm not sure if this is possible or not. I've been poking around and haven't been able to find a way to complete this. Any help would be appreciated!
Answers
-
Hi @Kholt,
Try to activate the following setting in your form settings
and add in your sheet the following column type "Created By"
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 464 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 61 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!