survey123 connect using csv file to select a subset of data

Question

hello,

I am brand new to the survey123 world.  i am hoping to build a survey to be used offline.   the data to be collected is tree diameter and health.  i have a CSV file that has the data from a pervious inventory.  i attached a simplified version of it.  the idea is to go the field (no wifi/cell) select a location from a site list.  then select a plot from a list based on the location. not all locations have the same plot numbers or number of plots.  That then would create a repeat group with all the tress found at that location in a given plot.   the concept seemed simple but i am getting no where with the samples or videos.

I started with pulldata in the calculation column but if i read that correctly i can't filer by location and plot because those values repeat.

then i moved to search() in the appearance column.  i failed to get that to work.

i was envisioning lots more functionality but i struggling with what i thought would be easy..

i completed several trainings and watched a number of videos. I have been working through the blog post and forum posts.

there is no spatial information included in this survey.

i also realize that there are likely many ways to solve this.

any and all help welcomed

thanks

j

treedata.csv

Service_SIG_CAPDFT_0-1739179657541.png

jamiehollingsworth · Answer

thanks Doug,

sorry i forgot to add the sites.csv.  i changed the trees.xlsx to refence the choices tab for site selection.  Adding the string-lenght(${s_p_con}) >0 removed the unfiltered list.    So i have to select an individual  tree to be able to add a new diameter measurement.  When i use the complete historical dataset the list of tree numbers will be in the hundreds making the list hard to use.  Tracking which trees have been completed will be difficult.  i thought that a repeat would let me scroll back and forth through the list that matches the site and plot criteria?  i want to be able to know how may trees are left to measured with a running count. also be able to avoid entering the same tree twice by showing the diameter that was just entered. i am getting the feeling that this level of complexity needs Java Scripts?

thanks for your help

attached is the newest xlsx

trees.xlsx

dougbrowning · Answer

You did not add sites.cav so I cant test.  But it seems like it works ok to pull the data?  If you do not want to see the whole list add a relevant on it so it does not show up until the other fields are filled in.  You can use string-length > 0 usually for the relevant.  Common way to do it.

You could also just go to one drop down to bit the combined ID right from the start.

jamiehollingsworth · Answer

thanks Doug,

i did create an unique ID column and that has gotten me a bit further along but it seems i am going need some serious hand holding to get this worked out. I have also been struggling to find examples.

currently when the app first loads it displays all the records in the select_one data search('treedata','startswith','name', ${s_p_con}) question.  i can filter it down to just one site and and one plot by answering the question above.  so functional it works, but not sure why it is showing all the data at the start and not waiting until its filtered.    I had wanted to be able to count all the records for any combination of site and plot and get them into a repeat i can scroll through.

this probably is not making any sense.

i attached the data and form

using count or position()..

treedata.csv

trees.xlsx