Dialogue List Duplicates

HCL Domino Domino Forum
1

Hi all,

I have a dialogue list box called ‘Events’.

I already have inserted some options for the user to choose from and if the option they want is not there then they have the option of adding that to the list.

I was wondering whether there is a way of preventing any duplicates being entered into the list and also i would like it so that if a user enters the following option like “orange ball”, it would change to “Orange Ball”?

I hope that makes sense?

Any help would greatly be apreciated

Thanks

2

Subject: Dialogue List Duplicates

remove duplicates by placing @Unique around your formula for the choices displayed.

3

Subject: RE: Dialogue List Duplicates

Hi,

Ive tried that but Im still getting the occasional duplicates.

Here is my code…

@Sort(@Unique(@Trim(@ProperCase(@DbColumn(“”:“Nocache”;“”:“”;“va_eo”;1)) : " meeting 1" : " meeting 2 " : " meeting 3 ")))

Does this seem right to you?

Thanks

4

Subject: RE: Dialogue List Duplicates

looks fine to me. only thing I see off the bat is that you are not proper casing meeting 1 meeting 2 and meeting 3 so if you have a Meeting 1 in your DbColumn you will have a Meeting 1 and a meeting 1 in your list.

5

Subject: Dialogue List Duplicates

You could do a comparison between what was entered by the user and the existing list by applying @UpperCase to everything before the comparison

6

Subject: Dialogue List Duplicates

Hello Stabilio,As for ur second query. use @propercase when the value from the dialog list will get set in the respective field.