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.