Color code the emails based on a field value(along with sender colors)

[SatishBolla]

Hi,

We have an urgent requirement where we need to color code an email sent as Urgent. From what I know, I did the following:

1. Created a hidden field "Urgent" whose value is 0 in the "Memo" form.

2. Created a button in the memo form which sends the email normally while setting the value of the "Urgent" field as 1.

3. I tweaked the code in the $Sender1 field of the "CalendarProfile" form as below:

S_0B1 := \"00FF0000\";
S_0F1 := \"00FFFFFF\";
color01 := S_0B1 : S_0F1 ;

@If(
@IsAvailable(Urgent) & Ugent=1; color01;
@Contains(LCfrom; list1) & list1 != \"\"; color1;......

It is of no use. Then tried the below.

4. In the $Inbox folder, added the below line in the first column "ColorColumn(Hidden)"

@If(Urgent = 1;255:0:0:255:255:255;@UserName)

Still, I couldn't see any difference. Can someone point out what I'm doing wrong and what should have been done?

Thanks & Regards,

Satish.

[anon-1145]

Hope below helps:

1. Modify the column value formula as @If(Urgent = "1";255:0:0:255:255:255;255:255:255:1:1:1)

Here "1" is missing in @If

2. Now ensure to check the hidden column formula property as "Use value as color".

[SatishBolla]

Hi Pravin,

Thanks for the reply. However, the Urgent field is just a number field, so the value still stands as 1 only. I just opened the Preferences, changed the sender colors to default and then my code worked. Strange but true.