Calculate field based on another feature service?

ShelbyZelonisRoberson

I'm trying to do something in Survey123 (Enterprise/Portal) that I don't know if possible.

Context: I have a form built that the public can fill out. On the backend (via Integromat), upon submittal a PDF report of the survey gets emailed to the submitting user and CC'd to an internal email address.

Question: The survey has a geopoint field. Can I take this data and use another feature service to essentially do a spatial join/point-in-polygon and calculate a new field in the survey with attribute information based on the external feature class? Basically - I want the form to autopopulate a District field based on the geopoint location. The District boundaries are in a separate feature class in my Portal. I intend to then filter the survey results in Integromat and only email each district's surveys to each district's POC. 

Thanks!! 

ZacharySutherby

Hello @ShelbyZelonisRoberson, 

For your first question you can accomplish this by using a JavaScript function in your survey. Please refer to the JavaScript sample in Survey123 Connect there is a section that queries a Feature Service and returns attribute information based on the location of the Geopoint. 

Please use this link for more information on JavaScript functions in Survey123: https://community.esri.com/t5/arcgis-survey123-blog/extending-survey123-smart-forms-with-custom-js-functions/ba-p/898782

Please use this link for more information on limitations when using JavaScript functions in Survey123: https://doc.arcgis.com/en/survey123/desktop/create-surveys/pulldatajavascript.htm#ESRI_SECTION1_2A1B3F6B4F4741E9BC1BE519E671E565

 

For your second question I don't think a Webhook would be best because they are more geared towards individual responses. What you can do is use the Survey123 module in the ArcGIS API for Python and specify the `where` parameter to return only records that match a certain District. Ismael wrote a good blog on using Python to configure an email notification system. The email piece of that script can be used to automatically send the email to the Districts email address. Or if you did want to use Webhooks you can use this workflow to use the Python API script in a Webhook. 

We are in the process of creating documentation to help understand the Survey123 module in the Python API, but I have attached a sample notebook that highlights how to work with Reports using Python.

 

Thank you,

Zach

Working_with_Reports.zip