Softpedia >Mac >Developer Tools >FileMaker Pro >  Changelog

FileMaker Pro Changelog

What's new in FileMaker Pro 20.3.2.201

Feb 28, 2024
  • Addressed issues:
  • This update provides important security fixes and is recommended for all users.
  • macOS Sonoma: Changing modes or reopening files caused custom toolbars to reset to defaults.
  • If a file already had a FileMaker or ODBC external data source added, you couldn't add a table from your Claris Studio data source in the relationships graph.

New in FileMaker Pro 20.3.1.31 (Nov 16, 2023)

  • New features and enhancements:
  • The Loop script step now includes the Flush option which determines when relationships are updated. Flush includes the following three values:
  • Always: When setting a field within a loop, the relationship is flushed along with the join data.
  • Minimum: When setting a field within a loop, minimal data is flushed.
  • Defer: When setting a field within a loop, data and relationship data are flushed only after exiting the loop.
  • Layout calculations now let you to specify the data type for the result in the Specify Calculation dialog.
  • The new FMDeveloperTool command-line tool is now available. See FileMaker Server Release Notes.
  • Secure connection tunneling can now be enabled over port 443 instead of port 5003 for FileMaker Pro and FileMaker Server for Linux. HTTPS tunneling can be enabled in the following locations:
  • FileMaker Pro preferences: Choose Edit > Preferences (Windows) or FileMaker Pro > Settings (macOS), then on the General tab, select HTTPS Tunneling.
  • Assisted Install.txt file: AI_USE_HTTP_PROTOCOL_NETWORK=1
  • Notes:
  • HTTPS tunneling may only be enabled for FileMaker Server for Linux installed on Ubuntu 22.
  • The Get(NetworkProtocol) function now returns "HTTPS" when HTTPS tunneling is enabled on the FileMaker client or FileMaker Server where the calculation is performed.
  • OmniOrb has been updated to version 4.3.0.
  • To improve performance, the database engine now caches relationships to evaluate dependencies.
  • FileMaker Pro also includes optimized memory allocation for relationship changes.
  • Addressed issues:
  • Layouts:
  • In layout calculations, references to fields in the current table occurrence now require only the field name, not the fully qualified name (table::field).
  • If part of a layout calculation failed to evaluate, the calculation formula was displayed in Browse mode.
  • macOS Sonoma: In Layout mode, the shortcut menu didn't display the color palette when you tried to change the color of an object or layout part.
  • macOS Sonoma: Resizing an object in Layout mode caused the handle to flash and the border to display as thicker than normal.
  • Script Workspace:
  • macOS: Rapidly renaming scripts or folders in the Script Workspace sometimes caused FileMaker Pro to quit unexpectedly.
  • macOS Sonoma: Opening and editing a script in the Script Workspace, then closing and reopening the Script Workspace caused the toolbar to no longer appear in the Script Workspace.
  • General:
  • When using an OAuth 2.0 provider to send email, the email wasn't sent, and an error was returned saying the access token couldn't be generated. This happened when FileMaker Pro tried to send email or when FileMaker Server tried to send email notifications.
  • Databases on FileMaker Server stopped responding or closed unexpectedly when errors appeared in temporary database files.
  • In the Specify Field dialog, the methods to open the Manage Database dialog were missing or didn't work.
  • macOS: Creating a self-join in the relationships graph caused FileMaker Pro to quit unexpectedly.
  • macOS Sonoma: When Stage Manager was turned on, in some cases, FileMaker Pro windows returned to their original positions after you moved them.
  • macOS Sonoma: The status toolbar failed to appear in the document window of a newly opened file if the document window was closed while the status toolbar was hidden in another file.
  • Note: The toolbar settings for the New Window script step are ignored in macOS Sonoma.
  • macOS Sonoma: FileMaker Pro quit unexpectedly when using the cut command (Command+X) on a picture in Layout mode.
  • Known issues:
  • If a field reference in a layout calculation uses only the field name, the layout calculation doesn't update when the field data changes. To work around this issue, use the fully qualified field name (table::field).
  • macOS Sonoma: When you customize the status toolbar then switch modes, the customization is lost.

New in FileMaker Pro 20.2.1.60 (Oct 6, 2023)

  • New features and enhancements:
  • The Trigger Claris Connect Flow script step now includes a dialog that allows you to select a flow from a Claris Connect team. The Select Claris Connect Flow dialog allows you to select a team and flow the signed-in Claris ID user, who must be in a Claris Connect team. The name of the flow you select for the Flow option is saved at the time you select it and will not be updated if you change the flow's name in Claris Connect. See Trigger Claris Connect Flow.
  • The new layout calculation allows you to place a calculated value on a layout without creating a calculation field or setting a variable in a script.
  • To insert a layout calculation onto a layout:
  • In Layout mode, click in the layout where you want to insert the layout calculation, then choose Insert menu > Layout Calculation.
  • Don't insert layout calculations over a field or any other object that you want to view.
  • In the Specify Calculation dialog, enter the a formula for your calculation, then click OK.
  • A layout calculation, including the specified calculation, () appears on the layout.
  • To modify a layout calculation:
  • In Layout mode, right-click the layout calculation, then choose Edit Layout Calculation.
  • In the Specify Calculation dialog modify the calculation, then click OK.
  • Addressed issues:
  • The OnRecordCommit and OnRecordRevert script triggers were incorrectly triggered for record data committed between the Open Transaction and corresponding Commit Transaction or Revert Transaction script step.
  • Known issues:
  • macOS: After a successful update, FileMaker Pro must be relaunched manually.

New in FileMaker Pro 20.1.2.204 (Jun 7, 2023)

  • Addressed issues:
  • The Close Window script step in a script triggered by the OnWindowTransaction script trigger failed to close the document window.
  • The following French script trigger name and description translations have changed:
  • OnWindowTransaction (English):
  • SurOperationFenetre is updated to SurTransactionFenetre (French)
  • The following French control script step name and description translations have changed:
  • Revert Transaction (English):
  • "Annuler l'opération" is updated to "Annuler la transaction" (French)
  • Open Transaction (English):
  • "Ouvrir une opération" is updated to "Ouvrir une transaction" (French)
  • Commit Transaction (English):
  • "Valider l'opération" is updated to "Valider la transaction" (French)
  • The following French design function name and description translations have changed:
  • BaseTableIDs (English):
  • IDsTableBase is updated to IDsTablesBase (French)
  • BaseTableNames (English):
  • NomsTableBase is updated to NomsTablesBase (French)
  • TableIDs (English):
  • IDTable is updated to IDsTables (French)
  • LayoutIDs (English):
  • IDModele is updated to IDsModeles (French)
  • ScriptIDs (English):
  • IDScript is updated to IDsScripts (French)
  • FieldIDs (English):
  • IDRubrique is updated to IDsRubriques (French)
  • ValueListIDs (English):
  • IDListeValeurs is updated to IDsListesValeurs (French)
  • The Get ( ModifiedFields ) function failed to return all field modifications when a field repetition other than the first repetition was modified.
  • Creating, modifying, and deleting find requests incorrectly triggered the OnWindowTransaction script trigger.

New in FileMaker Pro 19.6.3.302 (Feb 2, 2023)

  • Addressed issues:
  • Performance:
  • Databases hosted by FileMaker Server took longer than expected to open for the first time when they contained a large number of accounts and the network connection experienced delays.
  • General:
  • Under certain conditions, index values were missing after the index was built during a transaction.

