Dynamically update form data
Looking for help...
I'd like to update the fields on a form dynamically.
Example: Use the system-generated Creation Date to calculate a "Delivery Date" 2 weeks in the future and display it on the form. I know I can do this on the Smartsheet but I don't know how to display it while the user is entering information.
Comments
-
This currently isn't possible with Smartsheet Forms. But you could probably set up something that emails them the Date based on when a new row is entered? And include that date in the email? Perhaps a notification based on a new row being entered would work?
https://www.smartsheet.com/blog/new-in-smartsheet-advanced-notifications
-
Thanks, Mike. It's a bit awkward but might work. I'll play with that and see what happens.
-
Yes, but with notifications, you can adjust all of the text from the email and they would never know what triggered it!
-
Is there a solution for this?
I'm also creating a form that needs to calculate expenses incurred by user for specific travel categories. However, I want that total amount shown on the form and should dynamically calculate based on user input. This would help the user filling out the form to ensure the amount entered per line is accurate prior to submission.
Any way we can achieve this functionality? I can see it happening with a calc field on the sheets-level but that's only after a record is saved. The form functionality request is during the time the form is filled out. Thoughts?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 464 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!