Latest Contributions by ZacharySutherby

Hello Federico Riet Sapriza‌,  One option would be to use the Survey123 custom JavaScript Pulldata() functions to hit a lunar phases API.  I have attached a sample that hits a weather API based on a Geopoint location. The sample may be able to be modified in which the survey will pass along a date and the JavaScript function will hit a lunar phases API to return the phase for that date.  In researching it seems that NOAA has an API that may be able to be used to extract this information.  Please use these links for reference:  php - Lunar Phase API - Stack Overflow  Astronomical Data - NOAA Tides & Currents  Another option is to potentially use the NOAA information above and create a CSV file with dates and phases for some period of time in the future and use the pulldata() function in your survey to grab those values.  Thank you,  Zach ... View more

Hello Joe Michael Cornely (MDPR)‌,  Geometry can not be modified once a survey is published using the Web Designer. If you would like to change the geometry captured in the survey you can download the survey in Survey123 Connect and change the geoshape (polygon) question to a geopoint (point) or geotrace (line) if you like.  Please note through that this change will delete the hosted feature service associated with the survey and recreate it to accommodate for the new geometry type. If there is data in the existing survey that you would like to keep please download the feature service as a file geodatabase before making the change in Survey123 Connect and overwriting the survey. It will likely not be a simple append to add the records back onto the survey as the geometry is different. Depending on what new geometry is chosen you may need to convert the polygons to centroids (points) or polylines to append the data to the new service.  Thank you,  Zach  ... View more

Hello bob wright‌,  You can side load a survey by creating a folder in the My Survey's folder on whichever device you have the Survey123 Field App installed on. The folder will be named the item ID for the form item for example c195e79b35cb4cabb42dafe01d17c083. Then create a new folder inside that folder named esriinfo. Finally copy all of the files from the "My Survey Designs" folder where Survey123 Connect is installed (I didn't include the media or debug folders when testing the workflow because my sample survey did not utilize those folders. If you survey does utilize those folders I believe you would copy them as well). Copy those files into the esriinfo folder that was previously created. The files should include:  <surveyName>.info <sureyName>.itemInfo <surveyName>.png <surveyName>.webform <surveyName>.xlsx <surveyName>.xml <surveyName>.json Thank you,  Zach  ... View more

Hello Kevin Burkman‌ You can add your text question and in the relevant box put something like selected(${question2c},'q2cdepgeohum').  I have attached a test XLSForm to take a look and test it out.  Thank you,  Zach ... View more

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