Latest Contributions by Jim-Moore

‎01-16-2020

Hi Michelle When working on a CSV in Excel, it can enclose text strings in double quotes " " (particularly if the string contains spaces). The quote mark used in the string (used for inches) could be confusing things. Try opening the CSV in a text editor to see if it shows something like "CROSS PLATE ANCHOR 24""". A simple fix would be to find/replace all the triple quotes with double quotes in the text editor. Hope this helps Best, Jim

‎01-16-2020

Hi Michelle To store your favorite answers, the survey must be submitted (i.e. saved to the Sent box) or saved to Drafts. A couple of things to note: a sent survey cannot be used for favorite answers if the Sent box has been disabled (in which case you can use a draft); and favorite answers cannot be saved for some question types. Please see the documentation for more info: Quick reference—Survey123 for ArcGIS | Documentation Best, Jim

‎01-08-2020

Hi Eric Just to confirm, when you say the string is being truncated are you referring to an existing string when editing an existing record from the Inbox? Do you receive an error on submit? When submitting the survey does the string get truncated in the feature service, or is the truncation only visible in the form? Could you please provide screenshots and your XLSForm so I can try to reproduce what you're seeing? Also which version of the Survey123 field app and Connect are you using? Thanks, Jim

‎01-08-2020

Hi Joshua The question shown in your screenshot is a Multiple Choice question with horizontal or horizontal (compact) appearance. When configuring a multi choice question in the web designer you can specify the appearance and also choose to allow "Other": Hope this helps Cheers, Jim

‎01-05-2020

Hi Jeremy Launching a survey in the field app or web app from a URL will usually open a new survey - that is, to collect a new feature (in this case, a new parcel polygon). However, it is possible to edit an existing feature in the web app using the mode=edit URL parameter. The web app needs to know which feature you wish to edit; this is specified using the additional objectId parameter. This editing method is explained in detail in this handy blog (including instructions for launching an edit from a pop-up in a web map): https://community.esri.com/groups/survey123/blog/2019/05/24/survey123-tricks-of-the-trade-editing-records-in-a-web-form Editing in the web app is also documented here: Edit existing survey data—Survey123 for ArcGIS | Documentation More on URL parameters for the web app here: https://community.esri.com/groups/survey123/blog/2019/02/06/survey123-tricks-of-the-trade-web-form-url-parameters Regarding your second query - the field: parameter will not work with mode=edit and is not supported for questions in a repeat. If the APN is stored in the parent layer, one option would be to make the APN question in the repeat read-only and use a calculation to make it inherit the APN from the parent. Hope this helps, Cheers, Jim

‎01-05-2020

Hi Alex The way you had nested the if statements in your original post looks correct, besides the syntax for the and function and the missing false argument for the final if statement. As a simple example: if(${fruit}='banana','yellow',if(${fruit}='apple','green',if(${fruit}='strawberry','red','no fruit selected'))) Hope this helps Cheers, Jim

‎01-02-2020

Hi Jeremy The parent layer and its related table(s) can be in the same survey form. In your XLSForm, the related table fields are accessed through questions placed inside a repeat section (denoted by begin repeat and end repeat). The questions outside of this repeat section relate to fields in the parent layer. Please see our documentation on repeats: Repeats—Survey123 for ArcGIS | Documentation Survey respondents could browse the parcels from the Inbox, open the relevant record and add new repeats (i.e. add records to the related table) or optionally edit existing repeats, while also updating the fields in the parent layer. Please see this documentation about editing existing survey data via Inbox (includes section on repeats): Prepare for editing existing survey data—Survey123 for ArcGIS | Documentation Cheers, Jim

‎01-02-2020

Hi Alex If statements require three arguments: a condition; the result if the condition is true; and the result if the condition is false. It looks like the final false argument is missing (i.e. what to return if all conditions are false). Also, the XLSForm syntax for and statements is to use the word "and" between two expressions. For example: ${homelessness}='1to2yrs' and ${mhDis}='Yes' XLSForm functions are detailed here: Formulas—Survey123 for ArcGIS | Documentation Hope this helps. Cheers, Jim

‎01-01-2020

Hi Jeremy From your description and screenshot, it appears your feature service is using the 'APN' text field for the relationship. To work with Survey123, relationships must be based on Global IDs. Please find feature service prerequisites and other useful info here: Use Survey123 with existing feature services—Survey123 for ArcGIS | Documentation And also described in this detailed blog: https://community.esri.com/groups/survey123/blog/2017/09/25/working-with-existing-feature-services-in-survey123-for-arcgis Hope this helps. Cheers, Jim

