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:
NOT(IN([KeyColumn]), TableName[KeyColumn]))
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
Admin users have no restrictions.
The full expression Im using on Editable_If for the fields is:
OR(
NOT(IN([KeyColumn]), TableName[KeyColumn]))
,
ISBLANK([_THIS]) ,
IN(UserSettings(UserID), SELECT(User[Email], [Admin?])) )
You need to read the status from the table, not from the record itself. Let’s say the column name is “Column”. You can read the status like… ISBLANK(LOOKUP([_THISROW].[KeyColumn],TableName,KeyColumn,Column)).
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |