How to fill values in the combo box dynamically

HCL Domino Domino Forum
1

Hi All,

I want to fill the values in the combo box by fetching data from database.

I am using Notes Database that is nsf file to store the data.

Can anybody help me in doing that using Lotus Script or Java Script?It’s urgent.

Thanks & Regards,

Kalyani A.

2

Subject: How to fill values in the combo box dynamically

Hi,

You don’t need to use LS or JS.

On the field you are trying to populate, set the properties (first tab) to ‘Dialog List’ and ‘editable’ and (second tab) to ‘use formula for choices’. Then use a simple dbcolumn lookup for the formula.

source := “Notes” : “No Cache”;

location := “”;

view := “viewname”;

colNumber :=1;

@DbColumn( source ; location ; view ; colNumber )

Check the help for more details.

Note: Make sure ‘allow values not it list’ is NOT checked of if you are using this form on the web.

hth

3

Subject: RE: How to fill values in the combo box dynamically

Hi!

Thanks a lot for your help!It worked

Kalyani