Downloads from HORNEKS ANS

New in this 1.7.8.7 version is the new Image Drawing functions. https://horneks.no/manuals/ACF/acf-pluginimagefunctions.html

This is a small package with only the plugin and ACF-Compiler in a single DMG archive, without examples and documentation. Just for install on client machines that do not need to dive into developer details. This is the version with ZIP file integration, Language Macro implementation, Excel Spreadsheet implementation. Also Inter-package calls in this version. Multilingual support and a lot more,

Improved version for use on FileMaker server

Read the article found here about the changes since 1.7.8.4

Reworked the compiler to allow declarations inside loops and conditional branches.

Look for the other download if you want examples and documentation

This is the full developer package with the plugin, examples, documentation, Editor bundles, compiler and tools. This is the version with ZIP file integration, Language Macro implementation, Excel Spreadsheet implementation. Also Inter-package calls in this version. Multilingual support and a lot more,

Improved License handling in this version.

Read the article found here about the changes since 1.7.8.4. It is for the linux beta, but the same changes descibed there is Valid for this MacOS release.

Reworked the compiler to allow declarations inside loops and conditional branches.

1.7.8.4

• Bugfix release, otherwise same as 1.7.8.3

1.7.8.3

• Linux version in Alpha
• New functions : Min_(mixed parameter list) and Max_(mixed parameter list). They returns the less or greatest value from the list. It can be discrete variables or constants of any type, and arrays. The return type is determined by the types of your parameters: Int, long or float. Strings is treated as Float, as they can contain float numbers. The parameters does not need to be the same type. The functions also works on TIME, DATE or TIMESTAMP variables or constants (as they contain unix-timestamps).
• BugFix: Functions returning a container, and used the FunctionID to make ACFU_Function_name - when called using the ACFU... it didn't return the container, while ACF_Run... did. Fixed.
• New Constants: isLinux , isServer - in additon to the isMac, isWindows that we had before.
• New System variables: appVersion returns the FileMaker application version, or server. Also plugginVersionthat returns the version string for the plugin as dot-separated version number.
• NOTE: If you are using any of those new functions, variables or constants, it is required that all clients of your database update to this version. Otherwise, functions might fail due to lack of runtime support for the new functions.
• NOTE: Also install the new ACF-Compiler for syntax check from your IDE, as this have the new functions defined.
• Improved server-side functions for Documents_directory() to retun the path for the documents directory on the server, if executed from server. Also the same for temporary_directory()
• The built-in bootstrap ACF-library has been updated. The GetFilenameFromPath(path) , GetDirectoriesFromPath, GetExtentionFromPath has been improved to correctly handle all types of paths/plattforms. The functions that involves UI operations has been made server-safe, either returning a default value or empty if used on server.
• BugFix: In the function Excel_SetRowHeight - Sometimes thrown an error exception - Allocated space in the row-heigh list using a wrong variable. Errnously reported to invalid or negative row index. Fixed.

This is a small package with only the Windows version of the plugin in a single ZIP archive, without examples and documentation. Just for install on client machines that do not need to dive into developer details. This is the version with ZIP file integration, Language Macro implementation, Excel Spreadsheet implementation.

• Improved License handling in this version.

• Reworked the compiler to allow declarations inside loops and conditional branches.

1.7.8.5

Read the article found here about the changes since 1.7.8.4

1.7.8.4

• Bugfix release, otherwise same as 1.7.8.3

1.7.8.3

• Linux version in Alpha
• New functions : Min_(mixed parameter list) and Max_(mixed parameter list). They returns the less or greatest value from the list. It can be discrete variables or constants of any type, and arrays. The return type is determined by the types of your parameters: Int, long or float. Strings is treated as Float, as they can contain float numbers. The parameters does not need to be the same type. The functions also works on TIME, DATE or TIMESTAMP variables or constants (as they contain unix-timestamps).
• BugFix: Functions returning a container, and used the FunctionID to make ACFU_Function_name - when called using the ACFU... it didn't return the container, while ACF_Run... did. Fixed.
• New Constants: isLinux , isServer - in additon to the isMac, isWindows that we had before.
• New System variables: appVersion returns the FileMaker application version, or server. Also plugginVersionthat returns the version string for the plugin as dot-separated version number.
• NOTE: If you are using any of those new functions, variables or constants, it is required that all clients of your database update to this version. Otherwise, functions might fail due to lack of runtime support for the new functions.
• NOTE: Also install the new ACF-Compiler for syntax check from your IDE, as this have the new functions defined.
• Improved server-side functions for Documents_directory() to retun the path for the documents directory on the server, if executed from server. Also the same for temporary_directory()
• The built-in bootstrap ACF-library has been updated. The GetFilenameFromPath(path) , GetDirectoriesFromPath, GetExtentionFromPath has been improved to correctly handle all types of paths/plattforms. The functions that involves UI operations has been made server-safe, either returning a default value or empty if used on server.
• BugFix: In the function Excel_SetRowHeight - Sometimes thrown an error exception - Allocated space in the row-heigh list using a wrong variable. Errnously reported to invalid or negative row index. Fixed.

