Survey123 Report Syntax Select Multiple Help

aprhyde11 — Tue, 04 Mar 2025 14:01:26 GMT

I'm working on a report template for my survey123 data. I need it show the corresponding answer only if "no" is selected on another question.

These are the questions

These are the possible answers

If accessible=yes, I need my template to return N/A

If accessible=no, I need my template to return the answer to inlet_outlet

This is what I have been using variations of

${if accessible==”Yes”}N/A${/}

${if accessible==”No”}

${if inlet_outlet | selected:"NA" && inlet_outlet | selected:"Inlet"} && ${inlet_outlet | selected:"Outlet"}Inlet and Outlet ${/}

${if inlet_outlet | selected:"NA"} && ${inlet_outlet | selected:"Inlet"}Inlet ${/}

${if inlet_outlet | selected:"NA"} && ${inlet_outlet | selected:"Outlet"} Outlet ${/}

${if inlet_outlet | selected:"Inlet"} Inlet ${/}

${if inlet_outlet | selected:"Outlet"} Outlet ${/}

${if inlet_outlet | selected:”NA”} N/A${/}

${/}

This is the output I get on my sample reports for when accessible=no and inlet_outlet=Inlet and Outlet

I need the output to only say "Inlet and Outlet". I would also like the check box gone.

Thanks in advance!

Re: Survey123 Report Syntax Select Multiple Help

AnninaRupe1 — Tue, 04 Mar 2025 20:17:54 GMT

If I'm understanding correctly, I would try something like this in the calculation field:

if(selected(${accessible},'No'),"N/A","Inlet and Outlet")

If the accessible question is marked "No," return "N/A," else return "Inlet and Outlet."