Locking a field that uses time now()
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 t...
Forum Discussion
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
------------------------------
Thank you so very much for this! I did not know of this possibility. It worked beautifully and simply.
------------------------------
Bailey Desormeaux
------------------------------