Collection of georeferenced data with return of fields from csv files

[mathieubossaert]

Hi Giulia,

this is really close to some of our scenarios and needs for biodiversity relative forms.
I achieved to do what you expected for a water level monitoring form (showing the expected value at the day of visit for the selected place) but with really less column (1 per month). I wrote a logical test to get every value (one per month) and show the good one to the user :

Get custom data from choices sheet for calculation

Sorry to zombify this topic, but I am not able to achieve this. I would like to get a value from a column of a list in the choices sheet (not from a extarnal csv file) and I can't. I get no error, no value. I would like to get, from the "stations" list the value of the column "month_03" for tech selected item. In the calculation column of my calculate field I have this xpath expression : instance('stations')/root/item[name=${station}]/month_03

In your case you have too much columns to use that way.
(let's say we rename the quadrant and column to avoid forbidden characters so 9432/3 becomes _9432_3)
this calculation will work and return the value 4 for Abies alba :

instance('Species')/root/item[name=${species}]/_9432_3

At the time I created my form, I did not thought about using a question name to access the wanted attribute.
I tried with your form but it seems to not be possible.

instance('Species')/root/item[name=${species}]/${quadrant}

This syntax does not work and does not rise any error (so I think ODK is looking for a column named '${quadrant}' that does not exists. Maybe xlsforms gurus (@LN , @Xiphware and others) can complete or correct my understandings

This would be really helpful and practical indeed, at least from a theoretical point of view