1. On the Options tab of the View Properties box, the "Allow customizations" option is checked.
2. The first column of the view, named PD1 has the following options set on the Column Info tab of the Column Properties box:
Purple := 128:0:128;
Blue := 0:0:128;
DkGreen := 0:160:0;
Brown := 130:66:0;
PaleYellow := 255:255:208;
Tan := 224:161:117;
DefaultColor := 0:0:0;
Use this color for Koala: [ Koalacolor]
Use this color for Giraffe: [Giraffecolor]
Formula for view to read from profile doc: [PD1 ]
Note Koalacolor and Giraffecolor are color fields which automatically present a color picker to the user. The PD1 field is critical -- PD1 is the name of the field and the programmatic name of the column in the view/folder that uses the profile document. This field ties the profile document to the column.
@If(dialog ="\"giraffe\";"+"\""+GiraffeColor+"\""+"; (dialog=\"koala\");"+"\""+KoalaColor+"\""+";PaleYellow:DkGreen)")
Note In this formula the color fields, KoalaColor and GiraffeColor, return RGB color coordinates. These values needs to be passed to the parser as a string -- thus the double set of quotes around the field names. If the formula just specified "GiraffeColor", the quotes would be stripped off during parsing, and the result would be a numeric coordinate instead of a string list. Therefore, the formula uses the backslash and the quotation mark (\") to pass the quotation mark (") to the parser as a character. If you are experiencing problems with a formula, check that your quotes are done correctly.
See Also