Automatically Selection based on last question

User Support Form Building
, , ,
1

I have a question titled “Survey Status” with the following options:

  1. Completed
  2. Partial

How can I configure it to automatically select an option based on the status of the last question? Specifically:

  • If the last question is answered, “Completed” should be automatically selected.
  • If the last question is not answered, “Partial” should be automatically selected.
2

@sudeep, this post discussed previously should help you solve your issue:

3

Thank you @Kal_Lam(Profile - Kal_Lam - KoboToolbox Community Forum) for your prompt response; it was very helpful and worked as expected.

Additionally, I would like to implement a logic where, if Q1 (the first question) is selected and Q5 (the last question) is not selected, option 2 (Partial) should be automatically selected. If both Q1 and Q5 are selected, option 1 (Completed) should be automatically chosen.

I have attempted to merge the logic, but it does not seem to be functioning as intended. Could you kindly assist me with this issue?

calculation : if(${q1} != ‘’ and ${q5} != ‘’, ‘1’, if(${q1} != ‘’ and ${q5} = ‘’, ‘2.’, ‘’))
trigger : ${q1} ${q5}

4

I would like to implement a logic where, if Q1 (the first question) is selected and Q5 (the last question) is not selected, option 2 (Partial) should be automatically selected in question before Q1. If both Q1 and Q5 are selected, option 1 (Completed) should be automatically chosen in question before Q1.

I have attempted to merge the logic, but it does not seem to be functioning as intended. Could you kindly assist me with this issue?

calculation : if(${q1} != ‘’ and ${q5} != ‘’, ‘1’, if(${q1} != ‘’ and ${q5} = ‘’, ‘2.’, ‘’))
trigger : ${q1} ${q5}

5

As previously discussed, I am attempting to implement a logic where, if the first question (rand1) is selected and the last question (rand5) is not selected, the option “Partial” should be automatically selected in the preceding question (category_1). However, if both the first and last questions are selected, the option “Completed” should be automatically chosen in the same preceding question.

While the logic works correctly when applied separately to either the first or last option, I encountered an issue when attempting to combine the conditions. The desired behavior doesn’t seem to function as expected.

I have tried merging the logic, but it does not appear to work correctly. Could you kindly assist me in resolving this issue?

For reference, the category_1 is the question where the option should be automatically selected, and the variables rand1 and rand5 represent the first and last questions respectively.

Please find the attached XLSX file for further context.
Randomized)Kobo).xlsx (17.5 KB)