Why does my Survey123 pulldata calculation yield no results?

474
2
03-25-2019 09:17 AM
KaitlynAbrahamson
Occasional Contributor

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!

Tags (2)
0 Kudos
2 Replies
BrettStokes
Esri Contributor

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

KaitlynAbrahamson
Occasional Contributor

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

0 Kudos