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
-
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.
-
BUMP
-
You can use the Formula:
'AUDIT TRAIL':='AUDIT TRAIL'+"
"+now()+" "+Paid
—-
the first record must be empty or 0
Leo
-
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.
-
'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.
-
'AUDIT TRAIL' := now() + " paid value changed to " + Paid +"
" + 'AUDIT TRAIL'Leo
-
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
-
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' -
format(now(), "MM/DD/YYYY, hh:mm A")
-
Is it possible to timestamp when a record was opened?
-
BUMP
-
No, it is not possible.
-
Only created date "_cd" and modifications date "_md“
Leo
Content aside
- 6 yrs agoLast active
- 13Replies
- 4627Views