log edits to a formula text field

  • 1
  • 1
  • Question
  • Updated 11 months ago
  • Answered

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.

Photo of M

M

  • 80 Points 75 badge 2x thumb

Posted 3 years ago

  • 1
  • 1
Photo of Eric

Eric

  • 40 Points
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: http://quickbase.intuit.com/developer/knowledge-base/how-can-i-create-log-track-changes-made-text-fi...
Photo of Pierce

Pierce

  • 10 Points
1. It would be great if someone was to provide a solution to this problem. 
2. Useless link provided. Directs to the generic 'Community' home page. 
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,720 Points 50k badge 2x thumb
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.

 
Photo of M

M

  • 80 Points 75 badge 2x thumb
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.