Pass 'Location' Reliably from Workforce to Survey123
Hello,
I am trying to pass location in xy or address format from Workforce to a Survey. I want to be able to populate a text field in Connect with the coordinates or the address and then convert to coordinates, so that I can use it as a parameter for the 'Working with a feature service' Javascript example published by Survey123.
I want to be able to determine what district the survey is in using that script, it works good on its own, but with Workforce not so much.
Passing Workforce Location is fine, but in Workforce when you click on the map an xy populates the location, while searching for an address populates the location field in address format. Therefore it cant be expected of end users to consistently submit an assignment with either or.
I was wondering if anyone had any ideas, I'm thinking there might be a way to calculate a location field in survey123 that accounts for either address or xy but im not sure how to go about it. I am aware of the geocode and reverse geocode functions, but how to account for both formats I'm not sure. I'm new to Connect and super new to Javascript so thank you for any advice.
Here is the script im using;
// Query a feature layer and returns a specific field value from
// the feature that intersects the location
function fieldValueByLocation(layerURL, location, field, token) {
// Output value. Initially set to an empty string (XLSForm null)
let outValue = "";
// Check to make sure both layerURL and location are provided
if (layerURL == null || layerURL === "" || location == null || location === "") {
// The function can't go forward; exit with the empty value
return outValue;
}
// The coordinates will come in as `<lat> <lon> <alt> <acc>`.
// We need <lon>,<lat> for the query
// Note that I'm using the relatively new ` ` string that lets me place variables ${var}
let coordsArray = location.split(" ");
let coords = `${coordsArray[1]},${coordsArray[0]}`;
// Set up query parameters
let f = "f=pjson";
let geometry = `geometry=${coords}`;
let geometryType = "geometryType=esriGeometryPoint";
let inSR = "inSR=4326";
let spatialRel = "spatialRel=esriSpatialRelIntersects";
let outFields = `outFields=${field}`;
let returnGeometry = "returnGeometry=false";
let returnCount = "returnCount=1";
let parameters = [f,geometry,geometryType,inSR,spatialRel,outFields,returnGeometry,returnCount].join("&");
if (token) {
parameters = parameters + `&token=${token}`;
}
let url = `${layerURL}/query?${parameters}`;
/*
https://services.arcgis.com/P3ePLMYs2RVChkJx/arcgis/rest/services/World_Administrative_Divisions/FeatureServer/0/query?
f=pjson
&geometry=-122.32759252280006,47.59698828035203
&geometryType=esriGeometryPoint
&inSR=4326
&spatialRel=esriSpatialRelIntersects
&outFields=NAME
&returnGeometry=false
&returnCount=1
https://services.arcgis.com/P3ePLMYs2RVChkJx/arcgis/rest/services/World_Administrative_Divisions/FeatureServer/0/query?where=&objectIds=&time=&geometry=-117.19605707130171%2C34.0675386635019&geometryType=esriGeometryPoint&inSR=4326&spatialRel=esriSpatialRelIntersects&resultType=none&distance=0.0&units=esriSRUnit_Meter&returnGeodetic=false&outFields=NAME&returnGeometry=false&returnCentroid=false&featureEncoding=esriDefault&multipatchOption=xyFootprint&maxAllowableOffset=&geometryPrecision=&outSR=&datumTransformation=&applyVCSProjection=false&returnIdsOnly=false&returnUniqueIdsOnly=false&returnCountOnly=false&returnExtentOnly=false&returnQueryGeometry=false&returnDistinctValues=false&cacheHint=false&orderByFields=&groupByFieldsForStatistics=&outStatistics=&having=&resultOffset=&resultRecordCount=&returnZ=false&returnM=false&returnExceededLimitFeatures=true&quantizationParameters=&sqlFormat=none&f=html&token=
*/
// return url;
// Create the request object
let xhr = new XMLHttpRequest();
// Make the request. Note the 3rd parameter, which makes this a synchronous request
xhr.open("GET", url, false);
xhr.send();
// Process the result
// This an abbreviated version without being able to distinguish different types of errors
if (xhr.status === 200) {
let response = JSON.parse(xhr.responseText);
if (!response.error) {
if (response.features[0]) {
outValue = response.features[0].attributes[field];
}
}
}
return outValue;
}
Here is the form for reference as you see it in the example.
Here is the excel that comes with it as well.
| geopoint | location | Please set a location | |||||||||||||||||||||||||||||||||
| hidden | adminURL | URL for feature layer of 1st level admin boundaries | The URL is added as a hidden question to make the pulldata() function more readable and so that it can be changed outside of the script. | https://services.arcgis.com/P3ePLMYs2RVChkJx/arcgis/rest/services/World_Administrative_Divisions/Fea... | null | ||||||||||||||||||||||||||||||
| note | adminFeature | The 1st level admin area feature the location is in | Queries a feature layer to return the feature the point intersects. Returns a JSON object that can be processed in the form. | multiline | pulldata("@javascript", "url_requests.js", "featureByLocation", ${adminURL}, string(${location})) | null | 100000 | ||||||||||||||||||||||||||||
| text | adminISO | ISO_CODE value | A specific value can be extracted using the pulldata("@json") function. | pulldata("@json", ${adminFeature}, "attributes.ISO_CODE") | |||||||||||||||||||||||||||||||
| text | adminName | NAME attribute | Uses a different function that returns only the text value. | pulldata("@javascript", "url_requests.js", "fieldValueByLocation", ${adminURL}, string(${location}), 'NAME') |
