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...