Skip to main content
Question

Locking a field that uses time now()

  • November 22, 2023
  • 0 replies
  • 93 views
Forum|alt.badge.img+3

I am creating a check out/in process for assets coming and going from an inventory yard. Personnel will use the check out/in form to track the movement of the assets. Part of the process is logging the time of the check out/in. I was hoping to have the time automatically filled when the check box for check out was marked as true. However I am noticing if I use the formula if([Check Out]=True,now()), it constantly updates the time if i visit the form again and it updates the field everywhere it is used. Is it possible to lock down the time the first time the check out box is marked as true on the specific record I am editing?

Thanks so much!



------------------------------
Bailey Desormeaux
------------------------------
    This topic has been closed for replies.

    Forum|alt.badge.img+9
    • ChayceDuncan
    • Registered
    • November 22, 2023

    You will want to use a form rule instead of a formula. So you want your date/time field to be a of type date/time instead of formula-date/time. 

    On your form then - you would make a form rule that says when [Check Out] is checked, change the value of your date/time field to 'Now'. On the form you can make the field read only, and this will freeze it with the current date/time as your intending. 



    ------------------------------
    Chayce Duncan
    ------------------------------
    Terms & ConditionsAccessibility statement