FileMaker CRUD: Create, Update & Retrieve Records

This n8n workflow provides a complete demonstration of CRUD operations focused on create, update, and retrieve actions within FileMaker databases. It begins with a manual trigger to execute the workflow on demand. The first FileMaker node creates a new record in the 'My Form Layout' using hardcoded values for 'first_name' (Harshil) and 'last_name' (Agrawal). The subsequent update node (FileMaker2) modifies this record by injecting an 'address_country' field set to 'Germany', referencing the recordId and modId from the creation step. Finally, the retrieve node (FileMaker3) fetches the complete record data using the original recordId.

The benefits include rapid prototyping of FileMaker integrations, reducing manual data entry errors, and enabling scalable automation for record management. It showcases dynamic parameter passing between nodes, such as using expressions like {{$json["response"]["recordId"]}} for seamless data flow.

Ideal use cases span customer onboarding (e.g., adding and updating contact info), inventory tracking, or any scenario requiring sequential record lifecycle management in FileMaker. Extend it by integrating with triggers like webhooks or other apps for production use in CRM, e-commerce, or data syncing workflows. Despite the Travel/Weather category, it's broadly applicable to database automation.