Reference > Glossary
 

Glossary

A

access key (Windows)

A key that activates a menu, menu item, or control when used with the ALT key. In Windows, this key corresponds to the underlined letter on a menu, command, or dialog box option.

access privileges

Permission to view and work with certain records, fields, layouts, value lists, and scripts and to perform selected activities in a file.

account

A user name and (usually) a password, which identifies a user. Accounts are created in FileMaker Pro or externally (for example, in the Claris ID identity provider system). Once an account exists, you assign access privileges to it, which determine the tasks that the account is allowed to do.

account access

A user's account or a group with a privilege set. You create an account access entry in the FileMaker Pro Manage Security dialog box.

Active Directory

In Windows, the distributed directory service that is included with modern Microsoft Windows Server operating systems. Active Directory provides centralized, secure management of a network.

active pane

In the FileMaker Pro Script Workspace, the pane (scripts pane, script editing pane, or script steps pane) that's active for use.

active tab

In the FileMaker Pro Script Workspace, the tab in the script editing pane that's active for use.

ActiveX Automation

A Windows programming and scripting protocol that allows external control of specific commands and actions in FileMaker Pro, including opening and closing FileMaker Pro files, toggling the application's visibility, and performing FileMaker scripts.

additional database folder

In FileMaker Server, in addition to the default database folder and the secure database folder, FileMaker Server can also host databases in an additional database folder specified by the server administrator to host encrypted and nonencrypted database files. This folder supports placing files in subfolders, but only one level down. It also supports using a container data folder.

add-on

A predesigned set of components that can be added to a custom app to perform specific actions or tasks. An add-on may include layouts, layout objects, schema, scripts, and value lists that work together.

Add-ons tab

In Layout mode, a tab in the objects pane where you install add-ons and drag them to the layout. To open the Add-ons tab, click Objects pane button in the status toolbar, then click Add-ons. Or choose View menu > Objects > Add-ons Tab.

Admin Server

The FileMaker Server software component that manages the deployment of the other FileMaker Server components and displays FileMaker Server Admin Console on client computers for configuring FileMaker Server.

administrative tasks

Procedures performed regularly by the administrator to keep FileMaker Server running efficiently and ensure data integrity in hosted databases. For example, running regularly scheduled database backups is a typical administrative task.

advanced tools

FileMaker Pro development and deployment features (for example, Script Debugger, custom menus, and database encryption) that are available when the Use advanced tools general preference is selected.

alpha channel

The alpha channel of an image stores transparency information and controls the transparency of the red, green, and blue color channels.

animation

A visual effect that provides feedback while you are performing actions in FileMaker Pro and FileMaker Go, such as switching between slide panels.

API (Application Programming Interface)

A set of software application building blocks—such as classes, methods, data structures, variables, procedures, and functions—used by programmers.

Apple events

A macOS technology that lets applications communicate with one another. FileMaker Pro can send and receive Apple events to and from applications that support them.

AppleScript

A scripting language you can use to control functions of macOS and of applications that support AppleScript (often called scriptable applications).

ascending sort order

Alphabetical sequence (A to Z) for words, lowest to highest order for numbers, and earliest to latest for dates and times.

ASCII character set

American Standard Code for Information Interchange. A standard character set used by computer systems worldwide (often extended for different alphabets).

authentication

The process of checking the validity of an account and password (if one is defined) before assigning privileges and allowing access to a system or a file.

authorization

Allowing a file to access a protected FileMaker Pro file’s schema (including its tables, layouts, scripts, and value lists). Such a file is an authorized file.

auxiliary files

In a Kiosk custom app, files that are bundled with a primary file.

B

backup

A copy of a file that can be used if the original is lost, damaged, or otherwise irretrievable.

backup schedule

A schedule that backs up one or many hosted database files.

badge

An icon indicating that conditional formatting, script triggers, placeholder text, or tooltips have been applied to a field, object, or layout; that find is available for a field; that an object is a button, popover button, or button bar; or that a custom app is a favorite.

base directory

For container fields that store an external reference, the folder in which the referenced data is stored. You can also specify a file system path or a calculation for each open storage container field.

blank layout

In FileMaker Pro, a layout that contains empty body, header, and footer parts.

block

A string of data elements recorded or transmitted as an individual unit. A block is often the smallest unit of data a program reads from or writes to the hard disk.

body part

In FileMaker Pro, a layout part that contains individual records from a file.

Boolean value

A Boolean value is either true or false. A field containing any number except zero evaluates as true. A field containing zero, no data, or content that does not resolve into a number evaluates as false. For example, a field containing "ABC," "ABC0," or an empty field is false. A field containing "1" or "ABC2" is true.

break field

In a FileMaker Pro subsummary part, records are grouped (sorted) by values in another field, called the break field. Whenever the value of the break field changes, the report "breaks" and FileMaker Pro inserts the subsummary part.

Browse mode

The FileMaker Pro mode in which you enter and edit information in fields. Groups of fields make up the records of a file. You can view one record at a time (click Form View in the layout bar), view your records in a list (click List View), or view records arranged in a spreadsheet-like table (click Table View).

button

A FileMaker Pro layout object that performs a specified script in Browse or Find mode.

button bar

A FileMaker Pro 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

An area of RAM (Random Access Memory) reserved by a program to store frequently used data, providing faster access than if the data were read from the hard disk. 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.

card

In FileMaker Pro, a type of window that is modal to its parent window, allowing users to open other windows or files without having to first close the card. Create and customize a card using the New Window script step.

cascading style sheets

A system of codes or tags that define how a web browser displays information in a webpage. Cascading style sheets provide more control over the layout and appearance of webpages than HTML. Cascading style sheets work like templates for webpages. If a webpage contains cascading style sheets, users must view it in a browser that supports cascading style sheets.

certificate

A digital key issued to other entities (organizations or individuals) allowing them to prove their identity to others. Signed server certificates and client certificates are issued by a trusted certificate authority (CA). The certificate authority's main purpose is to verify the identity of entities and issue digital certificates that identify those entities.

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. The Claris FileMaker Platform 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, patterns, and symbols assigned to a data series in a chart.

Claris Customer Console

A web application for working with files hosted by FileMaker Cloud and for managing Claris ID and external IdP accounts, groups, hosts, settings, and subscriptions.

Claris ID

Refers to either the Claris ID integrated sign-on system for authenticating users of FileMaker products and services, or a Claris ID account, which authenticates a Claris ID user in the Claris ID system.

Claris ID account

An account that uses the Claris ID identity provider system to authenticate users.

Claris ID user

A user who has a Claris ID account and has all rights to use Claris Customer Console.

Claris ID user name

The email address used for a Claris ID account.

Claris International Inc. team

The default team for Claris ID or external IdP accounts.

Claris Store

A website where users can browse and purchase products, upgrade subscriptions, and more.

CLI

The command line interface. Using the FileMaker Server CLI, an administrator can enter fmsadmin commands to administer FileMaker Server. In the CLI, use the fmsadmin help command to see Help pages on the CLI commands.

client

Software that opens a connection to a hosted FileMaker Pro custom app, including FileMaker Pro, FileMaker Go, an ODBC/JDBC client application, or a web browser via FileMaker WebDirect. A FileMaker client is FileMaker Pro or FileMaker Go. A web publishing client is FileMaker WebDirect, Custom Web Publishing, or the FileMaker Data API.

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 or a FileMaker Cloud product.

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 that was 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.

column

When a FileMaker Pro layout is viewed in Table View, a column corresponds to a field.

combo box

A type of list in Layout mode. In the Data Data tab in the Inspector, select Include arrow to show and hide list. The list opens only when users click the arrow, not when they enter the field.

commit

To save changes to a file. Certain actions, such as navigating between records, finding, and sorting, do not change the file’s modification date. Other actions, such as changing data in a record or changing a layout, do change the file’s modification date.

