Skip to main content

FileMaker

The FileMaker node allows you to automate work in FileMaker, and integrate FileMaker with other applications. Robbot Automation has built-in support for a wide range of FileMaker credentials, including creating, finding, getting, editing, and duplicating files.

On this page, you'll find a list of operations the FileMaker node supports and links to more resources.

!!! note "Credentials" Refer to FileMaker credentials for guidance on setting up authentication.

!!! note "Examples and templates" For usage examples and templates to help you get started, take a look at Robbot Automation's FileMaker list.

Basic Operations​

  • Find Records
  • Get Records
  • Get Records by Id
  • Perform Script
  • Create Record
  • Edit Record
  • Duplicate Record
  • Delete Record

Example Usage​

This workflow allows you to create, update, and retrieve a record from FileMaker. You can also find the workflow on Robbot Automation. This example usage workflow uses the following nodes.

1. Start node​

The Start node exists by default when you create a new workflow.

2. FileMaker node​

This node will create a new record in FileMaker.

  1. First of all, you'll have to enter credentials for the FileMaker node. You can find out how to do that here.
  2. Select 'Create Record' from the Action dropdown list.
  3. Select a layout from the Layout dropdown list.
  4. Click on the Add Field button.
  5. Select a field from the Field dropdown list.
  6. Enter a value in the Value field.
  7. Click on the Add field button.
  8. Select a field from the Field dropdown list.
  9. Enter a value in the Value field.
  10. Click on Save to run the node.

3. FileMaker1 node​

This node will add a new field to the record that we created in the previous node.

  1. Select the credentials that you entered in the previous node.
  2. Select 'Edit Record' from the Action dropdown list.
  3. Select a layout from the Layout dropdown list.
  4. Click on the gears icon next to the Record Id field and click on Add Expression.
  5. Select the following in the Variable Selector section: Current Node > Input Data > JSON > response > recordId. You can also add the following expression: {{$json["response"]["recordId"]}}.
  6. Click on the gears icon next to the Mod Id field and click on Add Expression.
  7. Select the following in the Variable Selector section: Current Node > Input Data > JSON > response > modId. You can also add the following expression: {{$json["response"]["modId"]}}.
  8. Click on the Add field button.
  9. Select a field from the Field dropdown list.
  10. Enter a value in the Value field.
  11. Click on Save to run the node.

4. FileMaker2 node​

This node will get the information about the record that we created earlier.

  1. Select the credentials that you entered in the previous node.
  2. Select 'Get Records by Id' from the Action dropdown list.
  3. Select a layout from the Layout dropdown list.
  4. Click on the gears icon next to the Record Id field and click on Add Expression.
  5. Select the following in the Variable Selector section: Nodes > FileMaker > Output Data > JSON > response > recordId. You can also add the following expression: {{$node["FileMaker"].json["response"]["recordId"]}}.
  6. Click on Save to run the node.