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. 

ACF-Plugin Mac:

ACF-Plugin Win:

NOTE Demo download itself for both Plattforms is located in the bottom of the article

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