Update Survey123 form data from another source

Question

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,

MD

BE4 · Answer

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

MikeDeBoer · Answer

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.

danbecker · Answer

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.