💥 New Release: ACF Plugin 1.7.8.2 – Excel Reports & Charts directly from FileMaker

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

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