FORMULA LANGUAGE
Examples: @PickList
1. This formula displays the Products view of PROD.NSF in a dialog box. If the user selects a Staple remover and Stapler from the products view, the temporary variable choice gets assigned the following text list:
Staple remover; Stapler
choice:=@PickList( [CUSTOM] ; "" ; "Products" ; "Select a product" ; "Please select the products you want to order" ; 1 );
2. This formula achieves the same result as the one above, but uses @DbName to display the Products view of the current database.
choice:=@PickList( [CUSTOM] ; @DbName ; "Products" ; "Select a product" ; "Please select the products you want to order" ; 1 );
3. This formula also displays the Products view of the current database, but returns the contents of the second column in the view.
choice:=@PickList( [CUSTOM] ; @DbName ; "Products" ; "Select a product" ; "Please select the products you want to order" ; 2 );
4. This formula is the same as above but limits the selection to a single document.
choice:=@PickList( [CUSTOM] : [SINGLE] ; @DbName ; "Products" ; "Select a product" ; "Please select the products you want to order" ; 2 );
5. This formula opens the By Category view of the current database and displays only the items in the Leather category.
choice:=@PickList( [CUSTOM] ; "" ; "By Category" ; "Select a product" ; "Please select the products you want to order" ; 5; "Leather");
6. This formula displays the Names dialog box. The names of the people, groups, or servers that the user selects are placed in the person field on the current document.
FIELD person:=person;
@SetField( "person"; @PickList( [NAME] ) )
7. This formula displays the Names dialog box, with the current value of myNames preselected. The names of the people the user selects are placed in the myNames field on the current document.
FIELD myNames := @PickList([NAME]; myNames)
See Also
@PickList
Glossary
Feedback on
Help
or
Product Usability
?
Help on Help
All Help Contents
Glossary