Omit the column when empty

AppSheet AppSheet Q&A
1

On the basic report I need to omit the columns that are empty

IMG_0378.png
IMG_0378.png2388×1668 315 KB

2

Do you mean hiding rows where the sum is blank?

3

Yes

I believe i need to add ISNOTBLANK(), But evertime I do it it doesn’t work I’m missing something

1 Like
4

When you are using table with your Bot template, the IF: & EndIf expression can hide the value, but I’m afraid it doesn’t remove the row itself from your table.

5

@AleksiAlkio is correct.

So instead of using If/EndIf expressions in your current template you need to take a different approach to this. Depending on how your tables are structured, it may not be possible but here is one way to do it.

Create an EXPENSE TYPE table with, ID, name, and fixed/variable type.

Entries in the EXPENSES table has a column to reference the EXPENSE TYPE table.

Then run your on a schedule without setting any particular table but use <> to select the EXPENSE TYPE like this

TeeSee1_0-1714903213946.png
TeeSee1_0-1714903213946.png1030×743 31.2 KB

Then the following data

TeeSee1_1-1714903264385.png
TeeSee1_1-1714903264385.png566×743 23.8 KB

outputs this

TeeSee1_2-1714903301378.png
TeeSee1_2-1714903301378.png922×795 18.4 KB

Below is what is in EXPENSE TYPE

TeeSee1_3-1714903392991.png
TeeSee1_3-1714903392991.png515×766 21.3 KB

Again this may not work for you because of other constraints, but I hope this gives you ideas that you can play with.

6

I believe that you may have gave me the solution to two problems

  1. Omitting columns when empty .It may work i will try

  2. I needed a way to make a report show the enums that the user adds to the “Basic Expense Report”