Select one cascade choice filter - make some choices relevant to more than one previous choice
Hi, I am looking for ways to make the choice list of the child select_one choice be relevant to more than one options selected in the parent select_one choice.
For example, I have the choice list of Site to be filtered by Location.
However, I would like to have the choices in Site to be filtered by more than one Location choice, example below:
So that 'Tomato' would be shown on the list when A is selected, and also show when C is selected. I've tried separating the parent choices with a comma as above but it doesn't work, and I've also tried separating with OR (e.g. A OR C) which did not work either. With both comma and OR, the choices list for Site was not displayed at all or the dropdown arrow was not offered (for autocomplete appearance).
Is this type of choice filter possible at all, and if so, how should I separate the parent choices? I've done google searches and community searches but haven't been able to find any mentions of anything similar.
Thank you!
Accepted Solutions
It's actually quite simple! Just add duplicate rows for the additional choices you'd like to include. Using the example you gave, it would look like this:
| List Name | Name | Label | Location |
| Site | 1 | Tomato | A |
| Site | 1 | Tomato | C |
To share a real-world example we use Surevy123 for an inter-departmental document workflow, and there are various combinations of choices in other questions that will depend on the status field. For instance, if the status is set to "Assessor Review", the review result field will only allow for the choices "Combination", "Good Legal", "Not GIS Relevant", or "Split", and will only allow the department field to be set to "assr".
It's actually quite simple! Just add duplicate rows for the additional choices you'd like to include. Using the example you gave, it would look like this:
| List Name | Name | Label | Location |
| Site | 1 | Tomato | A |
| Site | 1 | Tomato | C |
To share a real-world example we use Surevy123 for an inter-departmental document workflow, and there are various combinations of choices in other questions that will depend on the status field. For instance, if the status is set to "Assessor Review", the review result field will only allow for the choices "Combination", "Good Legal", "Not GIS Relevant", or "Split", and will only allow the department field to be set to "assr".
