HORNEKS ANS

Practical ideas for FileMaker developers

ACF Tip of the Day

One feature at a time. Explore the tips, read the details, and try the ACF examples.

ACF artwork: a quarterly-sales worksheet and editable column chart together in an XLSX file. Headline: Send the chart. Keep the data.

Put an editable chart inside your Excel report

Read tip & example →
ACF HTTP_GET feeds a response card with Status 200, Headers and Body. Headline: Check the response. Then use the data.

Check an API response before using its body

Read tip & example →
A Photo.jpg file feeds through ACF Get_ImageInfo into a JSON-style card showing Dimensions, EXIF and GPS. macOS; available metadata depends on the file.

Inspect image metadata before importing the file

Read tip & example →
An English order-collection notice passes through an nb.po catalog to its Norwegian translation, with the order number preserved. ACF for FileMaker.

Keep translations out of your business logic

Read tip & example →
Two attachment cards, Quote.pdf and Artwork.png, feed through ACF QuickView into one preview panel with navigation arrows. FileMaker Pro on macOS.

Preview several attachments in one Quick Look panel

Read tip & example →
ACF Formula2Latex turns sqrt(x^2+y^2)/2 into notation shown as a typeset square root over a fraction bar with denominator 2. Show the formula, not just the answer.

Show the formula, not just the answer

Read tip & example →
ACF tip: SQL rows become JSON through INTO :data. A three-row table points to a JSON result with success true and rows_found 3. No delimiter splitting.

From SQL rows to JSON inside ACF

Read tip & example →
ACF mail_parse on macOS: raw email becomes structured From, Subject and Body fields. Parse locally. Send nothing.

Turn raw email into structured data with mail_parse

Read tip & example →
ACF value-converter library: Mixed units. Clear formulas. Four cards show length in2cm, weight lb2kg, volume gal2l and temperature c2f.

Simplify mixed-unit formulas with ACF's value-converter library

Read tip & example →
ACF tip: check the size before you upload. A 3 MB report.pdf is within a 5 MB limit, illustrated beside file_size(path).

Check the file size before an upload

Read tip & example →
ACF tip showing a message and shared secret feeding HMAC-SHA256 to produce an authentication code, with the reminder Authentication, not encryption.

Generate an HMAC authentication code inside ACF

Read tip & example →
ACF tip showing Hello transformed into SGVsbG8= with base64_encode(text, 1), no added line breaks, and the reminder Encoding, not encryption.

Prepare single-line Base64 for API payloads

Read tip & example →