Latest Contributions by erica_poisson

I was able to get some help and figure out how to do this. I wanted to post the result here in case it is helpful to others. I am using a custom JavaScript function and a series of hidden and relevant questions in the XLSForm to accomplish my goal - prevent the submission of a new Survey123 form if the file number entered is a duplicate value.  First, here is the JS function: /* * JavaScript functions for Survey123 */ function returnFeatures(DCR_File_Number, token, debugmode) { // Output value. Initially set to an empty string (XLSForm null) let outValue = ""; let layerURL = "https://URL GOES HERE/FeatureServer/0"; let response =""; // Set up query parameters let f = "f=json"; let where = `where=DCR_File_Number='${DCR_File_Number}'`; let outFields = "outFields=*"; let returnGeometry = "returnGeometry=false"; let returnCount = "returnCount=1"; let parameters = [f,where,outFields,returnGeometry,returnCount].join("&"); let url = `${layerURL}/query?${parameters}`; if (token){ url = url + "&token=" + token; } // 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 if (xhr.readyState === xhr.DONE) { if (xhr.status !== 200) { // The http request did not succeed return "bad request: " + url } else { // Parse the response into an object response = JSON.parse(xhr.responseText); if (response.error) { return (debugmode? JSON.stringify(response.error):""); } else { if (response.features[0]) { return "DCR File number is not unique" //JSON.stringify(response.features[0]); } else { if (DCR_File_Number !== "") { return "DCR File number is unique"} //(debugmode? "No Features Found":""); } } } } }   Next, I configured the XLSForm - here is what all of the populated columns look like (I hid all of the empty/non-relevant columns to fit this into one image): When the user goes to enter a file number, if it is invalid (AKA a duplicate), they will see this message in the Survey123 form: Because of line 6 in the XLSForm, they are prevented from submitting their form until they correct the DCR File Number so that it is unique.  When a unique DCR File Number is entered, this message appears and the user is able to submit: This seems to work very well for my use case. Since this is a web-only form (users only complete from a desktop PC) this works perfectly.  ... View more

@thesweenis -  You can use custom JavaScript functions in your survey to parse a scanned drivers license into your Survey123 form. It works well, although sometimes the actual scanning process is a bit slow (still).  Here is the js function which gets saved in your survey's "scripts" folder.  function DL2JSON (data) { var m = data.match(/^@\n\u001e\r(A....)(\d{6})(\d{2})(\d{2})(\d{2})/); if (!m) { return null; } var obj = { header: { IIN: m[2], AAMVAVersion: parseInt(m[3]), jurisdictionVersion: parseInt(m[4]), numberOfEntries: parseInt(m[5]) } }; for (var i = 0; i < obj.header.numberOfEntries; i++) { var offset = 21 + i * 10; m = data.substring(offset, offset + 10).match(/(.{2})(\d{4})(\d{4})/); var subfileType = m[1]; var offset = parseInt(m[2]); var length = parseInt(m[3]); if (i === 0) { obj.files = [ subfileType ]; } else { obj.files.push(subfileType); } obj[subfileType] = data.substring(offset + 2, offset + length - 1).split("\n").reduce(function (p, c) { p[c.substring(0,3)] = c.substring(3); return p; }, { } ); } if (obj.DL) { ["DBA", "DBB", "DBD", "DDB", "DDC", "DDH", "DDI", "DDJ"].forEach(function (k) { if (!obj.DL[k]) return; m = obj.DL[k].match(/(\d{2})(\d{2})(\d{4})/); if (!m) return; obj.DL[k] = (new Date(m[3] + "-" + m[1] + "-" + m[2])).getTime(); } ); } return JSON.stringify(obj); }   Here is the syntax for your XLSform which will parse the information into your form:   ... View more

You were correct - I had not realized this was required now with Field Maps, as it wasn't when I'd previously configured these types of URLs for Collector.  I was able to get some help via the Field Maps Questions and you can see the answer here - https://community.esri.com/t5/arcgis-field-maps-questions/custom-survey123-url-with-field-maps-callback/m-p/1140741#M2412  ... View more