Claris FileMaker Pro Release Notes

Addressed issues

• When performed in a hosted file, the Perform Semantic Find script step returned a found set that wasn't consistently sorted by cosine similarity as expected.

• After specifying an ODBC data source in an Import Records script step, the Specify Import Order dialog didn't display source fields for you to map to target fields.

• Windows: When signing in to FileMaker Pro with an account authenticated via certain external identity providers to access files hosted by FileMaker Cloud, an error message was displayed instead of the page for two-step verification.

• Windows: FileMaker Pro was unable to import records via the Sage Accounts 50 v29 ODBC driver.

• Windows: After selecting a button or button bar in Layout mode, opening the Button Setup or Button Bar Setup dialog, clicking a control that opened the Specify Calculation dialog, then, in some cases, changing focus outside the application, FileMaker Pro stopped responding or quit unexpectedly.

Important  FileMaker Pro 2024 is not supported on macOS Monterey 12 and, in an upcoming release, will no longer install on Monterey. To keep using the latest version of FileMaker Pro, Monterey users will soon need to upgrade to a later version of macOS first. For the supported versions of macOS, see Claris FileMaker 2024 Technical Specifications.

New features and enhancements

Artificial intelligence script steps and functions

The new AI script steps and functions help you more easily use data from your FileMaker Pro apps with large language models (LLMs). Along with script steps to get embedding vectors from your data and various utility functions, the Perform Semantic Find script step helps make performing a find much smarter than just finding keywords.

New AI script steps:

• Configure AI Account: Sets up an AI account to use by name, given a model provider (or endpoint) and an API key.

• Insert Embedding: Enters the vector representation of the specified input text into a field or a variable.

• Insert Embedding in Found Set: Inserts a value in a field in every record in the found set with the vector representation of the contents of a specified field.

• Perform Semantic Find: Performs a semantic find in the specified field and constrains the specified record set for the given search text and model to use or for the given embedding vectors.

• Set AI Call Logging: Controls whether details of AI calls are saved to a log file.

New AI functions:

• CosineSimilarity: Returns the similarity between two embedding vectors as a number between -1 (opposite) and 1 (similar).

• GetEmbedding: Returns a vector representation as container data for input text using an embedding model.

• GetEmbeddingAsFile: Converts an embedding vector from text format to binary container data.

• GetEmbeddingAsText: Converts an embedding vector from binary container data to text format.

• GetTableDDL: Returns table information in Data Definition Language (DDL) format for a list of table occurrences specified as a JSON array.

• GetTokenCount: Returns the token count for the specified text. Use for guidance only; actual counts used by models may vary.

• Get(LastStepTokensUsed): Returns the tokens used in the last AI script step.

Along with these new script steps and functions, the existing machine learning script step and function are now located in the new "Artificial Intelligence" category in the Script Workspace and Specify Calculation dialogs.

Open Quickly

• To make it easier to open your creations in FileMaker Pro, the Open Quickly box can now:

  • Open recent and favorite FileMaker Pro files.

  • Search across all open files for layouts and scripts.

  • Be accessed in any mode as well as when the script editor menu is active.

  • Open the selected layout in a new window if you press and hold the Alt key (Windows) or Option key (macOS).

  • For the selected script, run the script (default) or, if privileges allow, open the script for editing.

• To open the Open Quickly box more easily, its keyboard shortcut has been swapped with that of the Fields tab in Layout mode:

  • Open Quickly box: Ctrl+K (Windows), Command-K (macOS)

  • Fields tab: Ctrl+Alt+K (Windows), Command-Option-K (macOS)

See Using the Open Quickly box.

Script step enhancements

• The Perform Script on Server with Callback script step now includes:

  • The State option to specify whether the callback script should pause, resume, exit, or halt a currently running script. This provides the same options as for scripts started via other methods.

  • The By name option to specify a callback script name via a calculation to more easily customize the flow of scripts.

  See Perform Script On Server with Callback.

