Forum Discussion

Mike's avatar
Mike
Qrew Member
4 years ago

dynamic form rule question

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
------------------------------
Forms
Formulas and functions

2 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    4 years ago
    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
    ------------------------------
    • Mike's avatar
      Mike
      Qrew Member
      4 years ago
      YES YES YES!!!!!!! You are BRILLIANT!  Thank you so much, Mark!!!!!!

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