Problem in column property 'Use value as color'

HCL Domino Domino Forum
1

I have made a profile document with three fields1. Background (Color Field)

  1. Text (Color Field)

  2. $ColorInUse (Formula Field) with formula

Background:Text

In the view, extreme left column is hidden, with ‘Use value as color’ checked and with programatic name ‘$ColorInUse’ and with profile name given.

But its not working.

Anyone with a clue for it???

2

Subject: Problem in column property ‘Use value as color’

Hi,

I faced the same problem and found out the following:

  1. The “Formula” field, $ColorInUse in your case, needs to be a regular text field. The value of this field needs to be a string evaluating to a formula

e.g. “Red := 255:0:0; Black := 0:0:0; @If(Status ="Draft";"”+ColorField1+“"; Status="Final";"”+ColorField2+“"; Black:Red)”

  1. The value of the color column ($ColorInUse) in the view needs to be @UserName. Any other formula will result in a view showing only replication of save conflicts.

I hope this helps.