Can location data (geopoint) be automatically associated with a preloaded polygon shapefile coverage? I came up with something like that the data of 3 drop-down menus would be automatically filled according to the Country, region and commune with the data contained in the preloaded shape
If it exists, what is the formula associated with the XLS form?
Custom JavaScript function: Using a custom JS function in a calculation you can pass the point geometry of your Survey123 record into a feature layer and return the intersecting polygon. Then, you can extract from that record attributes that you can use within your form. This is an advanced technique that involves working with JavaScript cod and the ArcGIS REST API. Check the 'Working with web services' section in https://community.esri.com/t5/arcgis-survey123-blog/extending-survey123-smart-forms-with-custom-js/b... for details. Since this technique queries a feature layer using the REST API, it will only work if the user is online (connected).
Workflow automation: You can also use Integromat or Microsoft Power Automate to do a similar query once the Survey123 record has been submitted to ArcGIS. You can find info about how to do this with Integromat here: https://community.esri.com/t5/arcgis-quickcapture-blog/data-enrichment-with-arcgis-quickcapture-and/... This article I reference talks about ArcGIS QuickCapture but the steps are pretty similar with Survey123. If you take this approach, the calculations will happen when the GIS record is sent into ArcGIS. For this reason, it does not matter if the user is online or offline when the data is collected.
Python automation: This would be similar to Workflow Automation as described above, except that you would be writing a Python script to do the queries and updates, and then schedule the script to run when you like.
Please note that none of the solutions outlined above works with pre-loaded geographic data in the device. They all rely on queries to a feature layer. At this moment in time, it is not technically possible to reference a local shapefile in your device to do this type of queries.
