Freelancer profile translated to English.

Description

Do you have a process that still runs on Excel? A business software that doesn't talk to your ERP? An existing FileMaker solution that could benefit from an upgrade?

I've been tackling these issues for 15 years, for SMEs across all sectors.

What sets me apart is the ability to connect FileMaker to systems that don't natively communicate with it: ERP, DAM, accounting software, e-commerce — but also the Adobe Suite. I control Photoshop and InDesign directly from FileMaker via AppleScript: automatic file creation, assembly, content injection via InCatalog. A rare skill, concretely useful for the publishing, fashion, and printing industries.

My solutions are in production at my clients' premises, some for over a decade, used daily.

Development · Integration · Adobe · Audit · Training · Remote across France

Industry field of expertise

Languages

English
Fluent

Workplace preferences

Can work on-site

Valence (up to 50km)

Lionel Astol - Heronis (projet R&D personnel)
Natural Language Search in FileMaker via AI
May 2026 - Today (3 months)
Searching in FileMaker is powerful but technical. Users need to know the fields, operators, and database logic. Result: advanced searches are underutilized, and existing data remains undiscoverable for non-experts.
I've developed an integration of the Claude (Anthropic) API directly into FileMaker using the native "Insert from URL" step:
· The user types their question in natural French
· Claude receives the question with a description of the database structure
· Claude returns the search criteria in JSON format
· FileMaker executes the search and displays the results
Concrete example: "All customers with an order pending for more than 15 days" automatically becomes a structured multi-field query, without the user touching a single criterion.
Validated architecture, first conclusive tests on real business data. Integrable into any existing FileMaker solution without additional infrastructure.
Claris FileMaker Artificial Intelligence REST API JSON System Integration
Lionel Astol - Heronis (projet R&D personnel)
Development of an Electronic Invoicing Solution Compliant with 2026 Regulations
April 2026 - Today (4 months)
The electronic invoicing reform requires all French companies to use an approved Partner Dematerialization Platform (PDP) starting in 2026. Invoices must be issued in structured formats (Factur-X, UBL, CII) readable by tax systems.
I developed a fully functional POC, integrated directly into FileMaker:
· Generation of invoices in formats compliant with the reform
· Successful validation tests
· Architecture designed to integrate with an existing solution without restructuring it
· Connection to the client's PDP available upon production launch
This component is now operational and can be integrated into any FileMaker solution that handles invoicing.
Claris FileMaker Electronic Invoicing Factur-x external-api-integration erp-integration-with-external-systems
Lionel Astol - Heronis
Freelance FileMaker Developer · Custom Business Solutions for SMEs
DIGITAL AND IT
February 2024 - Today (2 years and 6 months)
Valence, France
Design and development of custom FileMaker solutions for SMEs. Specializing in complex system integrations (ERP, DAM, accounting software, e-commerce) and modeling constrained business logic.
Main areas of activity: publishing and editorial production, real estate and rental management, fashion and catalog sales, printing and webtoprint.
Recurring missions: development, audit, version migration, user training, long-term support.
Claris FileMaker System Integration Application Development Relational Data Modeling Apple Script