FORMULA LANGUAGE


Examples: @Keywords
1. This formula returns Harvard;Yale.
2. This formula returns "", a null string.
3. This formula returns Harvard;Yale. It searches textList1 for the textList2 keywords that follow either a comma or a space.
4. This formula returns Harvard;Yale University;UCLA.
5. This formula returns Mary Jones. when used in the "Result" field on a form that also contains the "Applicants" field, which has a default value of: ",Mary Jones.":",John Chen.":",Miguel Sanchez.".
6. This formula returns Mary Jones. when used in the "Result" field on a form that also contains the "Applicants" field, which has a default value of: ",Mary Jones., who works downtown, is being interviewed on Friday.":",John Chen.":",Miguel Sanchez.".
7. This formula returns book.
8. If list1 contains "guava":"eggplant":"date":"cherry":"banana":"apple" and list2 contains "apple":"banana":"date," this formula, when triggered from a Release 6 client, returns date, banana, apple. When triggered from a pre-Release 6 client, it returns apple, banana, date.
9. If list1 and list2 contain the same text lists as in the previous example, this formula returns apple, banana, date from all versions of Notes.
See Also