Let's assume we have an intake form which allows the user to select different types of communication methods (Face to Face, Online, Text, etc.). After selecting the communication method the user selects which date the want to communicate. How would I make it so that the user could only select dates that fall on Mondays for one of the selections? I've never been asked for that type of functionality before, so i'm taking it to some of the experts.
------------------------------
Michael Sargent
------------------------------
Question
Date field - Mondays only
This topic has been closed for replies.
+24Trying to type on an iPhone ......
there is a function with syntax DayOfWeek([my Date field])
it will rerun a number from 0 (Sunday) to 6 (Saturday)
you can put that on the form in a hidden section by form rule and then have a form rule to abort the save if type is XYZ and that day of week field is not equal 1
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
there is a function with syntax DayOfWeek([my Date field])
it will rerun a number from 0 (Sunday) to 6 (Saturday)
you can put that on the form in a hidden section by form rule and then have a form rule to abort the save if type is XYZ and that day of week field is not equal 1
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.