Forum Discussion

MuraliGangineni's avatar
MuraliGangineni
Qrew Cadet
6 years ago

Logging edit history for Numeric Field

I want to log the edit history for a Numeric field. I tried creating FORMULA-TEXT field. But using that i can log only last edit details. But i want to log all the edit history for that Numeric Field. 

Currently QuickBase supports logging edits only for Text Fields. Is there any way i can do that for a Numeric Field. Also, i dont want the user to see that edit history on the form. I want the edit history to be visible to Admin only. 
  • There isn't necessarily a field setting that can log number changes - but you can use Automations as a pseudo-log - and whenever your number changes, there is a built in way with automations to track the 'old' value and you can write that old value into a different field. Just pop that new field as an admin only field and you're all set.

    Chayce Duncan | Technical Lead
    (720) 739-1406 | chayceduncan@quandarycg.com
    Quandary Knowledge Base
    • MuraliGangineni's avatar
      MuraliGangineni
      Qrew Cadet
      Yes, Using Automation i can log the last updated value but not the previous values before the last updated value. 

      Is there a way to log all the edit history for that field ?
    • ChayceDuncan2's avatar
      ChayceDuncan2
      Qrew Cadet
      With an automation there are two values you can grab - the current value - meaning what the value is right now, and the 'old' value, which is the prior value. 

      So if your number changed from 100 to 200 - an automation knows how to pull them both and you can log either. 

      As for tracking the entire history - you would still need a text field with logging turned on. Basically you would use an automation to push the value you want to preserve into a text-log field so you have the running history. Its basically the same method as a using a standard text field with logging - you just need the automation to populate it


      Chayce Duncan | Technical Lead
      (720) 739-1406 | chayceduncan@quandarycg.com
      Quandary Knowledge Base
    • MuraliGangineni's avatar
      MuraliGangineni
      Qrew Cadet
      While creating Automation > Actions > Filter Records :
      I don't want any filter condition to be applied. If at all i applied any filter condition, the number of records automation has to be applied is becoming more than 1000. 

      My Automation has failed with the following error:
      ActionExecutionException: Number of records returned exceeded max of 1000.

      Is there any other way ?
  • Murali,
    If all data entry is done on a form, you can have a text field with logging enables and have a form rule

    When he record is saved
    and
    [My field] has changed

    Change [My logging] field
    to the value in the field [field to be logged]

    You may need to have a new field called [My field to be logged in text format]
    with a formula of ToText([My field to be logged]])
     and use that to be written to the logged field.



    • MitchKoyle's avatar
      MitchKoyle
      Qrew Trainee
      Mark,

      I used your suggested above to use a form rule to populate a log edits field. This works great in most cases, but I have a scenario where there is a button on a form that updates the status with one click. When using this button, the form rule + log edits field does not update. Presumably this is because when using a button to update the status the editing isn't truly done on the form. I tried using an automation to update the log edits field, but the owner of the automation is entered as the user in the log edits field, so no dice. Any thoughts on getting around this issue?
    • QuickBaseCoachD's avatar
      QuickBaseCoachD
      Qrew Captain
      I suggest that adjust the button to also update the logged field.