Selection In List Box Defined With An Expression

[ManiSK]

Month

Apr 2019

May 2019

Apr 2019|May 2019

I have above list box, now i need to create another list box with month names like below one.

Month names

Apr 2019

May 2019

So now here if i select Apr 2019 from (month names) list box, both Apr 2019 and Apr 2019|May 2019 should get selected from (month) list box and if i select May 2019, both May 2019 and Apr 2019|May 2019.

To achieve the above i tried with below conditions 

if (WildMatch(Month,'*Apr*'),'Apr 2019',
if (WildMatch(Month,'*May*'),'May 2019'))

but this works only for Apr 2019 and for May 2019 it selects only May 2019 not selecting Apr 2019|May 2019

could someone help me on this?

[jonathandienst]

Using an expression does not work here because when you click on the expression, you are really making a selection on the underlying field. The April/May value maps to April, it cannot map to May as well.

You need to do this in the load script to create a field associated correctly. For example:

Load * Inline
[
	Month, MonthName
	Apr 2019,Apr 2019
	May 2019,May 2019
	Apr 2019|May 2019,Apr 2019
	Apr 2019|May 2019,May 2019
];

[sultanam]

Hi Mani,

for achieving below you need to create a Variable in front end. try below one

vMonth = '*'  &  GetFieldSelections([Month names])  & '*'

Use trigger 

 setting>>Document>>Triggers>>Variable event trigger>> on change

Trigger: select in field 

Field 
Month

Search String
=vMonth

then you can select anything from Month name list box you will get your put.

let me know if you face any issue

[ManiSK]

Hi Sultanam,

Thanks for you response, tried with that but still not working, facing the same issue.

[sultanam · Accepted solution]

Hi Mani,

please find the attached file as reference. If you face the same issue let me know.

[ManiSK]

It worked perfectly . Thank you so much

[ManiSK]

Hi Sultanam,

I have another query regarding triggers.

In my dashboard, i have multiple containers so now i want to use triggers in containers, is that possible?

Thanks,

[sultanam]

Hi Mani

As per my knowledge there is no option to use trigger on container.

If you have any query kindly post here i will try to help you on that.

Regards,
Sultan