Picklist command

HCL Domino Domino Forum
1

Hi,

Here is another problem for you.

I have a form with a field (which I call “X”) of type Dialog list / editable.

On the control pane of the field’s properties, I choose “Use formula for choices” and in the choices, I typed the following formula:

@PickList([Custom]:[Single];“”;“BrancheActivite”;“Branches d’activités”;“Choisissez une branche”;1)

This formula should open a modal dialog list based on the view named “BrancheActivite” when I click on my field “X”.

But this dialog list appears immediately when the form opens and not when I click on my field “X”.

Before using the @Picklist command, I used the option “Use View dialog for choices” in the control pane. And it worked well.

What’s happening ?

Thx for your help.

dd

2

Subject: Picklist command

You can’t use a picklist in a dialoglist.

Instead, you have 2 possibilities:

  1. create a button with the picklist, to fill out the (text) field

field x := @picklist(…);“”

  1. use a @dblookup/column to populate your choices. If BrancheActivite is the name of your view, do something like:

@iferror(@dbcolumn( “” ; @dbname ; “BrancheActivite” ; 1 );“error”)

instead of your picklist.

And read the designer help.

cheers,

Tom