PROGRAMMING OVERVIEW AND USER INTERFACE
Examples: Keyword field formulas
1. This formula uses as a keyword list the values in column 1 of the Names view in the current database.
@DbColumn(""; ""; "Names"; 1)
2. This formula reformats the user name as last name, comma, first name, taking care to handle hierarchical names. The formula looks up the reformatted user name in the Phone Numbers view of the current database and returns a list consisting of the values found in columns 2 and 3.
n := @Left(@V3UserName; "/");
k := @Right(n; " ") + ", " + @Left(n; " ");
@DbLookup(""; ""; "Phone Numbers"; k; 2) : @DbLookup(""; ""; "Phone Numbers"; k; 3)
See Also
Keyword field formulas
Glossary
Feedback on
Help
or
Product Usability
?
Help on Help
All Help Contents
Glossary