Getting Started

 View Only
  • 1.  dynamic form rule question

    Posted 03-16-2021 18:23
    Is it possible to have a dynamic form rule that would go like "change" -- "schedule date" -- to -- "(value) yesterday" ???   the option it gives me is "current date" or "value."

    Thank you!!

    ------------------------------
    Michael Brumfield
    ------------------------------


  • 2.  RE: dynamic form rule question

    Posted 03-16-2021 18:45
    np,

    Just make a formula date field called [Yesterday] with a formula of 
    Today() - Days(1)

    Then have the form rule change the field to the value in the field [Yesterday]

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: dynamic form rule question

    Posted 03-16-2021 19:32
    YES YES YES!!!!!!! You are BRILLIANT!  Thank you so much, Mark!!!!!!

    ------------------------------
    Michael Brumfield
    ------------------------------