Using a form, is there a way to have a message come up if a person picks a date that is taken?
I'm trying to figure out if there is a formula that can be used with forms that would alert someone if they pick a date that is taken already. have a sheet with a list of class dates, and I'm using a form to collect information from instructors that will tell me when they would like to hold a class, but if they select a date that is taken, I would like to alert them that the date has other classes scheduled on that same date.
Best Answers
-
There is not a way within the form itself. You could imbed the form on a dashboard alongside a sheet that contains the available dates. Then if someone picks an unavailable date you could have an Update Request automation automatically sent to them prompting them to pick a date that is available.
-
That is an excellent idea! Thank yoyu.
Answers
-
There is not a way within the form itself. You could imbed the form on a dashboard alongside a sheet that contains the available dates. Then if someone picks an unavailable date you could have an Update Request automation automatically sent to them prompting them to pick a date that is available.
-
That is an excellent idea! Thank yoyu.
-
Happy to help. 👍️
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives