List of @Functions(Formula Language) in Lotus Notes

Agents

@Command([RunAgent]; agent)

@DocMark([Update])

@DocMark([NoUpdate])

@IsAgentEnabled(agent)

Characters

@Ascii(string)

@Ascii(string; [AllInRange])

@Char(codeNumber)

@Narrow(string)

@NewLine

@Wide(string)

@Commands

@Command([command];

parameters)

@PostedCommand([command];

parameters)

Control Logic

@Do(expressions)

@DoWhile(statement; ...; condition)

@For(initialize; condition; increment;

statement; ...)

@If(condition1; action1; condition2;

action2; ...; condition99; action99;

elseAction)

@Nothing

@Return(value)

@Select(number; values)

@V2If(condition1; action1; condition2;

action2; …; condition99; action99;

elseAction)

@While(condition; statement; ...)

Data Types

@False

@IsNull(value)

@IsNumber(value)

@IsText(value)

@IsTime(value)

@No

@Text(value; format String)

@TextToNumber(string)

@TextToTime(string)

@Time(hour; minute; second)

@Time(year; month; day; hour; minute;

second)

@Time(timeDate)

@TimeMerge(date; time; timeZone)

@TimeToTextInZone(timeDate; timeZone;

formatString)

@TimeZoneToText(timeZone;

formatString)

@ToNumber(value)

@ToTime(value)

@True

@Yes

Databases

@DbExists(server : fi le)

@DbExists(server; replicaID)

@DbManager

@DbName

@DbTitle

@ReplicaID

@ServerName

@TemplateVersion

@WebDbName

Internationalization

@FormLanguage

@LanguagePreference([AlternateName])

@LanguagePreference([Content])

@LanguagePreference([Region])

@Locale([action])

@Locale([action]; localeTag)

@UserNameLanguage(index)

Mail

@CheckAlarms

@EnableAlarms(fl ag)

@LDAPServer

@MailDbName

@MailEncryptSavedPreference

@MailEncryptSentPreference

@MailSavePreference

@MailSend

@MailSend( sendTo ; copyTo ;

blindCopyTo ; subject ; remark ;

bodyFields ; [ fl ags ] )

@MailSignPreference

DDE @OptimizeMailAddress(address)

@DDEExecute(conversationID;

command)

@DDEInitiate(application; topic)

@DDEPoke(conversationID;

location; data)

@DDETerminate(conversationID)

Documents

@Accessed

@AttachmentLengths(excludeMIMEBody)

@AttachmentModifi edTimes

(excludeMIMEBody)

@AttachmentNames(excludeMIMEBody)

@Attachments(excludeMIMEBody)

@Author

@Created

@DeleteDocument

@DocFields

@DocLength

@DocLevel

@DocLock([options])

@DocOmittedLength

@DocumentUniqueID

@GetDocField(documentUNID; fi eldName)

@HardDeleteDocument

@InheritedDocumentUniqueID

@IsDocBeingEdited

@IsDocBeingLoaded

@IsDocBeingMailed

@IsDocBeingRecalculated

@IsDocBeingSaved

@IsDocTruncated

@IsModalHelp

@IsNewDoc

@IsResponseDoc

@Modifi ed

@NoteID

@SetDocField(documentUNID;

fi eldName; newValue)

@UndeleteDocument

Error Handling

@CheckFormulaSyntax (formulaText)

@Error

@Eval(textExpressions)

@Failure(string)

@IfError(statement)

@IfError(statement; alternateStatement)

@IsError(value)

@IsValid

@Success

Fields

@Abstract([keywords]; size; beginText;

bodyFields)

DEFAULT variableName := value

FIELD fi eldName := @DeleteField

FIELD fi eldName := value

@GetField (fi eldName)

@IsAvailable(fi eldName)

@IsUnavailable(fi eldname)

@SetField(fi eldName; value)

@ThisName

@ThisValue

FIELD fi eldName := @Unavailable

Folders

@AddToFolder(folderNameAdd;

folderNameRemove)

@Command([FolderDocuments];

folderName; moveOrCopy)

Frames

@SetTargetFrame(targetFrame)

HTTP/URL

@GetHTTPHeader(requestHeader)

@SetHTTPHeader

(responseHeader; value)

@URLDecode(decodingFormat; token)

@URLEncode(encodingFormat; token)

@URLGetHeader(urlString;

headerString; webUserName;

webPassword; proxyWebUserName;

proxyWebPassword)

@URLHistory([command])

@URLOpen

@URLOpen(urlString)

@URLOpen(urlString; [reloadFlag])

@URLOpen(urlString; [URLList])

@URLOpen(urlString; [reloadFlag]

: [URLList])

@URLOpen(urlString; [reloadFlag]

: [URLList]; charset)

@URLOpen(urlString; [reloadFlag]

: [URLList]; charset; webUserName)

@URLOpen(urlString; [reloadFlag]

: [URLList]; charset; webUserName;

webPassword)

@URLOpen(urlString; [reloadFlag]

: [URLList]; charset; webUserName;

webPassword; proxyWebUserName)

@URLOpen(urlString; [reloadFlag]

: [URLList]; charset; webUserName;

webPassword; proxyWebUserName;

proxyWebPassword)

@UrlQueryString(parameterName)

@ValidateInternetAddress

([Address821]; address)

@ValidateInternetAddress

([Address822]; address)

Lists

@Compare(textList; textList; [options])

@Count(list)

@Elements(list)

@Explode(dateRange)

@Explode(string)

@Explode(string; separators)

@Explode(string; separators;

includeEmpties)

@Explode(string; separators;

includeEmpties; newLineAsSeparator)

@Implode(textListValue)

@Implode(testListValue; separator)

@IsMember(textValue; textListValue)

@IsMember(textListValue1;

textListValue2)

@IsNotMember(textValue; textListValue)

@IsNotMember(textListValue1;

textListValue2)

@Keywords(textList1; textList2)

@Keywords(textList1; textList2; separator)

@Member(value; textList)

@Replace(sourceList; fromList; toList)

@Sort(list)

@Sort(list; [order];

customSortExpression)

@Subset(list; number)

@Transform(list; variableName; formula)

Lookups

@DbColumn(class : cache; server :

database; view; columnNumber)

@DbColumn(“ODBC” : cache;

data_source; userID1 : userID2;

password1 : password2; table;

column : nullHandling; Distinct : sort)

@DbCommand(Domino;

ViewNextPage)

@DbCommand(Domino;

ViewPreviousPage)

@DbCommand(Domino; FolderList;

promptString; foldersToExclude)

@DbCommand(“ODBC” : cache;

dataSource; userID1 : userID2;

password1 : password2;

commandString : nullHandling)

@DbLookup(class : cache;

server : database; view; key; fi eldName;

keywords)

@DbLookup(class : cache;

server : database; view; key;

columnNumber; keywords)

@DbLookup(“ODBC” : cache;

dataSource; userID1 : userID2;

password1 : password2; table;

column : nullHandling; keyColumn;

key; “Distinct” : sort)

service names may be trademarks or service marks of others.

Math

@Abs(anyNumber)

@ACos(cosine)

@ASin(sine)

@ATan(tangent)

@ATan2(x; y)

@Cos(angle)

@Exp(power)

@FloatEq(number1; number2;

confi denceRange)

@Integer(numberValue)

@Ln(number)

@Log(number)

@Max(number1)

@Max(number1; number2)

@Min(number1)

@Min(number1; number2)

@Modulo(number1; number2)

@Pi

@Power(base; exponent)

@Random

@Round(number)

@Round(number; factor)

@Sign(signedNumber)

@Sin(angle)

@Sqrt(number)

@Sum(numbers)

@Tan(angle)

Names

@Name([action]; name)

@NameLookup([lookupType];

userName; itemToReturn)

Profi le Documents

@Command([EditProfi leDocument];

formName; uniqueKey)

@GetProfi leField(profi leName;

fi eldName; uniqueKey)

@SetProfi leField(profi leName;

fi eldName; value; uniqueKey)

Remarks

REM “comments”;

REM {comments};

Security

@Certifi cate([dataToRetrieve]; certifi cate)

@EditECL(server : database; name)

@EditUserECL

@HashPassword(string)

@Password(string)

@PasswordQuality(fi eldName)

@RefreshECL(server : database; name)

@ServerAccess([access]; userName)

@ServerAccess([access]; userName;

serverName)

@UserAccess(server : fi le; [accessLevel])

@UserNamesList

@UserPrivileges

@UserRoles

@V4UserAccess(server : fi le)

@VerifyPassword(password; password)

Selection

@All

SELECT selectionFormula | @AllChildren

SELECT selectionFormula |

@AllDescendants

SELECT formula

Tables

@@GetFocusTable([CellColumn])

@GetFocusTable([CellRow])

@GetFocusTable([TableName])

Temporary Variables

@Set(variableName; value)

Text

@Begins(string; subString)

@Contains(string; subString)

@Ends(string; subString)

@Left(stringToSearch; numberOfChars)

@Left(stringToSearch; subString)

@LeftBack(stringToSearch; numToSkip)

@LeftBack(stringToSearch; startString)

@Length(string)

@Length(stringList)

@Like(string; pattern)

@Like(string; pattern; escape)

@LowerCase(string)

@Matches(string; pattern)

@Middle(string; offset; numberChars)

@Middle(string; offset; endString)

@Middle(string; startString;

numberChars)

@Middle(string; startString; endString)

@MiddleBack(string; offset;

numberChars)

@MiddleBack(string; offset; endString)

@MiddleBack(string; startString;

numberChars)

@MiddleBack(string; startString;

endString)

@ProperCase(string)

@Repeat(string; number; numberChars)

@ReplaceSubstring(sourceList; fromList;

toList)

@Right(stringToSearch; numberOfChars)

@Right(stringToSearch; subString)

@RightBack(stringToSearch;

numberOfChars)

@RightBack(stringToSearch; subString)

@Soundex(string)

@Trim(string)

@Unique

@Unique(textList)

@UpperCase(string)

@Word(string; separator; number)

Time/Dates

@Adjust(dateToAdjust; years; months;

days; hours; minutes; seconds; [DST])

@BusinessDays(startDates; endDates;

daysToExclude; datesToExclude)

@Date(year; month; day)

@Date(year; month; day; hour;

minute; second)

@Date(timeDate)

@Day(timeDateValue)

@Hour(timeDateValue)

@Minute(time Date)

@Month(time Date)

@Now

@Now([ServerTime] :

[LocalTimeOnError])

@Now([ServerTime] :

[LocalTimeOnError]; serverNames)

@Second(time Date)

@Today

@Tomorrow

@Weekday(time Date)

@Year(time Date)

@Yesterday

@Zone

@Zone(timeDate)

User Interaction

@DialogBox(form; [AutoHorzFit] :

[AutoVertFit] : [NoCancel] :

[NoNewFields] : [NoFieldUpdate] :

[ReadOnly] : [SizeToTable] :

[NoOkCancel] : [OkCancelBottom]; title)

@PickList([Custom] : [Single];

server : fi le; 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)

@Prompt([Ok]; title; prompt)

@Prompt([YesNo]; title; prompt)

@Prompt([YesNoCancel]; title; prompt)

@Prompt([OkCancelEdit]; title; prompt;

defaultChoice)

@Prompt([OkCancelList] : [NoSort]; title;

prompt; defaultChoice; choiceList)

@Prompt([OkCancelListMult] : [NoSort];

title; prompt; defaultChoice; choiceList)

@Prompt([OkCancelCombo] : [NoSort];

title; prompt; defaultChoice; choiceList)

@Prompt([OkCancelEditCombo] :

[NoSort]; title; prompt; defaultChoice;

choiceList)

@Prompt([LocalBrowse]; title; fi letype)

@Prompt([Password]; title; prompt)

@StatusBar(statusBarText)

User Environment

@BrowserInfo(propertyName)

@ClientType

@Confi gFile

@Domain

ENVIRONMENT variable := textValue;

@Environment(variable)

@Environment(variable; value)

@FileDir(pathname)

@FontList

@GetAddressBooks([options])

@GetCurrentTimeZone

@GetIMContactListGroupNames

@GetPortsList([Disabled])

@GetPortsList([Enabled])

@IsAppInstalled(application)

@IsVirtualizedDirectory

@LaunchApp(application)

@OrgDir

@Platform([Specifi c])

@RegQueryValue(keyName;

subKeyName; valueName)

@SetEnvironment(variableName; value)

@UpdateFormulaContext

@UserName(index)

@V3UserName

@Version

@Version(versionNumber)

Views

@DocChildren

@DocChildren(defaultString)

@DocChildren(zeroString; defaultString)

@DocChildren(zeroString; oneString;

defaultString)

@DocDescendants

@DocDescendants(defaultString)

@DocDescendants(zeroString;

defaultString)

@DocDescendants(zeroString; oneString;

defaultString)

@DocNumber

@DocNumber(separator)

@DocNumber(“”)

@DocParentNumber

@DocParentNumber(separator)

@DocParentNumber(“”)

@DocSiblings

@GetViewInfo([CalendarViewFormat];

column)

@GetViewInfo([ColumnValue]; column)

@GetViewInfo([IsCalTimeSlotOn];

column)

@IsCategory

@IsCategory(trueString)

@IsCategory(trueString; falseString)

@IsExpandable

@IsExpandable(trueString)

@IsExpandable(trueString; falseString)

@Responses

@SetViewInfo([SetViewFilter];

fi lterString; columnName; isCategory)

@SetViewInfo([SetViewFilter];

fi lterString; columnName; exactMatch)

@ViewShowThisUnread(unreadOnly)

@ViewTitle