Is there a way to make the form after saving non-modifiable?
For the criteria, you just have to find something that makes sense from your data.
[Date] = TODAY()
(Careful with this one, what happens when they need to edit something later?)
[Status] = "Complete"
isnotblank([Signature])
Another thing you might do is literally create a field in your table to hold this lock information for the record.
Then you could give people control over locking things (either in the form or with actions), and base your formulas off that.
[Record_Lock] = false
Does this row exist in the table? Is this an existing row?
IN([_ROWNUMBER], table-name[_ROWNUMBER])
More like:
IN([RowID], table-name[RowID])
Best
Matt
I have a column and want after filling in the form it is not editable
maybe put something like this ISBLANK([_THIS])
in the Editable If?
However, this option cannot be undone when the column type is Yes No
Is there a way to make the type optional but when saving it cannot be undone
What I do in this case is use an Action to change the lock-value, set to run on the form save event.
So while inside the form, they can do whatever - but as soon as they save, the lock is changed and they canโt modify anything again.
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |