In the data/column area I have a DateTime column (with an =NOW() initial value) that is editable. I want this not to be editable, so I move the slider and hit Save.
After the save it is resets back to editable. I have tried this multiple times and it will not save. There is no formula.
Has anyone else seen this?
Solved! Go to Solution.
The Editable? switch is a little bit confusing. If set to the OFF position, it actually means the column is read-only, which means nothing can change it: not the user, not actions, not workflows or reports, not app formulas, and not initial values. To only prevent the user from modifying the columnโs value, set Editable? to the expression, FALSE
. The expression is what controls the userโs access.
Any changes allowed:
No changes allowed:
No user changes allowed:
The Editable? switch is a little bit confusing. If set to the OFF position, it actually means the column is read-only, which means nothing can change it: not the user, not actions, not workflows or reports, not app formulas, and not initial values. To only prevent the user from modifying the columnโs value, set Editable? to the expression, FALSE
. The expression is what controls the userโs access.
Any changes allowed:
No changes allowed:
No user changes allowed:
That fixed it, thank you.
Hopefully the AppSheet development team can make this less confusing.
Also check for warnings in the table when you save like such:
That can tell you if the editor is forcing it to be editable. I also believe keys are always editable if there is not a formula.
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |