Pulling back data values from locally saved / submitted form data

Question

Hi All,

I am recording survey data under a predominent 'waypoint' number at each location. When finished at each location 'waypoint' the form is submitted (or stored locally, until a connection is available), so to get a as 'real time' as possible plot of waypoints from a map on the collector App.

I would like a field on the S123 form to return a 'last waypoint recorded' value that was previously used (and submitted), by that particular user. As far as I can tell this would have to imported from the 'locally' saved (on the mobile) device. Is this actually possible?

Any pointers would be helpful. Thanks.

I see that it may is possble to pulldata from the feature layer (service)? this involves javascript by the looks of things... this is way beyond me (looking at a few complex examples like extracting data at a certain geopoint... ) is there a simple example somewhere I can learn how to extract a single value such as in my case?

Anonymous User · Accepted Answer

Hi Chris,

It is not currently possible to query an existing survey record on the device in the database to get a value for a previously submitted survey. Only values is the same survey you are editing can be used in calculations.

As you pointed out, the only way to currently do this in the 3.11 released version of survey123 field app is using a JavaScript function, where you can write a function to query the feature service and return a value from the submitted data stored in the feature layer. You will need to know how to write JavaScript functions to do this, or at least try and find an example of how someone else has done this.

Alternatively, in the current 3.12 beta release available on the Early Adopter Community, there are now new ways to link a select one (choice list) to a feature layer table or CSV file in your hosted organization. You can also use the search() function to search and query a feature layer. Please see the documentation here and here to test out the latest 3.12 beta builds for these new features.