Skip to main content
Question

Logging edit history for Numeric Field

  • May 14, 2019
  • 0 replies
  • 204 views
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. 
    This topic has been closed for replies.

    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
    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.



    Terms & ConditionsAccessibility statement