• The Execute FileMaker Data API script step now supports:

  • Write operations to modify record data. In the request, set the action key to create, update, delete, or duplicate values.

  • Returning appropriate error information via the Get(LastError), Get(LastErrorDetail), Get(LastErrorLocation) functions as other script steps do.

  • Overriding the Allow user to override during data entry validation option. In the request, set the new options.entrymode key to user (follow validation rules) or script (override validation rules).

  See Execute FileMaker Data API.

• The Configure Local Notification script step now supports:

  • Running in FileMaker Pro (previously supported only in FileMaker Go).

  • Displaying a notification when FileMaker Go is in the foreground (supported in FileMaker Go only). Use the new Show when app in foreground option.

  See Configure Local Notification.

• The Set Error Logging script step is now supported in scripts run by FileMaker WebDirect and FileMaker Data API to help you quickly identify and troubleshoot issues. See Set Error Logging.

• The Revert Transaction script step is now supported in sub-scripts to help you streamline your scripts that use transactions. For more information on this improved support for nested transactions, see Open Transaction.

• Insert from URL now supports the --aws-sigv4 cURL option. This option is not supported when the file is hosted by FileMaker Server on Ubuntu 20. See Supported cURL options.

• The Save a Copy as Add-on Package script step is no longer in preview and has been added to FileMaker Pro Help. See Save a Copy as Add-on Package.

Functions

New functions:

• The new JSONMakeArray function converts a list of values to a JSON array given the line separator and the JSON data type to use. See JSONMakeArray.

• In macOS, iOS, and iPadOS, the new GetLiveTextAsJSON function returns the text found in an image provided in a container field, similar to how the GetLiveText function does. However, this function returns JSON data for each separate line of text and its location within the image. See GetLiveTextAsJSON.

Function enhancements:

• Syntax improvements for JSON functions:

  • To easily append elements to an array with the JSONSetElement function, you can now use "[+]" in the keyOrIndexOrPath parameter to represent the next element after the end of the current array. For example, this adds two elements to the end of an existing array in $$jsonArray:

    Copy

    JSONSetElement ( $$jsonArray ;
        [ "[+]" ; "Claris" ; JSONString ] ;
        [ "[+]" ; "FileMaker" ; JSONString ]
    )
    

  • To easily reference the last element in the current JSON array, you can now use "[:]" in the keyOrIndexOrPath parameter in any of the JSON functions. For example:

    • JSONGetElement ( "[1, 2, 3, 5]"; "[:]" ) returns 5.

    • This creates an array with one element using the "[+]" syntax, then adds another key-value pair to that element by referencing it with the "[:]" syntax:

      Copy

      JSONSetElement ( "[]"; 
          [ "[+].a", 5, JSONNumber ] ; 
          [ "[:].b", 6, JSONNumber ]
      )

      Which returns:

      [ { "a":5, "b":6 } ]

    See Working with the JSON functions, JSONSetElement, and JSONGetElement.

• With support for Live Text in Thai and Vietnamese languages added in iOS 17, iPadOS 17, and macOS Sonoma, the GetLiveText and GetLiveTextAsJSON functions now support these languages as well. See GetLiveText.

Layouts

• Web viewers now support Web Real-Time Communication (WebRTC) in FileMaker Pro (not supported in FileMaker Go). For web viewers to use WebRTC, when FileMaker Pro starts for the first time, the user is requested to grant access to the camera and microphone.

Application

• macOS: The Window menu now shows icons for minimized FileMaker Pro windows.

• Windows: Performance has been improved when using the search box in areas such as the Manage Layouts dialog, the Fields tab in Layout mode, and the Script Workspace.

• Windows: All references to the Microsoft Edge WebView2 runtime have been updated to the same version for a more consistent experience.

