Latest Contributions by ZacharySutherby

Hello @Cyprus_Forest_Department,    With 3.12 we are introducing support for indexed repeats. Please check out this EAC documentation for more information on the updates. Specifically I think the `position(..)` function may help with calculating the repeat title.  Another option that currently works in 3.11 is to add a hidden question in the survey with the default value of 1, then add a calculate question that uses once(count(${default1Question})) and that will return the current repeat instance.  Thank you,  Zach ... View more

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 ... View more

Hello @LeeIrminger1,  Apologies for the delay in reaching out! I wouldn't expect it to be something with the CSV formatting but it could very well be a formatting issue. To remedy that  resaving the CSV's using UTF-8 may help if it is a formatting issue.  I know you had mentioned that the CSV was present in the media folder upon publishing, just to confirm the CSV isn't also hosted in your organization and linked to the survey correct?  If I could obtain a copy of the XLSForm and CSV's I can do some testing on my end and see if I can reproduce the behavior. Feel free to send them to ZSutherby@esri.com if they are not able to be passed through the thread.   Thank you,  Zach ... View more

Hello @LeeIrminger1,    To confirm was the CSV present in the Media folder upon initial publishing, or is the CSV hosted in ArcGIS Online and linked to the survey using the workflow outlined in this EAC documentation?  If the CSV is only present in the Media folder and not linked to the survey I would not expect this  behavior as I did not see the behavior when I had tested on my end. If the CSV is linked to the survey there may be something different going on.  If the CSV is only present in the Media folder the Survey123 website should be making a request for item and pulling from the response of that request.  If you navigate to:  https://www.arcgis.com/sharing/rest/content/items/<FormID>/info/media/<CSVName.csv?token=<accessToken> Does this download the most recent version of the CSV?  If you capture the web traffic when loading the web form you will also see that same request in the web traffic. Is the response of that request the updated choices or the old choices?    Thank you,  Zach ... View more

Hello @LeeIrminger1,    We are in the process more formally presenting python scripts and will be updating that Esri Community blog post shortly.  In the meantime we have updated the Update Media Folder script to use the ArcGIS API for Python.  I have attached a zip file that contains a Jupyter notebook and .py file that use the updated workflow.  I have just tested the same workflow using the script in the zip file attached and I was not able to reproduce the same behavior.  If you test updating the CSV using the script in the zip file is the same behavior observed?    Thank you,  Zach ... View more

Hello @raybricedev,    From the error message it looks like Survey123 is having an issue identifying the parent layer related to the T12_Construction_Contractor table.  Does that table happen to have multiple layers related to it or another tertiary layer or table related to it?    If possible would I be able to obtain a copy of the File Geodatabase with the layers and tables for testing on my end?    If you don't want to share it over Esri Community feel free to email it to my Esri email ZSutherby@esri.com.    Thank you,  Zach ... View more

Hello @GarrettRSmith,  One consideration to keep in mind is how repeats are stored when the survey is published. When you publish a survey that includes repeats, each repeat will be created as a related table in your feature layer, or a related layer if your repeat contains a geopoint, geotrace, or geoshape question. So when designing your form just keep that in mind as it will impact the schema of the service that is created in your Organization.  To answer your last question, to my knowledge there is not a limit for the amount of repeats that can be submitted. If you have a repeat and a field worker needs to submit 20+ additional locations they can submit however many they need.  If you are looking to limit the number of repeats that can be submitted you can specify a repeat_count in the XLSForm as that will limit the max number of repeats that can be submitted.  As for designing the schema that is up to you one option would be to keep it the way you have it, add a yes_no select_one question that asks if the field worker would like to add more locations and if 'yes' is selected the repeat can be relevant based on selecting 'yes' and display the restoration, restorationlocation, and restorationnotes questions within the repeat.  One note about that workflow is you would then have a layer related to a layer where the first layer would contain the single repeat question, and the second layer would then contain all the additional repeated geopoints in their own records.    Another option would be to only have the restoration, restorationlocation, and restorationnotes questions in a repeat. What you could do is create a geopoint outside of the repeat, make it hidden, and set the bind::esri:fieldType to null. When you publish this survey only the repeat questions are in a layer and the questions outside of the repeat are in a table. I have attached a sample XLSForm with this setup.  Here are a few other Esri Community posts that may also help: https://community.esri.com/t5/arcgis-survey123-questions/multiple-geopoints-in-survey123/td-p/826769 https://community.esri.com/t5/arcgis-survey123-questions/multiple-geopoint-questions/m-p/820908 https://community.esri.com/t5/arcgis-survey123-questions/capturing-location-several-times-in-survey123-form/td-p/769092   Thank you,  Zach ... View more

Hello @AndrewPadilla @DougBrowning @OrrinBabcock,    We have created an internal issue for this behavior. I would suggest contacting Esri Technical Support and they will be able to log an official BUG for the behavior which will allow for tracking progress on the issue.    Thank you,    Zach  ... View more

Hello @CherylWheeler2,  On top of what Ruth suggests another workflow would be to use the Search() appearance which we currently have support for in our 3.12 beta builds.  The Search() appearance lets your query existing Feature Services to see if there is a spatial overlap.  Please check out our Early Adopter Community for more information on using the Search() appearance in your survey.    Thank you,  Zach ... View more

Hello @ulb,    Typically the "Maximum record count" refers to the number of features that can be returned in a single request and is usually used in the context of service performance. I haven't heard it used in a record submission context before.    When you say species and variables is that referring to related records (repeats), or choices in a choice list? Unless the survey was quite large with a lot of choices (thousands to hundreds of thousands of choices in the choices sheet) and repeats etc. I wouldn't expect 44 records with repeats to cause the app to crash.    Would I be able to obtain a copy of the XLSForm I can test on our end and see if we can reproduce the same behavior?   Since the app was deleted all associated files with the app were also deleted so performing root cause analysis would be impossible.    The recommended workflow when failures occur is to recover the data from the device prior to troubleshooting that way a backup of the data has been maintained.    Thank you,    Zach   ... View more

Hello @ScottStanton__GISP,    I have tested the arcade expression on my end and I was not able to reproduce the same behavior on my IOS 14 device.   If you temporarily change the link's text to the Arcade expression in the pop up, in Collector do you see the XY information or is it missing from the pop up in Collector?    One option you can try is encoding the XY information, something along the lines of:  function MetersToLatLon(x, y) { // Converts XY point from Spherical Mercator EPSG:3857(Web Mercator Auxiliary Sphere) to lat/lon in WGS84 Datum (EPSG:4326). // Source: http://www.maptiler.org/google-maps-coordinates-tile-bounds-projection/ var originShift = 2.0 * PI * 6378137.0 / 2.0; var lon = (x / originShift) * 180.0; var lat = (y / originShift) * 180.0; lat = 180.0 / PI * (2.0 * Atan( Exp( lat * PI / 180.0)) - PI / 2.0); return [lat, lon]; } function CreateURLSurvey(lat, lon) { var url = "arcgis-survey123://?itemID=<surveyid>"; url += "&field:name1=" + $feature["name1"] + "&field:name2=" + $feature["name2"]; url += "&field:name_new=" + $feature["name_new"] + "&field:rel_globalID="; url += $feature["GlobalID"] + "&callback=https://collector.arcgis.app" + "&center="; var loc = lat + "," + lon; Console(url); return url + UrlEncode(loc); } var latlon = MetersToLatLon(Geometry($feature).X, Geometry($feature).Y); var url = CreateURLSurvey(latlon[0], latlon[1]); return url;   Thank you,    Zach   ... View more

Hello @AlainMunyaneza1,    Can new records be added to the service through a Web Map or Web App in the ArcGIS Enterprise Portal? If new records can not be added to the service through ArcGIS Enterprise Portal Survey123 won't be able to add those records either.    If you grab the diagnostic logs, as well as the ArcGIS Server logs are there any additional error messages in the logs?    Worst case scenario the data can be recovered from the device and after some modifications should be able to be submitted from a desktop machine.    Thank you,    Zach   ... View more

Hello Marcus Klatt‌,  It looks like the request for Item ID 6e96f6dec.... is not being found. If you copy that Item ID and search for it in your content or if you are not the survey owner search for it in your Organization. Does that Item ID return a Form Item or Hosted Feature Service?  Thank you,  Zach ... View more

Hello Taylor Schyrbiak‌,  Sweet I am glad that worked out! Unfortunately with the Survey123 Power Automate connector monitoring for updating records is not enabled by default.  - Zach ... View more