nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Is it possible to use select_one and pulldata() together?

KaceyCummings

I am pre-populating a survey using the pulldata() function and was hoping to use it in conjunction with choice lists (in the event that the native data needs to be updated). It looks like this is not a possibility. In fact, pre-populated fields with type = text will no longer populate when the select_one feature is added to a different field using the pulldata calc.

Any suggestions/workarounds?

Find more posts tagged with

Accepted answers

Anonymous User

Hi @KaceyCummings @Pauline_Low_Pui_Ling @DougBrowning @Stephanie_F ,

Just wanted to let you know with the upcoming 3.16 October Release of Survey123 we have extended the pulldata() function to now include spatial searches and URIs (feature service URLs). You can find the latest announcements, documentation and test out the latest 3.16 beta builds via the Early Adopter Community to get early access to these builds.

Regards,

Phil.

All comments

JamesTedrick

Hi Kacey,

I'm a little unclear on what you are asking. Select_one questions with choice lists can be used to select a value that then is used in subsequent pulldata calculations.

Are you asking about populating a select_one choice list's via an external CSV file? That is currently not supported- when implemented, the function name will be search(), in accordance with the XLSForm specification.

KaceyCummings

Hi James,

Thanks for the quick response. I have a list of assets that are being inspected in a CSV, and I have created choice lists in my xlsForm corresponding to several fields in that CSV. My hope was to use the pulldata function to prepopulate data, however, if at the time of the inspection the person conducting the survey determines the pre-populated value no longer applies, they'd simply choose the correct value from the drop down in that same field.

Thanks!

Kacey

JamesTedrick

Thanks for the clarification. It sounds like you are being affected by a known issue - Survey123 currently does not support the calculation of select_one questions.

ErickWiggs2

James,

when can we expect the search() function to be available?

I have two surveys that rely heavily on address based location as well as what is currently in inventory. being able to search any external csv (that could then be updated) would make a world of difference for some of our fuctionality.

Erick.

DanielMcIlroy

Hi Erick, I have exactly this problem too. We are trying to implement an asset tracking form, but being able to lookup a central CSV or database that can be updated would be perfect.

JTedrick-esristaff‌, any word on this functionality?

VirajP

Looking forward to this functionality

AdamDaily

I have a question regarding select_one and pulldata. I want to use survey123 to collect surveys tied to a point layer. At the same time I need to collect new points with new attributes as my point layer is not complete. The info I want to collect in the survey is time sensitive. If a new location is captured and a survey is submitted, I want that new location available in a select_one list to others using the same survey without having to add that info to an existing csv file or a survey pick list.

I know you can create a feature service from a related point & db table, or export a point file to csv to pulldata from, but the workflows I have seen depend on either having that database table and all the rules set up, or having a completed point feature class to draw from. I have a survey form created,and I have a incomplete point shape file.

JamesTedrick

Hi Adam,

Unfortunately, you're running up against a limitation of Survey213 currently. We do want to support the workflow you describe in the future, with more dynamic sources of data than CSV files.

AdamDaily

James,

Thank you for the response. I don't necessarily need my data in a shape file but I would like it all in 1 place. I'm trying to find the best way to load existing data into my survey results layer to start, and then add to it using a survey. I also would like to stay in 1 application (not go out to collector) and even stay within 1 survey (same survey used to collect new geopoints and then to conduct surveys against those points).

Can I create a survey from a hosted feature service (my point file) and would that pull the existing point file records into the survey results layer, or is it schema only? Is there a way to load existing shape file (or database) records into the survey results layer?

Once I have everything in 1 layer, can I pull data into my survey fields using that same layer? For example, say I have points 123 & 456 that came over from my original point layer. Field worker 1 goes out and collects new geopoint 654 and field worker 2 collects new geopoint 321 using the survey. Now I want to conduct a survey against one of those same points. The next time I open the survey, is it possible to select from a pick list pulling from the survey results layer attriubte field that would now contain all 4 of those values?

JamesTedrick

Hi Adam,

My apologies for being late in responding. Yes, you can set up a survey based on what you describe. You could either create the survey based on an existing feature service with the data you have, or create the survey and then load the data into it (the Append tool in ArcGIS Pro does this, for example).

For the second part, this could be done either through the Inbox functionality or by combining Survey123 with either Explorer or Collector as a viewing client to show the features as they come in.

ElinFields

Related to this, I have a few questions. If an external select is used in a survey, a csv file containing those choices is saved in that survey's media folder (and I'm assuming is in AGOL when the survey is published). Is there a way to have multiple surveys reference that same CSV file in AGOL? Furthermore, would it be possible to 'update' that CSV file from AGOL (as with hosted feature layer CSV files, as long as the file name is the same)?

I ask because the external choices I plan to use would be a constantly changing list based on another survey's responses. If those two things were possible, it would allow me to update the external choices on a daily basis without republishing all surveys.

JamesTedrick

Hi Elin,

We are working on a sample python script to automate the uploading process so that the CSV file can be updated. In the longer term, we want to support additional data sources like Feature Services that would be closer to meeting the central CSV resource that you describe.

novakc

Are we closer to having dynamic selects for multiple choice questions? I have a survey that has over 10,000 choices and it takes over 2 minutes to load.

Thank you

JamesTedrick

Hi Carolyn,

We don't have plans to address this in the near term. Could you describe how the 10,000 choices in a select_multiple work within your form? Have you given thought to splitting them into separate questions that show based on relevance?

GregConiglio

Hello! This post is a bit dated... trying this in v2.6.6 and noting the same behavior with not being able to calculate a select_one. has ths been addressed in a subsequent version? Thanks!

RobertMarros

All,

I have noticed that if my select_one is set as Hidden (not displaying in my survey due to a relevancy) then it can NOT be pre-populate by a PULLDATA calculation. If I set the type to Note instead of select_one then it can be pre-populated by a PULLDATA Calculation. Is there anyway I can prepopulate a select_one question that has a relevancy making it not appear in my survey?

Please see the row highlighted in yellow

Thanks

Steven

James Tedrick @survey123 Survey123 for ArcGIS Is it possible to use select_one and pulldata() together? survey123calculations‌

JamesTedrick

Hi Robert,

If a question is non-relevant, it cannot be calculated; non-relevance means that no calculations will occur or data be stored for a question.

RobertMarros

James,

That is what I thought. So as long as it remains as "hidden" in my survey, or non-relevant, it will never be able to be calculated or store data for that particular question.

I guess I will have to come up with a workaround.

Thanks,

Steven

dougbrowning

I use the hidden type for this. Then I usually add a if(otherfield <> ''; calc, ''). So basically you build the relevant check into the calculation. If the "relevant" field is blank do nothing, but if it has data then do the calc. Note for numbers use string-length=0 to check for a blank.

Also watch out for the old bug of defaults. A field with a relevant will be blank - unless it has a default then it will load the default even if it is hidden.

Anonymous User

Hi @KaceyCummings @Pauline_Low_Pui_Ling @DougBrowning @Stephanie_F ,

Regards,

Phil.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.