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!
