Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to create dynamic variable which get current selection.
Than I want to use this variable in condition.
For example, if current selection = A, show green color, else gray.
=if(FieldName = My selection), rgb(139,191,31), rgb(124,124,124))
Thanks,
if(GetCurrentSelection(FieldName ) = A, rgb(139,191,31), rgb(124,124,124))
Hi Jose,
It should be dynamic selection.
It works well with replace bookmarks.
=if(Industries = only({BM03} Industries), rgb(139,191,31), rgb(124,124,124))
When I published it on web server, my bookmarks didn't work.
That's why I need to create dynamic variable.
Thanks,
well, create an entry box and use New Variable option and use this as the value:
=GetFieldSelections(FieldName)
=if(Industries =$(vVariable), rgb(139,191,31), rgb(124,124,124))
It doesn't work. I attached an example.
Take a look on this.
Is something like this or I´m missunderstanding?
I haven´t modified the expressions but you could use the variables
I have problem this expression.
I can't create right condition.
I create variable =GetFieldSelections(FieldName).
Cheers,
what's the problem exactly?
with this expression?
=if(Industries = $(vIndustry) ,rgb(139,191,31), rgb(124,124,124))
Yes, It doesn't reconize Industries.
I select from Industries =A.
My vIndustry shows Industries:A
And condition doesn't work. I think it should be like
=If( Industry (selected A)=$(vIndustry) (Industries:A), rgb(...)
It should compare apple to apple.
If I select indusry A, the vIndustry should be only A. In this case my expression works.
I hope you understand me.
Thanks,