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}="luke@skywalker.com"
Formula: AND({Email}="luke@skywalker.com", DATETIME_DIFF({Date},TODAY(), "day")>=0)


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


Najlepsze szablony

The Money OS Notion template displayed on two MacBook laptops against a dark, professional backdrop. Left screen shows sophisticated financial analytics with multiple line graphs tracking income and expenses over time. Right screen demonstrates the dark-mode interface with navigation icons and current month financial tracking. 'Made for Notion' badge in top-left corner emphasizes native integration. Stylish product visualization highlighting The Money OS's comprehensive financial management and analysis capabilities in a modern, premium presentation.
Advanced KPIs Tracker Notion template: Dark-mode interface with KPI dashboard, progress bars, and performance chart on laptop screen. Made for Notion."
Simple KPIs Tracker Notion template in dark mode on laptop screen. Dashboard displays three KPI cards with progress bars, targets, and current values. Clean interface for efficient performance tracking, ideal for startups and small businesses using Notion.

Najlepsze szablony

The Money OS Notion template displayed on two MacBook laptops against a dark, professional backdrop. Left screen shows sophisticated financial analytics with multiple line graphs tracking income and expenses over time. Right screen demonstrates the dark-mode interface with navigation icons and current month financial tracking. 'Made for Notion' badge in top-left corner emphasizes native integration. Stylish product visualization highlighting The Money OS's comprehensive financial management and analysis capabilities in a modern, premium presentation.
Advanced KPIs Tracker Notion template: Dark-mode interface with KPI dashboard, progress bars, and performance chart on laptop screen. Made for Notion."
Simple KPIs Tracker Notion template in dark mode on laptop screen. Dashboard displays three KPI cards with progress bars, targets, and current values. Clean interface for efficient performance tracking, ideal for startups and small businesses using Notion.

Najlepsze szablony

The Money OS Notion template displayed on two MacBook laptops against a dark, professional backdrop. Left screen shows sophisticated financial analytics with multiple line graphs tracking income and expenses over time. Right screen demonstrates the dark-mode interface with navigation icons and current month financial tracking. 'Made for Notion' badge in top-left corner emphasizes native integration. Stylish product visualization highlighting The Money OS's comprehensive financial management and analysis capabilities in a modern, premium presentation.
Advanced KPIs Tracker Notion template: Dark-mode interface with KPI dashboard, progress bars, and performance chart on laptop screen. Made for Notion."
Simple KPIs Tracker Notion template in dark mode on laptop screen. Dashboard displays three KPI cards with progress bars, targets, and current values. Clean interface for efficient performance tracking, ideal for startups and small businesses using Notion.

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