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?

Knowledge Base

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

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. Create a field of type 'Text - Multi-line'. The following link explains how to create a field.

https://www.quickbase.com/help/adding_a_field.html

Step 2. Enter the field properties for your new text field. The link below explains how to access a field's properties.

https://www.quickbase.com/help/changing_field_properties.html

Step 3. Within the field properties, check the box called Log entries. The following link explains the display settings for this kind of field.

https://www.quickbase.com/help/default.html#append_fields.html

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.

https://www.quickbase.com/help/default.html#form_rules_based_on_record_s...

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

Tags:

42142 reads

Comments

Is this only for entry for the entire record?

Submitted by Christine Woo (not verified) on Wed, 08/10/2011 - 20:23.

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

Submitted by sshearin on Wed, 08/24/2011 - 15:52.

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

Your name: *

E-mail: *

The content of this field is kept private and will not be shown publicly.

Homepage:

Subject:

Comment: *

Input format

Filtered HTML

Web page addresses and e-mail addresses turn into links automatically.
Allowed HTML tags: <a> <p> <hr> <br> <br /> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <em> <b> <u> <i> <strong> <font> <del> <ins> <sub> <sup> <quote> <blockquote> <pre> <address> <code> <cite> <embed> <object> <param> <strike> <caption> <img> <h1> <h2> <h3> <h4>
You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <c>, <cpp>, <drupal5>, <drupal6>, <java>, <javascript>, <php>, <python>, <ruby>, <xml>. The supported tag styles are: <foo>, [foo].
Images can be added to this post.

Plain Text

Web page addresses and e-mail addresses turn into links automatically.
Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>

More information about formatting options

Word verification: * 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.

Knowledge Base