Editable unchecked versus Editable_If set to FALSE

AppSheet AppSheet Q&A
1

I’ve a column called last_update to keep track of the date & time of the last edit. I’ve set the column with Init Value NOW() / Editable unchecked / Reset on edit? checked. And… it works inside the app, but the new date/time is not saved to Sheets (in the edits). In fact, the old value appears again on the next sync.

But, if I use an Editable_If expression, and I set the expression to FALSE, it works (!). It befudles me, Editable unchecked, o Editable_If set to FALSE should not be the same thing ???

2

I agree, the behavior is not consistent. Let me figure out why.

1 Like
3

It sounds that you are experiencing the following behavior from the help article Conditionally allow column edits (Editable_If) - AppSheet Help

Suvrutt_Gurjar_0-1736332014814.png
Suvrutt_Gurjar_0-1736332014814.png1067×112 8.81 KB

I believe if editable_if is set to unchecked, it will not allow any edits to the field- user as well as by app formulas and initial values. However, if it is checked and set to FALSE, app formulas and initial values will change as per expression evaluation.

1 Like
4

Excatly :slightly_smiling_face:

1 Like
5

Use App formula rather than Initial value + Reset on edit? + Editable?.

1 Like
6

Yes, it is right. But, the problem is, when unchecked, it allows edit by initial values, so you can see the new value on the form, but when saved, it does not sync the new value to sheets.