You can use the $prev syntax in pipelines to handle it. If you're looking to track each field individually you might try something like:
Trigger: When the record changes on any of those fields
IF condition
if a.client_name != a.$prev.client_name
Log record to change history table logging phone as the field and the a.client_name as value and a.$prev.client_name as old
IF condition
if a.phone != a.$prev.phone
Log record to change history table logging phone as the field and the a.phone as value and a.$prev.phone as old
Qrew LegendJust 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
------------------------------
Qrew LegendI think you will find it problematic to construct your Pipeline branching, so that's why I suggest logging the old and new value for each field you are tracking, knowing that the vast majority of those log records will end up getting purged overnight as there is no change in that particular field.
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"
Qrew LegendSuggest 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.
