Make.com search record formula problem

[thereverend]

This should be a simple fix but I'm not seeing it.

I'm doing a record search in Make.com using the Airtable Search Record module. See the attached screenshots.

I'm trying to filter out records that already exist. But I'm getting the same output regardless whether I use the NOT() function.

If I use the NOT() function I get 15 bundles output from that module. I get the same bundles without the NOT() function.

What am I doing wrong?

[TheTimeSavingCo · Accepted solution]

Hmm that looks fine.  I just tested it and it seems to work fine:

And here's the output without the NOT:

[ScottWorld]

Not sure why you're getting the same 15 records for each search.

For testing purposes, copy and paste your formula from Make.com into Airtable (but manually type in one of your Comment IDs where it says "13. id_str").

And then see how Airtable responds. The records that result in 1 in Airtable are the ones that Make will find.

You can continue tweaking your formula in Airtable to see what the problem might be.

If "Comment ID" isn't a text or a number field, that might be part of the problem.

- ScottWorld, Expert Airtable Consultant

[thereverend]

Your test works for me as well now. Seems to have solved my problem. Maybe I had an extra space somewhere. Not sure. Thank you!