conditional merge

AppSheet AppSheet Q&A
, ,
1

I generate a PDF report in my app that displays results of testing of some real world devices. Sometimes there are 2 extra fields that are filled in depending on the type of device tested. My report has those fields with empty contents. How can I leave those out of the report if they are empty?

eg. I’d like this whole line not to print.

Bypass Check1: 0<<[Bypass Check1]>>kPa Bypass Check2: 0<<[Bypass Check2]>>kPa

Cheers

2

Please try

<<IF(AND( ISBLANK([Bypass Check1]), ISBLANK([Bypass Check2])) ,“”,

CONCATENATE("Bypass Check1: " , “0”, [Bypass Check1],"kPa “,” Bypass Check2: ", “0”,[Bypass Check2],"kPa ") )>>

Alternatively you can try

<<IFS(NOT(AND( ISBLANK([Bypass Check1]), ISBLANK([Bypass Check2]))),

CONCATENATE("Bypass Check1: " , “0”, [Bypass Check1],"kPa “,” Bypass Check2: ", “0”,[Bypass Check2],"kPa ") )>>