I am using XLSform to build a form for use in Collect.
I have a Select_One that returns the name of a district. However, I also need to return a number for that district ( its a count of facilities in that district) to be used in a later calculation. The number is not unique. So it feels intuitively that i need to add an additional column to the choices sheet with the facilities count in it and somehow reference that column in my calculation but I can't work out how to!
I have tried looking into the choice_filter route but its not quite right and have also been playing around with choice-name but can't get the syntax.
Any thoughts?