Help

Formula works natively in Airtable, but does not work from a Make (Integromat) Airtable Service mod

Topic Labels: Formulas
Solved
Jump to Solution
551 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Richard_Foxwort
7 - App Architect
7 - App Architect

I am trying to build a module in Make (Integromat) that will find a single Airtable record that matches an AND + OR condition:

My formula is:

AND( {NMI}="XXXXXXXXX", OR( {Subscription status}="Active", {Subscription status}="Pending", {Subscription status}="Extend"))

If I create a dummy formula field in my Airtable  base and use this formula, it displays the value '1' (for 'True') in for the record I'm looking for, and all other records have the value '0' for False.

When I use this exact same formula in my Search Airtable module in Make, it does not return any matches

Multiple_subscriptions___Make.png

Any ideas on what could be happening here? I'm scratching my head...

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

Could the record be filtered out of the view that the scenario uses?

See Solution in Thread

2 Replies 2
kuovonne
18 - Pluto
18 - Pluto

Could the record be filtered out of the view that the scenario uses?

Richard_Foxwort
7 - App Architect
7 - App Architect

Thanks Kuovonne - this was a silly mistake that did result in the record being filtered from a view. Your answer helped me diagnose it.