[URGENT HELP] Error 422 in Make.com + Airtable – “Invalid Formula” in Search Records even with correct fields
📌 The problem
I'm constantly getting this error:
pgsql
CopiarEditar
RuntimeError [422] The formula for filtering records is invalid: Invalid formula. Please check your formula text.
Even though all the Airtable field names are correct, Make.com keeps rejecting the formula.
🧩 Airtable Table Details:
-
Table Name:
Table 1 -
Fields:
-
Nome do Cliente(Single line text) -
Produto -
Qtd -
Valor do produto -
Valor Total -
Data da Entrega✅ Confirmed: Date with time format
-
❌ Formulas tested (all returned 422 errors in Make):
plaintext
CopiarEditar
AND( {Nome do Cliente} != "", IS_AFTER({Data da Entrega}, DATEADD(TODAY(), -5, 'days')) )
Also tried with IS_BEFORE, simplified formulas, and also using "ok" in a formula field with static text — still getting the error.
✅ Formula that worked in a previous database:
plaintext
CopiarEditar
AND( {Cliente} != "", IS_AFTER({Entrega}, DATEADD(TODAY(), -30, 'days')) )
But this time the fields are different (Nome do Cliente and Data da Entrega), and the same logic doesn't work.
📎 Notes:
-
Field names are 100% correct (copied directly from Airtable).
-
The date field is properly formatted with date and time.
-
Formula works perfectly inside Airtable, just not in the Make.com “Search Records” module.
-
Tried escaping quotes, pasting from Notepad, switching fields — still fails.
❓What I need:
-
Help from someone who successfully used a formula with DATEADD and IS_AFTER/IS_BEFORE in Make.com.
-
A known working example of a filter formula with Airtable dates.
-
Any trick to avoid silent formatting issues or “invisible character” errors in formulas.