This is the full developer package with the plugin, examples, documentation, Editor bundles, compiler and tools. This is the version with ZIP file integration, Language Macro implementation, Excel Spreadsheet implementation. Also Inter-package calls in this version. Multilingual support and a lot more,

Improved License handling in this version.

1.7.8.5

Read the article found here about the changes since 1.7.8.4

1.7.8.4

• Bugfix release, otherwise same as 1.7.8.3

1.7.8.3

• Linux version in Alpha
• New functions : Min_(mixed parameter list) and Max_(mixed parameter list). They returns the less or greatest value from the list. It can be discrete variables or constants of any type, and arrays. The return type is determined by the types of your parameters: Int, long or float. Strings is treated as Float, as they can contain float numbers. The parameters does not need to be the same type. The functions also works on TIME, DATE or TIMESTAMP variables or constants (as they contain unix-timestamps).
• BugFix: Functions returning a container, and used the FunctionID to make ACFU_Function_name - when called using the ACFU... it didn't return the container, while ACF_Run... did. Fixed.
• New Constants: isLinux , isServer - in additon to the isMac, isWindows that we had before.
• New System variables: appVersion returns the FileMaker application version, or server. Also plugginVersionthat returns the version string for the plugin as dot-separated version number.
• NOTE: If you are using any of those new functions, variables or constants, it is required that all clients of your database update to this version. Otherwise, functions might fail due to lack of runtime support for the new functions.
• NOTE: Also install the new ACF-Compiler for syntax check from your IDE, as this have the new functions defined.
• Improved server-side functions for Documents_directory() to retun the path for the documents directory on the server, if executed from server. Also the same for temporary_directory()
• The built-in bootstrap ACF-library has been updated. The GetFilenameFromPath(path) , GetDirectoriesFromPath, GetExtentionFromPath has been improved to correctly handle all types of paths/plattforms. The functions that involves UI operations has been made server-safe, either returning a default value or empty if used on server.
• BugFix: In the function Excel_SetRowHeight - Sometimes thrown an error exception - Allocated space in the row-heigh list using a wrong variable. Errnously reported to invalid or negative row index. Fixed.

📦 ACF_U24x86_64_1.7.8.5_Beta2.zip Download

🧩 Beta 2 Changelog

Console function and thread safety

The console function is primarily used for debugging ACF functions (using the print statement) and logging messages from the plugin. Its in-memory text buffer can be retrieved at any time using the ACF_GetConsoleOutput function. This console is shared across sessions and is not used for any other purpose.

In Beta 1, the console implementation was not fully thread-safe, which could—under rare conditions—lead to race-related issues. Beta 2 introduces a completely thread-safe console, ensuring reliable output even when multiple processes or server scripts write to it simultaneously. We have also cleaned up the plugin by removing leftover debug output that was unintentionally included in Beta 1.

📦 ACF_U24arm64_1.7.8.5_Beta2.zip Download

🧩 Beta 2 Changelog

Console function and thread safety

The console function is primarily used for debugging ACF functions (using the print statement) and logging messages from the plugin. Its in-memory text buffer can be retrieved at any time using the ACF_GetConsoleOutput function. This console is shared across sessions and is not used for any other purpose.

In Beta 1, the console implementation was not fully thread-safe, which could—under rare conditions—lead to race-related issues. Beta 2 introduces a completely thread-safe console, ensuring reliable output even when multiple processes or server scripts write to it simultaneously. We have also cleaned up the plugin by removing leftover debug output that was unintentionally included in Beta 1.

ACFcompiler for syntax checking from Sublime Text without leaving the editor. Syntax coloring and more.

Also in version, autocomplete for over 276 ACF functions and commands. The autocompletes are loaded with parameter defs to ensure you write function names correctly and with the correct parameters.

This download matches the 1.7.8.5 version of the ACF-Plugin

ACFcompiler for syntax checking from Sublime Text without leaving the editor. Syntax coloring and more.

Also in version, autocomplete for over 276 ACF functions and commands. The autocompletes are loaded with parameter defs to ensure you write function names correctly and with the correct parameters.

This download matches the 1.7.8.5 version of the ACF-Plugin

DDRparser 1.4.1 – Split FileMaker DDR (Database Design Report) XML or “Save a copy as XML” files into readable, multilingual files

DDRparser is a free, fast, and fully native command-line tool that parses FileMaker Database Design Report (DDR) XML exports — or “Save a copy as XML” exports — and splits them into structured, readable text files.

Perfect for developers who want to search, diff, and version-control FileMaker solutions using Git and modern tools.

This release also demonstrates the new translation concept built with DDRparser 1.4.1 and ACF-plugin 1.7.6.4.(or higher)

📝 Note: The accompanying FileMaker GUI app has been updated to use ACF-plugin, which now includes translation functions both for ACF functions and for plugin functions available directly from FileMaker calculations. The app also showcases the translation workflow, with 10 selectable languages available in the GUI tools app.

