I have this values in my Google Sheet.
When the value is "FALSE" or "0.00", they are not shown in the Inline view (see screenshot below).
This is the Show_if expression of the Select Bill Number column.
It's a Yes/No Type column with an initial value of "No".
This is the Show_if expression for column Waivers.
It's also a Yes/No type column with an initial value of "No".
This is the Show_if expression for column Amount Paid.
It's a Price column
How can I make the "FALSE" and 0.00 values to show up?
Solved! Go to Solution.
I found the solution.
I have to modify the Show_if expressions. In the Select Bill Number column, I have to include the CONTEXT("VIEWTYPE")<>"Form" expression.
In the column "Waivers", I reordered the expression.
In the column "Amount Paid", I have to include the CONTEXT("VIEWTYPE")<>"Form" expression.
All the issues were related to the Show_if expressions.
This behavior is weird because it shows some values, but doesn't show others.
I suggest the AppSheet team take a look at this so that the app displays all the values.
I found the solution.
I have to modify the Show_if expressions. In the Select Bill Number column, I have to include the CONTEXT("VIEWTYPE")<>"Form" expression.
In the column "Waivers", I reordered the expression.
In the column "Amount Paid", I have to include the CONTEXT("VIEWTYPE")<>"Form" expression.
All the issues were related to the Show_if expressions.
This behavior is weird because it shows some values, but doesn't show others.
I suggest the AppSheet team take a look at this so that the app displays all the values.
User | Count |
---|---|
37 | |
31 | |
28 | |
22 | |
18 |