Select to view content in your preferred language

Autofilling multiple select_one fields using CSV

157
1
2 weeks ago
spf999
by
Emerging Contributor

Hi all, 

I am currently upgrading my survey for the next field season and have run into some issues. My goal is to have some select_one questions survey auto filled, based upon the sample ID that is entered. I have a CSV that will be updated prior to each field outing, and it is uploaded to the media file within the Survey123. I hope to have the sampinfo_type, sampinfo_filterps, sampinfo_prestype select_one fields auto populated with the values found within the CSV as these values are project specific (within the choices that are already determined). My main motivation for this is to mitigate data entry errors and make the survey less time consuming for the field staff. 

Based off my brief research, pulldata() does not seem to be compatible with select_one questions, is this true? 

I've attached my survey XLSX sheet as well as the CSV file in which I'd like to auto populate from. 

Any suggestions will be much appreciated! Thanks for your help in advance! 

0 Kudos
1 Reply
ZekeMI
by
Frequent Contributor

If there aren't dozens of possible values to auto populate, you can do this directly in the calculation field of sampinfo_type, et al., using an Iif statement. Here's a post to get you started.

0 Kudos