✨ Key Features

💡 Handles even multi-gigabyte DDR files in seconds

💡 Includes translation workflow tools

🔍 Makes your solution searchable with BBEdit, VS Code, or any text editor

🗂️ Extracts Scripts, Layouts, Custom Functions, Menus, Tables, and more

🧼 Optional cleanup removes outdated files

🔁 Git auto-commit support for effortless version control

🧰 Includes an optional FileMaker GUI tool powered by the ACF plugin

✅ Free to use — no license required, no plugin dependencies for the core tool

🍎 Runs on macOS 10.13+ (Intel + Apple Silicon)

Built by Ole Kristian Ek Hornnes @ HORNEKS ANS 👉 Visit the blog article for full details.

DDRparser 1.4.1 – Split FileMaker DDR (Database Design Report) XML or “Save a copy as XML” files into readable, multilingual files

DDRparser is a free, fast, and fully native command-line tool that parses FileMaker Database Design Report (DDR) XML exports — or “Save a copy as XML” exports — and splits them into structured, readable text files.

Perfect for developers who want to search, diff, and version-control FileMaker solutions using Git and modern tools.

This release also demonstrates the new translation concept built with DDRparser 1.4.1 and ACF-plugin 1.7.6.4.(or higher)

📝 Note: The accompanying FileMaker GUI app has been updated to use ACF-plugin, which now includes translation functions both for ACF functions and for plugin functions available directly from FileMaker calculations. The app also showcases the translation workflow, with 10 selectable languages available in the GUI tools app.

✨ Key Features

💡 Handles even multi-gigabyte DDR files in seconds

💡 Includes translation workflow tools

🔍 Makes your solution searchable with BBEdit, VS Code, or any text editor

🗂️ Extracts Scripts, Layouts, Custom Functions, Menus, Tables, and more

🧼 Optional cleanup removes outdated files

🔁 Git auto-commit support for effortless version control

🧰 Includes an optional FileMaker GUI tool powered by the ACF plugin

✅ Free to use — no license required, no plugin dependencies for the core tool

🍎 Runs on macOS 10.13+ (Intel + Apple Silicon)

Built by Ole Kristian Ek Hornnes @ HORNEKS ANS 👉 Visit the blog article for full details.

This demo showcases how the ACF Plugin can be used inside FileMaker to generate a complete Excel workbook from database data — including dynamic charts and cross-tab summaries — all created directly through ACF script functions.

NOTE: The ACF-Plugin version >= 1.7.8.2 must be downloaded separately for the plattform you are using.

The demo is based on a fictive company “Demo Furnitures Inc.”, and produces an Annual Report spreadsheet with four automatically generated sheets:

1. By Category × Period – Sales totals grouped by product category and month
2. By Seller × Period – Sales totals grouped by salesperson and month
3. By Product × Period – Sales totals grouped by product and month
4. By Seller details – Per-seller summary tables with category and product breakdowns, each accompanied by two doughnut charts showing proportional sales distribution

All data is generated from a small sample of 1000 invoices created by the included Python script (generateDemoData.py), stored in the FileMaker table DemoInvoices.

• The simplicity of ACF’s SQL + array INTO syntax for data extraction
• Automated creation of Excel workbooks, styles, and charts using ACF Excel functions
• How developers can combine SQL, JSON, and charting seamlessly in ACF scripts

I’m thrilled to announce the release of ACF Plugin version 1.7.8.4, featuring the latest advancements in Excel functionality! To celebrate this release—and with the New Year just around the corner—I’ve developed a demo application to showcase the new features.

This demo application is designed to generate Excel cash flow budgets effortlessly. It includes two key tables in addition to the ACF developer table:

• Budget: For managing your budget projects.
• Transactions: For tracking recurring income and expenses.

Key Features

• Transactions are categorized into two main types: Income and Expenses.
• Define recurring rules for each transaction, specifying how often the transaction occurs, along with its start date and interval (days, weeks, months, or years).
• Set your budget’s start and end dates (designed to run for full months).

The layout:

The resulting Excel Spreadsheet

The package contains

• an FileMaker Demo Application, (You need FileMaker PRO to run it)
• ReadMe File
• Version 1.7.7.4 ACF Plugin for FileMaker (Mac)

Enjoy.

The package contains

• an FileMaker Demo Application, (You need FileMaker PRO to run it)
• ReadMe File
• Version 1.7.7.4 ACF Plugin for FileMaker (Win)

Enjoy.

The Devtool-download.zip Download

The ACF Developer Tool is a compact FileMaker application that lets you create, edit, compile, and test ACF functions directly — both locally and on FileMaker Server. It connects seamlessly with Sublime Text and the ACF Compiler, providing a full development workflow from source to runtime in one place.

Use it to manage your ACF packages, view console output, test functions with live parameters, and verify results instantly. Whether you’re developing new ACF packages or maintaining existing ones, this tool gives you a fast, consistent way to build and deploy ACF code across all platforms.