‎12-23-2019

Hi John Here are a couple of ways to do this (there are probably several more!). Write a nested if statement calculation for the county question (if email equals this, county equals that, etc.). This could be in a hidden/text question (wouldn't need to be a select_one). If you haven't got many email addresses, this would be fairly straightforward, but might get a bit cumbersome if there's a long list of emails/counties. Put each email address and its county in a CSV file and use pulldata() to lookup the county from the CSV. For more info on using pulldata with CSV please see: https://community.esri.com/groups/survey123/blog/2016/10/27/the-pulldata-function-access-external-data and Formulas—Survey123 for ArcGIS | Documentation. Again, the pulldata calculation could be in a hidden/text question. Then your city choices can be filtered as normal based on the county. Hope this helps! Cheers, Jim

‎12-18-2019

Hi Lisa One way to achieve this would be to use substr() with nested if statements. Luckily in this case you only have three scenarios (i.e. one-, two- or three-digit number) so the calculation shouldn't be too cumbersome! Check the postion of the "-" separator to work out how many digits, then return the first 1, 2 or 3 characters as applicable. For example: if((substr(${address1},1,2)='-'),substr(${address1},0,1),if((substr(${address1},2,3)='-'),substr(${address1},0,2),if((substr(${address1},3,4)='-'),substr(${address1},0,3),''))) Alternatively, you could use regular expressions in each if statement to match the pattern. For more info on regex please see: Formulas—Survey123 for ArcGIS | Documentation. Hope this helps Best, Jim

‎12-17-2019

Hi Michael Sounds like this is being caused by the data validation on the appearance cell (or column). You could try selecting the appearance column, then removing the data validation by setting it to allow any value (data validation settings are on the Data ribbon in newer versions of Excel). Note that this will remove the drop-down options (however, as as reference all available appearances are listed on the types sheet). Alternatively, you could download the latest advanced XLSForm template in Connect as a starting point and build your survey from here; the advanced template has data validation rules for certain columns to assist you with your selections, but it should allow you to override the rule after displaying a warning. Some handy info on grid theme available here: https://community.esri.com/groups/survey123/blog/2019/11/20/survey123-tricks-of-the-trade-groups-grids-and-pages Appearance—Survey123 for ArcGIS | Documentation Best, Jim

‎12-17-2019

Hi Sean Just to double-check, has the revised survey been downloaded again in the field app since it was updated? Changes to Inbox settings, etc. won't be reflected in the app unless the survey has been downloaded again. Also, can you see the existing records when viewing the survey data on the Survey123 website (Data tab)? Best, Jim

‎12-17-2019

Hi The date filter uses the CreationDate field, which is a system-managed field added to a feature layer or table when editor tracking is enabled (in addition to Creator, Editor and EditDate). To enable editor tracking, select the Keep track of who created and last updated features option. See the ArcGIS Online documentation for more info: Manage hosted feature layers—ArcGIS Online Help | Documentation Editor tracking is enabled by default for a feature service created when a survey is published from Survey123 Connect or the web designer. Best regards, Jim

‎12-17-2019

Cheers Luke, great to hear it's working now.

Online Status	Offline
Date Last Visited	2 weeks ago

My Ideas

Latest Contributions by Jim-Moore

Re: Formatting Question

Re: Survey123 3.7.57 isn't showing paste favorite answers

Re: Survey123 app truncating string field from 254 to 3 characters

Re: Would someone point me in the right direction to configure this style of "grid" in my web based Surveys?

Re: Survey123 version 3.7.62 (Unsupported relationship type)

Re: nesting if AND formula in XLSform.

Re: Survey123 version 3.7.62 (Unsupported relationship type)

Re: nesting if AND formula in XLSform.

Re: Survey123 version 3.7.62 (Unsupported relationship type)

Re: Survey123 Connect - Cascading Sheets

Re: Basic substr string parsing question

Re: Survey123 grid theme issues

Re: Trying to access existing data in the field app using the Inbox, but none of the existing data is showing up.

Re: Cannot Query by Date Range

Re: What is the best method to automate the download Survey123 data?

Re: Calculating Hours between two Time questions

Re: Survey123 videos on mediaspace site presenting...

Re: Select_Multiple conditions

Re: Survey123 Report Template Error

Re: Multiple-page Survey123 form