Dialog list

HCL Domino Domino Forum
1

Hi guys Im new to lotus…im doing lotus support work for our client…3 dialog list was created…each refreshing when selection is made from the other…problem is, im not getting the expected result from the third dialog list…plz help

2

Subject: dialog list

Ronald, we need more information to be able to help. What’s the code you use to generate choice list? What are the field names? What is the result you are expecting?

3

Subject: RE: dialog list

dialog list #1Name: WWBU

choices: temp:=@Trim(@Unique(@DbColumn(“”:“NoCache”;“”;“DEVIVNWBUPAY”;1)));

@If(@IsError(temp);“”;@Trim(@Unique(temp)))

dialog list #2

Name: Pays

choices: temp:=@DbLookup(“”:“NoCache”;@DbName;“DEVIVNWBUPAY”;WWBU;2);

temp2:=@If(@IsError(temp);“Choose a WWBU”;@Unique(temp));

@If(WWBU=“”;“Choose a WWBU”;temp2)

dialog list #3

Name: BU

choices: temp:=@DbLookup(“”:“NoCache”;@DbName;“DEVIVNWBUPAYBU”;WWBU+“##”+Pays;2);

temp2:=@If(@IsError(temp);“Choose a country”;@Unique(temp));

@If(pays=“”;“Choose a country”;temp2)

flow of application:

  1. dialog list # 1 will be the only list with choice (many choices)

  2. select from dialog list #1 (select only 1, for the meantime)

  3. dialog list #2 will be dynamically filled up

  4. select any choices from dialog list #2(you can select as many as you want)

  5. dialog list #3 choices will depend what you select on dialog list #3

the problem:

  • the problem arises when you select 3 or more choices on dialog list #1

  • when i selected 3 or more choices on dialog list #1, and also 2 more more choices on dialog list #2, dialog #3 only shows 1 choice, where in fact, it should show many choices

please help guys, thanks

4

Subject: RE: dialog list

to my knowledge @dblookup does not return values from multiple keys. When you choose multiple values on dialog list, the key becomes a text-list.

You might want to use some hidden fields to store your choice lists and a lotusscript for onchange of your dialog lists to set the values on the hidden fields.