Hi guys,
I have a form with some fields and a field โDateTime_Closedโ with app formula โnow()โ so users canโt edit that field, I save the form, all good.
But If I open the form to make any edit to the same record, the field โDateTime_Closedโ takes the current date-time, changing every time I edit the form.
Not sure if that is the way the app formula should work but meanwhile I โfixedโ putting this in the App Formula:
โIF( ISBLANK([DateTime_Closed]), NOW(), [DateTime_Closed] )โ
Solved! Go to Solution.
Yes, that is the expected behavior of the App Formula and your expression is one way to resolve it.
But, if you are setting the [DateTime_Closed] column when you create the record, instead you could set the column to โnot editableโ and set the โInitial Valueโ property to NOW().
Initial Value is set in the form ONLY when the row is new. Normally a user could then change the column but when setting it to โnot editableโ a user would never be able to change it.
Yes, that is the expected behavior of the App Formula and your expression is one way to resolve it.
But, if you are setting the [DateTime_Closed] column when you create the record, instead you could set the column to โnot editableโ and set the โInitial Valueโ property to NOW().
Initial Value is set in the form ONLY when the row is new. Normally a user could then change the column but when setting it to โnot editableโ a user would never be able to change it.
Thanks @WillowMobileSystems!
User | Count |
---|---|
43 | |
30 | |
24 | |
23 | |
13 |