topic Re: Update Survey123 form data from another source in Geodatabase Questions

Update Survey123 form data from another source

MikeDeBoer — Thu, 02 Jul 2020 13:36:43 GMT

Hello,

I am looking for a way to auto populate form drop down answers. We are using Survey123 for a work order application and new jobs are being added daily. My current workflow is to get the job list sent to me, then batch edit the populated answers.

I am looking for a way to have Survey123 reach out to a shared excel sheet or SQL endpoint to auto update and republish.

Thanks,

Re: Update Survey123 form data from another source

DerekLaw — Wed, 08 Jul 2020 14:45:08 GMT

Hi Mike,

> I am looking for a way to auto populate form drop down answers.

Please take a look at the pulldata() function, this might meet your needs

Hope this helps,

Re: Update Survey123 form data from another source

MikeDeBoer — Wed, 08 Jul 2020 15:14:29 GMT

Derrick,

Thanks for the quick response. That is a good function, but can I use to pulldata function to only update the dropdown list? I am pretty sure this will only work when you select something in the survey (ie select name > auto populate address). What I need is for the pull data to update the list from a CSV (see below):

I might be missing something with this workflow and it is probably an easy fix. Follow up functionality would be a way to auto republish a survey when the auto populate csv is updated (different conversation though).

Thanks,

Mike DeBoer

Re: Update Survey123 form data from another source

DerekLaw — Fri, 10 Jul 2020 05:07:05 GMT

Hi Mike,

I am sharing this thread with the Survey123 forum so other folks on the Dev team can assist with your questions.

Hope this helps,

Re: Update Survey123 form data from another source

danbecker — Fri, 10 Jul 2020 12:05:09 GMT

I would consider a new workflow that doesn't involve editing the dropdown values, i.e. coded value domain.

Each time the dropdown values are edited, you have to re-publish the survey so others can view your form changes. Likewise, others then have to refresh the survey form in the s123 app. Seems clunky to me.

Some options off the top of my head:

--Put all possible values that will ever exist in the dropdown, then filter the results

--Change the select_one question to a text box. Maybe after they enter the project name once at the top of the form it auto-populates other entries below, limiting entry mistakes.

Re: Update Survey123 form data from another source

MikeDeBoer — Wed, 15 Jul 2020 13:39:46 GMT

Dan,

Can you fill me in on what you mean by coded values? It is possible to update coded values with a hosted feature service in Survey123?

Thanks,
Mike D.

Re: Update Survey123 form data from another source

BE4 — Fri, 02 Jun 2023 13:51:56 GMT

Hey Mike,

This workflow is supported now. See links below. You may have to use python and set a scheduled script up to run and update your external csv. Hope it helps!

XLSForm essentials—ArcGIS Survey123 | Documentation

Update CSV item in ArcGIS | ArcGIS Survey123