Hi, I have a question which i want to show it after selection of some other questions. For that i have to put operators in relevant column in xls form.
How can i use multiple operators for same question
say for example
Question is “Name of Beneficiary”
this question should be activated once 3 questions are answered in particular way
say 3 questions are batch=‘yes’, and either activity = ‘visit’ or activity=‘meeting’
This condition satisfies if and only if Q1 is entered something or Q2 is entered something or Q3 is entered something. Else if none of the fields are entered Q4 would not show up.
As an alternative, you could also try out the following:
${Q1}>'0' and ${Q2}>'0' and ${Q3}>'0'
This condition satisfies if and only if Q1 is entered something and Q2 is entered something and Q3 is entered something.
Additionally please feel free to have a look at our support article Advanced Calculate Question Type. It should help you a lot with using advanced calculations within your xlsform.