Skip to main content
Question

creating a revision report

  • September 12, 2016
  • 0 replies
  • 20 views
Forum|alt.badge.img+7

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

This topic has been closed for replies.

  • MCFNeil
  • Registered
  • March 9, 2017
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.
Terms & ConditionsAccessibility statement