New in FileMaker Pro 19.6.1.45 (Dec 1, 2022)

  • New features and enhancements:
  • Transactions:
  • You can use the following new script steps to commit or revert all changes in a transaction together. A transaction consists of changes to one or more records in the current window. Transactions support creating new records, editing records, and deleting records.
  • Open Transaction: Starts a transaction; subsequent record changes are held in the transaction until a Commit Transaction or Revert Transaction script step is performed.
  • Commit Transaction: Saves all record changes and ends the current transaction.
  • Revert Transaction: Returns all records changed in the transaction to their original state and ends the current transaction.
  • macOS Ventura:
  • FileMaker Pro supports installation on macOS Ventura 13.
  • Sign in with Apple:
  • Sign in with Apple (Apple ID) is now available as an authentication option when opening a file.
  • Script steps:
  • The new Set Dictionary script step allows you to specify the language and dictionary to check spelling in a file.
  • Functions:
  • The new Get(TransactionOpenState) function returns 1 (true) if called within an open transaction; otherwise, it returns 0 (false).
  • The new Get(CurrentTimeUTCMicroseconds) function returns the current time in Coordinated Universal Time (UTC) to the nearest microsecond.
  • The Get(LastExternalErrorDetail) function is renamed to Get(LastErrorDetail) and additionally returns the text of transaction error information, including script name, step name, and line number when it is evaluated after a Commit Transaction script step.
  • The new Get(LastErrorLocation) function returns the location of errors that are returned by the Get(LastError) function.
  • Updated libraries:
  • The jsonCPP library has been updated to version 1.9.5.
  • The ChartDirector library has been updated to version 7.0.
  • OpenSSL has been updated to version 3.0.7.
  • General:
  • The Show sign-in fields even when OAuth or AD FS is enabled file option is now enabled by default for newly created files.
  • Context menus for interactive container fields can now be disabled in the Inspector's Data tab in the Data Formatting area.
  • In Preferences in the General tab, you can now delete cached temporary files.
  • The new Tools menu > Create Add-on command allows you to create an add-on without using the Save a Copy as Add-on Package script step. This command lets you specify information about the add-on, creates the add-on package, and saves it where you can then install and use it in an app. This feature is incomplete but available for preview and should only be used for testing purposes.
  • To create an add-on with this command:
  • In Layout Mode, name the layout "__FMAddOnTemplateDirectives_en".
  • Select multiple objects on the layout.
  • Choose Arrange menu > Group.
  • With the group selected, choose Tools menu > Create Add-on.
  • Addressed issues:
  • Windows:
  • When using the Insert from URL script step and the --cookie-jar cURL option, the cookie data was not returned.
  • When custom apps contained more than 255 layouts, navigating to a layout with an ID greater than 255 caused the last layout in an app to load instead of the expected layout. The limit is now 1020 rather than 255.
  • The Insert from a URL script step failed when using a cURL option with the LDAP protocol.
  • Rendering performance was slower than in FileMaker Pro 18.
  • In the Script Workspace, importing a script containing errors when no script was open caused two script tabs to open and could cause the application to close unexpectedly if the script was deleted or the script tabs were closed.
  • FileMaker Pro intermittently quit unexpectedly when dragging files to a web viewer.
  • Container fields set to automatically play audio or video were not automatically playing.
  • Button parameters incorrectly displayed only the value of the first parameter when you changed the value in one button and navigated to the next button using the Button Bar Setup dialog box.
  • macOS:
  • Using the Command-Z keyboard shortcut while in some dialog boxes cause FileMaker Pro to quit unexpectedly.
  • Popover titles were sometimes missing when opened for the first time on a layout.
  • Keyboard shortcuts were different when using a keyboard with a non-US layout.
  • Dragging an Assisted Install.txt file to FileMaker Pro unexpectedly reverted the application to Trial mode.
  • Windows and macOS:
  • Importing records using the Import Records script step with the Specify import order option specified caused FileMaker Pro to quit unexpectedly.
  • When the Trim function was used within the List function, the Trim function didn't remove beginning or trailing spaces.
  • When opening a local file using the Open URL script step with a URL such as fmp://filename.fmp12, a prompt requested if the file should be added to the permitted host list, even though the file was not hosted remotely.
  • Web Viewers defined as buttons did not function as buttons.
  • Using the Enter, Delete, Tab, or Backspace keys while pressing mouse buttons to select a value in a drop-down list caused the "Assertion Failed" error message to appear.
  • If a user's account name was longer than 31 characters, it couldn't be entered in Preferences as the user name to automatically fill in the sign-in dialog box.
  • The conditional formatting badge might not have been shown for button bars embedded in popovers or slide controls.
  • The Open Record/Request script step failed to return an error if the focus was in a global field and when a record was already open in another window.
  • The Open Record/Request script step incorrectly returned error 101 if the focus was in global field.
  • The GetThumbnail function incorrectly returned the full width and height values if the specified width or height was larger than the width or height of the original image.
  • The FedEx preset URL in the WebViewer Setup dialog box was incorrect.
  • Previous value: "http://www.fedex.com/Tracking?" & "tracknumbers=" & ""
  • New value: "https://www.fedex.com/fedextrack/?" & "trknbr=" & ""
  • The Execute FileMaker Data API script step sometimes returned the incorrect found count.
  • The Base64EncodeRFC function incorrectly returned its result as a number rather than as text.
  • Using the Save a Copy as XML script step or command to create XML files greater than 4GB caused FileMaker Pro to quit unexpectedly.
  • PDF files with path names longer than 255 characters displayed icons with error messages instead of their content when viewed in interactive container fields.
  • Styles for layout parts couldn't be copied and pasted.
  • Enabling indexing for a field in the Manage Database dialog box incorrectly altered the modification counts on all records.
  • FileMaker Pro quit unexpectedly when opening a file with an fmp URL.
  • While starting, FileMaker Pro quit unexpectedly if the license certificate data was corrupted.
  • Copying and pasting a button on a layout cleared the tab order of the pasted button.
  • Known issues:
  • macOS 13: Animation in the Script Workspace window may not be smooth.
  • macOS 13: Card windows may not display correctly after being minimized and restored when using Stage manager.
  • macOS 13: When printing, the Current Record option is ignored; the Pages option is used instead.
  • Within transactions, aggregate functions like List and Count don't have access to records modified within the transaction and only provide information for records that are not part of the transaction.
  • Documentation errata:
  • The new Get(CurrentTimeUTCMicroseconds) function is missing from Claris Pro and FileMaker Pro Help. This function is similar to Get(CurrentTimeUTCMilliseconds) except that the return value is given to the nearest microsecond.
  • APIs, technologies, or features to be deprecated:
  • As FileMaker Pro evolves, the list of supported technologies, APIs, and features will change. As part of this evolution, certain operating systems versions, hardware, and features may be deprecated in favor of newer ones. Although deprecation does not mean the immediate deletion of an item, you should migrate your solution away from deprecated technologies, because these technologies may be removed in a future version of the product.
  • For the latest information about deprecated APIs, technologies, and features, search the Knowledge Base.

New in FileMaker Pro 19.5.4.401 (Sep 20, 2022)

  • New and removed features:
  • This release includes in-product notifications which allow us to share our latest news with you directly in FileMaker Pro and FileMaker Server (English only).
  • macOS: The quick start experience is no longer available.
  • Addressed issues:
  • FileMaker Pro and FileMaker Server can now open files that could not be reopened after modifying the settings in the File Options dialog box with a limited access account.

New in FileMaker Pro 19.5.2.201 (Jul 13, 2022)

  • Addressed issues:
  • Custom functions were commented out if imported from another file.
  • Functions were commented out in fields with calculations if tables were imported from another file.
  • The Replace Field Contents script step was much slower in version 19.5.1 than in previous versions.
  • In some cases, field validation incorrectly displayed a warning message for empty repeating fields or fields that were not modified.
  • PDFs being generated in a hidden background file didn't calculate an object's visibility correctly.
  • Windows: Upgrading to version 19.5.1 with a valid maintenance contract resulted in an invalid maintenance expired message.
  • In version 19.5.1, the Quote function was modified to handle line feeds the same way as carriage returns. This change caused existing calculations to return different, unexpected results. Previous functionality has been restored.
  • macOS: Modifying data in a field while an administrator modified the same field in the Manage Database dialog box caused FileMaker Pro to quit unexpectedly.

