Track date modified for a date field

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

I have a table that has a field [Promise Date], used to inform our customer when a line item is shipping.  I want to create a way to track every time that field is modified.


Thanks for any help!

Photo of Cody

Cody

  • 0 Points

Posted 3 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 65,280 Points 50k badge 2x thumb
If all the editing is done on a form, then I suggest using a text field called [Promise Date history] set to "Log Changes". 

Then have a form rules that says

When the record is saved

and the [Promise date] has changed

Change the [Promise Date Log] to the value in the field [Promise Date]
Photo of Cody

Cody

  • 0 Points
What if some editing is done in Grid Edit?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,280 Points 50k badge 2x thumb
Well for rules are call form rules because they work on forms only.  If Grid edit is a requirement, then this method will not work.  Can you live with disabling their ability to grid edit that field?