Eligibility criteria

Hello community, I have a questionnaire which first have screening questions for eligibilty and ineligibilty criteria. for example, if they answer 3 questions yes, and 1 question no, they are not eligible, otherwise eligible. How can I design that in XLS so that it does that automatically instead of the respondents selecting eligible or not eligible manually?(attaches is the image of the questions

Hi @paul_maleya
The last question, instead select_one, use a calculate and call it inelegible.
In the calculation column put a formula with the conditions that are true like if(${age1} < 18 and ${age1} > 55 and ${male} = 'No' and etcetc, 1, 0). (check form operators)

Then use a constraint.
It is easier if you send the xls file instead of a screenshot, that way we can see what you’re doing and correct the file or add formulas easier for you.

1 Like

Sorry, this will never evaluate to true. Please, review. Also, it might be preferable to define an “eligible” calculation (relevant filter).

1 Like

You’re right, I was just pointing in the direction of the answer. I’ll leave the error, if @paul_maleya needs additional help after checking the documentation and post the xls I’ll gladly review.

1 Like

@nmambre and @wroos thanks so much for your help.

Attached is the xls form
Trans Gender - Copy.xlsx (27.3 KB)

Check if this works @paul_maleya
Are you using web browser to fill in the forms? I opened with Kobo Collect and the datescreen question was not allowing me to proceed, but using a browser I could fill in.

Just a suggestion: this variables are integer type but your hint says letters and numbers, that may be confusing

integer	scrnid	Screening ID	3Letters followed by 3 numbers e.g KIS001/NRB123/MSA 056
integer	prtrcid	Participant ID	3Letters followed by 3 numbers e.g KIS001/NRB123/MSA 056

Trans Gender - Copy.xlsx (27.0 KB)

1 Like

Hello @nmambre , thank you for taking time and work on the xls. Actually I have worked on your suggestion to change integer from text(for screening and participant IDs). I had not realised. Unfortunately the calculate you have worked on is still not working. I have tried it out using web browser. I am not sure where the problem could be.

Here I have answered everything to be eligible:

And here I have said No to consent, and the follow up question don’t show up:

Did you change anything in the XLS?

1 Like

Hello @nmambre , Sorry I had loaded a different xls. It is really working perfectly well!! Thanks so much for the support!!!


@nmambre, :clap: :heart: :partying_face: