Form - Require fields in specific text formatting
I hope there's a way to do this, as it's frustrating with the limitations, but is there a way to make a Text or Contact List field on a form, require to be entered into a specific format? For example, I need the user to enter a valid email address, but both the Contact List and Text fields allow any garbage text to be entered and submitted. Same with Postal Code.
There really needs to be a simple 'Text Format' option for the fields like competing form solutions have (e.g. Name, Email, Date, Postal Code, etc.).
Also, if there is an Email field on the form, is there a way to copy that email address into the 'Send copy of form' email box? I can't find an easy way to do that, nor an easy to make that checkbox on by default.
Answers
-
Hi @JPJPJP
Hope you are fine, it's a great idea but Unfortunately, this feature is not currently available. You can submit Smartsheet Product Enhancement Requests using this form.
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"
-
Hi @JPJPJP
I hope you're well and safe!
Unfortunately, it's not possible now, but it's an excellent idea!
Please submit an Enhancement Request when you have a moment.
Here's a possible workaround or workarounds
- Add some checks by using the Form Logic feature
- Add checks in the sheet and set up an automatic Update Request to send if anything is wrong
- 3rd party form integration
Would any of those options work/help?
I hope that helps!
Be safe and have a fantastic week!
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 or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
@JPJPJP @Andrée Starå @Bassam Khalil
Field validation was added to Smartsheet forms in August. You can validate the "text/number" column for Number, Percent, Email, Phone, and the Contacts field for email. More information here: https://help.smartsheet.com/articles/2482427
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 459 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 138 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives