Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the below statement
If(GetFieldSelections(MYField)='A' and GetFieldSelections(MYField)='B', 1,0).
So If I am making a selection A and B in MYField this statement is returning 0 means False. It works fine with or but my requirement is and
What am I doing wrong here
Maybe there is just some misunderstanding between the requirement und you ... For your descriped use-case OR will be correct. Otherwise you need to explain it a bit more.
- Marcus
May be try like? I did not try let me know if it works?
IF(GetFieldSelections(Match(MyField, 'A', 'B')), 1, 0)
Hi Rehan
If you are select both A and B then GetFieldSelctions(MyField) will return A, B so your test should be
If(GetFieldSelctions(MyField)='A, B',1,0)
Adrain
Try below expression
=if(Concat(MyField,'|')='A|B',1,0)
Doesnt work
Doesnt work
I can see that ur sample app it works, but its working on mine .
If(Concat([My Field],'|')='Golden Harvest West|Golden Harvest East',1,0)
Sorry its not working on mine
Hi Rehan
It works for me, please note that the values of A & B must be in Alphabetical order and there must be a space after the comma.
Try just putting the following in a text box and seeing what comes back
=GetFieldSelctions(MyField)
Adrian