• Repetitions in variables are now supported in file paths. For example, $path[2] can be set to a file path and used in script steps like Export Field Contents where paths are expected:

  Copy

  Set Variable [ $path[2]; Value: Get ( DesktopPath ) & "test.pdf" ]
  Export Field Contents [ Table::Container ; "$path[2]" ; Automatically open ; Create folders: Yes ]

• The import.log file now includes error information when issues occur during copying or importing of value lists and themes.

• In the Manage Database dialog, the relationships graph now supports Dark Mode.

• The ability to make indirect database schema changes has been removed from scripting while a script is running with Full Access privileges.

• All Claris FileMaker 2024 products have a new icon. Look for it in the apps, installers, .fmp12 file icons, and more.

  

Installer (Windows)

• Windows: The Microsoft Edge WebView2 Runtime installer included with the FileMaker Pro installer has been updated to version 118.0.2088.76. If a later version is already installed, this version of the WebView2 installer isn't run.

• Windows: The FileMaker Pro installer now installs an updated Bonjour on top of an existing Bonjour installation.

Save a Copy as XML

When a FileMaker Pro file is saved using Save a Copy as XML:

• The image data for every instance of a custom icon was saved separately in the XML file. Now, the image is stored once and referenced by each instance, which can reduce file size and complexity.

• Layout objects, script steps, and custom menu items now include hashes, making it easier to detect when they change.

Updated libraries and packages

• The Xerces XML parser library has been replaced with libxml2, and the Xalan XSLT processor library has been replaced with libxslt. See XML format.

  • As part of the replacement with libxml2 and libxslt, extensions from EXSLT are also supported. See exslt.github.io.

• OpenSSL has been upgraded to version 3.0.11.

• OmniOrb has been updated to version 4.3.2.

Addressed issues

Script steps

• Windows: When the Insert from URL script step was used with a valid URL that started with file:// and included any Unicode characters, the script step returned a "connection failed" error.

• When using the Insert From URL script step with the --proxy cURL option and an HTTPS proxy server, an error was returned that the SSL certificate name of the proxy didn't match with the final destination.

• When using the Execute FileMaker Data API script step with the action key set to create or update, specifying a value for the dateformats key returned an error.

• FileMaker Pro quit unexpectedly when running an Execute FileMaker Data API script step that referenced a field ending with a colon.

• The Send Event script step in an add-on caused error 100 to be returned after exporting then re-importing the add-on.

• The Configure Local Notification script step failed to run when system notifications were disabled and failed to send the "NotificationNotAllowed" value in the script parameter.

• After running a script that performed the Loop script step with the Flush option set to Defer, related fields didn't always display or refresh data as expected.

Functions and calculations

• Get(ModifiedFields) did not necessarily return the list of non-empty fields when a record was deleted.

• Comparing numbers with high precision sometimes incorrectly caused equivalent numbers to be evaluated as different.

• In some cases, referencing a repeating field at an index containing 9 or more zeroes caused the operation to silently fail.

Performance

• Text shortening functions, such as Left and GetValue, were slower than in previous versions. Memory reduction changes to functions are now tuned to improve performance.

• JavaScript ran slow in web viewer objects when custom functions ran with recursion.

Layouts

• macOS: When opening Dropbox in a web viewer, an error was displayed directing you to "Update your browser to use Dropbox."

• Windows: Web viewers in FileMaker Pro always used English as the user interface display language. Now, web viewers use the Windows display language chosen in the Windows Settings app.

• macOS: FileMaker Pro stopped responding when thousands of repeating fields were visible.

• macOS: Conditional formatting in slide controls was not necessarily evaluated.

• Windows: Layouts using the old enlightened_print theme were slow to print.

• Hover state styling was often not correctly applied on fields configured with placeholder text.

• When you clicked in a layout calculation that was in a containing object like a panel control or portal, clicking outside the layout calculation caused it to move down and to the right.

• Layout calculations did not update when updating field data by field name instead of by fully qualified name.

