Knowledge Base

Our Knowledge Base covers a wide variety of technical topics, from the basic to the complex.

How can I track who changes a record, beyond the single "Last Modified By" built-in field, which only keeps track of the most recent edit?

While QuickBase only displays the name and a time/date stamp of the most recent person who has changed a record, you can use a text field with the append only option turned on to keep track of changes made to the record.

Step 1. Add a Text - Multi-line field. To learn how, please see our Add a New Field help topic.

Step 2. Enter the field properties for your new text field. To learn how, please see our Change the Properties of a Field help topic.

Step 3. Within the field properties, check the box called Log entries. For more on this setting, please see our Use Append Fields help topic.

Step 4. Create a form rule to detect field changes when the record is saved, and write some information to the append-only field you created. For more information on this kind of form rule, please see our Rules that fire when a record is opened or saved help topic.

Congratulations! You now have a field that records the name with a time/date stamp of each person who has edited a record.

Comments

Is this only for entry for the entire record?

http://quickbase.intuit.com/developer/knowledge-base/how-can-i-track-who-changes-record-beyond-single-last-modified-built-field-which-only-keeps-

 

I believe this works for field only and not for the entire record.  I'm interested in tracking edits/changes for the entire record.

Please help!

article updated

Hi Christine - 

Good catch -- we had left out the most important step! See the revised article, above. This article is also on our radar to add an example or two to, so look for those changes in the next few weeks.

Thanks for writing in,

--Sybil

Post new comment

The content of this field is kept private and will not be shown publicly.
Type the characters you see in this picture. (verify using audio)
Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.

© 1997-2014 Intuit Inc. All Rights Reserved.

Online Database VeriSign Secured Web Based Software TRUSTe Certification Online Database SSAE Audit