Community

Survey 123 - populate answer based on earlier survey entry

1093
1
04-13-2017 03:14 AM
AnthonyCheesman1
by
Occasional Contributor II
‎04-13-2017 03:14 AM

Hi

My organisation runs a large fleet of vehicles. I would like to build a Survey 123 implementation of our vehicle log book (which is currently paper based). Sounds easy, huh?

The survey asks for 2 odometer readings - START KM and FINISH KM. What I would like to be able to to do is to automatically populate the START KM field of a record with the FINISH KM value from the previous record from that vehicle. I would like for the user still to have the opportunity to edit the START KM, as there may be circumstances (eg log is not completed for a particular trip) where the prepopulated START KM is not correct.

Is this possible, and how would I go about setting this up?

Thanks in advance!

Tags (3)
0 Kudos
1 Reply
Siew_WeiGoh2
by
New Contributor III
‎11-28-2017 02:21 PM

Hi Anthony,

I'm not sure if you have worked out how to do this? But if you haven't, one way to prepopulate a question/field using existing data is by using 'pulldata' function with CSV file. 

See: https://community.esri.com/groups/survey123/blog/2016/10/27/the-pulldata-function-access-external-da... 

I am still experimenting on prepopulating a survey from feature services.

This site may help:  https://community.esri.com/groups/survey123/blog/2016/07/30/understanding-survey123s-custom-url-sche... 

Regards

Siew Wei

0 Kudos