I have a select_one question with a long list of Material Codes (select_one mat_code). Below that I have a field labeled 'Description'.
I would like my field workers to be able to select the material code from the drop-down list and have the 'description field auto-populate with the corresponding description for that material code.
My drop-down for Material Codes (Mat Codes) works, however I attempted to create a pulldata() function that would auto-fill the description field when a mat code is selected, but this function is not working. I am not sure if I entered the calculation correctly. Please let me know what I can do to fix this.
I have attached screenshots of my xls form for the survey, the csv file I am trying to pull from, and my choices page.
Is pulldata the best way to accomplish this? Or should I be doing something else? Any feedback is appreciated.
Thank you.
Hi Heide,
Yes, pulldata() should be able to accomplish this. One thing I see is that you have the field specified as '<description' in the pulldata function, but it appears to be 'description' in the CSV file - the values must match. I will also note that commas in the CSV file will cause issues in reading the values correctly.