Export Records automation from scripts

Beginner

Automate CSV, Excel, and XML record exports from FileMaker scripts with dynamic file paths, field order control, and error handling.

What you'll learn

How to build a dynamic export file path using Get(DesktopPath) or a user-specified location
How to export as CSV with a specific field order
How to detect write permission errors after Export Records
How to immediately open the exported file
Differences between Export Records and Save Records as Excel

Export Records lets you write the current found set to a file in CSV, Excel (xlsx), Tab-Separated, or XML format. When scripted, you control the output path, format, field order, and encoding -- and you can chain an Open URL step to immediately open the exported file. The key to reliable automated exports is building the file path dynamically and handling write permission errors.

1/3

Build a dynamic export path

Use Get(DesktopPath) or Get(DocumentsPath) as a base. Append a timestamped filename to avoid overwriting previous exports. On macOS, paths use forward slashes; on Windows, use Get(SystemDrive) & "\path\".

FileMaker Script

Set Variable [ $timestamp ; Value:
  Substitute (
    Get ( CurrentTimestamp ) ;
    [ ":" ; "-" ] ;
    [ " " ; "_" ]
  )
]
Set Variable [ $filename ; Value: "Invoices_Export_" & $timestamp & ".csv" ]
Set Variable [ $exportPath ; Value: Get ( DesktopPath ) & $filename ]

Sort Records patterns in scripts Import Records automation in FileMaker scripts