Dynamic Dialog List via user selection

HCL Domino Domino Forum
1

Good Day Folks,

I am attempting to have a dialog list adjust based on the users prior selection above or above the point they are at in the process. The Formula I am using is as follows:

choiceall := M2 +“:”+MU2_1 +“:”+ M2_1_1;

In:=“302 S|302” :“305 A|305”:“306 F|306”:“309 R|309”;

Out:=“308 C|308”;

@If(Site=“In”;List:=“302 S|302” :“305 A|305”:“306 F|306”:“309 R|309”;List:=“308 C|308”);

@If(@Contains(choiceall;“302”);@Replace(List;“302 S|302”;“”);

@Contains(choiceall;“305”);@Replace(List;“305 A|305”;“”);

@Contains(choiceall;“306”);@Replace(List;“306 F|306”;“”);

@Contains(choiceall;“309”);@Replace(List;“309 R|309”;“”);“”);

@Unique(List)

Please point me in the right direction… Especially if you have a better way of doing this… This is ugly…

PS. IBM… Let me put LS or Java in the Dialog List Formula section… I would have been done hours ago…

2

Subject: Dynamic Dialog List via user selection

Dropped the @Unique List and all is well…

Why you Lotus… I’m gonna get you…

3

Subject: Multiple Dynamic Dialog List via user selection

Here is the modified Formula that was used with the inclussion of a field named List.

choiceall := MU_2 +“:”+MU_2_1 +“:”+ MU_2_1_1;

In:=“302 S|302” :“305 A|305”:“306 F|306”:“309 R|309”;

Out:=“308 C|308”;

@If(Site=“Inbound”;List:=“302 S|302” :“305 A|305”:“306 F|306”:“309 R|309”;List:=“308 C|308”);

@SetField(“List”;List);

@If(@Contains(choiceall;“302”);@SetField(“List”;@Replace(List;“302 S|302”;“”));List);

FIELD List:=List;

@If(@Contains(choiceall;“305”);@SetField(“List”;@Replace(List;“305 A|305”;“”));List);

FIELD List:=List;

@If(@Contains(choiceall;“306”);@SetField(“List”;@Replace(List;“306 F|306”;“”));List);

FIELD List:=List;

@If(@Contains(choiceall;“309”);@SetField(“List”;@Replace(List;“309 R|309”;“”));List)

Hope this helps somene else…