Discussions

 View Only
  • 1.  Date field - Mondays only

    Posted 03-04-2020 15:49
    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
    ------------------------------


  • 2.  RE: Date field - Mondays only

    Posted 03-04-2020 19:49
    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
    ------------------------------