Latest Contributions by ZacharySutherby

Hello @mridul20, When you say survey123 services I assume you are talking about the feature services that are created when a Survey123 survey is published.  I would suggest reaching out to Esri Technical Support for assistance formatting your request to the REST endpoint of the service, as well as checking out the documentation for the specific request you are sending.  If you are trying to make a request to the Survey123 REST API (this is different from the REST endpoint of the feature service), please check out our REST API documentation.  Thank you,  Zach ... View more

@JakeMatthys,  Assuming the field that is being used for the select one question uses domain values the default value will need to use the domain code instead of the label, or from the XLSForm the choice name instead of the label.  Thank you,  Zach ... View more

Hello @EmilPerlt,  By default feature services created by Survey123 will use a composite relationship. Survey123 can work with both simple and composite relationship types the main thing that Survey123 requires is a GlobalID to GUID & 1:M relationship. If you would like to switch it to a simple relationship, unfortunately there isn't a way to do it directly in your organization. You would need to download the data as a file geodatabase and in ArcGIS Pro delete and recreate the relationship class using the other relationship type.  Since the relationship will be Global ID to GUID as long as the parent global ID and the value in the table for the parent global ID don't change, which deleting the relationship class and recreating it wont change global ID's. When the new relationship class is created the related records will be maintained.  Thank you,  Zach ... View more

Hello @KellyArmstrong,  If you're pointing the form_id to the related table you will also need to remove the begin and end repeat rows in the survey sheet. The only questions that should be in the survey sheet should be the questions that are in the table.  Please refer to the first six steps of this Tech Support KB article for the workflow.  Thank you,  Zach ... View more

Hello @ClintBoaz1,  The script is failing on passing along the size of the survey properties to the .update method. If you replace the surveyProp variable from the first parameter of the .update method and replace it with an empty dictionary {}. That should resolve the error message.  Thank you,  Zach ... View more

Hello @maplover,  The public status of the defect has been marked as implemented. Please feel free to reach out to Esri Technical Support and they will be able to assist with confirming the defect resolution.  Thank you,  Zach ... View more

Hello @KellyArmstrong,    If you navigate to the item details page of the feature service your survey is pointing to. At the bottom of the page there is a URL link, if you click the "view" button it will open the REST endpoint of the feature service in a new tab. On the page that it opens towards the top there will be a Layers section. Does the name of the layer with ID 0 match "table_name".  If not you will need to update the value you have in the form_id column of the settings worksheet in the XLSForm to match the name of the layer from the REST endpoint.  Thank you,  Zach ... View more

Hello @PrachiPatel,  Unfortunately Survey123 doesn't have an out of the box ABS function available, but there is a workaround. Please check out Ismael's comment on another post that discusses the workaround.  For the INT function, Survey123 has support for an int() function, please check out the XLSForm Formulas documentation for more information.  Thank you,  Zach ... View more

Hello @Lexicon1950,  Assuming you want your survey to only submit to the related table this Esri Support KB article will help you configure your survey to only point to the related table instead of the feature service.  Thank you,  Zach ... View more

Hello @Anonymous User,  To troubleshoot the issue would I be able to obtain a copy of the XLSForm & any CSV's used in the pulldata() function. Please feel free to pass them along to [email protected] and I'll be happy to look into it.  Thank you, Zach ... View more

Hello @ClintBoaz1,  In the path specified for the `download_folder` variable, if you navigate to that path is there a zip file with the same name as your survey in that location?  If not please double check the ID specified for the `itemID` variable is the item ID for your survey form item. For example:  You can also insert print statements in code block 4 to print the `itm` and `savedZip` variables which will show what item in your Organization will be downloaded, and where that item was downloaded to.  Thank you,  Zach ... View more

Hello @ClintBoaz1,  The Survey123 team has been working on updating the script to use Python 3 and the ArcGIS API for Python as that is the supported replacement for the arcrest module.  I have a copy of the updated script in another Esri Community comment that is intended to replace this script.  We are working on creating a central hub and documentation for a number of Python scripts the Survey123 has, but unfortunately isn't live just yet. Once that hub goes live we'll be updating the existing blog posts with the updated resources.  The updated script attached to the other Esri Community comment takes 6 variables. They are:  portalURL - The URL for your ArcGIS organization (in your case: https://gdrcnw.maps.arcgis.com) username - Your ArcGIS organization username (ex. gisadmin) password - You ArcGIS organization password (ex. gisadmin1) itemID - The item ID for the ArcGIS Survey123 form item in your ArcGIS organization (in your case: c2c2ab0e33aa4b518c4233bbed870c20) updated_files - The updated file name containing the extension (in your case: SiteInventory_SQLTableDownloadTest.csv) source_loc - Folder directory where the updated file is located (in your case //nwshfp01/arcgis/data/workingmapdocs/clint/forjarrod/output/)   The script will need to be run either in Jupyter notebook which ships by default with ArcGIS Pro, or can be run directly in ArcGIS Online if you have notebooks enabled for your account.  Thank you,  Zach ... View more

Hello @Anonymous User, Thank you for passing along the XLSForm! I have tested and was able to reproduce the same behavior on my end. There's a couple of things going on, but ultimately is a defect on our end. What's happening is after saving the survey as a draft the fist time, on the back end only the questions where data was recorded is stored. The issue is after saving the survey in the drafts for the second time all the questions are then stored on the back end and the ones that aren't answered have a "null" value associated with them. Since the choice lists are 0 based when the survey is opened back up the Field App is mistaking those "null" values as "0" and selecting the choices.  The workaround that worked on my end was to switch the choice lists from 0 based to 1 based (ex. 1:No, 2:Yes, 3:N/A). The issue (other than needing to update the form logic with the updated choices) is it looks like the survey was created based on a feature service pointing to an Enterprise Geodatabase feature class. After republishing the survey the domains in the Enterprise Geodatabase feature class will also need to be updated to reflect these changes.  We have an internal issue for the defect logged on our end but unfortunately it doesn't look like an official Esri Support BUG has been logged for the behavior just yet. I would suggest creating a ticket with Esri Technical Support to have the defect logged which will make it easier to track the status of the issue.  Thank you,  Zach ... View more

Hello @JoseVidal,  Thank you for passing along the XLSForms! I've tested on my end and I am not able to reproduce the same behavior:    The first thing that comes to mind is maybe when the original TestCalculation survey was published the option to Create coded value domains from choices may not have been selected.  In ArcGIS Online if you navigate to the Item Details page for the hosted feature service your surveys are pointing to > select the Data tab > Fields > select the Rating field > Does that field have a list of domain values?    Thank you,  Zach ... View more