I know images are not there I don't know why. Anyways I have done the same thing and that is working fine but the issue is i need to selec multiple values at a time and second condition is that in Customer field there are customers which have lenghty names. as I have mentioned already
for Product I am using like this
and for Customer I am using like this
because if i will use the above Syntax thn trigger will not work. and in this situation if I am selecting both Product and Customer at same time and aftere selection i want to remove for ex customer from the selection so out of 3 Customer only one Customer will get deselected and rest will remain selected. Is there any solution.
First of all sorry for the late reply, I have tweaked the earlier provided formulas a little to solve the long names and spaces between the names issue , I hope it helps
as you can see the symbol " has been added in the expression.
Also find attached a demo with the name '3 Mic Mini Max'
TEST.qvw 134.8 K