Question - app formula not writing in sheets

[Aurelien]

Hi Community !

Facing an issue:

• I use a expression in Virtual column that gives the expected result.
• I use the same expression in Normal column, that does not do anything, not even pretend to calculate
• More surprising: Test button gives correct result on this very same row.

So, my question is: what am I missing here ?

Settings look normal:

• Show ON
• Editable ON
• Data validity EMPTY
• Auto compute : app formula, that’s all

I found an old post talking about setting Editable to false instead of just tick/untick, if my understanding was correct, but that did do any impact on result.

New Bug Encountered: data doesn't write to sheet and formula doesn't save Questions

Awesome! You can fix this: set the Editable? property to the expression, FALSE, instead of setting it to OFF. Confusing, but it works. Why? Because Editable? is a misnomer. When you choose ON or OFF, you’re actually choosing whether the column is read/write (ON) or read-only (OFF) for the entire app. When you set an expression, the column is made read/write for the app, but the user’s access is controlled by the expression. This then gives you the ability to prevent the user from editing a vis…

Any idea of how the result can’t be wrote down on Sheets ?

Many thanks in advance !

[Steve · Accepted solution]

An App formula expression for a normal (non-virtual) column is only recomputed when the row it’s in is otherwise updated in some way, such as when saved from a form or modified by an action.

[Aurelien]

Oh great, thanks !
I though that it would be recomputed as any other virtual column. I will keep that in mind for future !