Hello,
I am having trouble with the Pulldata function when trying to work with a agol hosted csv file. My goal is to use a Pulldata function to do a lookup on a hosted csv file using the devices "deviceid" to return the users name and possibly additional info in the future. My formula pulldata('myusers', 'users', 'devices', ${ms_deviceid}) appears correct from what i can tell but it does not return anything. I've attached my test survey and csv file that i'm working with.
PS The reason i'm trying to grab the user name this way instead of using the username field is that not all my users will have a esri login. This will be a publicly shared survey.
Josh
Solved! Go to Solution.
I believe you have 'users' and 'devices' backwards:
pulldata('myusers', 'devices', 'users', ${ms_deviceid})
I was just about to post a very similar question. I have been trying all week with same formula with no success. I'm glad you asked.
I believe you have 'users' and 'devices' backwards:
pulldata('myusers', 'devices', 'users', ${ms_deviceid})
Hey thanks that worked! I thought it didn't at first because it still fails in Survey123 Connect but once i tried it in the field app it worked as expected.
Josh