Text object change color when value get associated

[Anonymous]

hello everyone

In below, i used Action>select in field on text object. my query is when i select abc from  emp_name list box that time text object will show as a active as below.

Thank You.

[neha_shirsath]

[mdmukramali]

Hi,

even you can try this one also:

for BPO:

=if(Concat(Dept,',')<>Concat({1}Dept,',') and Index(Concat(Distinct Dept,','),'BPO')>=1,Green(),RGB(213,238,248))

for IT:

=if(Concat(Dept,',')<>Concat({1}Dept,',') and Index(Concat(Distinct Dept,','),'IT')>=1,Green(),RGB(213,238,248))

[Anonymous]

It works fine but when i select  aabb from BPO & abc from IT then it shows like inactive .

my requirement is when i select both value then it change with green color.

[mdmukramali]

Hi,

Final Try:

for BPO:

=if((Concat(Dept,',')<>Concat({1}Dept,',') and Index(Concat(Distinct Dept,','),'BPO')>=1)

OR

(GetSelectedCount(Dept)>=1 and Index(Concat(Distinct Dept,','),'BPO')>=1)

,Green(),RGB(213,238,248))

For IT :

=if((Concat(Dept,',')<>Concat({1}Dept,',') and Index(Concat(Distinct Dept,','),'IT')>=1)

OR

(GetSelectedCount(Dept)>=1 and Index(Concat(Distinct Dept,','),'IT')>=1)

,Green(),RGB(213,238,248))

[neha_shirsath]

Add the below condition in your text box expression-

=if(GetSelectedCount(EmpName)>1,Concat(Dept,chr(10)),Dept)

[Anonymous]

hello neha

when i select BPO text object it shows IT details and same with IT text object but when i select values from list box then it works fine.

[sasikanth]

Try with below expressions

For BPO:

=IF( SubStringCount(Concat( Dept,'|'),'BPO') >0 and GetSelectedCount(EmpName)>0 ,Green())

FOR IT:

=IF( SubStringCount(Concat( Dept,'|'),'IT') >0 and GetSelectedCount(EmpName)>0 ,Green())

[neha_shirsath]

Hi, what is issue now?