I'm relatively new to ODK, but see it as a much better alternative to the current system of using excel forms, especially for sharing of data.
I currently encounter a problem that was very easy to tackle within excel userform. When I for example want to ask the participant for the place of his office I ask for province and district. Each district has a unique tracing number. The province and district are selected with cascading select, but after the selection of the district is done, I want the tracing number to be displayed next to it. Not for manipulation, but for the information of the participant to verify the number that he has written down. Of course I could just put the number as selection, but I want to use this idea in other instances as well.
So the question is, if there is a possibility to pull date from an external database that somehow represents the lookup function of excel, whenever a selection is made to display the reference value in the same row and different column in a box next to it.
During my search I did not find a discussion on that, but hope that anyone can help me out.
Thank you and best regards,