Create a profile document and name it "WebLogProfile" form.
Create the four fields as follows:
Sender1B (Color type, Editable),
Sender1F (Color type, Editable),
Sender2B (Color type, Editable),
Sender2F (Color type, Editable)
Create a field named 'List2Field' as
computed -- do not make it multi-value.
Add the following formula:
database := @Subset(@DbName; -1);
server := @Name([CN]; @Subset(@DbName; 1));
Sender1List := @Sort(@Unique(@Trim(@DbColumn
("";server:database; "ColorP";1))));
GetSenderList := """ + @Implode
(Sender1List; "":"") + """; GetSenderList
Add a second field '$color1' as
computed -- do not make it multi-value.
Add the following formula, don't worry about tmpColorButton, it is a temporary variable:
@If(tmpColorButton = "1"; "";
"S_1B := "" + Sender1B + ""; S_1F :=
"" + Sender1F + "";
S_2B := "" + Sender2B + ""; S_2F :=
"" + Sender2F + ""; colr1 := S_1B
: S_1F ; colr2 := S_2B : S_2F ;
@If(@Modulo(@Member(DDHID ; "
+ List2field + ")
+ 1; 2) = 0 ; colr1;colr2 )")