Using a mask - data entry
StephanieR
✭✭
How do you force data to be entered in specific format on a form? One of our forms requires date of birth, even though the HELP text says "Please use the following format when entering date of birth: Sample 01/01/1950" we get all kinds of weird entries. Can I force it the field accept only that input? Yes, this is a "Date" format on the sheet. But because most of the entries are for those 60 and older, they are not going to use the back arrow to get to 1950.
All suggestions would be welcome!
Stephanie
Answers
-
Perhaps a date picker/calendar type of selection might possibly assist with future entries.
-
We are using the "Date format" for the column. What is a data picker, I'm not familiar with this term?
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.2K Get Help
- 360 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 444 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives