Restrict cell to email only
Is there a way in an automation update request to be able to restrict a cell entry to emails only? For example: If I send a request that prompts the recipient to provide an updated email address for someone responsible for a project, can the sheet keep the recipient from entering anything that is not in the format of an email address in the specific cell?
I'm sure this is there but maybe I am missing any reference to how to do this. I see it has the option for dates only. Not that far of a leap, right? 🤔 Thanks for help in advance!
Answers
-
Hi @Sherry L
There currently isn't a way to set field validation on a Text/Number field in an Update Request to ensure that the value entered is an email address.
However if your field is a Contact List field, you could set the values in the Column Properties then restrict the column to those specific Contacts. This would mean that the Update Request would only accept those specific contacts.
Alternatively you could use validation in Form, which would create new rows: Validate Information in Forms
Please provide your feedback to the Product team through this form, here.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives