Can I create a field that stores the previous value the field had?

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
I have a field where the current progress of a project is entered.  When this value is updated I need to have a report that shows the previous value of that field and the difference between the two.  It would somehow need to store its value somewhere else once the value is changed.
Photo of Jeff

Jeff

  • 10 Points

Posted 2 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 65,096 Points 50k badge 2x thumb
You can make a form rule

When the record is saved

and [my field] has changed

Change the value on the field [log history of my field] to the value in the field [My field]

If you turn on Log changes in that log field, then you will see the history of all the changes.

This will not work in Grid Edit.
Photo of Jeff

Jeff

  • 10 Points
How do I log history on a numeric field?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,096 Points 50k badge 2x thumb
No problem. Just log to a text field.  It will look like a number.