Preload information from another database do prefill answers to some of survey questions.

166
1
01-19-2021 12:16 AM
Labels (1)
NaeimBabaii
New Contributor II

Hi Everyone, 

i know you can pull data from CSV file in your media folder to preload data into the Survey123.

but is there anyway that we can pull data to preload information from another database like Azzure or SQL or even live spreadsheet to prefill the answers to some of the question in survey form. 

i have to build an inspection form which required the user to have most of the answers/ results prefilled into the form and just adjust any answers that is different from previous inspection and some empty question field.

i can not use the csv media folder pull-data method as the data constantly changes.

Thanks

Naeim

@JamesTedrick,@ismael

 

 

Reply
0 Kudos
1 Reply
RyanUthoff
Occasional Contributor III

I've been looking for the same thing and I found this. It has the potential to be promising. It doesn't exactly pre-populate answers, but it will pre-populate dropdown lists. I'm not sure if that could be extended to what you need or not though.

 

https://community.esri.com/t5/arcgis-survey123-questions/dynamic-dropdown-list/m-p/856540