topic Re: Pre-fill answers with the pulldata function; works on the web, not in Survey123 app or Connect. in ArcGIS Survey123 Questions

Pre-fill answers with the pulldata function; works on the web, not in Survey123 app or Connect.

LaurieVIDAL — Wed, 11 Sep 2024 11:45:24 GMT

Hi everyone,

I'm still new to Survey123 (especially the advanced version with Connect) and I've made a survey where depending on the wetland number selected, 4 other questions are automatically filled in depending on what the user has chosen as wetland. I integrated a csv file containing all the information and used the pulldata function. The idea is to do the same thing as in this video: https://www.youtube.com/watch?v=CTq-ux2v5ds&list=PLGZUzt4E4O2L7h2PdpL7st93nURZAW58d
I was able to publish the survey (so far everything seems to be working), but when I test the survey in Survey123 Connect it doesn't work. The questions don't pre-fill when I choose a wetland (I see the question/note title, but not the answer). The same applies to the Survey123 application on the phone. However, if I choose to open the survey on the web instead of the app, it works. The answers auto-complete according to the wetland selected. Has anyone had the same display problem or could you help me identify the problem?
Is it a checkbox or a version problem?

Survey123 Connect 3.20.63 and on my phone, it's version 3.20.68.

I'm thinking that if it works on the web version, then it can't be due to a coding problem on my part, can it?

Thanks in advance for your help.

Re: Pre-fill answers with the pulldata function; works on the web, not in Survey123 app or Connect.

DougBrowning — Wed, 11 Sep 2024 13:03:29 GMT

This often caused by using reserved words or having special chars somewhere. Are there any green squares on your field names? If you can post the form may see something in it.

Re: Pre-fill answers with the pulldata function; works on the web, not in Survey123 app or Connect.

abureaux — Wed, 11 Sep 2024 14:31:03 GMT

Could be a few little things. But if it works on web, it should work on the Field App (the reverse is not always true though).

Can you post your XLSX and CSV?

Re: Pre-fill answers with the pulldata function; works on the web, not in Survey123 app or Connect.

DuncanC — Wed, 11 Sep 2024 14:55:10 GMT

My reply won't solve your problem but hopefully I can clear up one piece of potential confusion. What you've built won't work in Connect (this is ridiculous, be better ESRI) because it doesn't load the CSVs. But it should work in the Survey123 (not-connect) application on both windows and your phone.

Re: Pre-fill answers with the pulldata function; works on the web, not in Survey123 app or Connect.

LaurieVIDAL — Wed, 11 Sep 2024 15:18:22 GMT

Here is my xlsx and csv files (in attachments).

It doesn't contain much because I wanted to do a test to make sure the function works (or at least understand how it works before inserting it in my final form).

On the Internet, it works:

but on the application, the information doesn't appear :

Re: Pre-fill answers with the pulldata function; works on the web, not in Survey123 app or Connect.

LaurieVIDAL — Wed, 11 Sep 2024 15:20:56 GMT

Hi,

No I don't have any squares appearing or anything that might indicate a special character problem. The only ones I have, are accents, but I only use them in the label field so as not to cause an error.

Re: Pre-fill answers with the pulldata function; works on the web, not in Survey123 app or Connect.

LaurieVIDAL — Wed, 11 Sep 2024 15:23:02 GMT

That's what I think too...
Yes, I just added them under my first post.

Re: Pre-fill answers with the pulldata function; works on the web, not in Survey123 app or Connect.

abureaux — Wed, 11 Sep 2024 15:35:32 GMT

Your CSV is broken:

And is missing required column names (name and label)

Attached is a repaired CSV and updated XLSX

Re: Pre-fill answers with the pulldata function; works on the web, not in Survey123 app or Connect.

LaurieVIDAL — Wed, 11 Sep 2024 16:48:48 GMT

It works! Thank you very much.
I didn't know that it was necessary to add exactly label and name, I thought you could put another name for these two column headings.
Now I know. Thank you.

Re: Pre-fill answers with the pulldata function; works on the web, not in Survey123 app or Connect.

abureaux — Wed, 11 Sep 2024 17:57:23 GMT

No worries! That is a common miss. I did that with my first CSV as well.