• In a field set to display as a concealed edit box, placeholder text that used the text formatting functions in a calculation was not formatted correctly in the normal and hover states.

• Creating a new text object, then click-dragging the object caused the object width to change to 0.

• A portal with a single row increased in size by 1 pixel when the Portal Settings dialog opened.

• In Kiosk mode, in some cases the display of a layout was vertically offset such that the active area of a button was somewhat higher than the visible area of the button. Also, in List View, the first record was initially scrolled up somewhat, obscuring the first record.

Security

• If signed in to a FileMaker Pro file using an account with no record access privileges to some tables, the Data Viewer became active when a script with Grant Full Access Privileges enabled was run. If previously set up to watch values dependent on data in restricted tables, the Data Viewer's Watch tab revealed restricted data for as long as the script was running.

Application

• In files hosted by certain versions of FileMaker Server or FileMaker Cloud, FileMaker Pro prevented users from making changes in the File Options dialog.

• macOS: In the Hosts dialog, after you edited a favorite host and pressed the Escape key, FileMaker Pro 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.

• After you selected any of the following options in the File Options dialog, a Database Design Report listed them as "Off":

  • Allow stored credentials for authentication

  • Require iOS or iPadOS passcode

  • Show sign-in fields even when OAuth or AD FS is enabled

  • Hide all toolbars

• The OnWindowTransaction script trigger did not appear on the Database Design Report.

• macOS: When more than six OAuth providers are set up to sign in to a hosted FileMaker Pro file, buttons for only six providers are displayed in the sign-in dialog.

• macOS: When a computer was set to use a proxy server with a username and password to access the internet, if HTTPS Tunneling was turned on, then FileMaker Pro couldn't connect to a FileMaker Server host on the internet.

• macOS: After using Help > Check for Updates, the version dialog incorrectly displayed the caption "Update Error!" and the button "Cancel Update" when there was no update available.

• macOS: Quitting FileMaker Pro with multiple windows, both panes in Layout mode, the Manage Layouts dialog, and an Inspector window all open caused FileMaker Pro to report an error.

• macOS: Previously, after editing a function in the Custom Functions dialog, using Undo undid all changes. Now, each time you use Undo, it undoes only the most recent change, as in other calculation dialogs.

• macOS: In the Slide Control Setup dialog, the panel count was cut off when the number of panels was large.

• macOS: FileMaker Pro quit unexpectedly when using the Command-U keyboard shortcut while in the relationships graph if the Manage Database dialog was opened by a script. Also, keyboard commands and accelerators for the relationships graph will now function rather than being ignored.

• macOS: FileMaker Pro quit unexpectedly when a plug-in passed invalid UTF-8 data through the FM_Text_Assign() API.

• macOS Sonoma: FileMaker Pro quit unexpectedly when using the cut command (Command+X) on a picture in Layout mode.

• macOS Sonoma: Changing modes or reopening files caused custom toolbars to reset to defaults.

• macOS Sonoma: After you added or removed items in the status toolbar, hid the status toolbar in the current window, then opened another file or created a file, the status toolbar was reset to the default items.

• Windows: The Send Mail script step dialog for OAuth 2.0 hid the upper border of the Service Account Email option when the window was the default size.

• When editing an Import Record script step import order and a file type was selected but no file was provided, FileMaker Pro displayed an error and didn't allow you to modify the import order.

• Windows: Pasting a multi-line calculation in the Inspector caused only the first line to be pasted and the rest to be truncated.

• Windows: FileMaker Pro quit unexpectedly when resizing columns in the Manage Layouts dialog.

• When signed in with an account that had "no access" privileges to layouts, FileMaker Pro quit unexpectedly when you entered Layout mode and dragged an add-on to a layout.

• When editing a field, changes were reported even if the field was not modified due to validation errors.

• The conditional formatting icon did not appear for objects until the layout was saved.

