Discussions

 View Only
Expand all | Collapse all

Logging edit history for Numeric Field

  • 1.  Logging edit history for Numeric Field

    Posted 05-14-2019 08:40
    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. 


  • 2.  RE: Logging edit history for Numeric Field

    Posted 05-14-2019 12:44
    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


  • 3.  RE: Logging edit history for Numeric Field

    Posted 05-14-2019 13:28
    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 ?


  • 4.  RE: Logging edit history for Numeric Field

    Posted 05-14-2019 13:41
    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


  • 5.  RE: Logging edit history for Numeric Field

    Posted 05-14-2019 15:49
    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 ?


  • 6.  RE: Logging edit history for Numeric Field

    Posted 05-14-2019 16:56
    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.


  • 7.  RE: Logging edit history for Numeric Field

    Posted 05-14-2019 16:58
    Sounds like you might have a matching issue where you're trying to edit records outside of the one that just changed. Your comment about filters is true - you don't need any additional filters - but you need your matching condition such that you're only editing the same record that was just changed 

     Chayce Duncan | Technical Lead
    (720) 739-1406 | chayceduncan@quandarycg.com
    Quandary Knowledge Base


  • 8.  RE: Logging edit history for Numeric Field

    Posted 05-14-2019 17:23
    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.





  • 9.  RE: Logging edit history for Numeric Field

    Posted 05-15-2019 15:28
    It Worked by using Dynamic Form Rule.

    Thank You...


  • 10.  RE: Logging edit history for Numeric Field

    Posted 07-09-2019 14:17
    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?


  • 11.  RE: Logging edit history for Numeric Field

    Posted 07-09-2019 14:19
    I suggest that adjust the button to also update the logged field.


  • 12.  RE: Logging edit history for Numeric Field

    Posted 07-09-2019 14:46
    Duh, we seem to always over-complicate things don't we. One line of code was the solution. Thanks!