Is it possible to set up a choice filter using a hidden calculation field, rather than a select_one or select_many field?
For example, we have a hidden field (${organisation}) with the calculation:
if(${total_score}>=10, 'organisation1','organisation2')I then want to apply a filter to a choice list based on the value of this field. I've followed the steps above, but it doesn't seem to work. Am I missing a step? Or is it because it's not the correct field type?
Hi, could you please share your XLSForm so I can support on this regards.
Hi Anneka, I created a sample using default field type, please see the screenshots below.
Jing_Sun_0-1608779515266.png
Jing_Sun_1-1608779551764.png
Cheers
Hi. Yes, this is possible.
For example, here I calculate the Body Mass Index of a person and use that value to present menu items in a list. The Body Mass Index is hidden to the user.
IsmaelChivite_0-1609185984398.png
IsmaelChivite_1-1609186045506.png
The same goes with your original example, which should work well.
I am guessing that your version of Survey123 Connect is old. If you are running using the latest version, attach your XLSForm to a reply. There might be something else we could not see in your screenshot.