Anyone have success with the view color formula?

HCL Domino Domino Forum
1

I’ve successfully setup a color profile form and view column as per the help docs, but I cannot get the colors to work on a condition. I’m using a simple formula:

@if(Item=“T77628”;color1;color2)

(I know the colors work, because I set color1 as the formula result and I get all docs in that color)

The help is confusing when it comes to the conditional formula, in one place it states:

@If (category = “cats”;blue:red ;subcategory = “collars”;pink;subcategory =“leashes”;black:plain;0:0:0);

…so, it uses the normal syntax, but in another place, it says:

@If(dialog =“"giraffe";”+“"”+GiraffeColor+“"”+";

(dialog="koala");“+”"“+KoalaColor+”"“+”;PaleYellow:DkGreen)")

…so it looks like the syntax should have an extra set of quotes for the condition.

Of course, I cannot get either syntax to work. In fact, when I look at my mail db, the profile formula is commented out - so I don’t even have a working reference. Help, please?

2

Subject: Solution: View color formula in profile form

Hi Robert

In your profile form you have to provide a text field that combines quotes and one or two color field values.

Example:

2 color fields in profile form:

  • ColorBG

  • ColorText

1 computed text field with the following formula:

{“} + ColorBG + {”:“} + ColorText + {”}

Alternative (if you don’t like braces):

“"” + ColorBG + “":"” + ColorText + “"”

Note that this string is not a list but a string containing a colon. That means the text field must not be a multivalue field.

HTH

Bodo