feature starter solutions

Schermafbeelding 2013-05-24 om 21.41.58

File size:

Limited only by disk space, to a maximum of 8 TB (terabytes) on a hard disk and OS API capability

Number of files per disk:

Limited only by disk space

Number of files/windows open simultaneously:

Mac OS: Up to 125 files/windows recommended.
Windows: Up to 125 files/windows is recommended. NOTE: the actual number is determined by factors such as:

- The visibility of the Formatting Bar and the Status Area
- The machines resources

It is possible to have more than or less than 125 windows available to open. If you find that you are unable to open 125 windows, it is recommended to keep the Formatting Bar, Layout Bar and Status Toolbar hidden when possible

Number of remote users per file:

Maximum of 9 concurrent clients (not including the host and Instant Web Publishing connections). FileMaker Go clients are included in the limit of 9 users

Number of files shared:

There is no limit.

Number of sessions via Web browser:

Access to web-published database is limited to 5 concurrent sessions. Note. If another view is opened through 'New Window' that's still in the same session

Number of tables per file:

1 million

Number of records per table:.

64 quadrillion total records over life time of file.

Maximum record size:

Limited by disk space or maximum file size

Number of fields/columns per record:

256 million total fields over life time of file.

Number of relationships per file:

Limited only by disk space or maximum file size.

Number of Web Viewer objects per file:

No hard limit. The more Web Viewer objects on a layout can slow down printing, Preview mode, switching between records and scrolling through records for layouts that include multiple Web Viewers.

Length of field name:

Up to 100 characters.

Maximum length for a Layout Object name:

Up to 100 characters.

Table view width limitation:

32000 * 32000 points.

Field Types:

Text, Number, Date, Time, Timestamp, Container (for sound, picture, movie, documents, including Microsoft Word or Excel files, Adobe Acrobat PDF files, PowerPoint presentation files and so on) Calculation and Summary. The Global type is specified as an option.

Serial number options:

The maximum number is limited by the Number type's range. In the Auto-Enter Serial Number option, user can enter up to 255 characters in the 'next value' edit control and numbers in the range 1 to 32767 in the 'increment by' edit control. If alpha numeric the rightmost characters that are numbers are incremented.

Maximum field size, by type:

  • Text: Up to 1 billion characters per field per repetition (limited by available memory) with optional text style runs and paragraph runs. Index is based on the first 100 characters of each word or value.
  • Number: Support values from 10^-400 up to 10^400 and the negative values of the same range. Index based on the first 400 significant digits. Up to 1 billion characters per field. The first 400 digits are indexed.
  • Date: Gregorian calendar with the range of 1/1/0001...12/31/4000. Month, day, year order based on system settings when file is created.
  • Time: Input formats: Hour:Minute:Seconds.Fractional, Hour:Minute:Seconds,Minute:Seconds.Fractional, Hour:Minute, Seconds.Fractional and Seconds. Time may be preceded by a negative sign and each numeric value must be in a range of 0 to 999999. Times are not limited to 24-hour format to allow for calculations spanning multiple days. If the minutes or seconds exceed 60, the excess is carried over to minutes or hours as appropriate.
  • Timestamp: Standard date followed by spaces and then by a time in the range of 0:0:0.0 to 23:59:59.999999.
  • Container: Multiple streams of binary data totaling no more then 4 gigabytes per container field. (new storage types added)
  • Calculation: Depends on result type.
  • Summary: Depends on result type.

Number of field repetitions (sub records):

Up to 32,000 for each field.

Indexed (key) fields per file:

Any field may be specified to index as an option, except: Container, Summary, Global, or unstored Calculation fields.

Number of sort levels:

No limit

Size of calculation formula:

Maximum of 30,000 characters, including text and numbers, any referenced fields, operators, functions and parentheses.

Calculation operators:

=, ≠, >, <, ≥, ≤ , $, $, and, or, xor, not, (, ), +, -, /, *, ^, (paragraph), " " (text literal), & (concatenation).

Number of calculation functions:

  • Aggregate 10
  • Container 4
  • Date 13
  • Design 21
  • External 1
  • Financial 4
  • Get 102
  • Logical 18
  • Mobile 2
  • Number 18
  • Repeating 3
  • Summary 1
  • Text 45
  • Text Formatting 10
  • Time 4
  • Timestamp 1
  • Trigonometric 9

Number of summary functions:


Number of layouts per file:

Limited by disk space or maximum file size.

Layout size:

32,000pt x 32,000pt; may be limited by currently selected printer and page setup. Objects beyond current page width do not print

Number of layout objects:

Maximum of 32,768 objects on each layout

Number of scripts:

Limited by disk space. Displayed in Scripts menu: 512 on Windows, 32,767 on Mac OS.

Number of columns across the page:

Up to 99 columns

Number of labels across the page:

Up to 99 labels

File formats for import:

Comma-Separated Text (.csv or .txt), dBASE III and IV DBF (.dbf), FileMaker Pro, Merge, Microsoft Excel (.xslx), Tab-Separated Text (.tab or .txt), XML, Bento (on Mac) and ODBC

File formats for export:

Comma-Separated Text (.csv or .txt), dBASE III and IV DBF (.dbf), FileMaker Pro, HTML Table, Merge, Microsoft Excel (.xslx), Tab-Separated Text (.tab or .txt), XML

Picture formats for import:

Encapsulated Postscript (.eps), FlashPix (.fpx), GIF (.gif), JPEG/JFIF (.jpg), JPEG 2000 (.jp2) (Mac OS), MacPaint (.mac) (Mac OS), PDF (.pdf) (Mac OS), Photoshop (.psd), PNG (.png), QuickTime Image File (.qt), SGI (.sgi), Targa (.tga), TIFF (.tif), Windows bitmap (.bmp), Windows Metafile/Enhanced Metafile (.wmf/.emf) (Windows)

Limit of Repetitions for Variables in an Iterative loop:

10^400 for the variables if they are defined as numbers

Recursion limit for custom function:

  • 50,000 recursive calls total
  • The call stack is only allowed to be 10,000 calls deep at any point. If these limits are violated, the custom function will return "?".

Note that tail-recursion is properly optimized, so tail calls do not increase the size of the call stack.