> ## Documentation Index
> Fetch the complete documentation index at: https://learn.workflow.dog/llms.txt
> Use this file to discover all available pages before exploring further.

# Find Records by Formula

> Find Airtable records with a native Airtable filter formula.

The **Find Records by Formula** action passes a formula directly to Airtable and
returns the field objects for records where the formula is truthy.

## Inputs

| Input                   | Type             | Required | Description                                              |
| ----------------------- | ---------------- | -------- | -------------------------------------------------------- |
| **Third-party account** | Airtable account | Yes      | Account with record-read access.                         |
| **Base ID**             | String           | Yes      | Airtable base ID.                                        |
| **Table Name or ID**    | String           | Yes      | Table name or ID.                                        |
| **Filter Formula**      | String           | Yes      | Airtable formula used as `filterByFormula`.              |
| **Sort Field**          | String           | No       | Field used to order matches.                             |
| **Sort Direction**      | `asc` or `desc`  | No       | Sort direction. Defaults to `asc`; used with Sort Field. |

Example:

```text theme={null}
AND({Status} = "Open", {Amount} > 1000)
```

## Outputs

| Output      | Type            | Description                  |
| ----------- | --------------- | ---------------------------- |
| **Records** | List of objects | Fields for matching records. |
| **Count**   | Number          | Number of matches returned.  |

<Note>
  The action requests at most 1,000 matches and omits Airtable record IDs from
  each output object.
</Note>

## Troubleshooting

<AccordionGroup>
  <Accordion title="Airtable rejects the formula">
    Test it in Airtable first. Field names with spaces need braces, text needs
    quotes, and function names must follow Airtable formula syntax.
  </Accordion>
</AccordionGroup>