topic Re: Is it possible to use select_one and pulldata() together? in ArcGIS Survey123 Questions

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

KaceyCummings — Wed, 01 Mar 2017 18:56:23 GMT

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?

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

JamesTedrick — Wed, 01 Mar 2017 19:19:15 GMT

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.

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

KaceyCummings — Wed, 01 Mar 2017 19:25:33 GMT

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

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

JamesTedrick — Wed, 01 Mar 2017 19:32:17 GMT

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.

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

ErickWiggs2 — Fri, 03 Mar 2017 18:26:29 GMT

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.

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

DanielMcIlroy — Mon, 10 Jul 2017 03:27:01 GMT

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?

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

VirajP — Wed, 26 Jul 2017 00:53:46 GMT

Looking forward to this functionality

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

AdamDaily — Fri, 25 Aug 2017 13:57:20 GMT

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.

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

JamesTedrick — Fri, 25 Aug 2017 22:16:01 GMT

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.

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

AdamDaily — Sun, 27 Aug 2017 19:57:58 GMT

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?

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

JamesTedrick — Fri, 08 Sep 2017 21:17:35 GMT

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.

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

ElinFields — Thu, 12 Oct 2017 14:29:08 GMT

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.

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

JamesTedrick — Thu, 12 Oct 2017 20:41:12 GMT

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.

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

ShanaGail1 — Mon, 05 Mar 2018 18:57:06 GMT

Hi James,

We have inspectors and crew members that need to be updated fairly often in select_one questions. Is the functionality coming soon where we can just search a .csv? That would save a lot of time & overhead for our company. We have some painful hoops to jump through just to republish a service in our production environment.

Thanks!

Shana

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

Carolyn_Novak — Tue, 27 Mar 2018 20:24:40 GMT

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

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

JamesTedrick — Tue, 27 Mar 2018 21:04:37 GMT

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?

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

Carolyn_Novak — Wed, 28 Mar 2018 11:57:44 GMT

Thank you so much for the quick reply. This project is growing weekly. It started off very small so I'm sure I've taken a few wrong turns along the way. FDOT expects reports on our sidewalks for ADA purposes. I was tasked with recreating their current process and adding the FDOT specs.

What I have now is exactly what they want. I was able to incorporate every feature they asked for using Survey123. The only problem is that it's so slow they aren't going to want to use it. The engineers made it a requirement that every county road is to be part of a drop down and I had to do this 3 times! They aren't going to budge on this and it's killing the app. I tried pre-loading from a .CSV but I couldn't get that to work. I'm attaching the folder: Sidewalks/Sidewalk Field Inspection.zip and I am also in the process of setting up a website set up for the Inspectors for general information i.e, the FDOT reports: Sidewalk Field Inspection and Inventory | Sidewalk Data | or how to use the app: Sidewalk Field Inspection and Inventory | Home

I hope this explains the project better and I'm sure I'm approaching the roads incorrectly.

this is all in BETA

Thank you again!

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

JamesTedrick — Wed, 28 Mar 2018 15:53:24 GMT

Hi Carolyn,

The select_multiple dropdown is a list of the county's roads? Id there a reason it's a select_multiple as opposed to a select_one? Is there a limit to the total number of roads to be selected?

In other similar inspections, typically the list of roads is a select_one; this can then be used with a cascading select to have an initial filter (district within the county, for example) reduce the list before it is loaded into the form. This greatly increases the speed of the list. If multiple streets are needed to be recorded (if, say, you are looking at an intersection), then multiple select_one questions can be used (or, alternatively, instead of listing the roads, listing the intersections in a select_one).

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

Carolyn_Novak — Wed, 28 Mar 2018 16:34:05 GMT

I love your idea about the districts. We can have inspector areas that use the cascading select. Thank you so very much. The engineers are going to be very happy!

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

ShanaGail1 — Wed, 23 May 2018 17:26:27 GMT

Hi James,

Any update on when this will be available?

Thanks,

Shana