Formula for automatically entering data into fields makes them disappear! Why is this?

AppSheet AppSheet Q&A
1

I have an inspection form - at the top of the form is a simple “Can the inspection be carried out?” question [InspectionPossible].

If the answer is No I want to set the data in a number of columns to be “N/A”.

If I use the following formula in a column of type Enum:
"IF([InspectionPossible] = “No”, “N/A” , “” )
The column disappears.
Why is this?

2

If you have the expression set in App Formula field, move it to Initial Value.

Otherwise, choosing a non “No” value in [InspectionPossible] always forces the fields with the expression to evaluate to “”, which makes them disappear from the form because you cannot edit them..

1 Like
3

Excellent… thank you TeeSee :+1:

(every day’s a school day!)

1 Like