Functions Reference
Table Of Contents
- Contents
- Functions reference (alphabetical list)
- About functions
- Aggregate functions
- Container functions
- Date functions
- Design functions
- External functions
- Financial functions
- Get functions
- Get(AccountExtendedPrivileges)
- Get(AccountName)
- Get(AccountPrivilegeSetName)
- Get(ActiveFieldContents)
- Get(ActiveFieldName)
- Get(ActiveFieldTableName)
- Get(ActiveLayoutObjectName)
- Get(ActiveModifierKeys)
- Get(ActivePortalRowNumber)
- Get(ActiveRepetitionNumber)
- Get(ActiveSelectionSize)
- Get(ActiveSelectionStart)
- Get(AllowAbortState)
- Get(AllowFormattingBarState)
- Get(ApplicationArchitecture)
- Get(ApplicationLanguage)
- Get(ApplicationVersion)
- Get(CalculationRepetitionNumber)
- Get(ConnectionAttributes)
- Get(ConnectionState)
- Get(CurrentDate)
- Get(CurrentExtendedPrivileges)
- Get(CurrentHostTimestamp)
- Get(CurrentPrivilegeSetName)
- Get(CurrentTime)
- Get(CurrentTimestamp)
- Get(CurrentTimeUTCMilliseconds)
- Get(CustomMenuSetName)
- Get(DesktopPath)
- Get(Device)
- Get(DocumentsPath)
- Get(DocumentsPathListing)
- Get(EncryptionState)
- Get(ErrorCaptureState)
- Get(FileMakerPath)
- Get(FileName)
- Get(FilePath)
- Get(FileSize)
- Get(FoundCount)
- Get(HighContrastColor)
- Get(HighContrastState)
- Get(HostApplicationVersion)
- Get(HostIPAddress)
- Get(HostName)
- Get(InstalledFMPlugins)
- Get(LastError)
- Get(LastMessageChoice)
- Get(LastODBCError)
- Get(LayoutAccess)
- Get(LayoutCount)
- Get(LayoutName)
- Get(LayoutNumber)
- Get(LayoutTableName)
- Get(LayoutViewState)
- Get(MenubarState)
- Get(ModifiedFields)
- Get(MultiUserState)
- Get(NetworkProtocol)
- Get(NetworkType)
- Get(PageNumber)
- Get(PersistentID)
- Get(PreferencesPath)
- Get(PrinterName)
- Get(QuickFindText)
- Get(RecordAccess)
- Get(RecordID)
- Get(RecordModificationCount)
- Get(RecordNumber)
- Get(RecordOpenCount)
- Get(RecordOpenState)
- Get(RequestCount)
- Get(RequestOmitState)
- Get(ScreenDepth)
- Get(ScreenHeight)
- Get(ScreenScaleFactor)
- Get(ScreenWidth)
- Get(ScriptAnimationState)
- Get(ScriptName)
- Get(ScriptParameter)
- Get(ScriptResult)
- Get(SortState)
- Get(StatusAreaState)
- Get(SystemDrive)
- Get(SystemIPAddress)
- Get(SystemLanguage)
- Get(SystemNICAddress)
- Get(SystemPlatform)
- Get(SystemVersion)
- Get(TemporaryPath)
- Get(TextRulerVisible)
- Get(TotalRecordCount)
- Get(TouchKeyboardState)
- Get(TriggerCurrentPanel)
- Get(TriggerExternalEvent)
- Get(TriggerGestureInfo)
- Get(TriggerKeystroke)
- Get(TriggerModifierKeys)
- Get(TriggerTargetPanel)
- Get(UserCount)
- Get(UserName)
- Get(UseSystemFormatsState)
- Get(UUID)
- Get(WindowContentHeight)
- Get(WindowContentWidth)
- Get(WindowDesktopHeight)
- Get(WindowDesktopWidth)
- Get(WindowHeight)
- Get(WindowLeft)
- Get(WindowMode)
- Get(WindowName)
- Get(WindowOrientation)
- Get(WindowStyle)
- Get(WindowTop)
- Get(WindowVisible)
- Get(WindowWidth)
- Get(WindowZoomLevel)
- Logical functions
- Mobile functions
- Number functions
- Repeating functions
- Summary functions
- Text functions
- Char
- Code
- Exact
- Filter
- FilterValues
- Furigana
- GetAsCSS
- GetAsDate
- GetAsNumber
- GetAsSVG
- GetAsText
- GetAsTime
- GetAsTimestamp
- GetAsURLEncoded
- GetValue
- Hiragana
- KanaHankaku
- KanaZenkaku
- KanjiNumeral
- Katakana
- Left
- LeftValues
- LeftWords
- Length
- Lower
- Middle
- MiddleValues
- MiddleWords
- NumToJText
- PatternCount
- Position
- Proper
- Quote
- Replace
- Right
- RightValues
- RightWords
- RomanHankaku
- RomanZenkaku
- SerialIncrement
- Substitute
- Trim
- TrimAll
- Upper
- ValueCount
- WordCount
- Text formatting functions
- Time functions
- Timestamp functions
- Trigonometric functions
- Glossary
C
F
ILEMAKER FUNCTIONS REFERENCE 368
Button bar
A layout object that displays buttons or popover buttons in a horizontal or vertical bar. Button
bars contain segments that represent individual buttons consisting of any combination of a
button icon and a text label.
C
Cache
The amount of memory assigned to FileMaker Pro. A larger cache size increases performance.
A smaller cache size saves data to the hard disk more frequently, offering greater protection in
case of a system crash.
Calculation field
A field that returns the result of a calculation of values. You can create a formula for the
calculation using functions, constants, operators, and information from other fields in the same
record.
Cascading style sheets
A system of codes or tags that define how a web browser displays information in a web page.
Cascading style sheets provide more control over the layout and appearance of web pages than
HTML. Cascading style sheets work like templates for web pages. If a web page contains
cascading style sheets, users must view it in a browser that supports cascading style sheets.
Character encoding
The character set or code page of a file. If necessary, you can specify a character set to be used
when importing, exporting, indexing, sorting, and spell-checking files. FileMaker supports ASCII,
Windows ANSI, Macintosh, Japanese (Shift-JIS), Unicode UTF-8, Unicode UTF-16, and
Unicode UTF-16 Windows.
Chart
A graphical depiction that makes it easy to compare data and see patterns and trends.
Chart legend
A key that identifies the colors assigned to a data series in a chart.
Client
A user that opens a file that is shared on a network, published in a browser, or shared via
ODBC/JDBC. FileMaker Network settings and privileges determine how FileMaker
Pro and
FileMaker
Go clients interact with files hosted through FileMaker Pro, and FileMaker Server.
Client application
The application that requests data (using SQL) from a data source (using ODBC or JDBC).
Also, FileMaker
Pro is a client application when it accesses a file hosted by FileMaker Server.
Client/server architecture
The relationship between two networked computers that share resources. The client requests
services from the server, and the server provides services to the client.
Clipboard
A temporary storage area in computer memory where FileMaker Pro places the most recent
selection you've cut or copied.
Clone
A copy of a FileMaker Pro file that contains all the field definitions, tables, layouts, scripts, and
page setup options, but none of the data.