creating a revision report

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • In Progress

I have two fields that I want to track revisions, can someone help me with creating a report to only display records that these two fields have changes

Photo of Shontay


  • 490 Points 250 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,758 Points 20k badge 2x thumb
if the users are using the form normally, you can set up a few dynamic form rules to create a time-stamp when those field in question are changed.

If you want more reporting to see not only when it changed, but who, is you can do a few things.

If it is a text field, you can turn on 'edit logging'

If it is a date field then you can set up a date change table.  The user will click a button, add a new date, and possibly enter their 'reason'.

Then you can summarize the most recent data change back to the parent, along with when it was changed.

Most people like this approach when they have dates that change often because of outside factors.