Skip to main content
Question

Getting Time Stamp if value is changed

  • May 22, 2023
  • 0 replies
  • 115 views
Forum|alt.badge.img+2

Hello, I am new on QB. I need to create a few fields related to timestamp. 

I have column called weight which is being filled in table. I need to create a column next to it which would record the date and time when the weight for that particular record was changed. I tried following in report formula, but it gives current time not just the time it was updated. 
If ([Weight] > 0, Now())
Please help. I have multiple columns where I need to do this. Thank you. 



------------------------------
Imran Bijapure
------------------------------
    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+24

    If all editing is done on forms, then you can have a Form Rule which says

    When the Record is Saved
    and [Weight] has been changed

    Action
    Change [Date Weight Changed] to the Current Date.

    However,  Dynamic Form Rules only work on forms when a single record is being edited by a User.  If there is the possibility that these records will be edited In Grid Edit or by some other automated means then you would have to have a Pipeline which would trigger when the record is modified or added (ie on New Event) and when the weight has been changed. But if you had 10 different fields to track you would need 10 different pipelines each with a different trigger.  




    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement