Formula ignored in “Search Records” module (Airtable)

How To
1

In my Make scenario, I’m using the “Airtable – Search Records” module to find a specific record based on the column ListID - Onboarding Ads.

I enter a valid Airtable formula in the Formula field, for example:

{ListID - Onboarding Ads} = "901511418675"

Despite the correct formula, the module returns all records in the table, as if no filter is being applied. The condition is clearly being ignored.

:magnifying_glass_tilted_left: The following has been checked and tested:

  • The module in use is definitely the “Search Records” module (not “List Records”).
  • The formula was tested with both hardcoded values and dynamic placeholders (e.g., {{7.list.id}}).
  • The formula syntax follows official Airtable standards.
  • The value "901511418675" exists only once in the table.
  • The field ListID - Onboarding Ads is a plain text field (not linked, not multi-select).
  • No View is selected in the module configuration.
  • Max Records is set to 1.
  • The module was deleted and recreated from scratch.
  • The same behavior persists: all records are returned, regardless of the formula.

image
image1644×670 86 KB

image
image1372×723 98.6 KB

image
image1392×472 71.5 KB

image
image424×700 8.12 KB

2

Hey @m_m - are you sure the Airtable module is returning all records?

From your screenshots, it looks like the Airtable module (and all modules after it) ran 5 times which would be consistent with the ClickUp module before it finding 5 tasks.

So for each task found in ClickUp, the Airtable search module runs once (for 5 tasks it runs 5 times total = 5 “operations”), but each operation should be retrieving only one record (for the ClickUp task it’s currently processing).

If that’s not what’s happening, can you expand the Operations 1-5 from your last screenshot and show what happens in there?

–
Cheers,
Sierra

1 Like