I am trying to use selections made in a select multiple field (field 1) to populate another field (field 2) that uses the same list without those selections (from field 1) showing. I already am using a cascading select to filter down the list based on a name. I cannot figure out the following:
- Can it be done? (and how)
- How to structure the choice list statement for field 2 (that is already referencing a cascading select for name) to show items from the list that meet the name criteria, but also are all the values that are not selected in field 1.
Quick rundown of what I'm trying to accomplish:
Joe's tracts: 1, 2, 3, 4, 5, 6
Marnie's tracts: 7, 8, 9, 10
survery1
Name: Joe
Field 1: tract 1, tract 2, tract 3
Field 2: tract 4, tract 5
survery2
Name: Marnie
Field 1: tract 7
Field 2: tract 8, tract 9, tract 10
UPDATE:
- This survey will be public
- this survey will need to accessible both in the web form or S123 app
- Authoring the survey in S123 connect.