Just adding two more comments on this. The first is that an alternative is simply logging the old value and the new value any time any of the field to your tracking changes. This will result in many records, which have no change and you were just purchased them out overnight.
Just adding two more comments on this. The first is that an alternative is simply logging the old value and the new value any time any of the field to your tracking changes. This will result in many records, which have no change and you can just purge them out overnight. You would have an embedded report on the table to show the change log, but you would have a filter on that report to not show records where there was no change in the field
The other tip is to include the table name in your logging table, and that way you can use the same table to log changes in many different tables and with the report link field, it would only include logging for say customers on the customers table and parking for orders on the orders table.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Is there a way to write the actual field name to a column in the table so that we can see the field that was changed in the row? For instance, if there are 100 fields in the form and only the phone number was changed the row/record would reflect something like this:
Field Changed | Old Value | New Value
"Phone" | "1234567890" | "0987654321"
Suggest that in your log table you have separate fields for the table name, the field name, the old value and the new value and who made the change.
For the pipeline step that changes the field phone, you would just literally put Phone into the box for the field name.
