topic Re: Why does my Survey123 pulldata calculation yield no results? in ArcGIS Survey123 Questions

Why does my Survey123 pulldata calculation yield no results?

KaitlynAbrahamson — Mon, 25 Mar 2019 16:17:58 GMT

When I use the pulldata function in Survey 123, my survey shows the labels I have, but shows no data. It should pull data automatically when I put the sign type in, right?

What am I missing? Thanks for your help!

Re: Why does my Survey123 pulldata calculation yield no results?

BrettStokes — Mon, 25 Mar 2019 21:55:03 GMT

Hi Kaitlyn,

Your pulldata() expression is trying to match the 'signnumber' from your .csv (eg D1-1, D1-1a, D1-2 etc) with your ${signtype} field. This field in your survey uses D1-1... etc as the label but 1, 2, 3, 4 etc is the value (name) being stored → so it's not matching up.

To fix this you simply need to change the name column in your 'signtype' choice list to match the label column:

Alternatively, you could update the 'signnumber' column in your .csv to the original numbers used in the name column of your choice list (1, 2, 3, 4 etc):

Regards,

Brett

Re: Why does my Survey123 pulldata calculation yield no results?

KaitlynAbrahamson — Tue, 26 Mar 2019 13:35:10 GMT

Thank you so much! That did the trick! Now I just need to figure out why my compact questions won't allow default!