topic Re: Load Lists based on the device network connectivity in ArcGIS Survey123 Questions

Load Lists based on the device network connectivity

vijaybadugu — Fri, 06 Aug 2021 21:01:19 GMT

I have a requirement of loading lists from CSV or Feature Service to Select_one dropdownlist. I'm able to retrieve the data using search function from either of it.

But If the device is Offline, I need to pull the data from local CSV file from the media folder otherwise pull the data from feature service.

is there any way to add consdition in appearance column to achieve this functionality ? as below

autocomplete if(pulldata("@property", 'online'), search("<tablename>?url=<featureservice>"), search('<tablename>','','<fieldname>'))

Re: Load Lists based on the device network connectivity

DougBrowning — Fri, 06 Aug 2021 21:10:06 GMT

Is there a reason you are not using Linked Content to a CSV? Then just update the CSV - if they are online they get the new version on form open automatically if not it just uses the old one.

If not you could do the 3rd party trick. Create 2 fields with temp names and null binding, one linking to the CSV and the other to the service. Use relevant to show the correct one. Then have a 3rd final field that uses coalesce to pick the one used - this is the field that actually populates the service.

Hope that helps

Re: Load Lists based on the device network connectivity

vijaybadugu — Fri, 06 Aug 2021 21:13:42 GMT

Linked content , How to update CSV content dynamically in Linked content ?

Re: Load Lists based on the device network connectivity

DougBrowning — Fri, 06 Aug 2021 21:19:14 GMT

You add a CSV to AGOL then you can update that. You can do that manually or with a Python script. The form sees the changes and grabs a new copy of the CSV.

Help is about half way down in here https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformessentials.htm

Re: Load Lists based on the device network connectivity

vijaybadugu — Fri, 06 Aug 2021 21:29:04 GMT

My question is, as content is linked, if anything updated in arcgis online or enterprise for csv contents . will field user get an update to refresh the survey form ?

Re: Load Lists based on the device network connectivity

DougBrowning — Fri, 06 Aug 2021 23:12:07 GMT

Yes it will see the change and auto update. Give it a try.

Re: Load Lists based on the device network connectivity

vijaybadugu — Sat, 07 Aug 2021 15:08:03 GMT

Will give a try