FileMaker Pro Release Notes

Version 20.3.1

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.

Version 20.2.1

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:

  1. 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.

  2. In the Specify Calculation dialog, enter the a formula for your calculation, then click OK.

     A layout calculation, including the specified calculation, (<<ƒ:[calculation]>>) appears on the layout.

  To modify a layout calculation:

  1. In Layout mode, right-click the layout calculation, then choose Edit Layout Calculation.

  2. 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.

Version 20.1.2

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.

Version 20.1.1

New features and enhancements

Functions

• macOS: The GetLiveText function is now supported in a script run on the server.

• macOS Ventura: The GetLiveText function now additionally supports Japanese ("ja-JP"), Korean ("ko-KR"), and Ukrainian ("uk-UA") locales.

• The new GetBaseTableName function returns the base table name of a provided field.

• The new Get(CacheFilePath) function returns the path of the cache file for the currently active database.

• The new Get(CacheFileName) function returns the name of the cache file for the currently active database.

• The new BaseTableNames and BaseTableIDs functions return information about the base tables instead of all table occurrences.

• The ReadQRCode function is now available to use in FileMaker Pro on Windows.

• The Get(ModifiedFields) function now returns fields containing data when a new record is created.

Scripts

• The Execute FileMaker Data API script step now supports the dateformats parameter.

• The new Perform Script on Server with Callback script step performs a specified script on a server. When complete, the client locally performs another specified script.

• The cURL option in the Insert from URL script step now supports secure file transfer protocol (SFTP) and includes the pubkey option for SFTP public key authentication.

• The new Trigger Claris Connect Flow script step initiates a Claris Connect workflow automation.

General

• You can now double-click a fmcert license certificate file to initiate the license certificate import process. Upgrade licenses must be imported using Help > Replace FileMaker License.

• Windows: Thumbnails can now be immediately created for PDF files in container fields.

• The new OnWindowTransaction script trigger creates a JSON object whenever a window's transaction completes successfully. The JSON object includes the file name, base table name, record ID, operation, and contents of that base table's field named onWindowTransaction (or a specified field) for every operation within the completed transaction.

• SQL queries to FileMaker databases can now access a FileMaker_BaseTables system table. The new schema contains the following fields:

  • BaseTableName - the table name

  • BaseTableId - the table ID

  • Source - the source (<internal>, MYSQL, etc.)

  • ModCount - the number of times the table has been modified

• Sending mail using FileMaker Pro can now use OAuth 2.0 with Microsoft 365 Business or Google Workspace subscriptions.

• Dark Mode is now partially supported for the relationship graph.

Addressed issues

Layouts

• macOS: Web Viewers did not register mouse clicks while in Find Mode.

• macOS: Closing parent windows to card windows sometimes caused FileMaker Pro to quit unexpectedly.

• macOS Ventura: A previously minimized layout window was unable to display a card window if Stage Manager was enabled in macOS.

• The divider lines inside a button bar would resize incorrectly if the button bar was anchored and resized when the layout was resized.

• Portals with the Use active row state option disabled would render incorrectly if the portal was anchored and the layout was resized.

• JavaScript could not be performed in web viewers while in Find mode.

• Windows: PDFs in non-interactive containers and PDFs rendered from layouts were blurry.

Functions

• The application quit unexpectedly when using the GetContainerAttribute function on a table with many records.

• The Get(ModifiedFields) function incorrectly returned an empty result for fields modified with replace field contents, import, relookup, or drag and drop operations.

• Text shortening functions, such as Left and GetValue, used more memory than needed.

• Functions sometimes incorrectly used the operating system locale instead of the file locale.

Scripts

• Windows: Insert from URL failed to encode provided URLs and returned an error.

• When the Verify SSL Certificates option was off for the Insert from URL script step, certificate errors incorrectly caused errors to be returned instead of the expected result.

• Some text colors in Script Workspace did not change between Dark Mode and Light Mode.

• Scripts could no longer be executed when there was an open transaction, the main script was paused, and an error occurred.

General

• macOS Ventura: The FileMaker Pro options in the Print dialog were not used and the Pages option was used instead.

• You were able to enter an inactive FileMaker Account to Sign in with Apple when the Hide My Email option was selected.

• XML generated from Save a copy as XML did not include information about the Show sign-in fields when OAuth or AD FS is enabled option.

• Windows: Saving Records as PDF caused FileMaker Pro to stop responding when the layout included web content in a web viewer. Web content not retrieved before timeout will appear as blank in the rendered PDF.

• Windows: FileMaker Pro stopped responding or quit unexpectedly on computers with older hardware.

• Transactions with invalid dates were successfully committed to records instead of returning errors. Now transactions committed with invalid dates return error 500.