Create a field that can log changes made to the record

Question

In 2017 QuickBase&nbsp;Empower, someone showed me how they are recording all the changes made to the record in a text field. It logs username, time, changed made etc.How can we build this field?&nbsp;

mcfneil · Answer

I'd make a bet that they are utilizing an 'action' to watch for when things are changed. Then writing the user, data/time to normal fields on the records.

Or you could create child records based on that change as well.

_anomdiebolt_ · Answer

Changes originate in the browser so there is no good reason to create an action. This demo introduced the idea of detecting changes to various fields through script on the new/edit form and appending a short message to the text logging filed. You can make your own changes to records and see them logged after you save the form.

Come Mr Tally Man Tally Me Banana
https://haversineconsulting.quickbase.com/db/bi5q4vzj9

Pastie Databse
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=305

Forum Discussion

Create a field that can log changes made to the record

2 Replies

Related Content

Connected table not updating when record is changed in the connected database

Get latest child record on parent record

Efficiently use pipelines for record change logs

Change a record in one table when another table's record updates

Create Record, pause, then display record

Recent Discussions

Forms help

Create Child Record, Save and then Edit button

Bug with Advanced Query in Pipelines Designer?

When the Expiration Date is On or Before Today, Change the Contract Status to Expired

Share your feedback on the new Qrew Discussions