Combobox vs. Default Value vs. DbColumn

HCL Domino Domino Forum
1

Hi there,

in my client form I created a combobox - editable to display values from another database. I use “Use formula for choices” and the following formula:

@DbColumn( “” : “” ; “Server/GROUP”:“DIR/db1.nsf” ; “MyView” ; 1 )

Works fine except that the first line is blank. Is there a possibility to display the first entry from the db as a default value so the combobox is not blank anymore.

Thanks for any help

Holm

2

Subject: Combobox vs. Default Value vs. DbColumn

You’d have to repeat the @DbColumn formula in the default value section and take the first element if the result (e.g. using @Subset). Since @Db functions are relatively costly (even if cached), it might be worth it to keep a computed for display multi-value field on your form, that does the @DbCloumn and then reference this field from your other formulas.

3

Subject: SOLVED: Combobox vs. Default Value vs. DbColumn

Thank you Harkpabst for the quick reply: just for the following generation

Modify the “Default Value” in the object field and use formula

@subset(@DbColumn( “” : “” ; “Server/GROUP”:“DIR/db1.nsf” ; “MyView” ; 1 );1)

to get the first entry.

That’s it.

Holm