Date Dependency in a Form
Hello,
I have a form setup for vacation requests and tracking purposes. In the form the requestor has to input todays date, which automatically defualts to today's date, but we're having issues with the start and end dates. I would like default date to be dependent and automatically to at least update to the start date to reduce submissions with non corresponding dates like the attached.
Comments
-
Hello,
Currently default values are set statically and are not able to be dependent on other fields.
You can let our product team know that you'd like dependent default values in forms by clicking on the Submit Product Enhancement Request link on the right-side pane of Community pages.
Thanks!
Schiff
Smartsheet Support
-
Can any checks or rules be put into a form to validate upon submission and display an error?
If SS can't, you would get much more flexibility by integrating with google forms or one of the other providers.
-
Hello,
Smartsheet forms themselves can validate data using dropdown lists and can require fields.
Beyond that, you could use automated update requests to check submitted data and then send an update request to the submitter if there is invalid data.
You can also store Google Forms data in Smartsheet using Smartsheet Sync. See this article for more information about Google app integrations: https://help.smartsheet.com/articles/1850129-smartsheet-sync-add-on-for-google-formsThanks!
Schiff
Smartsheet Support
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives