SQL Condition to Change Tab Colour

Rahul

Hi Experts

I have created a B1 Validation Configuration and couple of Universal Function Configuration, but it doesn't seem to work and I can't figure out what the problem is. Still learning 

The aim is to change the color of the word Content in Content tab in the Activity window to RED if it contains some text

My B1 Validations is as below:

SELECT CASE WHEN Notes IS NOT NULL THEN 'RED' ELSE 'BLACK' END FROM OCLG

Form Type: 651

Form Mode: All

Even: Form Load

I have two Condition result with the below Function to execute

RED - UF-68

BLACK - UF-69

 

UF-68 has the below Macro

Click($[$24.0.0]); ForeColor($[$24.0.0]|RED); Click($[$65.0.0]);

UF-69 has the below Macro

Click($[$24.0.0]); ForeColor($[$24.0.0]|BLACK); Click($[$65.0.0]);

But it doesn't seem to be changing colors as expected

What am I missing???

Please help

 

Comments

0 comments

Please sign in to leave a comment.