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

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 ?

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

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 ?

Do you have another automation that is causing that many records to be changed at once? Generally when logging a field I don't expect that many records to be changing suddenly.

Logging edit history for Numeric Field

ChayceDuncan2
Qrew Cadet
6 years ago
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
  Qrew Cadet
  6 years ago
  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
  Qrew Cadet
  6 years ago
  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
  Qrew Cadet
  6 years ago
  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 ?
QuickBaseCoachD
Qrew Captain
6 years ago
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.
- MuraliGangineni
  Qrew Cadet
  6 years ago
  It Worked by using Dynamic Form Rule.
  
  Thank You...
- MitchKoyle
  Qrew Trainee
  6 years ago
  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
  Qrew Captain
  6 years ago
  I suggest that adjust the button to also update the logged field.

Forum Discussion

Logging edit history for Numeric Field