Log Historical Values of a Long Text Field

[mykrobinson]

I need some help thinking through the process for logging historical content. I previous had a method in place in the app i'm working on to push data to a separate table for tracking these entries, but the users requested that instead the field in question simply be a long text column type that they could easily see and edit at will.

I can see the need to still track this historically so we have a bit of an audit trail, so I am trying to think of a way to allow them to use the app as they wish, but still track when changes are made to that field and by whom.

I know that in the automation section, I can create an even that detects changes to a record. The column i want to focus on is called [Signout Notes] but I am not quite sure how to fine tune this event:

i think what i want to do is detect changes to the the [Signout Notes] column in the Patients table, and have any changes to that field trigger another action that logs the state before the change happens.This makes sense in my head, anyway, so that [Signout Notes] will always show the current state, and my other table will keep record of the historical values and who made the changes.

My previous workflow was a button that triggered the following:

LINKTOFORM("sign out notes_Form", "_patientIdentifier", [_THISROW],"Patient Name",[_THISROW].[Full Name])

But i think i can create another action to just set the values of columns in a new row on a table, i just need to understand how to only look for changes in the desired column, and also capture the "before" state of the column, if i am wording this right.