How to generate PDF with variable number of columns, depending on a NumList

AppSheet AppSheet Q&A
, , , ,
1

I want to generate a template in Google Doc that allows me to choose from my application which columns I want to display in my pdf report, i already have the filters, but i need to show the diferent columns in my report with the same Doc
Example:

Sheet
Name / lastname / document / age / subject / blood type / qualification

and have a virtual column that allows me to select between the categories of the Sheet and when generating the report I can choose

document Name and blood type report, then you want to generate another report with Last name, age and qualification, then Name and subject and qualification with the number of connections you want

I tested with iF within the template but I get blank spaces, the columns do not self-organize

Does anyone know how I could do it? thanks

2

You tried something like

<<IF(<THISISTRUE>,[Column1],"")>>
<<IF(<THISISTRUE>,[Column2],"")>>
<<IF(<THISISTRUE>,[Column2],"")>>

If the first 2 are FALSE then it should only show one line with no spaces

Simon, 1minManager.com