Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

filterByFormula with OR nested inside AND

Topic Labels: API
2225 1
cancel
Showing results for 
Search instead for 
Did you mean: 

I’m attempting to find a list of specific records that also meet other criteria, such as a date—however nothing is returned.

AND( IS_BEFORE({Start Date},TODAY()), OR(RECORD_ID()=‘recyZ1f0RSR1rTr3Z’,RECORD_ID()=‘recIFWsWuTPjAkxhg’))

Is it possible to nest a OR inside an AND? Is there another way I’m not thinking of?

AND( TRUE(), OR( TRUE(), FALSE(), FALSE() ))

1 Reply 1

Soooooo, yeah. This works totally and completely fine. Assuming you have records that match :slightly_smiling_face:

I needed to swap the order of the IS_BEFORE parameters because I was wanted to ask, “is TODAY() before {Start Date}”, not the other way around.