concealed edit box

In FileMaker Pro, a field set up to conceal confidential information by displaying dots in place of data.

Concurrent Connections License

A license type based on the number of FileMaker clients allowed to be connected simultaneously to FileMaker Server.

connector

A technology that retrieves data, updates data, or adds features to hosted databases.

consistency check

Examination of a file that may have been damaged by, for example, being closed unexpectedly. FileMaker Pro reads every file block, and verifies that the internal structure of the block is valid and the block is properly linked to other blocks in the file. (A consistency check does not read all the data within each file block or check the schema or higher-level structures in the file; these tasks are performed by file recovery.)

constant

In a calculation, an unchanging value. For example, a constant can be a field name, a text literal ("Total:"), or a number. The value of the constant doesn't change from record to record as the formula is evaluated.

container data type

Also container field. Pictures, movies, and documents such as Microsoft Word files and PDF files can be inserted in a container field. Data in container fields can be embedded in the field, stored by file reference, or stored externally.

container data folder

For container fields that store objects externally, the folder where container field data is placed.

context

The table occurrence from which calculations and scripts are begun, and from which a relationship is evaluated in the relationships graph. Context may also refer to the current layout, found set of records, record, field, window, or other current state of the app.

convert (file)

Opening a data file from another application, which creates a new FileMaker Pro file containing the data. Also refers to opening a file created with a previous version of FileMaker Pro.

Core ML (Core Machine Learning)

A framework developed by Apple Inc. for integrating machine learning models into apps.

Create window

A FileMaker Pro window where you create custom apps from a predefined app or a blank file, convert files from previous versions, and learn about creating custom apps.

custom app

A file or set of files containing database tables, layouts, scripts, and associated data. A custom app performs one or more specific tasks, such as tracking customers or invoices.

custom function

A function that is not one of the default FileMaker Pro functions. You can create custom functions that can be reused anywhere in the file.

custom menu

In FileMaker Pro, a menu that is not one of the default FileMaker Pro menus. You can create custom menus, menu items, and menu sets.

custom-separated values

Field values in a file that are separated with characters or other delimiters you specify, such as tab, comma, or semicolon.

Custom Web Publishing

A method of sharing FileMaker Pro databases on the web using XML or PHP. Use Custom Web Publishing to create dynamic webpages that enable users to interact with databases hosted by FileMaker Server.

D

Data Entry Only privilege set

One of the three predefined privilege sets that appear in every file. The Data Entry Only privilege set allows read/write access to the records in a file, but not design access (for example, the ability to create layouts and value lists).

data file

A file that can be used with create data file, write to data file, and read from data file script steps.

data point

In a chart, the value of data plotted on the x or y axis displayed as a column, bar, point, bubble, or slice.

data series

Data points that are plotted in a chart. When multiple data series are charted, each data series is displayed in a unique color and is defined in the chart’s legend, if included.

data service resource

Data related to licensed access to FileMaker products and services, such as FileMaker Pro, FileMaker Cloud, FileMaker Data Storage drives, FileMaker Data API/OData usage, and the User License.

data source

A named reference that provides access to another FileMaker Pro file or to an ODBC database. ODBC data sources are also referred to as external SQL sources (ESS).

In charting, refers to the origin of the data to be charted—current found set, current record (delimited data), or related records.

data source name (DSN)

A data structure that contains the information about a specific file that an ODBC driver needs in order to connect to it.

Data Viewer

In FileMaker Pro, an advanced tool used for monitoring expressions such as field values, local and global variables, and calculations. You can monitor expressions while running scripts or while testing them in the Script Debugger. You can also monitor field values and variables in the file.

database

The arrangement of tables and fields and their interrelationship in a file.

Database Design Report

In FileMaker Pro, an advanced tool that creates a report of a database schema.

Database Encryption

A form of encryption that protects "data at rest." For the FileMaker Platform, data at rest is a FileMaker Pro file, and its temporary files, while it is being stored on disk (and not open). An encrypted file is protected from unauthorized access with an encryption password. FileMaker Pro or FileMaker Cloud is required to encrypt files. Encrypted files can be decrypted and re-encrypted as needed.

database file

A component of a FileMaker Pro custom app.

database file compression

The process of removing empty fields or redundant or unnecessary data in database files to minimize the amount of disk space they require.

Database Management System (DBMS)

An application used to store, process, and retrieve information in a database.

Database Server

The component of FileMaker Server that hosts databases. In a multiple-machine deployment, the machine running the Database Server is called the master machine. Database files are stored on the master machine’s hard disk.

Databases folder

On startup, FileMaker Server looks for databases to host in the default Databases folder, Secure folder, additional folders, and in subfolders one level down.

default database folder

The default folder used by FileMaker Server to host encrypted and nonencrypted database files.

deployment

The process and result of installing and configuring FileMaker Server components on one or more machines. In a multiple-machine deployment, components are deployed across more than one machine and work together as a unit.

descending sort order

Reverse alphabetical sequence (for example, Z to A) for words, highest to lowest order for numbers, and latest to earliest dates and times.

Developer Utilities

In FileMaker Pro, an advanced tool used to display files in Kiosk mode, prevent users from modifying the design or structure of databases, and automatically rename sets of files and update links to related files.

dialog window

In FileMaker Pro, a document window in a modal state. Its behavior is similar to the behavior of a window when a running script is paused. Create and customize a dialog window using the New Window script step.

directory service

Software with client-server architecture that is used to store information about your organization.The primary function of a directory service is to centralize the storage of information and respond quickly to queries.

distinguished name (DN)

Uniquely identifies an entry in a directory tree, using a series of comma-separated attributes. In a DN, the leftmost component is the actual directory object, and the rightmost value is the directory root.

document window

In FileMaker Pro, a standard modeless window. Create and customize a document window using the New Window script step.

domain name

A name that identifies a computer on the internet.

domain name server (DNS)

