If 100% of your data entry is on Forms, as opposed to say Grid Edit, then I suggest that you set up a new set of fields matching the ones you want to Log Changes to.
Set the field priorities to log changes.
Make a Form rule that says,
When the record is saved
And the Approval status is changed to Approved
Change Main Contact Log field to the value in the field Main Contact.
Change Second Contact Log field to the value in the field Second Contact.
etc
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
