Hello! I have an appsheet that I generally do not want updates to be made to, only new fields can be added BUT I want to allow edits for 1 field only after a user has made a submission. How do I do this without enabling the entire form to be editable?
In general you could try the below
-
The field that you would like always editable - for new submission or editing an existing record, enable the editable_if for that field- so it is always editable.
-
For all other fields of the form, the editable_if constraint could have an expression something like
NOT( IN([Key column of the table], Table_Name[Key Column of the table]))
2 Likes
Thank you so much for replying !! to clarify would that still work if I have the updates turned off in the sheet? This is my current appsheet set up & I want the highlighted field to be editable always
Would you please elaborate?
In general, you may want to enable both adds and updates in Appsheet for that table because you want the user to update one field even after the record is saved.
1 Like