Discussions

Expand all | Collapse all

log edits to a formula text field

  • 1.  log edits to a formula text field

     
    Posted 05-09-2016 22:00

    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.



  • 2.  RE: log edits to a formula text field

    Posted 05-19-2016 18:58
    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...


  • 3.  RE: log edits to a formula text field

    Posted 06-22-2018 17:05
    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. 


  • 4.  RE: log edits to a formula text field

    Posted 06-22-2018 19:33
    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.

     


  • 5.  RE: log edits to a formula text field

     
    Posted 09-01-2016 12:51
    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.