Panel with conditional

[Anonymous]

Good afternoon,

EQUIPMENT have a table with fields:

n_Plaqueta	C_Descricao
1010	Computer
1011	Notebook

Another CALLED with the fields:

n_plaqueta	I_idChamado	D_chamados
1010	001	Maintenance
1011	002	Maintenance
1012	003	Maintenance

I need to change the color of the field or the cell-called platelets is not registered in the table equipment.

[sunny_talwar]

May be like this as your text color expression:

If(Len(Trim(Concat(DISTINCT C_Descricao, ','))) = 0, LightRed())

[Anonymous]

Check that the number of platelets that was entered in the table has called on the equipment table, if not it changes the color of n_plaqueta field in my table called does not have the description of the equipment.

[maheshkuttappa · Accepted solution]

Do the below changes in script (you can use Applymap which will be more efficient) 

A:

LOAD * INLINE [

n_Plaqueta,C_Descricao

1010,Computer

1011,Notebook];

B:

LOAD

*,

if(Lookup('n_Plaqueta','n_Plaqueta',n_Plaqueta,'A')=n_Plaqueta,1,0) as _Flag;

Load * INLINE [n_Plaqueta,I_idChamado,D_chamados

1010,001,Maintenance

1011,002,Maintenance

1012,003,Maintenance];

text color Definition:

If(_Flag = 0, LightRed())

• Panel with conditional