• The OnWindowTransaction script trigger was incorrectly triggered when leaving Find mode.

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

• The Insert from Index dialog was blank when one external data source was referenced by multiple files.

• In the Script Workspace, the gear icon at the end of certain script steps was sometimes partially hidden.

• macOS: Rapidly renaming scripts or folders in Script Workspace sometimes caused FileMaker Pro to quit unexpectedly.

• If a user was editing an account in a hosted file, a script step (for example, Reset Account Password) that tried to edit the same account at the same time failed but Get(LastError) didn't return an error. Now, Get(LastError) returns the new error code 310 to indicate that an item can't be modified because another user is modifying it.

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

• FileMaker Pro quit unexpectedly after you opened the Modify Table View dialog, opened the relationships graph from there and clicked a related table, then added a related field in the Modify Table View dialog.

• FileMaker Pro could not import an XML file by importing a folder of text files. Files with csv, tab, tsv, mer, htm, html, xml, svg, json, log, txt extensions are now recognized as text file types.

• An image in HEIF/HEIC format was inserted into a container field as a file rather than as an image.

• After you entered an upgrade license certificate, you could specify a license key but not a license certificate file from an earlier qualifying version. Now, you can specify whichever one you received with an earlier qualifying version.

• The Calendar add-on failed to display an event in the ending month if the event spanned multiple months.

• After cloning a file that used the Simple Chart add-on, the add-on's settings dialog was blank under certain circumstances. Namely, if the add-on was added to the original file on a system where the decimal separator was a period but the cloned file was opened on a system where the decimal separator was a comma.

• After an add-on with a layout that specified a custom menu set was added to a FileMaker Pro file containing a custom menu set with the same name, the add-on's custom menu set name was changed as expected in the Manage Custom Menus dialog to use a different name. However, in the Manage Layouts dialog, the Menu Set column for the add-on's layout displayed the file's rather than the add-on's menu set name.

Save a Copy as XML

When a FileMaker Pro file was saved using Save a Copy as XML:

• An XML CDATA terminating sequence of "]]>" without the beginning sequence caused FileMaker Pro to quit unexpectedly.

• The Field element included an unnecessary DefaultStyle attribute in the XML file.

• A field that was set to validate values as members of a value list, but that had no value list specified, was missing the ValueListReference element in the XML file.

• A custom menu item that performs a script was incorrectly saved in the XML file in some cases.

• A button with Action set to Do Nothing produced an unnecessary action element for the button in the XML file.

• A button in a button bar that was inside another object (for example, a popover or panel control) appeared multiple times in the XML file. Now, the button appears only once, which can reduce file size and complexity.

• A layout that was associated with a custom menu set didn't include a reference to the custom menu set.

• A merge field for a field in a related table in an external data source produced a TableOccurrenceReference element with invalid or empty attributes in the XML file.

• Tooltip elements were missing the child Calculation element.

• A ScriptTrigger element referenced the incorrect script trigger script.

• The FieldReference element for a merge field on a layout had no values for the name and UUID attributes.

• Privilege sets with Available menu commands set to Editing only were incorrectly represented as being set to All.

• Custom privileges when set for any new table used a different XML structure than those set for existing tables. Now, the XML structure for any new table is the same as that of existing tables.

• Field elements for fields that required validation with a value list had no ValueListReference element in them when the value list was from a missing file. Now, Field elements include a ValueListReference element in this case. The corresponding value list in the ValueListCatalog element now contains only an id, name, UUID, and source type. The details about the value list are now stored in the new OptionsForValueLists element.

Removed features

• macOS: Because macOS Sonoma has removed support for Encapsulated Postscript (.eps) images, FileMaker Pro no longer supports EPS images starting with that version of macOS. EPS images are still supported in Windows.

Known issues

• When you edit a layout calculation in the Specify Calculation dialog and click OK, function names in mixed or upper case aren't reformatted in title case as expected.

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

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