How can I log changes to a field in a separate "field"

  • 38
  • 1
  • Question
  • Updated 7 months ago
  • In Progress
I have a status field as a dropdown. I need to display the latest project status only in reporting. However, I also need to know when the previous status was changed "from what to what" and by whom, but not display in reports. The log feature adds the changes into the same field, but I require this status log info as a separate data set, as it should not be shared with my report recipients. I want to avoid creating an extra field for this, if I can use the log info for the purpose.....
Photo of Nicola

Nicola

  • 30 Points
  • challenged

Posted 7 months ago

  • 38
  • 1
Photo of Kingsly SD Samuel

Kingsly SD Samuel

  • 928 Points 500 badge 2x thumb
You can create a duplicate field of the existing status field and make that a log field and put the condition in the form to update it based on the update done to your existing status field. And, make that field appear only to you as admin, so that other cannot see it
Photo of Nicola

Nicola

  • 30 Points
You make it sound easy. But I have only used conditions before in a formula, and not multiple-choice fields :-(
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 69,774 Points 50k badge 2x thumb
A better way is to have an Action write out an audit trail record into a child table table of audit changes and record the old value, the new value and who made the change.  ie record the [Last Modified by]
Photo of Evan Martinez

Evan Martinez, Community Manager

  • 11,948 Points 10k badge 2x thumb
Hi Nicola,

I would agree with Mark that it is usually very handy when tracking things like a status change in a record to make a child table for that tracking. That way your new table can have a field to track What the status changed to, when was it changed, and by who and then that history can live in a table nice and accessible to those who need it but out of the users who don't need its way. Then once that table exists with the right field you can use Quick Base Automations and set them up to say every time a record is added or modified and the status field changes add a new record to the Status Tracking table and copy over the change and the time of the change. There is a Quick Base University less that actually goes over this kind of use case that might be helpful to walk you through some of the options and see if it might be the right fit for your need:

Track Data Changes with Automations