Named constants and other special keywords

FileMaker Pro defines certain constants you can use by name in any calculation formula. Many constants are defined as values for a parameter in specific functions, such as the JSONObject value for the type parameter of the JSONSetElement function. Other constants are for general use, such as the Boolean values True and False. Some keywords like ROWID are reserved because of their special use in SQL and OData; in FileMaker formulas, they are equivalent to specific Get functions.

Treat these as reserved words and avoid using them as field or table names. See Using a reserved word or symbol for a field or table name.

Name	Category	Notes
`AllStyles`	Text style	All text styles combined. Use with TextStyleAdd and TextStyleRemove.
`Bold`	Text style	Bold text. Use with TextStyleAdd and TextStyleRemove.
`CentralEurope`	Character set	Font character encoding.¹
`Condense`	Text style	Condensed spacing. Use with TextStyleAdd and TextStyleRemove.
`Cyrillic`	Character set	Font character encoding.¹
`DoubleUnderline`	Text style	Double underline. Use with TextStyleAdd and TextStyleRemove.
`Extend`	Text style	Extended spacing. Use with TextStyleAdd and TextStyleRemove.
`False`	Boolean	Returns 0.
`Greek`	Character set	Font character encoding.¹
`Higher`	Lookup	Find next higher value. Use with LookupNext.
`HighlightYellow`	Text style	Yellow highlight. Use with TextStyleAdd and TextStyleRemove.
`Italic`	Text style	Italic text. Use with TextStyleAdd and TextStyleRemove.
`JSONArray`	JSON type	JSON array type. Use with JSONSetElement and JSONGetElementType.
`JSONBoolean`	JSON type	JSON boolean type. Use with JSONSetElement and JSONGetElementType.
`JSONNull`	JSON type	JSON null type. Use with JSONSetElement and JSONGetElementType.
`JSONNumber`	JSON type	JSON number type. Use with JSONSetElement, JSONGetElementType, and GetRecordIDsFromFoundSet.
`JSONObject`	JSON type	JSON object type. Use with JSONSetElement and JSONGetElementType.
`JSONRaw`	JSON type	JSON raw type (auto-detect). Use with JSONSetElement.
`JSONString`	JSON type	JSON string type. Use with JSONSetElement, JSONGetElementType, and GetRecordIDsFromFoundSet.
`JSONStringRanges`	JSON type	JSON string ranges type. Use with GetRecordIDsFromFoundSet.
`Lower`	Lookup	Find next lower value. Use with LookupNext.
`Lowercase`	Text style	Lowercase letters. Use with TextStyleAdd and TextStyleRemove.
`OEM`	Character set	Font character encoding.¹
`Other`	Character set	Font character encoding.¹
`Plain`	Text style	Remove all styles. Use with TextStyleAdd and TextStyleRemove.
`PosixPath`	Path type	POSIX path format. Use with ConvertFromFileMakerPath and ConvertToFileMakerPath.
`Roman`	Character set	Font character encoding.¹
`ROWID`	Record metadata	Equivalent to Get(RecordID).
`ROWMODID`	Record metadata	Equivalent to Get(RecordModificationCount).
`ShiftJIS`	Character set	Font character encoding.¹
`SimplifiedChinese`	Character set	Font character encoding.¹
`SmallCaps`	Text style	Small capital letters. Use with TextStyleAdd and TextStyleRemove.
`Strikethrough`	Text style	Strikethrough text. Use with TextStyleAdd and TextStyleRemove.
`Subscript`	Text style	Subscript text. Use with TextStyleAdd and TextStyleRemove.
`Superscript`	Text style	Superscript text. Use with TextStyleAdd and TextStyleRemove.
`Symbol`	Character set	Font character encoding.¹
`Titlecase`	Text style	Title case letters. Use with TextStyleAdd and TextStyleRemove.
`TraditionalChinese`	Character set	Font character encoding.¹
`True`	Boolean	Returns 1.
`Underline`	Text style	Underline text. Use with TextStyleAdd and TextStyleRemove.
`Uppercase`	Text style	Uppercase letters. Use with TextStyleAdd and TextStyleRemove.
`URLPath`	Path type	URL path format. Use with ConvertFromFileMakerPath and ConvertToFileMakerPath.
`ValueNumber`	Value type	Value list format. Use with GetRecordIDsFromFoundSet.
`ValueNumberRanges`	Value type	Value list with ranges. Use with GetRecordIDsFromFoundSet.
`WinPath`	Path type	Windows path format. Use with ConvertFromFileMakerPath and ConvertToFileMakerPath.
`WordUnderline`	Text style	Underline words only. Use with TextStyleAdd and TextStyleRemove.

Reserved for the TextFont and TextFontRemove functions but no longer used.

Named constants and other special keywords

Related topics