Limiting data
I am creating a form which has a requirement for only the last 4 digits of the social security number. Any suggestions on how to limit the character input to only 4 or how can I pre-fill in 000-00 allowing the form user to only be able to input the last 4 digits?
Answers
-
I would first update the column name to specifically say "Last 4" or something to indicate that you only want the last 4. Even helper text in the form field.
To pre-fill with the zeros, you would use something like this:
=SUBSTITUTE("original form url" + "& insert column name here = 000-00", " ", "%20")
The output of this formula would be the URL that you share with people to fill out the form.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives