Any way to only have section in PDF display if they have a value in app?

[chrisdparent]

So I am creating a large report, but there are lots of fields that may or may not be filled out depending on the circumstance. I would like to have my PDF set up so it only displays the headings and results for those fields if data is entered. I know the information inside of <<>> will display as blank if no entry, but how can I get the whole section blanked out? Is there a way?

[AleksiAlkio · Accepted solution]

Yes you can use IF: & EndIf expression pair for this purpose on your template.

[chrisdparent]

Thanks for the response. Any way you could put the syntax up based on the example I sent as to how I might implement it? I am not sure how I would build the expression.

[AleksiAlkio]

Please check from this article.. https://support.google.com/appsheet/answer/11568425?hl=en

[chrisdparent]

I will see if I can figure it out. Need to figure out how to make the evaluation based on a particular item being blank

[AleksiAlkio]

You could use something like.. OR(ISNOTBLANK([ColA]),ISNOTBLANK([ColB]),ISNOTBLANK([ColC]))

[chrisdparent]

Does this syntax look correct? I confirmed I labeled the field exactly as it is in the table but it is not outputting anything to a PDF since making the change:

<<If: (ISNOTBLANK[Job_at_time_of_incident])>>

Specific job at time of incident:
<<[Job_at_time_of_incident]>>
<<EndIf>>

[AleksiAlkio]

Small typo in here.. <<If: (ISNOTBLANK[Job_at_time_of_incident])>>
It should be <<If: ISNOTBLANK([Job_at_time_of_incident])>>

[chrisdparent]

Perfect! That worked. Thanks so much! You all are awesome!

[AleksiAlkio]

You're welcome!

[Denny774]

Hey,

there is a really nice description with examples on here:
https://support.google.com/appsheet/answer/11568425?hl=en