Hello,
I have users with a form that has a date/time field on it. The field in question has the =NOW() formula applied to it, and it works great when the form is first started. But, on subsequent user tasks, I'd like that field to "refresh" and show the date/time the task was opened from the user's inbox. How would I go about doing that?
Thanks!
Question
Question
Forms - Date/Time field - Default to date/time task is opened
asked on April 28, 2022
0
0
Replies
replied on May 3, 2022
A field that is populated via a formula doesn't re-run the formula except when the field is blank or a variable referenced in that formula is changed. Since the =NOW() formula doesn't reference a variable, the only time it is triggered to update is when the form loads and the field is empty.
If you can work with different fields (with different variables) on different forms within your process, then that would work, ensuring that each one doesn't appear on any form until the first time is used within the process.
Alternately, you could use Javascript to populate the field, rather than the formulas.
0
0
You are not allowed to follow up in this post.