Forum Discussion

MICHAELSARGENT's avatar
MICHAELSARGENT
Qrew Cadet
6 years ago

Date field - Mondays only

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
------------------------------
Formulas and functions
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    6 years ago
    Trying 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
    ------------------------------