Column change not saving

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 Solved
0 3 398
1 ACCEPTED SOLUTION

Steve
Platinum 4
Platinum 4

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:
2X_5_50dd22680ca2cc20f80eeb507512d8f08967a775.png

No changes allowed:
2X_c_ce4132a9d14001489fc6c08faee05ad0f860914f.png

No user changes allowed:
2X_5_54725258e61fe34c796dac15d3dbb59049f2be70.png

View solution in original post

3 REPLIES 3

Steve
Platinum 4
Platinum 4

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:
2X_5_50dd22680ca2cc20f80eeb507512d8f08967a775.png

No changes allowed:
2X_c_ce4132a9d14001489fc6c08faee05ad0f860914f.png

No user changes allowed:
2X_5_54725258e61fe34c796dac15d3dbb59049f2be70.png

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:2X_d_d3271363994dab9c148a04ba0ba8a1e75da45fb6.png
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.

Top Labels in this Space