Latest Contributions by ZacharySutherby

Hello RTM RTM‌, Depending on the format of your customer records it would need to be appended to the Feature Service associated with your Survey123 survey.  One option would be to use the append tool in ArcGIS Online/Enterprise Portal: Manage hosted feature layers—ArcGIS Online Help | Documentation  Although the more pragmatic workflow would be to use the append Geoprocessing tool in ArcGIS Pro: Append (Data Management)—ArcGIS Pro | Documentation  If your customer data is a little more complicated with attachments and related records the following video may be helpful with the append process: https://www.youtube.com/watch?v=S5V6MIrAKCk&t=1s Thank you,  Zach  ... View more

Hello Brad,  I have tested the workflow and was able to reproduce the same behavior. The quick answer why nothing is being returned is because the string in the “where” parameter is incorrect. The string that I have gotten to work for generating a report against multiple OID’s was 'objectid=1 OR objectid=2'. In short the “where” parameter is looking for the same syntax as the Where clause when querying a layer from REST. If you enter Where: objected=1,2 from REST the request will return an invalid parameter error. If you use Where: objectid=1 OR objectid=2 the query will return both of those Object ID’s.   I had made one modification to the script for it to work in my environment which was to change the survey manager function to arcgis.apps.survey123.SurveyManager(gis) instead of SurveyManager(gis).   I have attached a copy of the script I have been testing with to the email in case it is helpful for testing. Thank you,  Zach ... View more

Hello Matt Creaney‌,  That is weird that no error message is obtained when submitting. If the behavior is still being encountered does the behavior occur with all people submitting the survey or just one person? Is the behavior observed on a specific OS (IOS, Android, Windows) or all OS's? Are you using ArcGIS Online or ArcGIS Enterprise? Is the device registered with an MDM or connected to a VPN when submitting?  A few troubleshooting workflows would be to grab the Survey123 diagnostic logs which can be enabled by opening the menu on the app's home page, select Settings, select the Diagnostics tab, enable logging. You can grab the logs from the device and see if there are any error messages there. Since no error is thrown I would think that there would not be much information in the logs, but something to double check.  The best way to see what the app is sending is to download a program called Fiddler, configure it to decrypt HTTPS traffic, and then configure it with the mobile device. This will show what the Field App is sending to the portal and confirm if those fields are populated or not. This will narrow the issue down to the Survey123 Field App, a firewall or environment issue, or the Web GIS infrastructure.  If the behavior is still happening I would recommend creating a ticket with Esri Technical Support and they will be able to assist grabbing this troubleshooting information and interpreting the results.  Thank you, Zach  ... View more

Hello Andy Heller‌,  Without really knowing what field types are in the repeats you can do something like if(${repeatAquestion} = ${repeatBquestion}, sum(repeatAquestion) + sum(repeatBquestion), or concat() whichever function is suitable for your data type, <whatever you would like returned>).  For example here is a quick sample that adds integers from two repeats together. If the sum's are equal the function returns the total sum other wise it says that they are not equal. I have attached the XLSForm for testing.  type name label calculation geopoint location location begin repeat repeatA Repeat A integer questionA QuestionA end repeat begin repeat repeatB Repeat B integer questionB QuestionB end repeat text calrepeats Cal Repeats if(${questionA}=${questionB},sum(${questionA})+sum(${questionB}),"these are not equal") Please use this link for reference regarding the if() sum() and concat() functions: Formulas—Survey123 for ArcGIS | Documentation  If possible would I be able to obtain a copy of your XLSForm and what fields would contain common values and I can modify my sample to fit you survey a little better.  Thank you,  Zach ... View more

Hello Wade, Bryan‌,  Assuming you are building your feature service's schema from Survey123 Connect and not creating a survey based on an existing service, one option would be to publish a survey that has two hidden questions one for submitted and one for reviewed. Since they are hidden questions they will be string field types by default but this can be changed in the bind::esri:fieldType column.  For the submitted question you can make the default answer 1 for yes, or 'True' however you would like to acknowledge the survey was submitted. For the reviewed question you can make the default 0 for no, or 'False'. Since they are hidden with a default answer whenever someone submits a survey those fields will always be populated.  You can then create a view of the feature service and create your review survey based on that view layer. The schema will come down and if you don't want the submitted question in the review survey you can remove that question. If you want the review question to be available for modification you can keep it as a text question or whichever field type is chosen. That way when you enable the Inbox on the review survey (assuming you are editing in the field app this is not needed if you are editing using the web form URL parameters), whoever is reviewing the survey can change the value from 0 or 'False' to 1 or 'True'.  Thank you,  Zach  ... View more

