Please Help: Dialogue List: Reputition of data

HCL Domino Domino Forum
1

Hi,

Im pretty stumped. I have a Dialog list field that allows the users to select from the list as well as add new options to the list. However, for some reason when adding a new option, it seems to repeat and add it twice.

In the control tab of the field properties, I have used the following formula in the choices section…

@Sort(@Unique(@DbColumn(“”:“Nocache”;“”:“”;“va_lookupopt”;1)) : “Example1” : “Example2” : “Example3”)

I cannot understand as to why the new options are being repeated. Any suggestions?

Thank you in advance

2

Subject: Please Help: Dialogue List: Reputition of data

hard coded bit means the text that you typed in, that is the all the ‘example’ strings

so this update should help

@Sort(@Unique @trim((@DbColumn(“”:“Nocache”;“”:“”;“va_lookupopt”;1) : “Example1” : “Example2” : “Example3”)))

3

Subject: RE: Please Help: Dialogue List: Reputition of data

Hi,

Thank so much

4

Subject: Please Help: Dialogue List: Reputition of data

Include your hard coded list within @Unique formula. You also might want to Trim the values as well:

@Sort(@Unique(@Trim(@DbColumn(“”:“Nocache”;“”:“”;“va_lookupopt”;1)) : “Example1” : “Example2” : “Example3”))

5

Subject: RE: Please Help: Dialogue List: Reputition of data

Hi,

Sorry I am new to lotus notes. Could you explain what you mean by “hard coded” bit?

Thanks