FORMULA LANGUAGE


@PickList
Example

Displays a modal window that contains either:


Syntax

@PickList( [CUSTOM] : [SINGLE] ; server : file ; view ; title ; prompt ; column ; categoryname )

@PickList( [NAME] : [SINGLE] )

@PickList( [ROOM] )

@PickList( [RESOURCE] )

@PickList( [FOLDERS] : [SINGLE] ; server:database )

@PickList( [FOLDERS] : [SHARED] ; server:database )

@PickList( [FOLDERS] : [PRIVATE] ; server:database )

@PickList( [FOLDERS] : [NODESKTOP] ; server:database )

Parameters

[CUSTOM]


[NAME]
[ROOM]
[RESOURCE]
[FOLDERS]
server : file
view
title
prompt
column
categoryname

Note This parameter is new with Release 5.


Return value

columnValue


Usage

This function is useful in button, manual agent, paste agent, form action, and view action formulas. It does not work in column, selection, mail agent, scheduled agent, hide-when, window title, or form formulas.

Although @PickList([CUSTOM]) operates similarly to @DbColumn and @DbLookup, @PickList is preferable because it:


@PickList doesn't offer a NoCache option like @DbColumn and @DbLookup because lookup results are never stored. Each time @PickList is executed, a new lookup is performed.

For a calendar view, @PickList displays two days starting with today, without time slots. The user can click on the date picker button to navigate to other days.

You cannot use this function in Web applications.

@PickList can return no more than 64K bytes of data. Use the following equations to determine how much of your data can be returned using @PickList.

For lookups that return text:

2 + (2 * number of entries returned) + total text size of all entries

For lookups that return numbers or dates:

(10 * number of entries returned) + 6

However, @PickList can access a view of any size, so there are no limits to the number of choices it can present. Only the return value is limited in size.

Language cross-reference

PickListStrings method of LotusScript NotesUIWorkspace class

Example
See Also