1. What is the problem? Be very detailed.
I would like to use two variables under the Trigger column since I have two options/scenarios that could happen depending on a condition.
- I have two types of household visit (First visit and Revisit).
- Any type of visit you chose requires that you key-in the number of households or structures in that compound.
- If the respondent erroneously said there are 5 households, you would be required to give information for all the households even if there were only 3 households.
- I need to use ${first_visithouseholds} ' , ' ${revisit_households} questions to serve as the trigger under the Trigger column so that I can go back and change number of households from 5 to 3 households to recalculate so that the repeat function does not ask for 5 households but instead ask for 3 households.
2. What app or server are you using and on what device and operating system? Include version numbers.
I am using ODK collect v1.25.2 on a Samsung Tab4 using Android version 4.4.2
3. What you have you tried to fix the problem?
I introduced a third row ${total_households} that calculates (sums the two options, if(${firstvisit_households}=null,0,${firstvisit_households})+if(${revisit_households}=null,0,${revisit_households})
Then used the ${total_households} variable under the Trigger column, but because its not a visible question, I am getting an error when I use the Online XLSForm converter (Error: The question ${total_households} is not user-visible so it can't be used as a calculation trigger for question ${position1}.)
4. What steps can we take to reproduce the problem?
Is it possible to use two visible questions under the Trigger Column to help avoid this error?
(Error: The question ${total_households} is not user-visible so it can't be used as a calculation trigger for question ${position1}.)
5. Anything else we should know or have? If you have a test form or screenshots or logs, attach below.trigger_test_Saduma.xlsx (10.7 KB)