A server that matches up the URL of a website (for example https://example.com) with its proper numeric IP address (for example 12.34.56.78).

driver

The ODBC or JDBC driver translates SQL queries into commands that a DBMS can understand. It processes ODBC/JDBC calls, submits SQL requests to the data source, and returns the data back to the driver manager, which then routes it to the requesting application (for example, FileMaker Pro).

driver manager

The control panel that manages communication between requesting applications and data sources. When an application makes a request via ODBC/JDBC, the driver manager routes the request through the correct driver to the correct data source and returns the data to the requesting application. All ODBC/JDBC drivers and data sources to be used on that computer are registered with the driver manager.

drop-down calendar

A field set up to display an interactive monthly calendar when a user enters the field in Browse or Find mode.

DTD (Document Type Definition)

A formal description of a particular type of XML. It defines a document structure, including the names of data elements and where they may occur within the structure. Valid XML conforms to the rules established in its DTD.

dynamic guides

In FileMaker Pro Layout mode, guidelines that extend horizontally and vertically to help you move, resize, or align objects. Dynamic guides also "snap to" the upper and lower boundaries and the centers of objects as you move, resize, or align the objects.

E

email notification

A notification sent to the server administrator via email using an SMTP server.

embedded

For container fields, a file that is stored in the container field. Container data can also be stored by reference or stored externally.

encryption password

The password required to open an encrypted file. For FileMaker Pro, the encryption password is required for the FileMaker Pro user who opens the file, but not for the client who opens a file hosted by FileMaker Pro. FileMaker Pro is required to enable, disable, or change an encryption password.

Envelope layout

In FileMaker Pro, a predefined layout with fields arranged for printing on standard business envelopes.

Ethernet

A type of fast local area network used for connecting computers and peripherals within the same building or campus.

Event Viewer

Windows: An administrative tool that comes with the Windows operating system and displays events stored in various log files. FileMaker Server reports its events to the Application log, and these events can be viewed using Event Viewer.

Event.log

A file that records events that occur while the Database Server is running.

export

To save data from one file so that it can be used in another file or in another application.

expression

A value or any calculation that produces a value. Expressions can contain functions, field values, variables, and constants. Expressions can be combined to produce other expressions.

extended privilege

FileMaker Pro data sharing permissions that determine the data sharing options that are permitted by a privilege set for a file. A privilege set may allow users to open a hosted file using FileMaker Pro, use a database as an ODBC/JDBC data source, or access data published on the web. For example, the Access via FileMaker WebDirect extended privilege determines whether the privilege set allows accessing the file from a web browser.

external identity provider (IdP)

An identity authentication system that's external to Claris ID, such as Microsoft Active Directory (AD) or Okta.

external IdP group

A Claris Customer Console group of users whose identity is determined and authenticated by the external IdP.

external IdP user

A user whose identity is authenticated by the external IdP.

external script

A script used by a file, but defined in a different file. Use the Perform Script script step to select a defined script from a related file, or to select a file reference to a file on your hard drive or network.

external user

A Claris ID or external IdP user who is not managed by the current team, but is managed by a different team.

F

Favorites window

A FileMaker Pro window where you view, add, remove, and reorder favorite files.

field

The basic unit of data in a record. Define a field to hold a specific, discrete category of data, such as Last Name, Employee Photo, or to display the result of a calculation. Define text, number, date, time, timestamp, container, calculation, and summary fields. Field can also refer to the object on a layout that displays the data, such as an edit box, checkbox set, or pop-up menu.

field boundary

In FileMaker Pro Layout mode, an outline that shows the size of a field. To see field boundaries, choose View menu > Show > Field Boundaries. These boundaries only appear in Layout mode. However, you can use the Appearance Appearance tab in the Inspector to format objects to have borders that do appear in Browse mode and when you print the layout.

field label

Text on a layout or within a field that identifies a field. A field label can be the field name, other text (such as instructions), or the result of a calculation. Field labels can appear in various positions outside the field or as placeholder text within the field. Field labels can be changed or deleted.

field name

The name assigned to a field when the field is defined. When you place a field on a layout, you can have FileMaker Pro also place an editable field label that matches the field name. The field name can also be used as placeholder text. Fully qualified fields are displayed in tablename::fieldname format.

field type

The part of a field definition that determines what kind of data can be entered in the field and the kinds of operations FileMaker Pro can perform with the data. FileMaker Pro can create text, number, date, time, timestamp, container, calculation, and summary fields. (Global fields contain the same value for all records in the file and can be of any type except summary.)

Fields tab

In Layout mode, a tab in the objects pane where you create fields and drag them to the layout. To open the Fields tab, click Objects pane button in the status toolbar, then click Fields. Or choose View menu > Objects > Fields Tab.

file ID

Also file identification. A numeric identifier for a data file.

file path

The location of a file in an operating system as identified by the drive, folders, filename, and file extension.

FileMaker Admin API

An API (application programming interface) that conforms to Representational State Transfer (REST) architecture and allows you to administer FileMaker Server.

FileMaker Cloud

A service that provides access in the cloud to custom apps that use FileMaker Pro, FileMaker Go, and FileMaker WebDirect. FileMaker Cloud uses the Claris ID integrated sign-on system or an external IdP to authenticate users and is offered directly from Claris International Inc.

FileMaker Cloud Admin Console

The FileMaker Cloud user interface that allows users to monitor and administer their instance.

FileMaker Cloud for AWS

A service that provides access in the cloud to custom apps that use FileMaker Pro, FileMaker Go, and FileMaker WebDirect. FileMaker Cloud for AWS runs on the Amazon Web Services (AWS) Cloud and is offered through AWS Marketplace.

FileMaker Cloud product

Refers to either FileMaker Cloud for AWS or FileMaker Cloud.

FileMaker Data API

An API (application programming interface) that conforms to Representational State Transfer (REST) architecture and allows you to work with data from hosted files.

FileMaker Data Storage

A service that provides cloud-hosted storage for databases, externally stored container field data, and backup files.

FileMaker Go

An application used for working with FileMaker Pro custom apps (developed in FileMaker Pro) on iPad or iPhone.

FileMaker License Server

A public license server that validates FileMaker license certificates.

FileMaker Network

A communications method that allows you to share files hosted by FileMaker Server, a FileMaker Cloud product, or FileMaker Pro with others over a network who are using FileMaker Pro or FileMaker Go. The FileMaker Network settings and privileges you set up determine how other users (clients) can open and use the shared file.

FileMaker Pro

An application for creating and modifying database files. Clients use FileMaker Pro to open database files hosted by FileMaker Cloud and FileMaker Server. FileMaker Pro enables database developers to build custom apps for use on the web or in workgroups, and to create custom FileMaker plug-ins.

FileMaker script

One or more instructions (script steps) that you create in FileMaker Pro to automate repetitive or difficult tasks. FileMaker Server can run a FileMaker script in a Script schedule or Script Sequence schedule.

FileMaker Script Engine (FMSE)

The FileMaker Server component that runs FileMaker scripts and third-party plug-ins.

FileMaker Server

A dedicated database server that hosts databases created using FileMaker Pro so that data can be shared and modified by FileMaker Pro, FileMaker Go, and FileMaker WebDirect clients, and by other client applications supported by the FileMaker Server Web Publishing Engine and the FileMaker Data API Engine.

FileMaker Server Admin Console

An application used to configure and administer FileMaker Server, work with hosted databases, view details about connected clients, and track statistical information.

FileMaker Server user account

The account under which FileMaker Server runs on the master machine. During installation, you specify either the default account (Local System on Windows or fmserver on macOS) or an existing account on the master machine.

FileMaker WebDirect

A web application for accessing layouts from files in a web browser. Web clients use FileMaker WebDirect to access layouts from files hosted by FileMaker Server or a FileMaker Cloud product.

Find mode

The FileMaker Pro mode in which you specify criteria for finding a subset of records.

find request

In Find mode, a blank form based on the current layout. Enter search criteria into one or more fields of the find request.

firewall

A security system used to prevent unauthorized users from gaining access to a LAN. A firewall usually has a single computer that is connected to the internet, and all internet traffic must pass through that computer.

floating document window

In FileMaker Pro, a standard modeless window that stays on top of other windows while users work in FileMaker Pro. Create and customize a floating window using the New Window script step.

focus

In FileMaker Pro, indicates that a record, portal row, tab, option, field, repeating field repetition, layout part, or layout object that has been activated by a click, the Tab key, a navigation button, or a script can then be acted upon in some way. For example, change the value in a field that has the focus; work with the data that’s in a record that has the focus; a calculation function can return the number of the portal row that has the focus.

footer part

In FileMaker Pro, a layout part that appears at the bottom of every screen or page (unless you add a title footer). Use the footer part for page numbers or dates. Each layout can have only one footer. A field in the footer displays data from the last record on that page.

foreign key

In relational databases, a field in one table that identifies a record in another table. Values in foreign keys don’t have to be unique in the table, and they can be empty (null). There may be multiple foreign keys in a table.

Form View

In FileMaker Pro, a layout view that displays one record at a time. By default, fields appear on separate lines. To select this view, click Form View in the layout bar.

formatting bar

In Layout and Browse modes, the area that displays options for formatting text and objects. To show or hide the formatting bar, click Formatting Formatting bar button in the layout bar.

 

Formatting bar in Layout mode

Formatting bar in Layout mode in macOS

formula

A set of instructions for calculating a value.

found set

The set of records in a table that are made active when you search for data. When you find all records, the found set is the entire table.

Full Access privilege set

One of the three predefined privilege sets that appear in every file. The Full Access privilege set allows complete read/write access to a file, including making changes to privileges for the file.

fully qualified name

The complete name of a field or layout, expressed using the format tableName::[field or layout name], where tableName is the name of the underlying table occurrence in the relationships graph upon which the field or layout is based. A fully qualified name identifies an exact instance of a field or layout. Because fields and layouts with common names can be based on different tables, FileMaker Pro uses fully qualified names to avoid errors in calculations and scripts.

function

A predefined, named formula that performs a specific calculation and returns a single, specific value.

function list separator

The punctuation character ; (a semicolon) that separates parameters in a function definition. If you type a comma (,), FileMaker Pro changes it to a semicolon after you close the Specify Calculation dialog box.

function variable

A variable whose scope is limited to a function. A function variable has no prefix (for example, variable).

G

geofence

A virtual boundary around a geographic location.

GIF (Graphics Interchange Format)

A platform-independent file format often used to distribute graphics on the internet.

global field

A field defined with the global storage option can contain one value that's used for all records in a file. Use the value of a global field as a fixed value in calculations, to define variables in If or Loop script steps, or for fields that rarely need to be updated (for example, a company logo in a container field). A global field can be any field type except summary. A global field can’t be indexed.

global variable

A variable that can be used in a calculation or script anywhere in a file—for example, other scripts or file paths. The value of a global variable is not cleared until the file is closed. A global variable is prefixed by $$ (for example, $$variable).

grammar

A precise description of a formal language, such as XML, consisting of sets of rules for how strings (words) in the language can be generated, and how the strings can be recognized as part of the language.

grand summary

Total or other aggregate value for all records in the found set.

grand summary part

Use grand summary parts to view and display summary information (totals, averages, and so on) in summary fields for all records in the found set. You can add one grand summary part at the top (leading) and one grand summary part at the bottom (trailing) of a layout.

grid

In FileMaker Pro Layout mode, a series of nonprinting intersecting horizontal and vertical lines. The grid aligns objects you create, resize, move, or position. Objects "snap to" the grid to help you create and edit objects more precisely. Gridlines adjust when you change the unit of measure.

group

A subset of Claris ID or external IdP users in a team. Groups are created on the Groups page by a team manager.

grouped object

A collection of objects that behaves as one object in Layout mode.

Groups page

The page in Claris Customer Console on which team managers manage the groups in the team.

guest

A user who opens a protected file without specifying an account name and password. The Guest account is assigned a privilege set that determines what guests can do in the file. Guest access may be disabled for a file.

guides

Nonprinting, movable horizontal and vertical guidelines to help you position and align objects in Layout mode. An object's left or right boundary, top or bottom boundary, or center "snaps to" a guide.

H

handle

One of the small squares surrounding a selected object, and used to resize and reshape the object.

hard link

A directory entry that associates a name with a file on a file system. To improve backup performance, if the Database Server finds that a hosted file is identical to the most recent backup file, the Database Server creates a hard link to the most recent backup file instead of creating an additional backup copy of the file. ReFS volumes don’t support hard links, so FileMaker Server creates a full copy of the database.

header part

In FileMaker Pro, a layout part that appears at the top of every screen or page of a layout. Use a header part for column headings, titles, and other information. FileMaker Pro displays the header in Browse mode and prints it on every page, except the first page if you add a title header. Fields added to a header are printed on every page, using data from the first record on that page.

hibernate

Windows: A power conservation mode that saves energy on an idle system. If the computer running FileMaker Server hibernates, all client activity is suspended. Hibernation will not occur on the server machine if there are clients connected to hosted databases.

Home page

The page in Claris Customer Console on which users can download FileMaker Pro and FileMaker Go, and work with custom apps that they have been granted access to.

homepage

The starting page for a website. It often has some form of a table of contents that allows viewers to link to other parts of the website.

host

A server running FileMaker software that shares FileMaker custom apps that users (clients) can access. FileMaker Server, and FileMaker Cloud products are hosts. (FileMaker Pro can also host files for a small number of users.) FileMaker Network settings and privileges determine how FileMaker clients interact with the hosted files.

hosted database

A file opened by FileMaker Server or a FileMaker Cloud product for clients to use on a computer network. One or more clients can access and change information simultaneously in hosted databases. Access privileges defined in the file determine how users interact with the hosted file. All changes are stored in the file on the computer where the file resides.

Hosts page

The page in Claris Customer Console on which team managers manage the FileMaker Cloud host and hosted custom apps.

HTML (Hypertext Markup Language)

A language that is used for displaying and accessing information on the World Wide Web.

HTTP (Hypertext Transfer Protocol)

The internet protocol that defines how a web server responds to requests for files.

I

iBeacon

A device that transmits a Bluetooth low-energy signal that iOS and iPadOS devices can detect to determine location and proximity to the iBeacon.

Import

To bring (copy) data from a table, another file, or another application into the current table. Scripts can also be imported from one FileMaker Pro file into another.

indexing

An option that can be enabled when defining (or changing) the definition of a field. When indexing is enabled, FileMaker Pro builds a list of all the values that occur in the field in the table. This improves the performance of tasks such as finding data, but it increases the size of the file on disk.

inline scroll bar

A scroll bar that appears only while scrolling is occurring.

Inspector

In Layout mode, allows you to view and edit the settings for objects, layout parts, and the layout background. To open the Inspector, click Inspector pane button in the status toolbar. Or choose View menu > Inspectors > Inspector.

interactive container

A container field for which the Interactive content option in the Inspector is selected. Interactive containers are rendered using the web browser technologies that web viewer uses.

internet

An international network of many other networks that are linked using the TCP/IP network protocol.

internet service provider (ISP)

The company from which you purchase your connection to the internet.

intranet

A private TCP/IP network of linked computers within a company or organization.

IP (Internet Protocol) address

For IPv4, a four-part number, usually formatted as 12.34.56.78, that uniquely identifies a computer on the internet. For IPv6, an eight-part number, usually formatted as [2001:0DB8:85A3:08D3:1319:8A2E:0370:7334], that uniquely identifies a computer on the internet. When referenced in an application, IPv6 addresses must be contained in brackets; for example, [2001:0DB8:85A3:08D3:1319:8A2E:0370:7334]. FileMaker Server supports IPv4 and IPv6 address formats.

J, K

JDBC

A Java API that uses SQL statements to access data from, and exchange data with, many database management systems. The JDBC driver communicates between your Java applet and the FileMaker Pro, FileMaker Server, or FileMaker Cloud for AWS data source.

JDBC client driver

A JAR (Java Archive) file that sends an SQL query to access data stored in a database and delivers the requested data to the client application.

JPEG (Joint Photographic Experts Group)

A platform-independent file format often used to distribute graphics on the internet.

JSON (JavaScript Object Notation)

A lightweight data-interchange format used by many web services to transfer data objects composed of name-value pairs.

key

A column (or columns) that makes a particular row unique (corresponds to a match field).

Kiosk

A FileMaker custom app that runs full screen, without toolbars or menus. Users click buttons to navigate. Use the Developer Utilities to create Kiosk custom apps.

L

Labels layout

In FileMaker Pro, a predefined layout with fields arranged for printing horizontally or vertically on mailing label stock, and media and index sheets.

LAN (local area network)

A connection between computers within a location using cable or a wireless system.

layout

In FileMaker Pro, an arrangement of fields, objects, pictures, and layout parts that represents the way information is organized and presented when you browse, preview, or print records. Different layouts can be designed for entering data, printing reports and mailing labels, displaying webpages, and so on.

layout background

The bottommost layer of a FileMaker Pro layout. The appearance of the background can be changed—for example, with an image or a gradient—which displays only when the layout part (above the layout background) is transparent.

layout bar

In the status toolbar, the area that displays options for working with layouts, such as the Layout pop-up menu.

 

Layout bar in Browse mode

Layout bar in Browse mode in Windows

 

Layout bar in Layout mode

Layout bar in Layout mode in macOS

Layout mode

The FileMaker Pro mode in which you determine how information in fields is presented on the screen and in printed reports.

layout part

In FileMaker Pro, a section of a layout that organizes or summarizes information. Layout parts include body, header, footer, title header, title footer, top navigation, bottom navigation, leading and trailing grand summary, and leading and trailing subsummary.

Layout pop-up menu

In the layout bar, a pop-up menu from which you choose Manage Layouts (Layout mode) or a defined layout (all modes).

layout theme

A collection of coordinated styles that determine the color, object, part, and background attributes, and the fonts used on a layout. Themes also enhance the appearance of a layout or report and give all your layouts a consistent look. A theme does not control the placement or behavior of fields or objects on a layout. A theme is assigned when you create a new layout, but you can change the theme in Layout mode. Themes can also be created by changing the styles used for the layout, and then saving the theme with a new name.

layout tools

In FileMaker Pro, in the status toolbar in Layout mode, a collection of tools that includes the Selection tool (pointer), Text tool, Line tool, Rectangle tool, Rounded Rectangle tool, Oval tool, Field/Control tool, Button tool, Popover Button tool, Button Bar tool, Tab Control tool, Slide Control tool, Portal tool, Chart tool, Web Viewer tool, Field tool, Part tool, and Format Painter tool.

layout types

FileMaker Pro includes several predefined types of layouts and reports to display on different types of devices (such as laptop computer screens or touch device screens), for different purposes (such as browsing records, entering data, or printing reports, mailing labels, or envelopes). After you choose a layout type, you can make additional choices.

To use a predefined layout type, in Layout mode, click New Layout/Report in the status toolbar. After you finish creating a layout or report using the assistant, use the tools and commands in Layout mode to tailor the layout for your needs.

license

Allowed authorization to a resource. A license is purchased and managed by a purchaser. A license is owned by one and only one team.

license certificate

A purchase agreement, as an encrypted file, that grants the user the right to install and use specified licensed FileMaker products.

licensed user

A Claris ID or external IdP user who is covered by the current team’s User License. A licensed user is assigned a team license by a manager of the current team.

Lightweight Directory Access Protocol (LDAP)

This protocol, which runs over TCP/IP, makes it possible for system administrators to centrally manage users, groups, devices, and other data.

List View

In FileMaker Pro, a layout view that displays records one record at a time in a list format. To select this view, click List View in the layout bar.

List view layout

A type of Report layout in which fields that you specify appear in columns across the screen or page in one line. Field names are in the header part and the footer part is blank.

local notification

A notification that is sent and delivered on the same device. Local notifications appear even when the FileMaker client is not in the foreground.

In FileMaker Server, refers to a notification sent to the server administrator via the web browser that's on the same machine where FileMaker Server Admin Console is running. Local notifications appear even when Admin Console is not in the foreground.

local variable

A variable that can be used only within the current script. A local variable is prefixed by $ (for example, $variable).

locked object

An object on a layout that cannot be edited or deleted. To lock or unlock an object, select it in Layout mode. In the Inspector, click the Position Position tab, then choose Lock or Unlock in the Arrange & Align area. If an object is locked, its selection handles dim.

lookup

A lookup matches records and copies data from a related table into a field in the current table. After data is copied, it becomes part of the current table (as well as existing in the table it was copied from). Data copied to a table doesn't automatically change when the values in the related table change.

lookup source field

The field in the related table that contains the data to be copied during a lookup.

lookup target field

The field that data is copied to during a lookup.

M

machine roles

Each computer in a FileMaker Server deployment is assigned a machine role as either a master or a worker. In a single-machine deployment, the one machine acts as both the master and the worker machine.

managed user

A Claris ID or external IdP user who is managed by the current team. Each user is managed by only one team at a time.

many-to-many relationship

A correspondence between data in database tables in which more than one record in the first table is related to more than one record in another table, and more than one record in that table is related to more than one record in the first table.

master

The machine in a FileMaker Server deployment that runs the Database Server and manages all worker machines. The master communicates with the workers to handle database requests from users and to monitor the status and activity of all components.

master-detail layout

In FileMaker Pro, a layout that displays a list of items in one area and the details about a selected item in another area. For example, in the list of email messages in your inbox, click one message to see details such as the date, sender, and body.

match field

For relational databases and lookups, a field in a source table and a field in a related table that contain values to use to find matching records. (A match field is sometimes called a key field or trigger field.) In the relationships graph, match fields appear in italics.

For importing records, values in the match fields determine which records in the source table update which records in the target table.

menu

A list of menu items. Each menu has a title that appears on the menu bar.

menu bar

The area at the top of the window (Windows) or screen (macOS) that displays the installed menu set.

menu item

One item listed in a menu on the menu bar. A menu item corresponds with one command, submenu, or separator.

menu item properties

All the settings for a menu item, including platform, display title, shortcut, and action.

menu set

The collection of menus that installs on the menu bar.

merge field

In FileMaker Pro, a placeholder on a layout for the contents of a field. A merge field expands or contracts in Browse and Preview modes, or when printed, to fit the amount of data in the field for each record.

Merge fields are useful for mail merge form letters; FileMaker Pro uses merge fields in predefined Labels and Envelope layouts.

merge variable

In FileMaker Pro, a variable inserted onto a layout that displays values from a or global variable onto the layout of the current record. You see the merge variable value in Browse, Find, and Preview modes, and when you print records.

modal window

A window that requires user action before users can continue working in FileMaker Pro. Use a modal window to display alert messages or to collect information from users.

mode

In FileMaker Pro, the four different environments (Browse, Find, Layout, and Preview) used for working with a file.

model

The result of applying a series of machine learning algorithms to a set of training data. The model is used for making predictions based on new input data.

multikey field

A match field that contains more than one value, each on a separate line. A multikey field can be used in one table involved in a relationship, to match several possible values in the match field of the other table. Sometimes called a complex key field.

My Apps window

For Claris ID or external IdP users, a window in FileMaker Pro and a tab in FileMaker Go that displays the files your account has access to, information about your account, and a link to Claris Customer Console. Files displayed in the My Apps window or My Apps tab appear on the Home page in Claris Customer Console.

N

navigation part

In FileMaker Pro, a layout part that appears above a title header part (top navigation part) or below a title footer part (bottom navigation part), and can contain fields, objects, and other controls to help users navigate a layout or custom app. Navigation parts do not print or preview.

network protocol

A set of rules that governs how computers exchange messages on a network. Common protocols include TCP/IP, HTTP, and HTTPS.

New Layout/Report assistant

The New Layout/Report assistant guides you through creating a layout or report. In Layout mode, click New Layout/Report in the status toolbar, or choose Layouts menu > New Layout/Report.

NFC (near field communication) tag

A chip containing data that can be read by mobile devices such as iPad and iPhone within close proximity. NFC tags can be locked or unlocked to prevent or allow data to be written. NFC tags are read, scanned for, and written to.

Notifications page

The page in Claris Customer Console on which Claris International Inc. communicates with Claris ID or external IdP users. For example, notifications may provide critical messages about product usage, warnings and subscription issues, and information about software updates.

O

OAuth

An authorization framework that enables third-party applications to authenticate users without the users sharing their credentials with the third party.

OAuth identity provider

A service that uses OAuth to authenticate a user.

object

On a FileMaker Pro layout, a discrete entity or shape that can be selected, moved, modified, deleted, or named. Lines, fields, buttons, popovers, panel controls, portals, imported graphics, blocks of text, tab controls, and web viewers are objects. Some objects, such as portals, have multiple components; for example, a portal row is a component of a portal.

object component

An element of an object, such as a portal row of a portal or a slide panel of a slide control.

objects pane

In FileMaker Pro Layout mode, a pane that includes the Fields tab and the Objects tab. To open the objects pane, click Objects pane button in the status toolbar. Or choose View menu > Objects > Fields Tab or Objects Tab.

Objects tab

In Layout mode, a tab in the objects pane where users view a hierarchical list of all objects that are on the layout; select, hide, and name objects; and change the stacking order. To open the Objects tab, click Objects pane button in the status toolbar, then click Objects. Or choose View menu > Objects > Objects Tab.

OData (Open Data Protocol)

A REST-based protocol for querying and updating data, which is built on standardized technologies such as HTTP, Atom/XML, and JSON.

ODBC

An API that uses SQL statements to access data from, and exchange data with, many database management systems. FileMaker Server can share data as a data source via ODBC. FileMaker Server can also interact with data from other applications (as an ODBC client application). FileMaker Pro uses ODBC drivers to share data (as a data source) and to interact with data from other applications (as a client application).

ODBC client driver

A DLL (Windows) or shared library (macOS) that sends an SQL query to access data stored in a data source and delivers the requested data to the client application.

omitted record

In FileMaker Pro, a record that has been excluded temporarily from the found set (but not from the file). View omitted records by choosing Records menu > Show Omitted Only, or add omitted records back to the found set by choosing Records menu > Show All Records.

one-away relationship

A correspondence between database tables in which two tables are directly related to each other, with no other tables between them.

one-to-many relationship

A correspondence between data in database tables in which one record in the first table is related to more than one record in another table.

one-to-one relationship

A correspondence between data in database tables in which one record in the first table is related to one record in another table.

Open Directory

Apple’s standards-based directory and network authentication services architecture for macOS.

operands

Components of a formula. For example, in the formula Quantity*Price, Quantity and Price are the operands.

operators

In calculations, symbols that indicate how to combine two or more expressions. These include the standard arithmetic operators (+, -, /, *), logical operators that set up conditions that must be met to make a value true or false (AND, OR, XOR, and NOT), and find operators (<, =, @) that limit the records defined in a find request.

In the relationships graph, symbols that define the match criteria between one or more pairs of fields in two tables. These include: != (not equal), > (greater than), < (less than), = (equal), <= (less than or equal to), >= (greater than or equal to) and x (all rows, or Cartesian product).

P

panel control

Panel controls include the tab control and slide control. Individual panels of these controls are tab panels and slide panels, respectively.

parent script

A script that defines script parameters and can call other scripts.

part label

In FileMaker Pro Layout mode, the label that appears at the left or side of the bottom dividing line of each layout part. To resize a part label, drag the part label up or down, or use the Part Definitions dialog box (by double-clicking the label).

permitted list

In FileMaker Pro, in the Preferences dialog box, the list of hosts and plug-ins that the user has permitted FileMaker Pro to use even though their security could not be verified.

PHP (PHP: Hypertext Preprocessor)

An open-source programming language primarily used in server-side application software to create dynamic webpages. FileMaker Server lets you publish data from FileMaker Pro files on customized webpages created with PHP.

placeholder text

In FileMaker Pro, a type of field label that displays within a field. Placeholder text can be a field name, other text (such as instructions), or the result of a calculation. In Layout mode, placeholder text is indicated by a Placeholder Text badge on a field.

plug-in

A third-party software component that extends the capabilities of an application in a specific way. For example, plug-ins extend the capabilities of FileMaker Pro through FileMaker Pro external calculation functions and external script steps.

popover

In FileMaker Pro, a layout object that can contain other layout objects. Popovers include a content area (where objects are placed) and can include a title. Popovers reposition on the screen as needed to stay in view.

popover button

In FileMaker Pro, a layout object that opens a popover.

portal

In FileMaker Pro, a layout object that displays data in rows from records that are in a related table or the current table.

post-processing script

In FileMaker Server, a system script that runs after a FileMaker script in a Script Sequence schedule.

pre-processing script

In FileMaker Server, a system script that runs before a FileMaker script in a Script Sequence schedule.

Preview mode

The FileMaker Pro mode in which you see how layouts will look when they're printed.

primary file

In a Kiosk custom app, the file that connects all of the auxiliary files and opens when you start the Kiosk custom app. From the Developer Utilities, you can select a primary file for custom apps that have more than one file.

primary key

In relational databases, a field that is in the same table as the record it identifies. A primary key value must be unique and not empty (non-null). There is only one primary key in a table.

private IP address

The private IP address of the host.

privilege set

A defined set of permissions that determines a level of access to a file. Privilege sets are defined in FileMaker Pro. Define as many privilege sets as needed for a file. There are three predefined privilege sets: Full Access, Data Entry Only, and Read-Only Access.

problem

In the FileMaker Pro Script Workspace, an error, omission, or other inaccuracy found in a script.

Profile page

The page in Claris Customer Console on which users manage their Claris ID account. Users can open their profile by clicking their Claris ID user name and choosing Profile.

progressive backup

In FileMaker Server, a copy of a database file created by FileMaker Server applying only the changes that have occurred during the save interval.

progressive downloading

In FileMaker Server, downloading of an audio, video, or PDF file stored in an interactive container field where the user may start using the file even if the entire file has not yet been downloaded.

proxy IP address

The proxy IP address to use for enabling outbound traffic.

Q

query

Retrieving, manipulating, or modifying data from a data source by sending SQL statements. Also, requesting and then receiving data from a DBMS. You can also add, edit, format, sort, and perform calculations on your data using queries.

quick find

In FileMaker Pro Browse mode, searches records across multiple fields on a layout.

R

Read-Only Access privilege set

One of the three predefined privilege sets that appear in every file. The Read-Only Access privilege set allows read access to the records in a file, but not write or design access.

Recent window

In FileMaker Pro, a window that displays files recently opened. You can remove recent files.

record

One set of fields in a database table. Each record contains data about a single activity, individual, subject, or transaction.

recover

If a file is damaged (for example, from an unexpected quit during a hard-drive update), you can attempt to recover the file. FileMaker Pro preserves as much data (the file’s schema and structure and its tables, records, layouts, scripts, and field definitions) as possible.

recurring import

A method of setting up a file to automatically import read-only data from another file. With recurring import, imported data refreshes when you open the file, view the layout that contains the imported data for the first time during a FileMaker Pro session, or run a data update script.

recursive script

A script that calls itself.

related field

For relational databases, a field in one table that is related to a field in another table (or to a different field within the same table). If a relationship is defined between two tables (even through another table), data in fields in one table can be accessed from the other table.

related record

A record in the related table whose match field (according to the relationship used) contains a value that's equal to the value in the match field of another table.

related table

For relational databases, the table that contains the data you want to access and work with in the current table. For lookups, the table that contains the data to copy.

relational database

A group of one or more databases that, when used together, contain all the data you need. Each occurrence of data is stored in only one table at a time, but can be accessed in any table, either in the same file or from a related file. Data from another table or file is displayed in the current table without being copied, and the data changes whenever the values in the other table or file change.

relationship

Relationships provide access to data from one table to another. Relationships can join one record in one table to one record in another table, one record to many other records, or all records in one table to all records in another table, depending on the criteria you specify when you create the relationship in the relationships graph.

relationships graph

In FileMaker Pro, a visual representation of the occurrences of tables both in the current file and from any external, related database files. In the relationships graph, you join tables and change relationships between fields in different tables, and specify multiple occurrences (with unique names) of the same table in order to work with complex relationships in the graph.

repeating field

A field containing multiple, separate values.

Report layout

In FileMaker Pro, a predefined layout type for setting up reports. Create a layout with simple rows and columns of data (as in a list), or a complex report with grouped data (subsummary reports). The fields that you specify appear in columns across the screen or page in one line. Field names are in the header part and the footer part is blank.

report with grouped data

A subsummary report that you create using the Report layout type. Reports with grouped data can include totals and subtotals.

resource

Data related to teams, groups, data services, Claris ID or external IdP accounts, FileMaker Cloud, and custom apps. Licensed users are authorized access to resources through their Claris ID or external IdP accounts.

restoration log

A log comprising multiple files that is used to restore a database file during startup restoration.

row

When a layout is viewed in Table View, a row corresponds to a record.

S

save interval

A setting that controls how often the progressive backup changes are written to a timestamped copy.

Schedule settings file

The file that contains information required to create schedules.

scheduled backup

A copy of a database file created by a backup schedule.

schedules

You can create schedules to back up hosted databases or run scripts.

schema

In database terminology, a schema is the organization of the tables, the fields in each table, and the relationships between fields and tables.

screen stencils

In Layout mode, nonprinting guides that help you design layouts for iPad, iPhone, or computers with different screen resolutions.

script

One or more instructions (script steps) that you define to automate repetitive or difficult tasks. You create and manage scripts using the Script Workspace. You run a script by clicking its button, choosing its menu command, calling it from another script or a plug-in, or running it at startup or when a file closes.

script client

A client created by the FileMaker Script Engine when a FileMaker script (or script sequence that includes a FileMaker script) runs as a scheduled task or when the Perform Script on Server script step is used to run a FileMaker script.

Script Debugger

An advanced tool for debugging FileMaker Pro scripts.

script schedule

A schedule that runs a system script, a FileMaker script, or a script sequence.

Script Sequence

A schedule that combines a FileMaker script with a preprocessing system script, a post-processing system script, or both.

script step

A command that you include in a script.

script trigger

A mechanism that causes a specified script to run when a particular event occurs.

Script Workspace

In FileMaker Pro, the window in which you build and edit scripts. The Script Workspace includes a toolbar with buttons, and areas for managing scripts (scripts pane), creating and editing scripts (script editing pane), selecting script steps (script steps pane), and getting Help for the selected script step (Help pane).

search criteria

In Find mode, the values and operators you specify to locate records. For example, if you type ABC Travel in the Vendor field, FileMaker Pro looks for and returns all records that have this name in the Vendor field.

secure database folder

A folder used by FileMaker Server to host database files that are required to be both password protected and encrypted.

Secure Sockets Layer (SSL)

A protocol to encrypt and authenticate communications on the internet. Used by the HTTPS access method.

security

The protection that’s placed on a file. Security includes various types of accounts to authenticate users, levels of privilege sets to determine what can be done with a file, and authorization of other files to create references to the current file (including its tables, layouts, scripts, and value lists). Security also includes extended privileges, which determine the data sharing options that are permitted by a privilege set.

segment

A component of a button bar object. Each segment can be defined as a button or popover button.

selected tab

In FileMaker Pro, in the Script Workspace, the tab that's in the foreground, in which scripts can be created or edited.

self-join

A relationship between fields in the same table. This creates another occurrence of the table in the relationships graph.

separator

A line within a menu that separates or groups menu items. A separator can also be the character used to separate parts of a date, time, or number, or the semicolon (;) used to separate parameters in a function definition.

serial number

A unique number entered by FileMaker Pro for each record. You can tell FileMaker Pro to automatically enter a serial number for each record by setting the Auto-Enter options in the Options for Field dialog box. You can also serialize records in Browse mode by choosing Records menu > Replace Field Contents.

server administrator

The server administrator is responsible for installing and configuring FileMaker Server as well as managing the FileMaker Pro databases and custom apps that are hosted on FileMaker Server.

service

Windows: a process that runs in the background and performs functions to support other programs. FileMaker Server runs as a service in Windows.

Settings page

The page in Claris Customer Console on which team managers manage settings for the team.

shared file

A file for which sharing has been enabled, which permits users to access the file over a network. FileMaker Server, FileMaker Cloud products, and FileMaker Pro each support one or more of the following ways to share files: FileMaker Network sharing, which permits multiple FileMaker Pro or FileMaker Go users to use a file simultaneously; publishing of files to web browser users via FileMaker WebDirect, Custom Web Publishing, or the FileMaker Data API; and sharing of data with other applications via ODBC/JDBC.

shared ID

A case-sensitive ID from 1 to 32 characters long that links encrypted files in a multifile custom app.

shortcut

Also known as keyboard shortcut. One or more keys that users can press to perform tasks.

shortcut menu

Use to edit objects or data quickly by choosing commands from a shortcut, or context, menu. Commands vary depending on the mode you're using, the item the cursor is over, and whether an item is selected.

To display a shortcut menu, right-click (Windows) or Control-click (macOS) the item.

sleep

A feature of the operating system that saves energy on an inactive computer. If the computer running FileMaker Server sleeps, all client activity is suspended.

slide control

A layout object made up of one or more slide panels, allowing you to organize fields and other objects within each slide panel’s borders.

 

Slide control in Browse mode

Slide control showing a slide panel in Browse mode

slide panel

A component of a slide control. The slide panel is the area displayed when a dot in a slide control is selected. Place objects such as lines, fields, buttons, portals, imported graphics, blocks of text, tab controls, slide controls, and web viewers on slide panels.

slider

In the status toolbar, the navigation control for quickly moving to a record in your file based on its location in the file. In Browse mode, moving the slider changes the current record. In Find mode, moving the slider changes the current find request. In Layout mode, moving the slider changes the current layout. In Preview mode, moving the slider changes the current page.

sliding objects

Objects that move together to close gaps left by entries in adjacent fields. Set sliding in Layout mode, in the Sliding & Visibility area of the Position Position tab in the Inspector.

SMTP (Simple Mail Transfer Protocol)

A standard server-to-server protocol for transferring email messages. FileMaker Server uses this protocol to send email notifications.

snapshot link

A found set of records that is saved in the FileMaker Pro Snapshot Link (FMPSL) format, with the filename extension .fmpsl. A snapshot link captures and preserves the found set as it was when you performed the find request. You can also email an FMPSL file to another person.

sort order

The sequence for rearranging records. Records are sorted by the first field in the sort order list, then the second, and so on. Values within each field are sorted by the order specified (ascending, descending, or custom).

source file

The file from which you bring data during importing or exporting, or the file from which you add a table to the relationships graph.

source table

The table upon which one or more table occurrences in the relationships graph are based. The source table is the table defined in the Tables tab of the Manage Database dialog box.

SQL

A structured programming query language that controls and interacts with a DBMS.

stacking order

In FileMaker Pro, the order in which objects overlap on a layout. In Layout mode, you can change this order in the Inspector or the Objects tab.

Standard form layout

The default layout, with all fields arranged on separate lines in the order they were defined. The body part is only as tall as it needs to be to include all the fields in the file. This layout includes header and footer parts.

startup restoration

The process of validating database entries when a file is first opened, before client access, if the file had not been properly closed. The restoration log (restore*.log) is used during the restoration process.

startup script

A script that automatically runs when a file is opened. You can script such things as setting system formats to the user's formats or setting a file to be shared in a startup script.

You specify a startup script in the OnFirstWindowOpen script trigger in the File Options dialog box.

status toolbar

The area across the top of the document window that displays navigation controls, customizable buttons, and a layout bar for working with layouts. In Layout mode, it includes layout tools.

 

Status toolbar in Browse mode

Status toolbar in Browse mode

 

Status toolbar in Layout mode

Status toolbar in Layout mode

If you don't see the status toolbar, choose View menu > Status Toolbar.

structure

In FileMaker Pro, the organization of file elements such as scripts, layouts, value lists, and privileges. You interact with a file’s schema through its structure.

style

A collection of attributes, such as font, color, line style, and text alignment, that determines the appearance of a layout.

submenu

A menu that extends from another menu item.

sub-script

A script that is called from another script.

Subscription page

The page in Claris Customer Console on which purchasers and team managers may make changes to their subscription and users may download FileMaker software.

subsummary part

In FileMaker Pro, use summary parts to view and display information from one or more records. You place a summary field in a summary part to display a summary of information for each group of records sorted on the break field. You can add one or more subsummaries above (leading) or below (trailing) the body.

subsummary value

Aggregate values for different categories of data within a field. For example, a subsummary value can be the total of employees for each department.

summary field

A field that contains the result of a summary calculation of values across a group of records.

supplemental field

A FileMaker Pro calculation field or summary field that you can append to ODBC tables in order to do calculations on the external data while working in FileMaker Pro. The calculations are not stored and you are not changing the schema of the ODBC table.

system formats

Settings that determine how your operating system displays and sorts dates, times, numbers, and currency.

If the system formats are different on your computer from those on the computer on which the file was created, the first time you open the file, FileMaker Pro asks if you want to use the system’s settings or the file’s settings. When you format fields, you can use the Inspector to have data displayed according to the current system formats.

T

tab control

A layout object made up of one or more tab panels that allows you to organize fields and other objects within each tab panel's borders.

 

Tab control and tab panels in Browse mode

Tab control showing a tab panel in Browse mode

tab order

The order in which you move from field to field in a record. In Layout mode, you can define a custom tab order and include buttons, panel controls, and web viewers in the tab order.

tab panel

A component of a tab control. The tab panel is the area displayed when a tab in a tab control is selected. You can place objects such as lines, fields, buttons, portals, imported graphics, blocks of text, tab controls, slide controls, and web viewers on tab panels.

table

A collection of data pertaining to a subject, such as customers or stock prices. A database contains one or more tables, which consist of fields and records. When you create a new table, a visual representation, or occurrence, of the table appears in the relationships graph. You can specify multiple table occurrences (with unique names) of the same table in order to work with complex relationships in the graph.

table occurrence

In the relationships graph, a separate view into a single underlying source table.

Table View

In FileMaker Pro, a layout view that displays multiple records in a tabular format like a spreadsheet. Each record appears in a row, and each field appears in a column. To select this view, click Table View in the layout bar.

In Browse mode, you can use Table View to create, modify, and delete fields; choose field types; add, delete, and sort records; or create a chart or dynamic report.

target file

The file into which you bring data during importing or exporting.

TCP/IP (Transmission Control Protocol/Internet Protocol)

The basic communication protocol that is the foundation of the internet.

team

A set of Claris ID or external IdP users who are authorized by the same purchase agreement.

team ID

The identification number of a FileMaker Cloud team.

team management privilege

Allows team managers to manage a team.

team manager

A Claris ID or external IdP user who manages a team’s accounts and other team resources.

team resource

Data related to a team, including Claris ID and external IdP accounts and Claris Store purchases.

template

A predefined website that you can select in the Web Viewer Setup dialog box to help you create a web viewer quickly.

text baseline

In Layout mode, the guideline that appears at the base of the text in a field or text block. Text baselines can be solid, dotted, or dashed. If you want text baselines to also appear in Browse and Find modes, select Text baselines in the Appearance Appearance tab in the Inspector.

text expression

Any expression that returns a text result. For example, a text expression can be a constant ("London"), a field reference (Status), or a calculated value (Rightwords(Lastname;1)).

timestamp

A field type combining date and time that is compatible with the ODBC requirement for the SQL format [yyyy.mm.dd hh:mm:ss.sss].

tooltip

A small box that displays text when a user pauses the pointer over a layout object. Tooltips display in Browse, Find, and Layout modes.

U

Unicode

A worldwide standard that, in one code page, provides a unique number for every character in human languages, no matter what the platform, software program, or operating system.

unit of measure

In Browse and Layout modes, you can set the unit of measure to points, inches, or centimeters.

unlicensed user

A Claris ID or external IdP user who is not covered by the current team’s User License.

unstored calculation

A calculation field with a result that is only calculated when the value is needed, for example, to browse or print. In most cases, FileMaker Pro makes a field stored when you define it, but you can change the storage type to unstored.

upload

To transfer data or files from one computer to a remote computer—for example, to use the Upload to FileMaker Server command in FileMaker Pro to transfer a database to FileMaker Server.

URL (Uniform Resource Locator)

A web address, which consists of a protocol, a host name, and optionally a port, a directory, and a filename. For example, https://example.com/ , ftp://12.34.56.78:80/myfiles/, or fmp://mywebsite.com/sample.fmp12.

User License

The license provided to a Claris ID user or external IdP user in a FileMaker Cloud team.

User license

A license type based on the number of users allowed to be connected simultaneously to FileMaker Server.

user type

In a FileMaker Cloud team, the two user types are managed users and external users.

Users page

The page in Claris Customer Console on which team managers manage the Claris ID or external IdP accounts in the team.

V

value list

To save time and ensure accuracy during data entry, define frequently used text, number, date, or time values as a value list. When you enter data, you can choose from the list of defined values.

You can format value lists to display in a drop-down list or pop-up menu, or as checkboxes or option (radio) buttons. The values in a value list can be user-defined or based on the values in a field in the same file or in a different file. You can also define relationships for use with value lists, to access and display particular related values. Another option is to use a value list from another file.

variable

In a calculation, a symbol or name that represents a value. Use certain script steps such as Set Variable or functions such as Let to specify the name, value, and repetition of the variable. Names prefixed by $ are local variables available only within the current script. Prefix the name with $$ to make the variable available throughout the current file (global). Local and global variables can have the same name but they are treated as different variables. Function variables have no prefix.

view

An arrangement of your data primarily useful for onscreen manipulation. In Browse mode, Find mode, or Preview mode, Form View displays individual records, List View displays records in a list, and Table View displays records in a spreadsheet-like table format.

W, X, Y, Z

web address

The calculated expression that you enter in the Web Viewer Setup dialog box. A web address is not equivalent to a URL that a web user could enter in a web browser.

web browser

An application that you can use to view webpages or websites on the World Wide Web or an intranet. Browsers download the webpages to the viewer's computer.

webpage

An HTML document displayed on the internet or an intranet.

Web Publishing Core

A software component of the Web Publishing Engine that processes requests for data and converts data from the Database Server into XML.

Web Publishing Engine

The Web Publishing Engine provides the Custom Web Publishing services and FileMaker WebDirect services for databases hosted by FileMaker Server.

web server

The software responsible for responding to HTTP or HTTPS requests from users on the web. Required in a FileMaker Server deployment for publishing databases on the web.

Web Server Module

A FileMaker Server software component installed on the web server machine. The Web Server Module enables the Web Publishing Engine to connect to the web server.

website

One or more webpages connected by links and displayed on the internet or an intranet.

web user

Someone using a web browser to access a FileMaker Pro file published on the World Wide Web or an intranet.

web viewer

A layout object that allows you to display information from websites based on data in your file.

worker

A machine in a FileMaker Server deployment that runs the Web Publishing Engine to host FileMaker WebDirect custom apps.

X-axis data

In a column, stacked column, line, and area chart, the data series you are comparing (for example, company name).

In a bar or stacked bar chart, the data series you are measuring (for example, annual sales).

XML (Extensible Markup Language)

Instead of being a rigid file format, XML is a language for defining agreed-upon formats that groups can use for exchanging data. Many organizations and businesses are using XML to transfer product information, transactions, inventory, and other business data.

FileMaker Pro can export XML data that can then be used, for example, by spreadsheet applications, data charting applications, and enterprise SQL databases. FileMaker Pro can also import XML data.

XSLT (Extensible Stylesheet Language Transformations)

XSLT (XSL Transformations) is a subset of XSL (Extensible Stylesheet Language) that is used to transform, or change, the structure of an XML document into a different document format. For example, you can use an XSLT style sheet to transform an XML document into an HTML or TXT document.

Y-axis data

In a column, stacked column, line, and area chart, the data series you are measuring (for example, annual sales).

In a bar or stacked bar chart, the data series you are comparing (for example, company name).