Latest Contributions by ZacharySutherby

Hello @AldousTsang,  Downloading the data as a file geodatabase is definitely a feasible workflow for taking a backup of your data. We have a notebook present in our Survey123 tools GitHub repo all about working with survey data, and can be scheduled to download your survey's data as a file geodatabase periodically.  My colleague James has also created a python script that if you have an Enterprise Geodatabase can be used to copy the data from your Survey123 survey to your Enterprise Geodatabase.  Please use this link to access James' Esri Community blog on the workflow: https://community.esri.com/groups/survey123/blog/2016/12/14/migrating-data-from-the-survey-feature-service-to-an-enterprise-geodatabase Additionally if you are using an Enterprise Geodatabase you can use a webhook to automatically post your new survey submissions to your Enterprise Geodatabase.  Thank you,  Zach ... View more

Hello @Giscol,  Thank you for reaching out! In translating the post I am unsure if there is a question or you are passing along a workflow. If you are passing along a workflow please feel free to use the Survey123 blog's to convey workflows and information others may find helpful!  Thank you,  Zach ... View more

Hello @KerryKang,  I would suggest taking a look at the Query feature service/layer documentation as the where parameter in the request is going to be very important when using attribute data.    I've attached a sample that uses the public facing COVID layer to do an attribute query using a Survey123 JS function. The main difference from the sample that is in Survey123 Connect is you don't need to work with the geometry, you can pass in the information for the fields you would like to use for the lookup. For example in the sample passed along we use state and county to extract the record from the feature service.  Thank you,  Zach ... View more

Hello @DataOfficer,  From the video it looks like you are selecting the return key on the devices keyboard which by default will navigate to the next question in the form's "tab order". We have an internal issue logged to be able to specify that order.  What you can do to avoid the behavior is either tap off the question instead of selecting the return key, or since it looks like you are on Android if your device has a back button you can select that. On IOS you can also tap off the question, or swipe down on the keyboard.  Thank you,  Zach ... View more

Hello @EricaCirigliano,  Adding @IsmaelChivite for visibility.  In looking at Supports database it looks like the previous defect you may be referring to is BUG-000120594, which was implemented in Survey123's 3.10 release and nested repeats can be submitted in the web form using the current 3.12 release.  Please feel free to message me directly at [email protected] and we can set up a call to discuss issues encountered and the defect logging process.  Thank you,  Zach ... View more

Hello @EricaCirigliano @DougBrowning,  I'm not seeing the behavior on my end, would I be able to obtain a copy of an XLSform that's reproducing the behavior?    Typically choices will be ordered the same way they are in the choices worksheet. Here is a sample XLSForm that I was testing with where I'm not seeing the behavior.  Thank you,  Zach ... View more

Hello @JohnWatson_EBA,  It seems the return column and lookup column are flipped in the pulldata() function. I had switched it to pulldata('Doyle', 'diameter_logs', 'Volume', number(${diameter_logs})) and that worked on my end.  I had added the number() function to ensure that the value passed in matches what's in the CSV.  As a note, not all number combinations return a value for example selecting Doyle, 15, 2 returns a value, but Doyle, 15,1.5 doesn't return a value because 16.5 doesn't exist in the Volume column.  Thank you,  Zach ... View more

Hello @DonovanC,  Depending on your ArcGIS Enterprise configuration if your ArcGIS Enterprise deployment is accessible over the internet (you don't need a VPN to access the environment) you could take the REST endpoint of your ArcGIS Enterprise feature service and add it as an item in ArcGIS Online. You could then point the survey to the feature service created in ArcGIS Online and data collected will be available in your ArcGIS Enterprise deployment.  If your ArcGIS Enterprise deployment is not accessible over the internet you can use a Python script to periodically copy survey data from ArcGIS Online to a feature class in an Enterprise geodatabase that's published to your ArcGIS Enterprise deployment.  Thank you,  Zach  ... View more

Hello @BryceHancock,  Thank you for passing along the XLSForm! In taking a look into the form the field used for the cascading select is using a SQLite reserved keyword (group) which conflicts with the database approach we switched to with the 3.12 release when managing choice lists.  I had switched the field name to sp_group and that is working on my end.  Thank you,  Zach ... View more

Hello @DougBrowning,  I would suggest reaching out to the folks on the ArcGIS Field Maps community to dig deeper into the issue, or create a case with Esri Technical Support and they will be able to take a look into the issue.  Thank you,  Zach ... View more

Hello @MillerDerek,  Thank you for confirming. Prior to cloning, both workflows in the notebook print the items that are going to be cloned. Are you seeing the hosted feature service in that list of items that will be cloned? Are you seeing any error messages in the script after the clone function finishes?  If you are, are you seeing the hosted feature service created in your ArcGIS Online content, just the link between the form item and the hosted feature service seems to be broken, or is the hosted feature service not present in ArcGIS Online at all?  If the hosted feature service isn't present in ArcGIS Online at all here is a mini python script that you can use to clone just the hosted feature service and see if that works.  Thank you,  Zach ... View more

Hello @srikanthnamburi3,  Can you please elaborate some more on what isn't working? What was returned in the report vs what are you looking for the report to return?  Please use this link for the documentation on printing reports: https://doc.arcgis.com/en/survey123/browser/analyze-results/printsurveyresults.htm#ESRI_SECTION1_2A4C07143C8E4147A1FEC9478D22206A Thank you,  Zach ... View more

Hello @MillerDerek,  Cloning from an internal Enterprise organization to ArcGIS Online is a supported workflow. Are you using a registered feature service with your survey (is the service pointing to an enterprise geodatabase)? On the item details page of the Form item created in ArcGIS Online there will be a Layers section halfway down the page. In that Layers section does it have the link to the hosted feature layer in your ArcGIS Online organization? Thank you,  Zach ... View more

Hello @PaulCone2,  Here is the link to the blog post which contains the updated script. We also host the script and a number of others on our Survey123-tools github repo.  As for working with SSO orgs the script uses the ArcGIS API for Python for authentication, please use this link for their documentation on working with different authentication schemes. You would need to create an application in your organization and use the client ID from that application in your GIS connection.  Thank you,  Zach ... View more