log edits to a formula text field

Question

I want to track the dates that have been entered into a specific field and log the date/time (and user) that the date was changed. How can i log edits to a formula text field without creating another text field in addition to the formula date field?

Example:

Primary field is: [Install Date]. This date changes periodically and we need to track it's lifecycle.

? User #1 changes [Install Date] from blank to May 9, 2016 - this change is made on May 2nd.

? User #1 changes [Install Date] from May 9, 2016 to May 10, 2016 - this change is made on May 8th.

? User #2 changes [Install Date] from May 10, 2016 to May 21, 2016 - this change is made on May 10th.

? User #1 comes back in and changes [Install Date] from May 21, 2016 to May 18, 2016 - this change is made on May 12th.

I'd like a text field that shows:

"

5/2/16 User #1 - New Install Date of 5/9/16.

5/8/16 User #1 - Install Date changed from 5/9/16 to 5/10/16

5/10/16 User #2 - Install Date changed from 5/10/16 to 5/21/16

5/12/16 User #1 - Install Date changed from 5/21/16 to 5/12/16

?

i know i can create a formula date field that "=[Install Date]" then create a form rule that changes the value in [AnotherNewField] to the value in the "=[Install Date]" formula date field and logs edits to the date field... But we need to duplicate this for a significant number of fields and would rather not create two new fields for each date field we have on the form.

archiveuser · Answer

First, formula fields technically don't contain any data so they don't ever "change". They're instead calculated at the moment they're used in a form, report, notification, etc. If instead you have a regular date field for example, this suggestion will allow you to track those changes:&nbsp;http://quickbase.intuit.com/developer/knowledge-base/how-can-i-create-log-track-changes-made-text-fi...

mm · Answer

any suggestions on how to get something to work when importing a large number of records? Each of my records has about a dozen fields that need to be tracked for changes and i import it weekly. I've been spending hours going through each line item and validating - using Excel and vlookup, but its still a pain in the butt.

piercehopkins · Answer

1. It would be great if someone was to provide a solution to this problem.&nbsp;2. Useless link provided. Directs to the generic 'Community' home page.&nbsp;

quickbasecoachd · Answer

Later on this summer there will be an ability to enable audit trails on selected fields. This is a significant undertaking by Quick Base and will be offered as part of the top level subscription "Platform" or with an extra charge to the Premiere" level.

But you can now use an Action to populate child table record of audit changes if there are a few key fields that you want to track. The concept would be to set up a child table to the Main table and have an Action write to that table when certain fields change.

wallace__dhs_ye · Answer

Hello,I have created a multi-line text field that I would like to capture all edits and history of changes made on the form. I selected the log edits feature in the field properties, however it is still not working. I'm sure this is a quick fix but I'm not sure what I'm doing wrong. Please find details below:
------------------------------Wallace (DHS) Yeboah------------------------------

Forum Discussion

log edits to a formula text field

Related Content

Using Grid Edit to Edit Multiple Records at Once

Formula URL - Edit then Add

Merging 2 Fields into a Formula-Text Field for Reporting Purposes

Color Code Date Field based on Formula

Formula Url Buttons