S123 Report Template | Conditionally render text if photo attachment not present

KyleWeaver — Mon, 09 Sep 2024 15:16:59 GMT

Hi all!

Been racking my brain and trying different approaches but still don't have the solution I'm looking for and wondering if anybody found a workaround. Basically within a S123 Word report template, I would like to conditionally render some text ("No Photos Included) in a table row when a photo attachment isn't included with that survey record.

Since attachments are stored differently (nested table), I wasn't having any luck with the usual IF conditional statements in the report. Basically, was trying to use the count function and if equal to "0", then render the text.

In testing, I used this attribute to get the count of photos and this returns the correct result of "0".

${site_photo_1 | getValue:"count"}

But then when I expand on this to include the conditional statement, it's not working correctly. Here is what I was using:

${ if site_photo_4 | getValue:"count" == 0}, No Photos Included ${/}

I've also tried other variations like:

${ if site_photo_4 == ""}, No Photos Included ${/} and others but still can't get the text to render the text correctly.

Anybody encountered this before or have a solution that works for them? Thanks so much!

Re: S123 Report Template | Conditionally render text if photo attachment not present

abureaux — Mon, 09 Sep 2024 18:34:52 GMT

if${!(site_photo_4)}No Photos Included.${/}

Re: S123 Report Template | Conditionally render text if photo attachment not present

KyleWeaver — Mon, 09 Sep 2024 18:59:24 GMT

Thanks so much for the response! I just had to modify the syntax slightly to get it to work (just had to switch the variable $ sign and incorporate the "if" statement within the brackets but it worked!! Final syntax:

${if !(site_photo_4)}No Photo Included For Item Scope Number.${/}

I really appreciate it!

Kyle

topic S123 Report Template | Conditionally render text if photo attachment not present in ArcGIS Survey123 Questions

S123 Report Template | Conditionally render text if photo attachment not present

Re: S123 Report Template | Conditionally render text if photo attachment not present

Re: S123 Report Template | Conditionally render text if photo attachment not present