Is there a “Im-in-the-middle-of-editing” mode in AppSheet?
I am trying to define if/how users can update specific fields in a table. They should be able to add new records without restriction, and all fields should be available for editing. This part I can do fine with this expression:
But for existing records the user should only be able to edit the field if its blank, with no data. However, during editing, the moment the user puts a value in the field it disables it. Ie, before the SAVE button is clicked
- ISBLANK([_THIS]). And the user cannot correct / change the value at the moment of editing.
Admin users have no restrictions.
The full expression Im using on Editable_If for the fields is:
IN(UserSettings(UserID), SELECT(User[Email], [Admin?])) )