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

[Richard_Foxwort]

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

 

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

[kuovonne · Accepted solution]

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

[Richard_Foxwort]

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