Color coded calendar entries

HCL Domino Domino Forum
1

Hi all,

I have created a new view, set up the form selection formula and

designed all the columns. Then i have changed the view type from

standard to calendar.

I have a vacation field in form which has 2 entries :

           1. Sick

           2. Holidays

So, whenever i create a new vacation request of type “Sick” then the

calendar entry should be in blue color and for “Holiday” it should be

in black color.

So, my doubt is about color code the entries based on the field type.

Is it possible to do ?

The database is normal database, is there anything to do with it.

Please help me on this regard.

Kiran.

2

Subject: An example

  1. Create a hidden “Use value as color” column to the LEFT of the columns you want to color code.2. Write the column’s formula similar to the following example:

gray:=239:239:239;

yellow:=255:255:208;

green:=224:255:223;

blue:=224:255:255;

red:=255:64:64;

white:=255:255:255;

black:=0:0:0;

none:=-1:-1:-1;

@If(RequestStatus=“Draft”;yellow:none;

RequestStatus=“Waiting for First Level Approval”;gray:none;

RequestStatus=“Waiting for Second Level Approval”;gray:none;

RequestStatus=“Approved”;green:none;

RequestStatus=“Waiting for Trip Report”;green:none;

RequestStatus=“Complete”;blue:none;

RequestStatus=“Denied”;red:white;

RequestStatus=“Cancelled”;black:white;

none:none)

The first color in each list is the background color. The second color is the text color.

3

Subject: RE: An example

Lawrence, thanks for your idea. Yesterday after i posted, i had a look at “Use value as color” option. But after writing the code i passed the field name (on last line for which i wanted the value for that column).

So that made the difference. Thanks for your help.

Kiran :slight_smile: