topic Re: Query data from separate feature service in Survey123 in ArcGIS Survey123 Questions

Query data from separate feature service in Survey123

AdrianDoss — Wed, 29 Jul 2020 22:15:32 GMT

We have a Survey123 form for vehicle inspections. Vehicle data is kept separately (manufacturer, model, etc.) in another corporate application, which we can query into a feature class/service. Each vehicle is identified in our system by an ID (eg. AF123).

What I would like to accomplish is when doing a vehicle inspection using Survey123 and the ID is entered, the separate feature service is queried to bring in vehicle details.

I have read that this is possible using pulldata() and/or javascript but have been unable to find an example. I am proficient in javascript.

Does anyone have an example they are willing to share? I am using the latest release candidate of Survey123.

Re: Query data from separate feature service in Survey123

Anonymous User — Wed, 05 Aug 2020 01:08:07 GMT

Hi Adrian,

Yes, the best way to achieve this is using pulldata @ javascript. There is a VIN Lookup example in the Early Adopter Community attached to the JavaScript documentation about how this has been done. With the 3.10 release due for release later this week, pulldata @ javascript will be fully supported in Connect, the field app and the web app.

Regards,

Phil.

Re: Query data from separate feature service in Survey123

AdrianDoss — Thu, 13 Aug 2020 04:28:30 GMT

Hi Phil

I have a use case where I have a Survey123 based on a feature service. The form is for pre-start checks on vehicles. I want to pull vehicle data from a non-spatial table hosted in our portal. Is there something analogous to feature services for non-spatial table data? And can I query it via pulldata()?

Cheers

Adrian

Re: Query data from separate feature service in Survey123

Anonymous User — Fri, 14 Aug 2020 00:15:50 GMT

Hi Adrian,

Yes, using a custom JS function you should be able to query your non-spatial table hosted in your portal to return the needed values.

Regards,

Phil.

Re: Query data from separate feature service in Survey123

AdrianDoss — Fri, 14 Aug 2020 02:39:39 GMT

Thanks Phil. So I can publish a table from an mxd in ArcMap / ArcGis Desktop as a service just as I would a feature class?

Re: Query data from separate feature service in Survey123

Anonymous User — Fri, 14 Aug 2020 02:47:46 GMT

Do you mean to use the table you publish from ArcMap / ArcGIS Desktop as a service to query? Yes, if you can write a custom JS function (you will need to write your own code to that and ensure the table is accessible and you have credentials etc) and can access that database and table on same network, you should be able to return the values from the table query, and pass them back into the survey form using pulldata @ JS into a text box.

Phil.

Re: Query data from separate feature service in Survey123

AdrianDoss — Fri, 14 Aug 2020 03:14:29 GMT

Yes, that's right, I want to publish it as a service. I thought services had to be a spatial layer, but I think you can publish a hosted table? I think that's the terminology.

Re: Query data from separate feature service in Survey123

Anonymous User — Mon, 17 Aug 2020 23:54:19 GMT

Hi Adrian,

Yes, if you publish it as a hosted table, you should be able to query it via a custom JS function.

Phil.

Re: Query data from separate feature service in Survey123

HarmondSantos1 — Wed, 03 Mar 2021 19:56:29 GMT

Hi Phil,

Just checking if it's possible to query via a custom JS function a layer which sits on our GIS server - not hosted on Portal?

Harmond

Re: Query data from separate feature service in Survey123

LieslDe_Swardt1 — Fri, 25 Jun 2021 09:59:54 GMT

Hi Philip, is there perhaps a workaround if your survey needs to be public? Recently found out that public survey does not support javascript.

Re: Query data from separate feature service in Survey123

Anonymous User — Mon, 28 Jun 2021 00:45:18 GMT

Hi @LieslDe_Swardt1,

No, JavaScript functions are not supported on public surveys (when a user is not signed in) due to security precautions.

Regards,

Phil.

Re: Query data from separate feature service in Survey123

Anonymous User — Wed, 11 Aug 2021 12:48:49 GMT

I'd like to follow up on this topic. I have a Survey123 and want to query another layer in the map. For example, Users enter their zip code and it queries another service in the map and filters to return a list of addresses based on the zip code. Both feature services update daily.

Does anyone have an example of doing this with a public services?