Dialog List - adding or remembering entries

HCL Domino Domino Forum
1

I have a dialog list in a form. I have ticked the box to allow users to enter values not in the list. Does anybody know if it’s possible to get Notes to remember these entries ?

For example. List may contain “UK, France, Holland”, if a user enters “Germany”, I would like all future users to be able to select this from the list instead of having to enter it manually.

Thankyou !

2

Subject: dynamic lists for keyword fields

This functionality has been around a long time in the Discussion template. See the Main Topic form, Categories and Web Categories fields; and the “By Category” view.

I prefer to create a hidden view that lists the values entered for the field; col 1 will be the values in alpha sort order.

lookupView := “(country)”;

list := “UK” : “France” : “Holland";

listLookup := @Unique(@DbColumn(“”:“nocache”; “”; lookupView ; 1));

choices := @Unique(@Trim(@Sort(list : listLookup)));

choices

3

Subject: Thanks !

I’ll give it a go. Many thanks for the prompt reply !

4

Subject: Working great thanks - code attached

Many thanks, working perfectly. Here’s the code I used :

lookupView := “(PFSO Lists)”;

list := “UK”:“France”:“Holland”;

listLookup := @Unique(@DbColumn(“”;“”:“”;lookupView;1));

choices := @Unique(@Trim(@Sort(list : listLookup)));

choices

5

Subject: dynamic list for keyword field

glad to help. But, I forgot to include an catch for error in the dbColumn lookup:

lookupView := “(PFSO Lists)”;

list := “UK”:“France”:“Holland”;

varList := @Unique(@DbColumn(“”;“”:“”;lookupView;1));

listLookup := @If(@IsError(varList);@Return(“”);varList);

choices := @Unique(@Trim(@Sort(list : listLookup)));

choices