XLS form: choice_filter and myfilter

Support
,
1

Hello,

I am working on my XLS sheet and I have a quesiton regarding the choice_filter and myfilter

This is what I have under the choices sheet:

list_name name label myfilter
fosa FOSA_1 CS d'UEBC Dagai TR_EN1
fosa FOSA_2 CS Disp. Dogba TR_EN1
fosa FOSA_3 CSI Dougoi TR_EN2
fosa FOSA_4 CSI Dargala TR_EN2
fosa FOSA_5 CSI OuroZangui I would like to have both

Is it possible for FOSA_5 to show for both TR_EN1 and TR_EN2?

Thanks

2

I think there's probably a more elegant way to do this but,
for your survey worksheet:

+-----------------+-------+------------+-------------------------------------+----------+
|      type       | name  |   label    |            choice_filter            | required |
+-----------------+-------+------------+-------------------------------------+----------+
| select_one tren | tr_en | select one |                                     | yes      |
| select_one fosa | fosa  | select one | myfilter=${tr_en} or myfilter='all' |          |
+-----------------+-------+------------+-------------------------------------+----------+

and for your choices worksheet:

+-----------+--------+-----------------+----------+
| list_name |  name  |      label      | myfilter |
+-----------+--------+-----------------+----------+
| tren      | TR_EN1 | TR EN1          |          |
| tren      | TR_EN2 | TR EN2          |          |
|           |        |                 |          |
| fosa      | FOSA_1 | CS d’UEBC Dagai | TR_EN1   |
| fosa      | FOSA_2 | CS Disp. Dogba  | TR_EN1   |
| fosa      | FOSA_3 | CSI Dougoi      | TR_EN2   |
| fosa      | FOSA_4 | CSI Dargala     | TR_EN2   |
| fosa      | FOSA_5 | CSI OuroZangui  | all      |
+-----------+--------+-----------------+----------+

Alternatively, you can keep your choice_filter as only myfilter=${tr_en} and duplicate the FOSA_5 option in your list options:

+-----------+--------+-----------------+----------+
| list_name |  name  |      label      | myfilter |
+-----------+--------+-----------------+----------+
| fosa      | FOSA_1 | CS d’UEBC Dagai | TR_EN1   |
| fosa      | FOSA_2 | CS Disp. Dogba  | TR_EN1   |
| fosa      | FOSA_3 | CSI Dougoi      | TR_EN2   |
| fosa      | FOSA_4 | CSI Dargala     | TR_EN2   |
| fosa      | FOSA_5 | CSI OuroZangui  | TR_EN1   |
| fosa      | FOSA_5 | CSI OuroZangui  | TR_EN2   |
+-----------+--------+-----------------+----------+
3

Thanks for your help Joseph