"FALSE" values not shown in the Inline view

I have this values in my Google Sheet.

AppSheet 1.png

When the value is "FALSE" or "0.00", they are not shown in the Inline view (see screenshot below).

AppSheet 2.png

This is the Show_if expression of the Select Bill Number column.
maretec_0-1702605320946.png


It's a Yes/No Type column with an initial value of "No".
maretec_1-1702605426196.png

This is the Show_if expression for column Waivers.

maretec_2-1702605520426.png

It's also a Yes/No type column with an initial value of "No".

maretec_3-1702605588313.pngmaretec_4-1702605626937.png

 

This is the Show_if expression for column Amount Paid.
maretec_5-1702605635532.png

It's a Price column

maretec_6-1702605765608.png

How can I make the "FALSE" and 0.00 values to show up?

Solved Solved
0 1 131
  • UX
1 ACCEPTED 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.

maretec_0-1702606463960.png

 

In the column "Waivers", I reordered the expression.

maretec_1-1702606599230.png

 

In the column "Amount Paid", I  have to include the CONTEXT("VIEWTYPE")<>"Form" expression.
maretec_3-1702606947894.png

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.

View solution in original post

1 REPLY 1

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.

maretec_0-1702606463960.png

 

In the column "Waivers", I reordered the expression.

maretec_1-1702606599230.png

 

In the column "Amount Paid", I  have to include the CONTEXT("VIEWTYPE")<>"Form" expression.
maretec_3-1702606947894.png

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.

Top Labels in this Space