0

Previous Value Formula?/Audit Trail

Is there a formula out there that will display the previous value to a cell?

OR

I am trying to create my own audit trail in a text box with trigger after update. I want it to automatically create a new line when a formula is changed with a time stamp and the new value. So each time that value is changed, there will be a history of it. The field I am working with currently is named "Paid"

 

Please help

13 replies

null
    • SMoore
    • 5 yrs ago
    • Reported - view

    Under my paid field, I have in trigger after update:

    'AUDIT TRAIL' := now() + " " + Paid

     

    then in my AUDIT TRAIL field, I need to create some formula that inserts the previous value, and the current value after update. 

    • SMoore
    • 5 yrs ago
    • Reported - view

    BUMP

    • Leonid_Semik
    • 5 yrs ago
    • Reported - view

    You can use the Formula:

    'AUDIT TRAIL':='AUDIT TRAIL'+"

    "+now()+" "+Paid

    —-

    the first record must be empty or 0

     

    Leo

    • SMoore
    • 5 yrs ago
    • Reported - view

    Great. It is working, but I am trying to manipulate the formula to where the newest update is on top, instead of bottom. Is this possible.

    • SMoore
    • 5 yrs ago
    • Reported - view

    'AUDIT TRAIL' := now() + " paid value changed to " + Paid +”
    “ + ” 'AUDIT TRAIL'

     

    I was trying this but I am not having any luck. I am also doing this from iPad Ninox app.

    • Leonid_Semik
    • 5 yrs ago
    • Reported - view

    'AUDIT TRAIL' := now() + " paid value changed to " + Paid +"
    " + 'AUDIT TRAIL'

     

    Leo

    • SMoore
    • 5 yrs ago
    • Reported - view

    I was so close. I’m starting to get a fair knowledge base of Ninox code, I’m discovering this is a very powerful database.

    Thank you so much for all of your help! 

     

    Lastly, how do I format the date inserted to MM/DD/YYYY, HH:MM AM/PM for example 06/19/2018, 11:30 PM

    • SMoore
    • 5 yrs ago
    • Reported - view

    Also, is there a formula to set to where it will add a timestamp when a record was opened/viewed? For example:

     

    'AUDIT TRAIL' := now() + " record was opened. " + "
    " + 'AUDIT TRAIL'

    • Leonid_Semik
    • 5 yrs ago
    • Reported - view

    format(now(), "MM/DD/YYYY, hh:mm A")

    • SMoore
    • 5 yrs ago
    • Reported - view

    Is it possible to timestamp when a record was opened?

    • SMoore
    • 5 yrs ago
    • Reported - view

    BUMP

    • Leonid_Semik
    • 5 yrs ago
    • Reported - view

    No, it is not possible.

    • Leonid_Semik
    • 5 yrs ago
    • Reported - view

    Only created date "_cd" and modifications date "_md“

    Leo

Content aside

  • 5 yrs agoLast active
  • 13Replies
  • 4613Views