In quickbase, I have a field for user and datetime. There are several project status like pending, submitted, review,approved and denied.
Everytime in the status field change I want to record who did the change and date time. I want to use the two buttons. submitted by and submitted datetime field to track the audit history or logs. I did try with a pipeline but there is no data being recorded. Anyone done this before?
Qrew LegendThe usual way to do this is to build a table which will be a child table to the table trying to track.
The pipeline triggers when certain fields are modified on the main table, and you create a new record with a pipeline, remembering to connect to the main table by populating related parent. There is syntax in a pipeline to record both the current value of the field, and the previous value of the field.
Would I like to do is to keep the Audit Table very simple and I have a field for the name of the field that was being changed and the old value and the new value. Of course there will be many entries where the old value and the new value is the same depending on how many fields you are trying to track. I filter those off the child Table reports and set up a pipeline to delete those records each night.
Before building another table is it not possible to listen when the status changes and records the current user and date of submission.
