nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Data Consistency with wide range of values in Survey123 and Dashboard

JoshBillings

Hey all,

I have a survey that feeds into a Dashboard for Events that are occurring in our Recreation and Parks department. On the dashboard, one of the selectors is "Age Group." Within the survey, the "Age Group" is formatted as a text question. Staff enter age group as "7-12" etc. I instruct staff in the survey to only use numbers but staff still type more than necessary sometimes.

I am trying to get staff to not enter any text (such as "years" or "years old" as seen in the picture attached) but can't use predefined answers due to the age groups being so different for each type of event. At the same time, "All Ages" must still be an option to enter.

Do you all have any suggestions on how I can maintain data consistency in Survey123 when staff enter in the Age Group while still being able to use Age Group as a category selector in the dashboard?

Dashboard.png

abureaux_26-1714160118097.png

Find more posts tagged with

Accepted answers

Jim Moore

Hi @JoshBillings in addition to Doug's suggestions, one other option could be to have two integer questions where staff can enter min & max ages, then have a hidden text question that concatenates these into an age range string, e.g. "7 - 12". You could precede this with a select_one that has two choices, e.g. "All ages" or "Specific age range", with the min/max integer questions relevant based on the selection. You could then use an if() statement in the hidden text question to set the string to "All ages" or the concatenated age range.

Best, Jim

All comments

dougbrowning

Take a look at input masks

https://doc.arcgis.com/en/survey123/desktop/create-surveys/esricustomcolumns.htm

Also a list would work if you have set groups.

Hope that helps

Jim Moore

Best, Jim

JoshBillings

Yes @Jim-Moore , this would work great!

I am running into an issue when I publish it though.

In Survey123 Connect, everything seems to work fine.

However, when I publish this, the Minimum and Maximum Age selections don't show up when Specific Range is selected. Any idea why this could be?

Jim Moore

Hi @JoshBillings thanks for the screenshots. Not sure what's causing the NaN error in the web app without seeing your XLSForm, but please see example survey attached demonstrating one way to set up the questions. The calculation for age group uses the if() and concat() functions to return the formatted age range.

If you don't want to store the min/max age fields in the feature layer you could set bind::esri:fieldType to null for these questions.

Hope this helps! Best, Jim

Age_Group_Example.xlsx

JoshBillings

Thanks @Jim-Moore! My error was in the "relevant" field. This works!

One final thing. I would like my Age Groups to be able to sort based on number value. Because I have text in my Age Groups (ie. 18 and over, All Ages), the field is a text field and is sorting it like text. Any work around for this?

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.