Forum Discussion
MarkShnier__You
Qrew Legend
4 years agoIf you know that all data entry is only going to be in a form then you can have a text field called [Prime Date Change History] set to
Log the edits to this field, and show them on forms
and have a form rule that says when the record is saved and the [Prime date] Fields has changed then change the value of the [Prime Date Change History] to the value of the [Prime Date] field.
That will only work if your users only added on forms. If there's any possibility of Grid Edit then you would need to set up an automation or pipeline to write out a record to a child table every time this field has changed.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Log the edits to this field, and show them on forms
and have a form rule that says when the record is saved and the [Prime date] Fields has changed then change the value of the [Prime Date Change History] to the value of the [Prime Date] field.
That will only work if your users only added on forms. If there's any possibility of Grid Edit then you would need to set up an automation or pipeline to write out a record to a child table every time this field has changed.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------