APPLICATION DESIGN


Designing a form that lets users make selections from a view
You can design a form that uses @PickList to display a list of choices from a view.

1. Create a form.

2. Create a button, hotspot, or action to store the @PickList formula.

3. For an action, choose View - Action Pane and then click the action. For button or hotspot, click the form and then click the button or hotspot.

4. In the Objects tab on the Info list in the Programmerfs pane, select the Click method for the button, hotspot, or action.

5. In the Script area of the Programmer's pane, make sure you have selected Run - Client - Formula.

6. Write a formula using @PickList and the [Custom] parameter, unless you want to use [Name] to display an IBMR LotusR Domino(TM) directory or personal name and address book.

7. Close and save the form.

Using @PickList

The @PickList function looks up the values in a view as @DbColumn does, but lets the user pick a value from one document. This function is similar to using @Prompt in a form, but is specifically for use with views.

@Picklist offers the following advantages over formulas that use @DbColumn or @DbLookup.


Example

This formula displays the Products view of PROD.NSF in a dialog box:

choice:=@PickList([Custom] ; "":"prod.nsf" ; "Products" ; "Select a product" ; "Please select the products you want to order" ; 1 );

See Also