How is a Selected List Item Used to Select the Next List to Display?

vocono1953

Hi. I’m working on a Surver123 Connect project. My experience developing apps is as a programmer and have no experience working with ESRI products.

What is needed is to use the selected ‘ListTaskType’ to display ListTask. Two lines from the survey sheet:

select_one list_task_type	ListTaskType	Types of Task
select_multiple list_task	ListTask	Tasks

 

I’m not certain how (in)correct the above is, but the followings choice sheet probably incorrect:

list_task_type	0	Hort Area
list_task_type	1	Greenhouse
list_task_type	2	Lawn/Turf
list_task_type	3	Other Tasks

 

if (${ListTaskType}=0) then
0	0	Clean
1	1	Prune
2	2	Plant
3	3	Water

 

if (${ListTaskType}=2) then
	0	Aerate
	1	Amend soil
	2	Manage Pests
	3	Mow

 

The IF statement is in the wrong column—don’t know where it goes. Not certain if the operator $ is correctly used. Tried to Google smaller questions with no good result.  Thank you for any help you offer.

--Bob

LaurenceTait

What you need is cascading select: https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformcascadingselects.htm. You need to add another column to your choices tab that tells the app which task is relevant to which task _type, and then add an expression to the [choice_filter] column of the survey tab to tell the app what to filter on.

Example attached below

Form 6.xlsx