There are thousands of downloadable custom function examples available on various websites. These can be enormous time savers and I encourage everyone to use them. However, when downloading code, it is often necessary and advisable to review and even rewrite the code. Recently a reader contacted me about his confusion regarding a downloaded function that converted a number ( 9,… read more →
FileMaker releases update for FileMaker Pro version 17.0.2. July 24, 2018 — Today, FileMaker pushed out an update to product line, releasing updates for FileMaker Pro Advanced and FileMaker Server. According to the release notes, the new version of the desktop applications contain the following changes: Application Windows: FileMaker Pro Advanced closed unexpectedly when the Hosts dialog box was opened and then… read more →
We Have a Winner! Congratulations to Stephen Wallace of Helsinki, Finland who won the Learn FileMaker Pro 16 Easter Egg Hunt and is awarded a $50 Amazon Gift Card! Stephen Wallace Contest Winner facebook: Facebook Stephen noticed an issue with the result of the Base64Encode function example on page 344. The example shows an encoded result value of “aHR0cHM6Ly95b3V0dS5iZS9kUXc0dzlXZ1hjUQ==”. However,… read more →
FileMaker releases version 17.0. May 15, 2018 — Today, FileMaker released version 17 of it’s database application development product line. The new version of the desktop application contain the following changes: Merging FileMaker Pro and FileMaker Pro Advanced FileMaker Pro Advanced replaces FileMaker Pro as the only desktop application for developing custom applications. Improvements for Opening & Creating Tables Some redesign of… read more →
FileMaker releases update for FileMaker Pro version 16.0.5. March 6, 2018 — Today, FileMaker pushed out an update to product line, releasing updates for FileMaker Pro, FileMaker Pro Advanced. The new version of the desktop applications contain the following changes (from the release notes): macOS High Sierra 10.13 Addressed an issue where scrolling could cause FileMaker Pro to close unexpectedly. The 16.0.5… read more →
JSONGetElementInArray will search through an array of uniform JSON objects until it finds a matching value in a specified key and then can return another key value or the entire object at the matching index location. JSONGetElementInArray ( array ; searchKey ; searchValue ; resultKey ) Parameters Click on a parameter to view the available options: array The array parameter must… read more →
I hope you had a relaxing holiday and a Happy New Year. If you are ready to learn or improve your knowledge of FileMaker Pro in 2018, please consider purchasing Learn FileMaker Pro 16. Released in September 2017, this 917 page volume contains everything you need to know to get up and running with FileMaker or to expand your knowledge into… read more →
FileMaker releases update for FileMaker Pro version 16.0.4. February 6, 2018 — Today, FileMaker pushed out an update to product line, releasing updates for FileMaker Pro, FileMaker Pro Advanced and FileMaker Server. The new version of the desktop applications contain the following changes (from the release notes): Application Checking for updates when plug-ins were installed caused FileMaker Pro to close unexpectedly. Scripts… read more →
FileMaker releases update for FileMaker Pro version 16.0.3. October 10, 2017 — Today, FileMaker pushed out an update to product line, releasing updates for FileMaker Pro, FileMaker Pro Advanced and FileMaker Server. The new version of the desktop applications contain the following changes (from the release notes): Application macOS: Switching to a layout that included a chart caused FileMaker Pro to close… read more →
The Comprehensive Guide to Building Custom Databases has something for everyone! September 9, 2017 — Apress released Learn FileMaker Pro 16: The Comprehensive Guide to Building Custom Databases by Mark Conway Munro. Learn FileMaker Pro 16 presents a comprehensive guide to the FileMaker Pro development environment, covering everything from basic database concepts to advanced functions and features. Written by a long-time FileMaker developer, this… read more →