when a field gets modified I want a date field to fill in todays date

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

So I have four fields called

  1. Institutional Pricing
  2. Institutional Check Out Limit
  3. Institutional Rev Share
  4. Title

When any of these are MODIFIED I want a date field called Date Changed to update to today's date.

Possible?

Photo of Cecelia

Cecelia

  • 160 Points 100 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,806 Points 50k badge 2x thumb
It can be done with Form Rules, as a caveat is that they are called Form Rules because they work on Forms and not Grid edit.



When the record is saved

and any of these are true

  1. Institutional Pricing has been changed
  2. Institutional Check Out Limit
  3. Institutional Rev Share
  4. Title
Change the value in the field [Date Changed] to"the current date".



I'm pretty sure "the current date" will be offered as a choice.
Photo of Cecelia

Cecelia

  • 160 Points 100 badge 2x thumb
Awesome!  That is perfect