Airtable search formula in Make.com

How to write an Airtable search formula on Make.com?

Start with some rules

  • Use the curly bracket to reference a Field (Column) in Airtable, for example: {Order Status}

  • Do not use the Make.com equation function (the green = ), use typed =

  • Remove all unnecessary spaces

  • Put strings into brackets

Examples

Formula: {email}="[email protected]"
Formula: AND({Email}="[email protected]", DATETIME_DIFF({Date},TODAY(), "day")>=0)


If you need more complex formulas, go to — Formula Field Reference


Najlepsze szablony

Notion Kanban Board template displayed on laptop and tablet, showcasing customizable task management columns and instructions for efficient project management and workflow organization.
Competitive Analysis template in Notion, showcasing dark mode interface. Laptop screen displays Apple competitor profile with detailed SWOT analysis, categories, and key information. Created by Lucas Ostrowski, demonstrating efficient market research setup in Notion's dark theme for The Hitchhiker's Guide to Automated Systems
Notion Keyboard shortcuts & commands template by Lucas Ostrowski: Dark mode interface showcasing comprehensive shortcut grid for Mac and Windows. Features categorized commands like "Create New Page" and "Toggle Light/Dark Modes". Enhances Notion workflow efficiency across platforms. Made for Notion badge included.

Najlepsze szablony

Notion Kanban Board template displayed on laptop and tablet, showcasing customizable task management columns and instructions for efficient project management and workflow organization.
Competitive Analysis template in Notion, showcasing dark mode interface. Laptop screen displays Apple competitor profile with detailed SWOT analysis, categories, and key information. Created by Lucas Ostrowski, demonstrating efficient market research setup in Notion's dark theme for The Hitchhiker's Guide to Automated Systems
Notion Keyboard shortcuts & commands template by Lucas Ostrowski: Dark mode interface showcasing comprehensive shortcut grid for Mac and Windows. Features categorized commands like "Create New Page" and "Toggle Light/Dark Modes". Enhances Notion workflow efficiency across platforms. Made for Notion badge included.

Najlepsze szablony

Notion Kanban Board template displayed on laptop and tablet, showcasing customizable task management columns and instructions for efficient project management and workflow organization.
Competitive Analysis template in Notion, showcasing dark mode interface. Laptop screen displays Apple competitor profile with detailed SWOT analysis, categories, and key information. Created by Lucas Ostrowski, demonstrating efficient market research setup in Notion's dark theme for The Hitchhiker's Guide to Automated Systems
Notion Keyboard shortcuts & commands template by Lucas Ostrowski: Dark mode interface showcasing comprehensive shortcut grid for Mac and Windows. Features categorized commands like "Create New Page" and "Toggle Light/Dark Modes". Enhances Notion workflow efficiency across platforms. Made for Notion badge included.

Nigdy nie przegap nowych wskazówek

Bądź na bieżąco z wszystkimi wiadomościami co tydzień w newsletterze

Nigdy nie przegap nowych wskazówek

Bądź na bieżąco z wszystkimi wiadomościami co tydzień w newsletterze

Nigdy nie przegap nowych wskazówek

Bądź na bieżąco z wszystkimi wiadomościami co tydzień w newsletterze