Skip to main content
Solved

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

  • March 27, 2023
  • 2 replies
  • 23 views
R
Forum|alt.badge.img+13

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

Best answer by kuovonne

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

2 replies

kuovonne
Forum|alt.badge.img+29
  • kuovonne
  • Brainy
  • 6009 replies
  • Answer
  • March 27, 2023

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

R
Forum|alt.badge.img+13
  • Richard_Foxwort
  • Author
  • Known Participant
  • 45 replies
  • March 29, 2023

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


Terms & ConditionsAccessibility statement