Wouldn't the contact field already be a validation itself, before this feature? It forced accurate email address entry before. This new feature can be used in alot of ways in the future. What are SmartSheet's plans to bring this to other areas of the system?
-Smartsheet 2023 Core Product Certification
-Smartsheet 2023 System Administrator Certification
I noticed that the number validation did allow for a single "e" entry. Not sure if this happens for anyone else, but thought I'd mention.
I'm so happy to have this new feature and can't wait for more to come rolling down the line! 😍
This is a very nice and needed update, thumbs up. I am also unable to add validation to a Contact List field type, is there any ETA on the fix?
@Aaron Manley I also found it strange that you can type a single "e" into the number field, but my developers reminded me that it is for exponential numbers for our scientist friends using forms ;) As the Help Article explains that is a valid entry in the number field.
A much needed feature! I'm very excited to see it! 😊
Any plans for future "validation phases" to prevent users from submitting a form if a field does not meet certain criteria?
Example: Form submitters who change a Boolean field to 1 need to be redirected to another form, so a description box is shown with logic, but they can still click the "Submit" button and generate a 99% blank row in the sheet. We've been using a required file upload field to prevent almost all of these, but it makes more sense to have control through validation.
This is huge for me. I have many operators submitting quality data and had no way to enforce data entry. This was breaking several of my formulas and charts. I would like to be able to limit to a specific range, or even include x decimals in a response as well for notes going forward.
@Caroline Sheldon Great news on the update! I really like that for the number, phone, and % validation that on mobile devices the numpad shows up instead of the keyboard. Much better for field entries!
I tested out the email validation on the contact list, and it appears that the validation only shows up when there's at least one contact pre-defined as a value in the list, AND if the contact list is unrestricted:
However, when filling out the form (even with the email validation), I typed "catdog" and was able to submit even when the value did not meet the email format:
Might just be me, but it seems bugged? I'd definitely like to apply email validation on an unrestricted, and empty contact column so I can use the values in automations.
Yeah, I can confirm this behavior that @Chris Mondeau mentioned here regarding the Contact List column. Email validation does not show up as an option until I add at least one value in the Contact List column. If I remove that value, the validation option goes away.
Otherwise, I love the new feature and I've already implemented on several forms. Thanks!
This is great!
@StevenBlackburnMBA This is true, the contact list field already validated for accurate email addresses in certain scenarios for multi-select contact fields that had values to choose from, but was also unrestricted so the person filling out the form could enter their own email as well. This functionality has not changed with the addition of this new validation. However, now that we have a validation option for the contact list field, you can now choose to validate for an email address in contact lists that don't have values, or the single contact list that allows someone to enter their own instead of picking from the dropdown (unrestricted). Scenarios where users may not want to validate for email in these fields could include wanting to let people type in "N/A" or "Engineering Team" instead of an actual email for the contact. But most of the time I would say that validating for an email in the contact list field is best practice because now it will work really well with automated actions.
As for incorporating this validation into other areas of Smartsheet, which areas in particular are you interested in seeing this validation functionality?
@Matt Stofka , @Chris Mondeau , @cthrasher97141 , @Karen Botha , @S Wood
Thank you all for your excitement for this new feature and for trying it out right away!!
So astute of you to see that the validation for contact list fields didn't quite fulling make it out to our users. We resolved that and you can now see the validation option for the following:
For 'Contact list - multi select - values - not restricted' we already do email validation as a requirement because the sheet does not allow a combination of text and emails to be entered into the sheet. As a form builder you do not have the option to change the validation functionality there as it is defined by the sheet.
We are so excited for this new validation and are already adding it to our own form. Please share any other feedback with us.
Yay! Was looking for this - can't wait for more enhancements (like number formatting graphs on dashboards to express M or K)
Thanks for this great update, but please add the all countries international code and number format because i found some countries only and we are dealing with deferent list of countries than you added in phone number validation.
☑️ 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"
@Bassam Khalil We currently support 46 common phone number formats. Can you please share the formats you are looking for that we don't currently have as an option? Thank you.
The following is mobile number
United Arab Emirates : +971 55 1234567
Saudi Arabia : +966 530 97 3300
Hi Community, Good news! We’re continuing to boost the all around awesomeness of all things workspaces, ensuring you have the ability to continually create and evolve powerful solutions. Among the enhancements that we are releasing is the ability for users to rename any item, folder or workspace directly from the solution…
Hi Community, We’re excited to announce the addition of bulk actions to Data Shuttle to help users and System Admins better manage their workflows! You are now able to “Select All” on a page by page basis (meaning up to 100 workflows at a time) or a subset of workflows to perform the following actions within Data Shuttle:…
Hi Community, I’m delighted to share that System Administrators can now transfer calendars (in Calendar App) from one user to another without needing to open a support ticket! This is especially useful when a calendar’s admin (previously called “owner”) either leaves the organization, is out of office, or changes their…
©2023. All Rights Reserved Smartsheet Inc.