Forum Discussion

brian_s's avatar
brian_s
Qrew Trainee
2 months ago

Copying data from a table to a seperate table on save/update

If I have a form that I am having a user fill out, what is the best way to copy that data (or specific fields) from that form to a new table? The form is for an approval and could be an "update" or ...
Pipelines
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
2 months ago

There are techniques which work well when you have a limited number of fields to track to record an Audit Trail of every field changed. So to record the old value and the new value and who made the change and if course the date time stamp. 

That can be shown in the form so the history is all conveniently all visible without needing to flip back and forth between records in different tables.