Softpedia >Mac >Developer Tools >FileMaker Pro Advanced >  Changelog

FileMaker Pro Advanced Changelog

What's new in FileMaker Pro Advanced 18.0.3.317

Oct 31, 2020
  • Application:
  • macOS: FileMaker Pro Advanced was not enabled to ask permission for use of system services.
  • macOS: The FileMaker Pro Advanced updater failed if the application name was changed.
  • Script steps:
  • Windows: The Insert from URL script step failed to support the LDAP (Lightweight Directory Access Protocol) protocol.
  • Converting files:
  • During file conversion, a table occurrence was named differently than the table.
  • Importing data:
  • When importing to a new target table and the import order was changed, a field was unavailable for selection.
  • Layouts:
  • Windows: An open drop-down value list overlaid the originating field.
  • Windows: The application closed unexpectedly when the view was switched while a popover object was active in the header part.

New in FileMaker Pro Advanced 17.0.6.600 (May 1, 2019)

  • Japanese era name change:
  • This software update supports the new Japanese era, Reiwa (令和), which begins on May 1, 2019. Japanese Emperor Year (Wareki) dates entered into date fields or used in calculations are changed to a Western Gregorian (Seireki) year and saved internally in the format specified by the file. For example, R1/10/28 is changed to 2019/10/28 (R1 = the first year of Reiwa, or 2019). For more information about Japanese Emperor Year dates, see FileMaker Pro Advanced Help.

New in FileMaker Pro Advanced 17.0.3.304 (Dec 13, 2018)

  • Layouts:
  • Improved performance when drawing layouts that don't contain portals used for master-detail layouts.
  • macOS Mojave 10.14:
  • There was a graphical problem in some Edit dialog boxes.
  • The operators list in the Specify Calculation dialog box did not display.

New in FileMaker Pro Advanced 17.0.2.205 (Aug 2, 2018)

  • Application:
  • macOS: In certain circumstances, the CPU usage increased to 100% after FileMaker Pro Advanced was opened.
  • macOS High Sierra 10.13: During some operations, the progress bar did not display.
  • Saving records as PDF:
  • Saving records as a PDF was slower than in previous versions.
  • Layouts:
  • macOS: FileMaker Pro Advanced closed unexpectedly when the field display format was changed in the Inspector.

New in FileMaker Pro Advanced 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 Advanced 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 Advanced 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 Advanced 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 Advanced 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 Advanced 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 Advanced 14.0.6.602 (Aug 12, 2016)

  • Replaces the PDF engine used for PDF creation.

New in FileMaker Pro Advanced 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.
  • 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 Advanced 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 Advanced 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 Advanced 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 Advanced 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 Advanced 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 Advanced 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 Advanced 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 Advanced 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 Advanced 13.0.2.228 (Apr 9, 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 Advanced 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 Advanced 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 Advanced 12.0v3 (Jan 8, 2013)

  • 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.
  • Windows: Improvements in performance made to zooming of windows that contained parts with sliced image fills.
  • 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 Advanced 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.