New in FileMaker Pro 19.5.1.36 (Jun 16, 2022)

  • New features and enhancements:
  • Security:
  • FileMaker Pro notifies you when an fmp URL is opening a hosted custom app. Choose to open anyway, add the host to your permitted hosts list, or cancel. See Setting permitted hosts and plug-ins preferences in FileMaker Pro Help.
  • This notification is disabled by default. To enable it, open the Preferences dialog box and in the Permitted tab, choose Warn me before an fmp URL opens a file. See FileMaker Pro Help.
  • To enable this notification for assisted installations, set AI_WARN_FMP_URL in the Assisted Install.txt file. See FileMaker Pro Network Install Setup Guide.
  • OpenSSL has been upgraded to version 1.1.1n.
  • Functions:
  • JSONGetElementType – Returns the type of JSON data for an element specified by an object name, an array index, or a path. For example, the following validates that fieldText contains a JSON object: ( JSONGetElementType ( fieldText, "" ) = JSONObject ).
  • GetLiveText – Returns the text found in the image of the specified container field using the text-recognition algorithm, starting with iOS 15.0, iPadOS 15.0, and macOS 12.0. You specify a container field and one of the supported language codes.
  • ReadQRCode – Reads a QR code from an image in a container field and returns it as text, starting in macOS Monterey, iOS 15, and iPadOS 15.
  • Scripts:
  • You can now save data from the current window by leaving the "Window name" option empty in the Save a Copy as XML and Save a Copy as Add-on Package script steps.
  • Layouts:
  • When you copy objects that have no tab order set, the pasted objects now have no tab order set. Previously, pasted objects were next in the tab order.
  • License:
  • You can now replace the existing license certificate file at any time without quitting FileMaker Pro. See Replacing the license certificate file in FileMaker Pro Help.
  • XML:
  • The Save a Copy as XML script step now includes the following in the XML file:
  • metadata specifying whether database files are encrypted
  • detailed calculation information, including variables
  • unique hashes for calculations
  • references to scripts across file relationships with the same UUIDs
  • references to fields across file relationships with remote UUIDs as members of related file layouts
  • external data source references and UUIDs for value lists
  • The timestamp property has been removed from the headers of the XML created by the Save a Copy as XML script step.
  • In the output XML file of the Save a Copy as XML script step, FileReference is renamed DataSourceReference. Other value list external reference errors have also been corrected.
  • Addressed issues:
  • Security:
  • It was possible to use the Add Account script step to specify the Full Access privilege after reordering the privilege sets. Full Access is now grayed out for the Add Account script step regardless of the order of the privilege sets.
  • Modification Detection Code 2 (MDC2) has been deprecated by OpenSSL and is now removed as an algorithm option from various FileMaker Pro cryptographic functions.
  • Long Custom OAuth names were truncated in the login dialog box.
  • Stability:
  • macOS: FileMaker Pro closed unexpectedly when performing the Close Window script step while processing layout scroll events.
  • macOS: FileMaker Pro quit unexpectedly when reverting changes in the Manage Database dialog box if field names contained uncommitted Japanese characters from an ATOK input.
  • Performance:
  • Conditionally hidden layout objects continued to be evaluated in hidden windows, slowing layout loads.
  • Script Workspace:
  • macOS Monterey: Line numbers in Script Workspace displayed inconsistently when scrolling through a script.
  • macOS: The working script in Script Workspace contained unexpected indentations between line numbers and the code until the working script was edited.
  • Adding comments (#) in Script Workspace caused inconsistent indentation.
  • Save a Copy as XML:
  • The output XML file of the Save a Copy as XML script step incorrectly used the same UUID to identify parent scripts and child scripts called from the Perform Script script step if the child scripts were located in different files from the parent scripts.
  • The output XML file of the Save a Copy as XML script step included the incorrect UUIDs for scripts in related files when calling the Perform Script script step.
  • When using the Save a Copy as XML script step, the FieldReference tag was missing in the output XML file.
  • The output XML file of the Save a Copy as XML script step included unnecessary ampersands (&) in the name attributes of base tags.
  • For the output XML file of the Save a Copy as XML script step, the timestamp for UUID under ScriptCatalog did not update when modification counts changed.
  • General:
  • Windows: When multiple container field objects on a layout contained mixed optimization options (such as "Images" and "Interactive content") in Inspector > Data > Data Formatting, and the objects were collectively selected in Layout Mode, the radio buttons for Optimize for in the Inspector became unresponsive.
  • When a group of relationships were copied on the relationships graph, the relation keys were appropriately related to the new table occurrences, but the sort fields continued to reference the original table occurrences.
  • The Quote function failed to escape line feed characters in the same way as carriage returns.
  • macOS: The View Index window sometimes truncated the index text.
  • Windows: Newly installed custom menus were not displaying after opening new windows unless the windows were refreshed.
  • The tooltip for the Shortcuts Donation icon in the Script Workspace incorrectly read "Run script with full access privileges" instead of "Run script by Siri".
  • Windows: The Save a Copy as Add-on Package script step returned an error.
  • macOS: Calculation field styles were not rendering in Table View for FileMaker Pro 19.4.1 when the width of Table View was longer than the width of the layout and for calculation columns further to the right than the layout edge.
  • macOS: Deleting a macOS shortcut from the FileMaker Pro preferences also removed all entries below the deleted entry.
  • Windows: Pressing the PgUp, PgDn, End, Home, Up Arrow, Down Arrow, Left Arrow, Right Arrow, or Delete keyboard keys or pressing the Ctrl+A, Ctrl+C, Ctrl+V, Ctrl+X, or Ctrl+Z keyboard key combinations while inside text fields in web viewers did not allow the cursor to move.
  • Windows: Web Viewers defined as buttons did not respond to button clicks.
  • Windows: The Insert from URL script step with the cURL options did not return values when it was performed from a computer user account containing Japanese characters.
  • macOS: FileMaker Pro quit unexpectedly when certain non-ASCII characters were selected in text fields and then the Accessibility feature Spoken Content was activated.
  • Tab controls with 0 point width caused a pixel bar to show up on layouts where an empty space was expected.
  • macOS: The OpenURL script step was unable to open macOS Shortcut URLs with the shortcut scheme (shortcut://).
  • When importing records, imports with field validation failed to filter record imports and instead ignored the “existing value” validation option and imported all records.
  • Web Viewers with dark backgrounds flashed white when entering a layout in browse mode before rendering the dark background.
  • macOS: Slide control panels applied one conditional format to all panels instead of applying conditional formatting to individual panels.
  • macOS: JPEG images with invalid DPI properties were displayed incorrectly.
  • macOS: The slider in the navigation controls did not slide when pressing backward and forward navigation buttons if slider navigation preceded button press navigation.
  • The literal string "

New in FileMaker Pro 19.4.2.204 (Jan 28, 2022)

  • Windows and macOS:
  • When an ECC P-384 SSL certificate was used for Claris FileMaker Server®, FileMaker Pro and Claris FileMaker Go® were unable to securely connect to custom apps using fully qualified domain names.
  • When using FileMaker Pro 19.4.1 to connect to custom apps hosted by FileMaker Server or Claris FileMaker Cloud®, layouts took significantly longer to display.

New in FileMaker Pro 19.4.1.36 (Nov 18, 2021)

  • New features:
  • Running scripts through Shortcuts (macOS Monterey):
  • Starting in macOS Monterey, shortcuts can run FileMaker® scripts in FileMaker Pro (as in Claris FileMaker Go® since version 19.0). In the Script Workspace, you can designate which scripts in a FileMaker Pro file to donate to the Shortcuts app. You can then run a shortcut using the Shortcuts app or Siri voice commands to open the file, run your script, and pass in an optional parameter.
  • Customizable OAuth identity provider support:
  • Starting in Claris FileMaker Server® 19.4.1, you can set up one of several additional supported OAuth identity providers. Along with more settings to support more providers, you can also customize the name and icon of the provider that users will see when they sign in with FileMaker Pro, FileMaker Go, or Claris FileMaker WebDirect®. See FileMaker Server Help. For a list of supported providers, see FileMaker Server technical specifications in the Knowledge Base.
  • In the Manage Security dialog box, FileMaker Pro now has a new account access type, Custom OAuth, to authenticate users via a customized OAuth identity provider. You can use this new account access type to create accounts for users or groups that you define in your identity provider.
  • The Get(AccountType) function now returns Custom OAuth when the current user's account is authenticated via a customizable OAuth identity provider.
  • Session identifier:
  • The new session identifier allows custom app developers to provide administrators additional information about a user connected to a hosted app. By default, the session identifier is the same value returned by the Get(UserName) function. An app can now use the Set Session Identifier script step to change that default value. For example, for FileMaker WebDirect users, you can change the default value [WebDirect-xxxxx], where xxxxx is an identifier generated by the host, to a value that's more meaningful to the administrator (a user name, account name, or other identifier).
  • The session identifier is available to FileMaker Server administrators in Admin Console and the Access log file, and to FileMaker Server and FileMaker Cloud administrators in the Claris FileMaker Admin API.
  • The new Get(SessionIdentifier) function returns the value set by the Set Session Identifier script step.
  • For more information, see FileMaker Pro Help.
  • Enhanced features:
  • Faster SQL queries for information about fields in FileMaker tables:
  • For faster SQL queries about fields defined in a FileMaker Pro file, you can now use the system table named FileMaker_BaseTableFields rather than the existing FileMaker_Fields table. FileMaker_Fields includes every table occurrence, but FileMaker_BaseTableFields includes only the source (or base) tables.
  • The FileMaker_BaseTableFields table includes the following columns:
  • BaseTableName – The name of the base table that contains the field.
  • FieldName – The name of the field.
  • FieldType – The SQL data type of the field.
  • FieldId – The unique ID for the field.
  • FieldClass – One of three values: Summary, for summary fields; Calculated, for calculated results; or Normal.
  • FieldReps – The number of repetitions of the field.
  • ModCount – The total number of times changes to this base table’s definition have been committed.
  • Offset and limit for related records returned by the Execute FileMaker Data API script step:
  • In the Execute FileMaker Data API script step, the Request option now supports the offset.portal-name and limit.portal-name keys to limit which related records are returned. See FileMaker Pro Help.
  • Addressed issues:
  • Important: To ensure that you don't encounter the following issues, you must update all clients to FileMaker Pro 19.4.1.
  • Windows and macOS:
  • The Claris FileMaker Platform was updated to OpenSSL version 1.1.1l to improve security.
  • When importing Excel (.xlsx) or XML files that referenced an external DTD (Document Type Definition), FileMaker clients processed the external DTD. To improve security, external entity resolution is now disabled in FileMaker clients so that external DTDs are no longer processed.
  • When transferring embedded container data to external storage for more than one container field at the same time in a hosted FileMaker Pro file, the embedded data wasn't removed from the FileMaker Pro file. Also, this issue may have damaged the temporary file and caused the host to stop responding.
  • After choosing File menu > Import Records > Folder and selecting Picture and movie files, video and audio files were imported by reference regardless of how the Import only a reference to each picture file option was set. Now, the option is named Import only a reference to each file and imports all supported image, video, audio, and PDF files by reference when selected.
  • In the status toolbar, choosing Share > Upload to Host either did nothing or failed to add the current file to the upload list.
  • When opening a custom app with the Guest account and with Kiosk mode enabled, the app opened normally, not in Kiosk mode.
  • Closing a file or window caused all open files to close if the file's OnLastWindowClose script trigger ran a script that included a Close File [ Current File ] or Close Window [ Current Window ] script step.
  • In an add-on with nested groups of layout object that was created by the Save a Copy as Add-on Package script step, objects in the inner group were duplicated in the outer group.
  • After completing successfully, the Insert from URL script step didn't set its error code, which caused the Get(LastError) function to return the error code for the previous script step instead.
  • Windows:
  • In interactive container fields:
  • After dragging a file to the field, the file wasn't added to the database. Depending on the file type, the file was either displayed in the field or downloaded to the Downloads folder.
  • When a PDF file was inserted with the Store only a reference to the file option, the file didn't display in the field.
  • After adding a favorite host in the Hosts dialog box and closing and reopening the Hosts dialog box, selecting a file on that host and clicking OK to open it did nothing.
  • Windows software that used the ActiveX protocol to access FileMaker Pro files failed to work after a version of FileMaker Pro from 19.0.1 to 19.3.2 was installed.
  • After successfully installing and starting FileMaker Pro, then signing out of Windows and signing in with a different Windows user account, starting FileMaker Pro again failed and this error was displayed: "This version cannot run with expired maintenance."
  • Under certain circumstances, clicking a popover button in the body part that opens a popover containing a web viewer and then clicking a popover button in the header part caused FileMaker Pro to close unexpectedly.
  • When closing a FileMaker Pro file, FileMaker Pro deleted local storage used by web viewers. Now, local storage—including cookies used to store user state information—is managed by the Microsoft Edge WebView2 control, which allows information saved by web viewers to persist between FileMaker Pro sessions.
  • When another Windows app was the active window, clicking in a web viewer that has a Hide object when calculation caused FileMaker Pro to stop responding in some cases.
  • macOS:
  • When scroll bars were set to always display in macOS, objects at the right edge of a layout were covered by the vertical scroll bar after changing between List View and Form View and resizing the window with the Adjust Window [ Resize to Fit ] script step.
  • When placed beyond the right edge of a layout, unstored calculation fields and summary fields were evaluated in Browse mode even though they were not visible.
  • While customizing the status toolbar, the record navigation controls didn't display correctly.

New in FileMaker Pro 19.3.1.43 (Jun 24, 2021)

  • This software updates Claris® FileMaker Pro™ 19 to version 19.3.1, adds new and enhanced features, and addresses issues. If you are unable to successfully update to FileMaker Pro 19.3.1, search the Knowledge Base for installation information.
  • New features:
  • Apple silicon support (macOS):
  • FileMaker Pro is now a Universal macOS app, which takes advantage of the advanced capabilities of Mac computers with Apple silicon and also runs on Intel-based Mac computers. If you use FileMaker plug-ins or ODBC client drivers on a Mac with Apple silicon, contact the developer to get versions that are designed to run on this type of Mac. See FileMaker Pro Installation Guide.
  • Get(ApplicationArchitecture) returns arm64 on Mac computers with Apple silicon.
  • Microsoft Edge support for web content (Windows):
  • FileMaker Pro now uses the Microsoft Edge (Chromium) engine instead of the Internet Explorer engine to render web content in custom apps in Windows. If your Windows computer hasn't been updated with the necessary Microsoft Edge components, the FileMaker Pro installer or updater will add them.
  • Web viewers provide better support for web standards, which may enable you to simplify the JavaScript and CSS you use in web viewers.
  • In interactive container fields, PDF files are displayed using the Microsoft Edge engine. You no longer need to install a web browser plug-in to display PDF files.
  • New function:
  • GetModelAttributes – Returns metadata in JSON format about a machine learning model that is currently loaded. See FileMaker Pro Help.
  • Enhanced features:
  • Preview: Enhancements to the quick start experience (macOS):
  • This release includes further enhancements to the preview of the FileMaker Pro quick start experience for creating custom apps. The preview is available in macOS only.
  • To create an app using the quick start experience:
  • Choose File menu > Create New.
  • Under "Try the quick start experience," click Get Started.
  • Type a name for the file, choose a folder, and click Save.
  • Enhancements:
  • New layout editing features in the preview include adding a bottom tab bar and creating relationships. For more information, see the Knowledge Base.
  • Enhanced functions:
  • JSON functions – The keyOrIndexOrPath parameter in JSON functions can accept periods in key names when paths are expressed in bracket notation.
  • Get(InstalledFMPluginsAsJSON) – Additionally returns information about the system that plug-ins run on. Scripts can use this information to install the plug-in that's appropriate for the operating system and hardware architecture.
  • GetAddonInfo – Additionally returns whether an add-on adds objects to a layout and whether it creates a relationship.
  • Get(SystemPlatform) – Returns the new value 8 for Ubuntu Linux; the existing value 5 is returned for CentOS Linux.
  • Addressed issues:
  • Important: To ensure that you don't encounter the following issues, you must update all clients to FileMaker Pro 19.3.1.
  • Windows and macOS:
  • The Claris FileMaker® Platform was updated to the following versions of open-source libraries to address security vulnerabilities and other issues:
  • OpenSSL version 1.1.1k
  • cURL version 7.76.0
  • JsonCpp version 1.9.4
  • After attempting to upload a large file to a Claris FileMaker Cloud® host for hours without success and force quitting FileMaker Pro, the file could be opened in Admin Console but FileMaker Pro couldn't access the file.
  • Under some circumstances, repeated use of the ExecuteSQL function caused the file size to increase greatly. Now, the file size no longer increases because of this issue; existing files can use the file recovery process to reclaim the excess space in the file.
  • Windows:
  • When connected to a hosted app that used value lists under some circumstances, FileMaker Pro stopped responding.
  • macOS:
  • On Mac computers with Apple silicon, sending email messages via an email client failed to include the message text specified by a text field containing more than 2,047 characters.
  • macOS Big Sur:
  • In Layout mode, the corner radius control in the Inspector was displayed incorrectly.
  • In the Script Workspace, under some circumstances, the checkboxes for Scripts menu management didn't correctly indicate whether they were selected.
  • Some types of TIFF images didn't display correctly and, under some circumstances, caused FileMaker Pro to stop responding when closing the file.
  • Checkbox sets and radio button sets didn't display the correct conditional formatting after the field value changed.

New in FileMaker Pro 19.2.1.14 (Dec 18, 2020)

  • New features:
  • Controlling plug-in access between files:
  • Extended privileges that start with fmplugin provide a way to control whether plug-ins called in one file can access another file. Plug-ins provide external functions and external script steps that can be called in a source file to operate on a target file. An fmplugin extended privilege affects only plug-ins that try to perform either of the following operations on a target file when the source and target files are not the same file:
  • execute a script by name
  • execute an SQL statement
  • The list of extended privileges is scanned in the order displayed in the Extended Privileges tab in the Advanced Security Settings dialog box. If the target file contains no extended privileges starting with "fmplugin" (not case sensitive), the above operations are allowed to run normally. Otherwise, the scan stops at the first extended privilege that is either of the following:
  • fmplugin
  • fmpluginXXXX where XXXX matches the plug-in's four-character ID (case sensitive)
  • If the current account's privilege set includes a matching fmplugin extended privilege, the above operations are allowed to run normally. Otherwise, the source and target files are checked to see whether they are authorized to access each other as defined in the File Access tab in the Advanced Security Settings dialog box. If they are authorized, the above operations are allowed to run normally.
  • If the files are not authorized and the following conditions are true, the user is prompted whether to authorize the files to access each other:
  • the plug-in is running in a FileMaker product that can display a user interface
  • the current account has full access privileges in both files
  • If the user authorizes the files, the operations above are allowed to run normally from now on between the source and target files no matter what extended privileges are in the target file. If the files aren't authorized (because the user declined or the FileMaker product doesn't display a user interface), an error is returned for the operation the plug-in is trying to perform.
  • Starting in version 19.2.1, fmplugin is present in the list of extended privileges in new files, but not in existing files. However, you can add fmplugin in existing files, if needed. See "Creating and editing extended privileges" in FileMaker Pro Help.
  • For any accounts that need plug-ins to perform the above operations in authorized files, you must add an fmplugin extended privilege to the privilege sets assigned to those accounts. See "Editing extended privileges for a privilege set" in FileMaker Pro Help.
  • Changed features:
  • Preview: Enhancements to the quick start experience (macOS):
  • This release includes further enhancements to the preview of the FileMaker Pro quick start experience for creating custom apps. The preview is available in macOS and only when the operating system language is set to English.
  • To create an app using the quick start experience:
  • Choose File menu > Create New.
  • Under "Try the quick start experience," click Get Started.
  • Type a name for the file, choose a folder, and click Save.
  • Enhancements:
  • To re-enter the quick start experience, you can now click Edit in the status toolbar. Previously, when you left the quick start experience, you couldn't return.
  • After you create an app using the quick start experience, you can now upload it to your FileMaker Cloud host, if you're a team manager. Then, you can open your app with FileMaker Pro and continue editing it on FileMaker Cloud using the quick start experience.
  • You no longer need to disable the Use advanced tools preference to create an app using the quick start experience. See the instructions above.
  • To end the quick start experience and begin using the full capabilities of FileMaker Pro in your app, click Use Pro Toolset in the status toolbar in Browse mode. This converts your app, so it will not be editable using the quick start experience. However, a copy of your app will be saved in the same location with "_QUICKSTART" appended to the filename. This copy is editable only using the quick start experience. Therefore, subsequent changes you make using the FileMaker Pro toolset will not be reflected in the quick start copy of your app.
  • Addressed issues:
  • Important: To ensure that you don't encounter the issues below, you must update all clients to FileMaker Pro 19.2.1.
  • macOS Big Sur 11.0: In the Script Workspace, under certain conditions, long script names that were truncated when the Scripts pane was narrow would remain truncated when the pane was widened.
  • The relationships graph was less responsive when scrolling or moving table occurrences than in versions before 19.0.1.

New in FileMaker Pro 19.1.3.315 (Oct 31, 2020)

  • New features:
  • New option parameter for fmp URLs:
  • The fmp and fmp19 URLs now support the option parameter when you use a URL to run a script. This parameter controls how a currently running script is handled. The parameter's values are the same as those defined for the FileMaker.PerformScriptWithOption() JavaScript function (see the FileMaker Pro 19.1.2 Updater Release Notes in the Knowledge Base).
  • For example, the following URL sets the option parameter to 3:
  • fmp://sales.example.com/Clients.fmp12?script=ListClients&option=3
  • If a script is currently paused, this URL resumes the paused script and, after the resumed script is completed, runs the ListClients script.
  • See "Opening files using a URL" in FileMaker Pro Help.
  • Addressed issues:
  • FileMaker Pro 19.1.2 couldn't connect to a FileMaker Cloud for AWS host.
  • FileMaker Pro 19.1.2 would close unexpectedly after creating a Database Design Report from a file that contained a summary layout part and had been modified in Table View.
  • Choosing Require password change on next sign-in could cause the Change Password dialog box not to close when you clicked a button.

New in FileMaker Pro 19.1.2.219 (Oct 2, 2020)

  • New features:
  • New add-ons:
  • The following JavaScript-enabled add-ons have been added:
  • Activity Timeline: Displays events on a descending timeline.
  • Barcode Generator: Generates a barcode image from field data.
  • Calendar: Displays events on a calendar that you can edit.
  • Calendar Heatmap: Shows the number of events per day on a three-month heatmap.
  • Kanban: Displays an organizational board that sorts task records as cards into columns (To Do, In Progress, Done). Click to edit the cards or drag to sort them or to move them to different columns.
  • Photo Gallery: Displays and automatically resizes photos in columns and rows.
  • Rich Text Editor: Enables you to write and display richly formatted text with links and images.
  • Simple Chart: Draws a visually rich, interactive chart.
  • Timer: Lets you use a stopwatch to time events and log the total time.
  • See "Working with add-ons" in FileMaker Pro Help.
  • Apex Blue theme:
  • The new Apex Blue theme is now the default theme for new custom apps. It's also used by the new add-ons listed above. See "Changing the theme of a layout" in FileMaker Pro Help.
  • Preview: Quick start experience (macOS)
  • This release includes a preview of the new FileMaker Pro quick start experience for creating custom apps. The preview is available in macOS and only when the operating system language is set to English.
  • To enter the quick start experience:
  • Choose FileMaker Pro menu > Preferences.
  • If Use advanced tools is selected, deselect it, click OK, and restart FileMaker Pro.
  • If this option is already deselected, click Cancel and continue to the next step.
  • Choose File menu > Create New.
  • Choose Blank and click Create.
  • Type a name for the file and click Save.

New in FileMaker Pro 16.0.5.500 (Mar 8, 2018)

  • Bug fix:
  • macOS High Sierra 10.13: Addressed an issue where scrolling could cause FileMaker Pro to close unexpectedly.

New in FileMaker Pro 16.0.3.302 (Dec 14, 2017)

  • Application:
  • macOS: Switching to a layout that included a chart caused FileMaker Pro to close unexpectedly.
  • macOS High Sierra 10.13: Interaction with a drop-down list was slow.
  • Network:
  • Under certain conditions, reconnecting to a hosted file could corrupt scripts.
  • Under certain conditions, committing a record while reconnecting could corrupt the record.
  • Calculations:
  • Addressed an issue where an unstored calculation based on related records did not update when the related record was modified in a portal and committed using the Enter key.

New in FileMaker Pro 16.0.2.205 (Jul 12, 2017)

  • SCRIPT STEPS AND FUNCTIONS:
  • Improved the performance of the SortValues and UniqueValues functions.
  • Addressed the following issues:
  • After the Go to Object script step was performed on an empty portal that did not allow the creation of records, the focus was not placed on the portal and the script step returned the error code 101 (“Record is missing”).
  • Opening a record and then closing the record without modifying it increased the internal record modification count returned by the Get(RecordModificationCount) function.
  • The CryptAuthCode function returned incorrect results for encoded text inputs.
  • The JSONGetElement function returned JSONBoolean and JSONNumber results as text instead of a number.
  • The JSONGetElement and JSONListValues functions returned the incorrect decimal separator for comma-based system locales.
  • External script steps evaluated calculated values for repetitions incorrectly.
  • The Set Variable script step did not set very large repetition values correctly.
  • MISCELLANEOUS:
  • Addressed the following issues:
  • Under certain conditions, ESS-based tables displayed incorrect records.
  • Documentation errata:
  • The FileMaker Pro Help “Configure Region Monitor” script step topic states that the Radius parameter returns a value in kilometers. This is incorrect; the value is returned in meters.

New in FileMaker Pro 16.0.1.162 (May 9, 2017)

  • SCRIPTS AND SCRIPT STEPS:
  • When a layout contains multiple instances of a field, and a script that includes the Go to Field script step is run, the first visible instance of the field, based on its creation order on the layout, will have the focus. To specify a particular instance, use the Go to Object script step instead.
  • When an empty portal that does not allow the creation of records is the target of the Go to Object script step, the script step returns error code 101 ("Record is missing").
  • EXTENDED PRIVILEGES:
  • To allow ActiveX and Apple events to continue performing FileMaker actions, you must add the new fmextscriptaccess extended privilege to privilege sets of existing accounts.
  • To allow URLs to continue running FileMaker scripts, you must add the new fmurlscript extended privilege to privilege sets of existing accounts.
  • FIELDS AND LAYOUT OBJECTS:
  • When an audio or video file is embedded in a container field and multiple clients play the content at the same time, it may not play correctly. For better performance of audio or video content that will be played by multiple clients, set up the container field to store data externally.
  • macOS: The technology used in web viewers has been updated to include security enhancements. See the FileMaker Knowledge Base.
  • DOCUMENTATION ERRATA:
  • In FileMaker Pro Help, in the "Open Launch Center" topic, this script step should be marked as compatible only with FileMaker Pro.
  • The following functions were omitted from chapter 4, "New features," in Installation and New Features Guide:
  • CryptEncrypt – Encrypts data with the specified key and returns container data.
  • CryptEncryptBase64 – Encrypts data with the specified key and returns text in Base64 format.
  • CryptDecrypt – Decrypts container data with the specified key and returns text or container data.
  • CryptDecryptBase64 – Decrypts Base64-encoded text with the specified key and returns text or container data.

New in FileMaker Pro 15.0.3.305 (Jan 19, 2017)

  • Application:
  • Addressed an issue where setting a field value in the source table while a script was running exited the active portal row.
  • OS X: Addressed an issue where, if update notifications had been disabled in FileMaker Pro 14 or earlier versions, FileMaker Pro 15 closed unexpectedly when it checked for updates.
  • Layouts:
  • Addressed an issue where FileMaker Pro closed unexpectedly when making a part smaller moved a tab control out of the part's visible area.
  • Saving and sending files:
  • Improved the behavior of sending emails with large attachments.

New in FileMaker Pro 15.0.2.220 (Sep 30, 2016)

  • Application:
  • OS X: Addressed an issue where, when FileMaker Server was installed on the same machine as FileMaker Pro, an alert displayed when an attempt was made to open the same hosted database using the host name and IP address.
  • OS X: Addressed an issue where the application stopped working when users who were logged in with a domain account tried to view or change the permitted hosts list.
  • Calculation functions:
  • Addressed an issue where the Get(ActivePortalRowNumber) function returned an incorrect value when used with the auto-enter field option or in a stored calculation when a new record was created through a portal.
  • Layouts:
  • Addressed an issue where, after reconnecting to a hosted file while in Layout mode when the application was set to save layout changes automatically, the application did not behave as expected.
  • Addressed an issue where the application closed unexpectedly when files whose current layout contained SVG icons were repeatedly closed.
  • Addressed an issue where copying, pasting, or editing a popover button whose label was a merge field caused the application to close unexpectedly. Note: If the application closed unexpectedly while you were working with a popover button object, you may be able to repair the layout by recovering the file.
  • Windows: Addressed an issue where layouts were not drawn correctly on a high-resolution display.
  • OS X: Addressed an issue where performing a script to switch from a layout containing a tab control object caused the application to close unexpectedly.
  • Saving as PDF:
  • Addressed an issue where a PDF generated in FileMaker Pro did not render JPG images when a DPI setting was internally set to 0.
  • OS X: Addressed an issue where generated PDF files were damaged when the FileMaker Pro file used Type 1 fonts.

New in FileMaker Pro 14.0.6.602 (Aug 12, 2016)

  • Replaces the PDF engine used for PDF creation.

New in FileMaker Pro 14.0.5.505 (May 12, 2016)

  • Addressed an issue where the View Databases Hosted by FileMaker Server dialog box displayed an incorrect SSL indicator (lock icon).
  • Addressed an issue where switching to a layout containing a sorted portal closed the application.
  • Addressed an issue where the Go to Related Record script step failed to switch to a custom menu set that was installed on a layout in a new window.
  • Addressed an issue that caused some OpenType fonts not to show when a file was saved as PDF.
  • Windows 10: Addressed an issue where, under certain conditions, renaming or creating a script in the Script Workspace caused FileMaker Pro to close.
  • OS X: Addressed an issue where the Copy (Command-C), Cut (Command-X), and Paste (Command-V) keyboard shortcuts were unresponsive after a file was saved as PDF using the Print dialog box.

New in FileMaker Pro 14.0.4.406 (Nov 12, 2015)

  • Scripts and functions:
  • OS X El Capitan: Addressed an issue where scripts using the Insert From URL script step incorrectly returned an SSL certificate error.
  • Calculations:
  • Addressed an issue in the Specify Calculation dialog box where auto-complete was unavailable in the tables list.

New in FileMaker Pro 14.0.3.313 (Oct 16, 2015)

  • Updater details:
  • This software adds support for OS X El Capitan version 10.11, and fixes bugs.
  • Application:
  • OS X: Addressed an issue where FileMaker Pro did not start correctly when the volume name contained certain characters.
  • Solution design :
  • OS X: Fixed an issue where scroll bars appeared prematurely in a layout window when the zoom control area was disabled.
  • Email:
  • OS X: Addressed an incompatibility issue with Microsoft Outlook 15 where sending an email with an attachment resulted in an empty email body and no attachment.

New in FileMaker Pro 14.0.2.200 (Aug 18, 2015)

  • Application:
  • OS X: Addressed an issue where FileMaker Pro did not open when a corrupted font had been installed in OS X.
  • Scripting and calculations:
  • OS X: Addressed an issue where clicking a script step parameter in the Script Workspace script editing pane caused FileMaker Pro to close.
  • OS X: Addressed an issue where debugging a script in the Script Debugger caused FileMaker Pro to close.
  • Japanese version: Addressed an issue where an error occurred when a calculation in the Specify Calculation dialog box contained a ≤ or ≥ operator that was inserted using the corresponding button.
  • Solution creation and use:
  • OS X: Addressed an issue where switching to Browse mode caused FileMaker Pro to close.

New in FileMaker Pro 14.0.1.175 (May 13, 2015)

  • Script Workspace: Create, edit and view your scripts and calculations all in one streamlined workspace to speed development time.
  • New Specify Calculation dialog box: Increase your productivity with auto-complete and search for calculation functions.
  • Launch Center: Visually organize all your FileMaker solutions. See a list of your most recently opened files. “Favorite” the files you use the most, and drag to organize them the way you want. Choose from 29 attractive, pre-designed icons to represent your solutions. Or add your own personal touch with custom icons.
  • Button bar: Create groups of buttons you can use for navigation or as custom toolbars.
  • Button icons: Get 140 professionally designed icons that cover a wide variety of tasks to use in your buttons. Or use custom button icons.
  • Top and bottom navigation parts: These new layout parts remain static on your layout so when you scroll, the navigation is always visible.
  • In-field labels: Simplify your layouts by adding placeholder text or instructions inside a field. This text disappears when you type.
  • Color selection: The color palette displays colors that coordinate with your current theme so it’s easy to create attractive layouts.
  • Object component styles: Select the color of icons in control styles such as pop-up menus, drop-down lists, and calendars. Change the color of radio buttons and checkbox sets.
  • Keychain: Save login credentials in Credential Manager in Windows just like you can with Keychain Access in OS X. Plus, control whether or not clients can save information to their credentials or the keychain.
  • Enhanced Starter Solutions: Events and Projects are entirely redesigned with a clean, new look and simplified workflow.
  • Learn more
  • Reconnect to server: If you lose your network connection or the server goes down, FileMaker Pro automatically reconnects to FileMaker Server when it’s available again.
  • Layout badge tooltips: See descriptions of layout badges as you hover over them. Plus, see what calculated values are used for conditional formatting of fields, and what scripts are attached to script triggers and buttons.
  • 64-bit application: FileMaker Pro 14 is architected for the 64-bit power of Windows and OS X operating systems.

New in FileMaker Pro 13.0.9.904 (Apr 7, 2015)

  • Security Update - FileMaker 13.0v9/FileMaker 12
  • Available for: FileMaker 13 and FileMaker 12 Platforms. This update is being released in two stages to minimize compatibility issues. FileMaker Server 13.0v9 and FileMaker Pro/Advanced 13.0v9 will be released first, with FileMaker Go 13.0.9, FileMaker Server 12 Security Update and FileMaker Pro/Advanced 12 Security Update following in approximately 2 weeks. FileMaker Go 12 will not be updated. FileMaker Go 13.0.9 will retain compatibility with the FileMaker Server 12 Security Update.
  • Impact: A potential SSL issue could allow network communication to be compromised.
  • Description: An issue with FileMaker's root SSL certificates could allow network communication to be compromised. This issue was addressed by updates to application UI and to FileMaker security certificates.

New in FileMaker Pro 13.0.5.503 (Jan 28, 2015)

  • OS X: Addressed an issue where each time FileMaker Pro 13.0v4 or FileMaker Pro 13.0v4 Advanced was opened, a system message asking whether to allow FileMaker Pro to accept incoming network connections appeared.
  • OS X: Addressed an issue where the VoiceOver onscreen-reader software failed to read field contents.
  • OS X: Addressed an issue where selected fields were not visible in the Specify Field dialog box without the user scrolling to them.
  • OS X Lion 10.7: Addressed an issue where FileMaker Pro 13.0v4 or FileMaker Pro 13.0v4 Advanced failed to open.

New in FileMaker Pro 13.0.4.418 (Dec 4, 2014)

  • Updater Details:
  • Bug fixes were made to address issues in FileMaker Pro 13 and FileMaker Pro 13 Advanced (Windows and OS X) and to provide support for OS X Yosemite version 10.10.
  • Calculations:
  • Addressed an issue where the Get(ModifiedFields) function did not return a list of modified fields in a solution using a schema in which, for example, a User Interface file (file 1) uses fields from a Data file (file 2) on its layout.
  • OS X: Addressed an issue where, under certain conditions, calculations may incorrectly evaluate to “?”.
  • ODBC / JDBC:
  • OS X: The xDBC client driver installer application is digitally signed for installation on OS X 10.9 and 10.10.
  • Documentation errata:
  • Note the following new information for the Get(ScreenScaleFactor) function: In OS X and FileMaker Go, this function returns a scale factor based on the relative pixel density of the screen; for example, 1 for a device without a Retina display; 2 for a Mac with a Retina display or for iPhone 6/iPhone 6 Plus.
  • Compatibility of the Copy Record/Request and the Copy All Records/Requests script steps with Custom Web Publishing is documented incorrectly. These script steps are not supported in Custom Web Publishing.

New in FileMaker Pro 13.0.3.231 (Apr 22, 2014)

  • Includes OpenSSL 1.0.1g, which is not vulnerable to the Heartbleed bug. In addition, the TLS heartbeat in OpenSSL is disabled, which removes the attack method used by the Heartbleed bug.

New in FileMaker Pro 13.0.2.228 (Apr 3, 2014)

  • Application:
  • Added a “Preserve external container storage” option to skip re-importing external container storage and, instead, reuse existing external contents during records import between FileMaker databases.
  • Extended the functionality of the FMP URL protocol to include:
  • Open Clients.fmp12 from the user’s Documents folder and run the ListClients script. fmp://~/Clients.fmp12?script=ListClients
  • Run the ListClients script from an open file named Clients.fmp12 fmp://$/Clients.fmp12?script=ListClients
  • Windows: Addressed an issue that may occur during application launch and in dialog boxes on Windows 7.
  • Calculations and scripting:
  • Addressed an issue where COUNT ( DISTINCT ... ) used with the ExecuteSQL function could return an incorrect result.
  • Addressed an issue where the Insert From URL script step could return an incorrect result.
  • Layout rendering:
  • Addressed an issue where, when switching or re-importing a theme and the source and destination themes both contain custom styles with the same display name, the custom style assignment would have been lost after the theme switch or re-import.
  • OS X: Addressed an issue where some fonts displayed incorrectly in charts.
  • Text editing:
  • Addressed an issue where characters from condensed and expanded fonts were not being placed in their correct locations.
  • Addressed an issue where copying and pasting from Excel 2011 into FileMaker Pro could insert an extra trailing tab character for each data row.
  • Miscellaneous:
  • Removed the 2048 character limit from the XML import text fields for the network path of XML and network path of XSLT used for http and httppost requests.
  • OS X: Addressed an issue where data entry could appear slower when a large number of windows were open.
  • Documentation Errata
  • The supported ESS data sources are listed incorrectly in FileMaker 13 ODBC and JDBC Guide and FileMaker Pro 13 Help.

New in FileMaker Pro 13.0.1.194 (Dec 3, 2013)

  • FileMaker WebDirect, an entirely new, HTML5 browser-based technology that allows teams to create and deploy desktop-style solutions in a web browser with no programming skills required.
  • Tools to create amazing iPad and iPhone solutions that support even more iOS behaviors, including slide controls, popovers and the ability to scan records using gestures. iPad and iPhone layouts can now be created in one step; and iOS solutions can include single-click capture of bar codes using on-device cameras and custom keyboards that speed data entry.
  • Major improvements to design capabilities, including support for shareable custom themes and styles, and the ability to drag and drop data fields onto design layouts.
  • More robust security, with AES 256-bit encryption that locks down data no matter where it lives – on iPad, iPhone, desktop or server. FileMaker Pro 13 Advanced is used to enable encryption.
  • Dozens of new enhancements for solution developers, from the ability to hide or display objects on a screen based on business logic to easier integration with web applications.
  • Simplified server administration, including an entirely new HTML5 administrative console in FileMaker Server 13 for managing business solutions from anywhere.

New in FileMaker Pro 12.0v4 (Apr 25, 2013)

  • Layout design and rendering:
  • Addressed an issue where portal line borders could render thicker than necessary.

New in FileMaker Pro 12.0v3 (Oct 24, 2012)

  • Layout design and rendering:
  • Addressed an issue where an object located beneath a transparent fill object could not be selected and dragged.
  • Addressed an issue in the Classic theme where a gradient in the footer part was cropped when the zoom level was greater than 100%.
  • Addressed an issue where a vertical or horizontal line set to a button would not appear.
  • Addressed an issue for the Classic theme where an image that spans multiple parts, commonly used as a watermark,would fail to draw in all parts.
  • Improvements in performance made to Layout mode when there are a large number of layout objects.
  • Improvements in performance made to layout rendering when objects contained conditional formatting.
  • Addressed an issue where FileMaker Pro may crash if a script containing the Go to Layout script step goes to a layout with a tab control located in the footer part.
  • Printing:
  • Addressed an issue where fields set to display with one border showed the other borders as hairline width when printed.
  • Addressed an issue where field contents in certain fonts were truncated when printed as PDF and the Inspector “Remove blank space by” option was set to “Sliding left.”
  • Addressed an issue where empty portal rows could appear even when the Inspector “Remove blank space by” option was set to “Sliding up.”
  • Improvements made to the printing quality of image thumbnails in container fields.
  • Plug-ins:
  • Addressed an issue where Instant Web Publishing could crash after a period of use.
  • Addressed an issue where the Install Plug-In File script step placed plug-ins in the same folder as earlier FileMaker Pro versions

New in FileMaker Pro 12.0v2 (Jul 13, 2012)

  • Layout design and rendering:
  • Addressed an issue where tooltips would not appear if there was a transparent object placed over the object containing the tooltip.
  • Addressed an issue where objects placed in the header or footer parts could be clipped when switching from Form View to List View.
  • Addressed an issue in List View where a field may draw in the wrong location if it was grouped with an object that resided in another part.
  • Improvements to copying and pasting of objects between different theme styles.
  • Improvements to scrolling.
  • Value lists:
  • Addressed an issue where the ValueListItems calculation function could not retrieve the values from a restricted access value list field in a hosted file, despite having "Run script with full access privileges" enabled.
  • Addressed an issue where value lists failed to show values when they were referenced from a related file located in a different folder on the host system.
  • Addressed an issue with value lists that display values with different regional format settings.
  • Addressed an issue where the application could crash when accessing a value list that is set to show values only from a
second field, if the first field was empty.
  • Addressed an issue where a value list using a field from a file hosted on another server would show if it
was formatted as a Pop-up menu.
  • Addressed an issue where a converted file with a value list set to show values only from the second field would show values from the first field as well.
  • Printing:
  • Addressed an issue where an object failed to slide left if the object next to it had "Hide when printing" enabled.
  • Addressed an issue where sliding/shrinking settings were not applied correctly to vertical fields with repetitions.
  • Addressed an issue where, depending on the related record count, portal rows may appear empty in printouts when
sliding is enabled.
  • Improvements to print, preview, and PDF generation.
  • Scripting:
  • Addressed an issue where it was possible for a script to execute on the wrong window.
  • Addressed an issue where the Speak script step failed if "Wait for speech completion before continuing" was deselected.
  • Addressed an issue where a Save Records as PDF script step set to run with full access privileges would show the
contents of an access-restricted container field in the PDF output.
  • Addressed an issue where a Go to Object script step set to run with full access privileges would show the contents of an access-restricted container field upon switching tabs.
  • Addressed an issue where running a script trigger that scrolls the viewable area could make the wrong record active.
  • Citrix:
  • Addressed an issue where data copied from databases hosted on Citrix Server would fail to paste into databases not hosted on Citrix Server.
  • Portals:
  • Addressed an issue where portal filtering failed with the "< >" operator.
  • Accessibility:
  • OS X: Addressed an issue where the VoiceOver screen reader failed to read the contents of a drop-down list.
  • OS X: Addressed an issue where button labels could be read twice by VoiceOver in header and footer parts in Table View.
  • Windows: Addressed an issue where the application could crash when using screen reader software to read a drop- down list if it was not the first field on the layout.
  • Mail:
  • OS X: Addressed an issue where an attachment would fail to appear in an email with Microsoft Outlook 2011 as the default mail client.
  • Menus:
  • Addressed an issue where a newly created file could show the active menu set from an open remote file.
  • Interactive containers:
  • Addressed an issue where a file drag and drop was accepted in an interactive container set to disallow entry in Browse mode.
  • Recovery:
  • Addressed an issue where recovery could fail on very large databases if you chose the “Rebuild field indexes Later (as needed)” option.
  • 
Instant Web Publishing:
  • Addressed an issue in order to prevent using the Go to Layout script step to go to layouts that do not use the Classic theme. If this script step is part of a larger script, script execution will stop at this point. No error dialog will appear, but an error log entry will be generated.
  • Addressed an issue where the Insert From URL script step may not return content from the URL to interactive container fields.
  • JDBC:
  • Improvements to retrieving record count when querying with "SELECT COUNT(*) FROM "
  • Miscellaneous:
  • Added the ability to identify a "Windows OLE object" via calculation, such as GetAsText.
  • Added the ability to copy the chart preview in the Chart Setup dialog box.
  • Added a "Theme name" value to each layout section of the XML Database Design Report.

New in FileMaker Pro 12.0v1 (Apr 4, 2012)

  • Eye-catching themes: Apply one of 40 stunning new themes to instantly change the look of your database.
  • More layout tools: Use new gradients, image slicing and alignment guides to get the design precision you need.
  • All-new Starter Solutions Manage projects, content, estimates and more with re-designed solutions – now with layouts for iPad and iPhone.
  • Enhanced container fields Drag and drop files into your database, render images faster, and securely store and manage data externally.
  • Quick Charts
  • Create eye-catching charts in a just a few clicks with the new integrated set-up and customization window.
  • iOS design and development tools – Get design tools, themes, scripts and calculation functions to help you quickly build apps for iPad and iPhone.

New in FileMaker Pro 11.0v4 (Aug 9, 2011)

  • Data Formatting:
  • OS X Lion only: Addressed an issue with some date field formats showing Asian characters.
  • OS X Lion only: Addressed an issue with not being able to use zero or negative numbers in data formatting in the Inspector and in some controls in the Chart Setup dialog.

New in FileMaker Pro 11.0v3 (Feb 10, 2011)

  • File references performance:
  • Mac OS X: Improved performance when opening a hosted file that references multiple related files by DNS name rather than an IP address.
  • Printing:
  • Mac OS X: Addressed an issue where using printing presets created in another application to print in FileMaker caused the FileMaker print options to disappear the next time you tried to print.
  • Windows and Mac OS X: Addressed an issue with text in a field spanning one or more page breaks being horizontally truncated in printouts, previews, and PDF exports.
  • Send Mail:
  • Mac OS X: Addressed an issue where Send Mail did not work with Outlook 2011.

New in FileMaker Pro 11.0v2 (Jun 30, 2010)

  • Field Definition:
  • Addressed an issue where field definition updates would sometimes take a longer than expected time to complete.
  • Mac OS X: Addressed an issue where the application could crash if you made changes to the field options for an ODBC based field and then switched to the Storage tab.
  • Recovery:
  • Addressed an issue that caused the FileMaker consistency check to fail to detect damaged access privileges.
  • Snapshot Link:
  • Addressed an issue where the snapshot link file would fail to restore the snapshots when the file had an externally referenced file.
  • Addressed an issue where the sort order was not restored using a snapshot link file where the sort is based on a supplemental field on an ODBC table.
  • Scripting:
  • Windows 7: Addressed an issue where the application could crash if you scrolled through a script with a large number of steps in the Edit Script dialog.
  • Mac OS X: Addressed an issue where the context of running script can be changed when the user clicks on another open window's title if the script is creating and closing temporary windows.
  • Mac OS X: Addressed an issue where the progress dialog would show during script execution even if you chose Hide from the application icon in the Dock.
  • Addressed an issue where copying and pasting a Perform Find script step could lose the contents of the variables defined for the Date, Time, or Timestamps fields.
  • Quick Find:
  • Addressed an issue where Quick Find finds data from fields that are not currently shown on the layout.
  • Value Lists:
  • Mac OS X: Addressed an issue with drop-down lists not widening to show all values when the field uses certain Asian fonts.
  • Mac OS X: Addressed an issue where application might crash when you activate and dismiss fields set up as drop-down lists or drop-down calendars.
  • Printing:
  • Addressed an issue where rotated text does not slide properly when printing.
  • Runtime:
  • Addressed an issue where runtimes could not be created if there was no internet access.
  • Windows: Addresses an issue that required that the Microsoft Visual C++ 2008 SP1 Redistributable libraries be installed before allowing you to create runtime solutions that will run on any supported Microsoft Windows operating system.
  • Plug-ins:
  • Mac OS X: Addressed an issue where functions stored in resource forks failed to load.
  • Addressed an issue with prepared SQL statements not accepting query parameters ('?') as arguments to functions.
  • Addressed an issue where application could crash in SQL engine with certain limited privileges.
  • General:
  • Addressed an issue with empty merge variables appearing on layouts in Browse, Find, and Preview modes.
  • Windows: Addressed an issue where portals flicker when scrolled.
  • Addressed a permissions issue on Mac OS X that caused the fast user switch environment to not function as expected.
  • Addressed an issue on Mac OS X where changing field options in Table View while there is a remote connection caused the application to crash if custom menus were installed.
  • Addressed an issue when saving a PDF from FileMaker onto Windows 2003 & 2008 server the files were created without Domain Admins and Domain Users.
  • Excel Import:
  • Addressed an issue with Japanese furigana (phonetic guides) being added to the kanji data when you import .xlsx files.
  • IWP:
  • Addressed an issue where IWP settings could display an out of range port number when FileMaker Pro 10 and FileMaker Pro 11 are installed on the same machine with IWP enabled.
  • Addressed an issue where objects in the header or footer do not align with
objects in the body after horizontal scrolling.
  • xDBC:
  • Addressed an issue where record modification cannot be reverted with the JDBC cancelRowUpdates() method in the ResultSet class.
  • Addressed an issue where FileMaker could crash when the statement handle was not freed when using SQLDisconnect().
  • Addressed an issue with JDBC update methods not updating record values if the ResultSet Class is the primary key column.
  • Addressed an issue where an error occurs with exponents that are used in VALUES clauses in SQL statements.
  • Addressed an issue where no text value is displayed with MS Word Mail Merge if the maximum number of characters was not specified in the field.
  • Addressed an issue with restarting xDBC after sharing was disabled in a client connection.
  • Addressed an "incompatible type" exception error that resulted from using PreparedStatement.setNull() to insert a null value into a number, date, time, or timestamp field.  
  • Addressed an error that occurred with joins in SQL statements if there was no space between the ON command and the ON parameters.

New in FileMaker Pro 11.0v1 (Mar 10, 2010)

  • Clear Recent Files:
  • A “Clear Recent” menu item has been added to the end of the Open Recent hierarchal menu.
  • When selected, the list of recent files is cleared from the menu and from the recent Files item of the FileMaker Quick Start Screen.
  • Drag and Drop Behavior for a Container Field with a QuickTime Movie:
  • Dragging and dropping QuickTime movie to the desktop is no longer supported.
  • Dragging and dropping QuickTime movies between container field is now supported.
  • Dragging and dropping does not show the movie poster.
  • Merge Variables in Layouts:
  • Variables are now supported in layouts, akin to Merge Fields and the handful of special sequences that are dynamically expanded, such as // and @@.
  • The syntax for a merge variable is similar to a merge field, where the variable name (e.g. $$gCompanyName) is wrapped between the > character sequences (e.g. .
  • There is a new Merge Variable menu item in the Insert menu in Layout mode, directly below the Merge Field... menu item. It inserts a placeholder .
  • Some restrictions are:
  • If the variable name is not a variable that is currently set to any value, the text remains unexpended (e.g. ).
  • The repetition syntax from the calculation engine is not supported (e.g. $var[2]).
  • New Privilege Sets - Switch to Minimum menu setting
  • In previous versions of FileMaker, creating a new Privilege Set would set default privileges to “Minimum.” Except for Available menu Commands, which defaulted to “All.”
  • In FileMaker 11, it now defaults to “Minimum.”
  • Animations (Mac Only):
  • On Mac OS, the following transition animations have been added:
  • Drop-Down Lists "drop down" from the field to which they are assigned when activated.
  • When a user changes the units of the rulers, the ruler contents and the "Unit Tile" control at the intersection of the rulers will fade out, then fade back in with new unit markings.
  • The opening "Splash Screen" now displays with a "ripple in" effect; it does a simple "fade out" when it is taken down.
  • Drag Image Appearance (Mac Only) - The "Drag Tracking" image that is used while dragging is a translucent rendering of the actual objects being dragged, so as to better distinguish between the "drag tracking" image and the "drop location" image.
  • Bento date format support during imports:
  • FileMaker now recognizes the date and timestamp formats used by Bento when importing data and reformats the text as a FileMaker-acceptable date or timestamp. Bento dates/timestamps imported into an existing date/timestamp field will pass validation, as will dates/timestamps imported into a text field (as when a Bento library is dragged onto the FileMaker Pro icon) that is later converted into a date/timestamp field.
  • Dates exported by Bento in CSV format are stored in a subset of the ISO-8601 format (YYYY-MM-DD, e.g. 2009-03-04), as are timestamps (YYYY-MM-DDTHH:MM:SS, e.g. 2009-03-25T15:50:32). FileMaker Pro 11 allows Bento dates, but only during import. Typing an ISO-8601 directly into a date field will still fail validation (except in locales where the date is in that format by default), and the date is reformatted according to the current locale during the import.
  • Identification of Bento dates relies on the current behavior of Bento where the creation timestamp is always exported as the first field of a record in ISO-8601 format. The identification technique has the side effect of never allowing dates/timestamps stored in ISO-8601 format to be imported into FileMaker while preserving the ISO-8601 format if the first field in a record is an ISO-8601-formatted timestamp.
  • CFM plug-in from third party no longer supported (Mac only) - FileMaker Pro 11 only supports Mach-O plug-in for third party plug-in and no longer supports CFM type plug-in on Mac.
  • Conditional Formatting and Quick find badges added - FileMaker shows special badges in layout objects with Tooltips and Script Triggers (that can be switched on/off via the View > Show menus).

New in FileMaker Pro 10.0v3 (Jul 15, 2009)

  • Import/Export:
  • DBF import and export are available.
  • Mac OS X: Addressed an issue to prevent a failure when attempting to export Excel (*.xls) without Rosetta installed.
  • Excel:
  • Addressed an issue where an Excel file could be created displaying data under the wrong header if a field was removed using the Modify Table View feature.
  • Addressed an issue where the application could crash if you imported an Excel 2007 file that contains a copied worksheet with named ranges.
  • Calculations:
  • Addressed an issue where the Random calculation function could generate non-random values on certain machines. The Random calculation will generate values greater than 0 and less than 1. The value will never be 1.
  • Recovery:
  • Addressed an issue that causes custom functions to occasionally get corrupted during recovery.
  • Addressed an issue that causes recovery to report no issues when there are invalid data blocks in the file.
  • SMTP Mail:
  • Addressed an issue with some SMTP servers that could lead to the BCC email recipients being shown inappropriately.
  • Addressed an issue where UTF-8 data is not being encoded correctly in SMTP mail.
  • Printing and PDF:
  • Mac OS X: Addressed an issue where the application would crash when printing to host-based printer models.
  • Addressed an issue where saving records to PDF could crash if the starting page number was not 1 and the layout extended beyond one page.
  • Networking:
  • Addressed an issue where a file set to ask a user to change the password on next login fails to change the password if the client and server are not the same version.
  • External Data Sources:
  • Addressed an issue where a FileMaker-based number field added to an external data source table does not display a zero.
  • General:
  • Addressed an issue where Auto-Complete in a field with multiple lined data fails to function unless you are on the last empty line of the text field.
  • Addressed an issue where a file set to use the system formats would still insert the date in layout mode with the file format, which may not match the system format.
  • Addressed a formula issue in the script for the New Layout/Report dialog to correctly account for localized formats to enter the correct view mode after a layout is created.
  • IWP:
  • Addressed an issue for some customers with Instant Web Publishing that causes any custom home page in the Web Folder in the FileMaker application folder to be ignored. The problem could also prevent the contents of a container field from being visible in a browser if the Instant Web Publishing solution refers to files stored in the Web folder.

New in FileMaker Pro 10.0v1 (Jan 7, 2009)

  • Script Triggers.
  • Saved Finds.
  • Themes and Templates.
  • Dynamic Reports.
  • Send Mail via SMTP.
  • Many more enhancements.

New in FileMaker Pro 9.0v3 (Dec 5, 2007)

  • Instant Web Publishing can now be correctly enabled and disabled on Mac OS X 10.5.
  • A problem has been fixed in which Instant Web Publishing might display the wrong value from a value list. In version 9.0v1 and 9.0v2, this problem could occur when one value list item is a substring of another value in the list. For example, if a text field uses a value list containing �room A7� and �room A73�, and the field is set to �room A73�, Instant Web Publishing erroneously displays �room A7� instead. In version 9.0v1 and 9.0v2, the erroneously displayed data could then be committed to the database, if the user entered Edit mode and clicked Submit.
  • Support added for Safari 3 and Firefox 2 on Mac OS X 10.5. See the FileMaker 9 Instant Web Publishing Guide for other supported web browsers.