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

  • 0
  • 1
  • Question
  • Updated 3 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 3 years ago

  • 0
  • 1
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?
No problem. Just log to a text field.  It will look like a number.