I am using an IF expression in an AppSheet Word/PDF template to conditionally display child-table data using START / END. Unfortunately, it does not work as expected.
Is there a supported solution or workaround for this scenario? Thank you
How so?
1 Like
NOTE: Your IF’s have =0 and >1 so will not show anything if =1. Maybe should be >0???
I have no clue if putting so many conditions into a single cell works. I’ve never tried it.
Regardless, it is difficult to maintain so I would recommend splitting this into two tables - one to display “No Data” and the other that displays actual data. The IF/ENDIF statements should wrap each table. For example:
<<if: COUNT() = 0>>
| Column 1 | Column 2 | Column 3 | Column 4 |
|---|---|---|---|
| No Data |
<<ENDIF>>
<<if: COUNT() >0>>
| Column 1 | Column 2 |
|---|---|
<<SELECT: …>> <<[column 1]>> <<[column 2]>> <<END>>
<<ENDIF>>
I hope this helps!
2 Likes
Good catch!
I’d think it would work fine.
1 Like
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.