|
BLOG
|
Survey123 is a very popular ArcGIS App for the Field and I'm always looking for new ways to work with it - to make sure it's delivering value for my users. Previously I've looked at applying a custom Other field and in this blog I investigate making survey results easier to analyse, or symbolise, when a survey includes the Other functionality. If you're not aware, the Other functionality allows users to enter an Other value as an answer to a multiple choice question, if the answer they need is not in the list. This has been implemented for the question What is the property type?: This functionality is awesome, but the Other value that a user inputs is assigned to a new field in the attribute table. This means it can be hard to analyse and query this question later on because the answers for one question are spread over two fields: Here's a method to collate these answers to one field, making it easier for end users to view and query the data. So instead of the answers looking like the above example, they will look like this: If you need some help setting up a Survey123 survey, check out the help videos and pages. This blog assumes you have a survey set up using the Survey123 Connect for ArcGIS desktop application with at least one select_one type question. The blog is split into 2 sections to cover different methods used to implement Other If you are using the or_other method, look at Section 1. If you are manually adding Other as a choice option, look at Section 2 If you are working with choice names that include spaces, step 5 in Section 2 covers this. Please note: the methods described below will only work in the Survey123 survey. If you edit the data in the ArcGIS Online map viewer or in Collector for ArcGIS, the changes won't automatically be reflected. Section 1 1) Browse to the select_one question you have set up with or_other: In the background, Survey123 creates a new field to hold the Other value entered by the end user. The name of this field is usually the name of the select_one field followed by ‘_other’. In the example above, the new field created for the is called PropertyType_other (you can also find this field name by looking in the Schema Preview in the Survey123 Connect for ArcGIS desktop application). 2) Create a new text question under the select_one question (this is for testing, later this field will be of type hidden). Name and label it something like this: 3) Now you need to create an if statement to determine what value is written to this new field. This if statement will be entered into the calculation field. The if statement for this survey will be: if(${PropertyType}='other', ${PropertyType_other}, ${PropertyType}) It’s important that 'other' is all lowercase as this is what Survey123 will recognise in this case. In simple terms: if the PropertyType question answer is ‘other’, then assign the PropertyType_other value to this field. Otherwise assign the PropertyType value to this field. The survey will look like this: 4) Save the Excel spreadsheet and preview the functionality in Survey123 Connect: 5) When you’re happy with the survey, head back to Excel and change the type of question to hidden for PropertyTypeCollated: This means that this question will be hidden from end users in the Survey123 app, but will be available for you later on. So you can display it in a pop up or use it as a field for analysis/querying. **Hidden fields are not currently supported in the Survey123 website (http://survey123.arcgis.com) but has been added as an enhancement request. 6) Your survey is now ready to be published and used on a mobile device. Section 2 1) Browse to the select_one question you have set up with Other as a choice option: 2) Create a new text question under the select_one question. This will be the text field to hold the Other - SurveyType answer. Name and label it something like this: 3) Now you need to create an if statement to determine what value is written to this new field. This if statement will be entered into the calculation field. The if statement for this survey will be: if(${SurveyType}='Other', ${SurveyTypeOther}, ${SurveyType}) This Other is looking at the name column in the choice list. In simple terms: if the SurveyType question answer is ‘Other’, then assign the SurveyTypeOther value to this field. Otherwise assign the SurveyType value to this field. The survey will look like this: 4) Save the Excel spreadsheet and preview the functionality in Survey123 Connect: 5) You may notice above that if you choose Health and Safety as the answer, the SurveyTypeCollated field has the text HealthandSafety. This is because Survey123 pulls the text from the name column and not the label column: We can expand the current if statement to compensate for choices that include spaces/characters by nesting the if statements: if(${SurveyType}='HealthandSafety', 'Health and Safety', if(${SurveyType}='Other', ${SurveyTypeOther}, ${SurveyType})) In simple terms: if the SurveyType question answer is ‘HealthandSafety’, then assign ‘Health and Safety’ to this field, if the SurveyType question answer is ‘Other’, then assign the SurveyTypeOther value to this field. Otherwise assign the SurveyType value to this field. More information about nested if statements can be found here but please note that Survey123 does not need the statements to begin with '='. 6) Save the Excel spreadsheet and preview the functionality in Survey123 Connect. 7) When you’re happy with the survey, head back to Excel and change the type of question to hidden for SurveyTypeCollated: This means that this question will be hidden from end users in the Survey123 app but will be available for you later on. so you can display it in a pop up or use it as a field for analysis/querying. **Hidden fields are not currently supported in the Survey123 website (http://survey123.arcgis.com) but has been added as an enhancement request. 😎 Your survey is now ready to be published and used on a mobile device. Collating answers to one field will make creating queries, filters, applying symbology and running analysis easier! This post was originally shared on the Esri UK blog: GeoXchange — Esri UK. It's also a valuable source for posts on other ArcGIS topics by other Esri employees, check it out!
... View more
12-11-2017
01:03 PM
|
8
|
18
|
13990
|
|
POST
|
Hi Erik, Do you have an Insights licence assigned to you? What happens if you remove the licence? Does this happen for other users in your organisation? It might be worth contacting the Tech Support team for your region - there might be a setting on your account that needs to be changed. Carmel
... View more
12-08-2017
09:12 AM
|
0
|
0
|
1533
|
|
POST
|
Hi Joe, When you changed the name in Settings > General, did you republish the survey? Another way to do it is to edit the name of the Form item in Content. Carmel
... View more
12-08-2017
09:08 AM
|
2
|
1
|
1465
|
|
POST
|
Hi there, Where are your videos hosted? What happens if you try and add a video manually?: What browser are you using? Carmel
... View more
12-08-2017
09:00 AM
|
0
|
4
|
1767
|
|
POST
|
Hi Aaron, This should work by using a mask: Esri custom columns—Survey123 for ArcGIS | ArcGIS Entering something like >XXXXXXXXX will allow a 9 character string with all letters capitalised If serial numbers vary in length you may need to make changes to allow for this. If the serial numbers are consistant, you could use something like this for the mask: >XXXX-XXXX Hope that helps! Carmel
... View more
12-08-2017
08:49 AM
|
0
|
2
|
3209
|
|
POST
|
Are all the users in the same ArcGIS Online organisation? If they are editing a layer, the new information will be found in this item, not under their username Content. Open the web map that they are using in Collector and check to see if their information is shown either spatially on in the attribute table Carmel
... View more
12-08-2017
08:39 AM
|
0
|
1
|
1088
|
|
POST
|
Hi Erik, Does this happen even when you're in Content? Do you have any Marketplace apps added to your organisation? Does this happen in all browsers? Carmel
... View more
12-08-2017
08:35 AM
|
0
|
2
|
1533
|
|
POST
|
Hi there, Have either of you found a solution for this? Carmel
... View more
12-05-2017
08:24 AM
|
0
|
0
|
2461
|
|
POST
|
Hi there, I don't think this is possible, but there might be a way to combine your existing application with the one downloaded from Github by using the ArcGIS Online Assistant to view the app's JSON. Carmel
... View more
12-04-2017
08:19 AM
|
0
|
0
|
877
|
|
POST
|
Hi Ethan, Arcade might help you: Use Arcade Expressions to Map Your Ideas | ArcGIS Blog The blog covers using it in ArcGIS Online but it's also available in ArcGIS Pro. Carmel
... View more
12-04-2017
07:43 AM
|
0
|
0
|
3733
|
|
BLOG
|
Hi Brent, Excellent, glad you've found that functionality too! I've documented in a post on our site (Making Other Work Harder in Survey123 Results — Esri UK ) which will also be published to GeoNet soon It's such a useful step in making your results usuable post survey!
... View more
12-04-2017
12:47 AM
|
1
|
0
|
9526
|
|
BLOG
|
Survey123 is an easy way to create new surveys or replace existing paper-based surveys because of the flexibility of its functionality. One example of this flexibility is the ability to allow users to enter an Other value as an answer to a multiple choice question if the answer they need is not in the list. This has been implemented for the question What is the property type?: In the background, Survey123 creates a new field to hold this Other value entered by the end user. The default name of this field is the name of the select_one field followed by ‘_other’, and the alias for this field is ‘Specify other.’. This means you aren’t able to define your own alias to the question in the survey and, if this is repeated functionality, you can end up with multiple fields with the alias ‘Specify other.’. I'm going to show you an alternative method of setting up an Other option using the question What type of survey is this?. This post assumes you have a survey set up using the Survey123 Connect for ArcGIS desktop application, with at least one select_one type question. If you need some help setting up a Survey123 survey, check out the help videos and pages. 1. Find the select_one question you want to implement Other for: 2. Navigate to the corresponding list for this question in the Choices sheet: 3. Add Other to the SurveyType list: You have the flexibility of giving a more descriptive option for users here like: 4. Create a new text question under the select_one question. This will be the text field to hold the Other answer for SurveyType. Name and label it something like this: 5. Next we need to make this question optional, so it only appears if the end user selects Other for the SurveyType question. For this example, enter ${SurveyType}='Other' in the relevant column: 6. Save the Excel spreadsheet and try out the functionality in Survey123 Connect for ArcGIS. 7. When you’re happy with your survey, publish it and see it in action! This post was originally shared on the Esri UK blog: GeoXchange — Esri UK. It's also a valuable source for posts on other ArcGIS topics by other Esri employees, check it out!
... View more
12-01-2017
01:51 AM
|
9
|
10
|
16726
|
|
POST
|
Hi Melissa, Glad you've found it - yes I've only found that option in Map Journals and no other story map templates. If this is something you think you'd encounter again, it might be worth posting it as an idea here: https://community.esri.com/community/arcgis-ideas - Ideas are regularly implemented to ArcGIS Online, considering it's updated so often Carmel
... View more
11-15-2017
07:46 AM
|
0
|
0
|
2580
|
|
POST
|
Hi Melissa, What do you see if you click on the Organize button in your screenshot? Carmel
... View more
11-15-2017
07:23 AM
|
1
|
2
|
2580
|
|
POST
|
Hi Jamal, What version of ArcGIS Pro are you using? Do you have any edits that need to be saved? Are the tools greyed out with all the map frames? If you click 'Activate', are you able to change the map extent/zoom? Carmel
... View more
11-15-2017
03:23 AM
|
2
|
3
|
7761
|
| Title | Kudos | Posted |
|---|---|---|
| 1 | 08-24-2023 07:58 AM | |
| 1 | 08-31-2023 12:51 AM | |
| 1 | 08-25-2023 04:17 AM | |
| 1 | 08-29-2023 01:44 AM | |
| 1 | 08-25-2023 04:24 AM |
| Online Status |
Offline
|
| Date Last Visited |
a week ago
|