I have been struggling to come up with the expression to kick into App formula for physical column (not VC).
I wish to run the expression when the other column in the same row meets a criteria. Otherwise the app formula/expression will be basically ignored. Meaning the app user can enter the value intot this particular column as if expression in app formula section is left blank.
For instance, pushing expression to run calculation on the number type field. I place some sort of if/ifs expression to fire formula when Col 1 value = A, otherwise this formula is not to be fired, then the app users are asked to place the number manually into this field.
IF A = B, then C, else D. sort of expression is supposed to this job, but apppsheet always “else” value need to be matching with value C . I just thought there is a way to place “null” sort of value into elseif part of the expression, like “”, or “ “”, but those are recognized as text or number value by appsheet, i.e. this formula stay NOT editable, rather than app user can enter users.
In short, I m looking for a solution to toggle On/Off appformula on physical column.