pulldata is not working for me and I don't know why!

ScottMarkowitz

I'm fairly new to Survey123, and have been trying to understand why my pulldata equation isn't working. Here's the equation:

pulldata("boxad", "mgrs", "site_name", ${address})

with boxad being my .csv document that is in my media folder, mgrs being the the military field after being looked up in the site_name column. The input should come from the address question. What I'm trying to get it to do is assign the military grid coordinate to the number I've assigned to the nest box. So, nest box in the site_name column TA041 would return 10TET2514909437 from the mgrs column. Here's a photo of my boxad.csv file. 

I've been trying to figure this out all day, and would be grateful for any help!

 

 

 

Neal_t_k

What kind of answer are you expecting in your address question?  It would need to match exactly your sitename in your csv for pulldata to work, In your form, your ${address} question is a open text question and appears to be calculated from ${city}?  A text question leaves a lot of room for entry error as the matching fields in the pulldata have to match exactly.  Have you considered a choice list for the address question you have them all worked out in the csv already?