Hello Julia Surkis‌,  If you create, or modify, your survey in Survey123 Connect there are a large number of formulas that can be used to autopopulate fields.  Please use this link for reference regarding the available formulas in ArcGIS Survey123: Formulas—Survey123 for ArcGIS | Documentation  You can also view a large number of samples and community templates in Survey123 Connect that can help with identifying what can be done.  Another option since you said you would like to embed the survey in the Web App is to use the Survey123 Web Form URL parameters which can pass along attribute data to the survey when it is launched.  For example you can use ArcGIS Dashboards to edit survey responses within the dashboard: https://community.esri.com/groups/survey123/blog/2020/04/27/survey123-tricks-of-the-trade-embedding-a-survey-within-a-dashboard  Thank you,  Zach  ... View more

Hello Chris,  Thank you for passing along the XLSForm! I had tested in my ArcGIS Online organization with a test tpk and I was not able to reproduce the same behavior.  I was testing in ArcGIS Survey123 3.10.323 (EAC build) on an IOS device.  For the TPK was it created in ArcGIS Pro? If so is the file extension TPK or TPKX? If it is TPKX if you save it as a .TPK is the same behavior reproduced?  Does the TPK use the ArcGIS Online | Bing Maps | Google Maps tiling scheme?  I have attached my sample TPK for testing (you will likely need to search for Redlands, CA in the Geopoint's search bar) When you hit send there is no error message correct? In Survey123 Field App on the MySurvey's page if you select your profile icon on the top right > Settings > Diagnostics > Enable logging. If you grab the logs when you try to submit a survey are there any error messages in the associated log file generated?  Thank you,  Zach  ... View more

Hello tim dunlevie‌,  On the Android device in question is it only 1 survey that sees the behavior or all surveys? Is your WebGIS infrastructure ArcGIS Online or ArcGIS Enterprise? If ArcGIS Enterprise what version of Enterprise?  Additionally is there an MDM or VPN being used on the devices?  If you click on your little profile icon on the top right of the MySurvey's page and hit "Settings", at the bottom there is a Diagnostics option. If you click that, enable logging, and reproduce the same behavior, would I be able to obtain a copy of the logs when the behavior has been observed? If you don't want to share it on GeoNet feel free to pass it along to ZSutherby@esri.com and I will be happy to take a look into it.  Thank you,  Zach  ... View more

Hello Gavin Wepener‌,  I am glad the issue has been resolved! When publishing with a related table from any database management system as long as the database is a Geodatabase you should be able to publish a feature service with a related table.  Please use the second to last point in this documentation for reference: Prepare data to publish a feature service—ArcGIS Server | Documentation for ArcGIS Enterprise  As for the workaround with the attachments, when ArcGIS Survey123 3.10 releases the ability to add multiple photos to one image question will be supported. This can be done with the multiline appearance.  There are builds in the Early Adopter Community that can be used for testing.  Thank you,  Zach  ... View more

Hello Gavin Wepener‌,  If you are creating a survey from an existing feature service the repeats should automatically populate with the related tables on the service.  If you are trying to create a survey that matches an existing feature service the name of the repeat needs to match the name of the table from the REST endpoint.  For example in my test survey the name of my related table was TenEightDB.SDE.defects, when I created my survey based on that service that is the name that populated the repeat:  This matches what is present on the REST endpoint:  If you do not see your related table on the REST endpoint it may be likely the table was not present in ArcGIS Pro or ArcMap when publishing the data.  Thank you,  Zach  ... View more

Hello Jose Barrios‌,  One workflow would be to use the format-date() function to break out specific pieces of the dateTime question. If you don't want the result of the dateTime question in your feature service, and only the extracted sections you can make the dateTime question null under the bind:esri:fieldType.  Please use the table below for an example I put together (XLSForm attached as well):  type name label default calculation bind::esri:fieldType bind::type dateTime timeofsurvey Time of Survey now() null dateTime note datesection Date Section format-date(${timeofsurvey}, '%a %b %e, %Y') note timesection Time Section format-date(${timeofsurvey}, '%H:%M') I had made the questions that break apart the dateTime question notes to see what the result was in Connect, but if you don't want those pieces visible in the survey you can make them hidden so that only the dateTime question is visible in the survey. On the back end only the questions that are broken out are submitted to the feature service.  Please use the Date formatting section of this documentation for reference regarding all the qualifiers that can be used: Formulas—Survey123 for ArcGIS | Documentation  I know you mentioned you like the formatting of the dateTime question, an alternative workflow would be to use the date and time question types independently.  For the date question if you want the default to be now you can set the default to today() and for the time question you can set the default to now().    The XLSForm would look something like:    type name label default date insdate date today() time instime Time now()   Thank you,  Zach ... View more

Hello Arthur Kopelman‌,  Are you using ArcGIS Online or ArcGIS Enterprise? Depending on your Web GIS infrastructure the answer may vary.  If you are using ArcGIS Enterprise are you creating and publishing surveys based on existing feature services?  Are you publishing a hosted feature service with your survey?  If you are using a registered service the export capabilities are going to be managed from ArcGIS Server manager on the service level.   If you are using a hosted feature service on the Item Details page under the settings at the very bottom there should be an option to enable or disable "Export Data".  If you are unsure if the service is hosted or not the easiest way to tell is on the Item Details page Overview right next to the thumbnail it will say "Feature Layer (hosted)" if it is hosted if it does not have that (hosted) next to it the service may have been added to ArcGIS Online as an item or in Enterprise it is a registered service.  If the service is indeed a hosted feature service and the ability to Export Data is enabled from the settings page can you export from the Item Details page of the service?  To answer your question about ensuring export is enabled when creating a survey, the export capability is managed by the service and not Survey123.  There is not an option in the Publishing Options in Connect that will allow for enabling or disabling export it will be enabled by default.  When publishing from the Web Designer there are no publishing options like there is in Connect, but by default the root feature service and the stakeholder view will have the ability to extract enabled. The fieldworker view will not have the ability to extract enabled.  Please use this link for reference regarding the fieldworker and stakeholder views: FAQ: What are the Fieldworker and Stakeholder hosted views used for in Survey123?  Thank you,  Zach  ... View more

Hello Bradley,  On top of what James said here are a few additional resources that may help out:  https://community.esri.com/thread/213108-loading-survey13-data-with-related-tables-into-a-new-form#comment-765091  https://www.youtube.com/watch?v=S5V6MIrAKCk&t=1s I will be updating that How To article to include the ArcGIS Pro workflow.  Thank you,  Zach  ... View more

Hello Whitney Covill‌ You can directly pull in your Feature Service in ArcMap using this workflow: Adding data from ArcGIS Online—Help | Documentation. When you publish your Survey123 Survey, assuming you are not using an existing feature service, your survey will automatically publish up a Hosted Feature Service to either ArcGIS Online or ArcGIS Enterprise Portal.  When it publishes a folder is created in your content that contains the Form Item, Feature Service (and views as necessary), and maybe a Web Map if you published from Survey123 Connect.  As long as the settings on the Hosted Feature Service are set to "Allow others to export to different formats", you can export the data as a File Geodatabase. You can then connect to the File Geodatabase and see how ArcGIS Survey123 built the Schema, and you can model your schema that way.  Another way is in ArcGIS Survey123 Connect if you select your survey and hit "Schema Preview" you will see how everything in the resulting Feature Service is created:  Assuming when you mention the repeat function in ArcMap you are talking about Survey123 Repeats, repeats in ArcGIS Survey123 are either related tables or related feature classes depending if there is a geometry question present in the repeat or not.  Please use this link for reference regarding Repeats in ArcGIS Survey123: https://community.esri.com/groups/survey123/blog/2020/04/09/survey123-tricks-of-the-trade-repeats  Here is a handy resource regarding relationship classes in ArcGIS: https://community.esri.com/people/MKellyesri-ireland-ie-esridist/blog/2016/11/18/related-data-in-arcgis-online  If you are expecting your end user to be editing in ArcMap they can add content to the related records using the following workflow: Editing the attributes of related features—ArcGIS Help | Documentation  If you are expecting your end user to be editing in ArcGIS Survey123 accessing a survey you can publish your data and create the survey based on an existing Feature Service.  Thank you,  Zach  ... View more