Trouble with multiple If statements in Survey123 Connect

Question

Hi there, I'm new to coding for survey 123 and I was wondering if someone could help me out.

I'm basically trying to create a check on a goshawk survey form to prevent conflicting data being entered. I want this check to be based on the response choice from two separate "select one" labels. Here is the example:

If the "yes" choice is selected for the "UTMs Accurate?" label, and the "unknown" choice is selected for the "Is nest Active?" label I want to be able generate a sub label with the question "Did you find the nest?" with a "yes" or "no" choice.

Is it possible for a response prompt like this to be activated only when two choices from two separate labels are selected? Or am I better off just generating that response when only one of the choices is selected?

Thanks for the help!

Hussam_AlJabri · Answer

I'm happy that works with you. Keep it up with the amazing application that let our organizations work smartly!

CoyeBurnett · Answer

Thank you Hussam! That actually took care of it. I thought I had to include "selected" within the formula before the field names, which is what was causing me grief. But this formula works perfectly!

Hussam_AlJabri · Answer

Could you please share a snapshot of your xlsform so I will get you clearly!

I understood that if you select "Yes" in (UTMs_Accurate) the second question should not select "Unknown".

if my understanding is correct.. You need to write this formula in the constraint column:

if(${utm_acc}='Y_accurate',${tree_tag}!='Unk_tag','k_tag')