Help

Make.com search record formula problem

Topic Labels: Formulas
Solved
Jump to Solution
316 3
cancel
Showing results for 
Search instead for 
Did you mean: 
thereverend
4 - Data Explorer
4 - Data Explorer

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?

Screenshot 2024-10-16 at 6.41.21 PM.pngScreenshot 2024-10-16 at 6.41.31 PM.png

 

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

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

Screenshot 2024-10-17 at 10.07.46 AM.png
Screenshot 2024-10-17 at 10.08.20 AM.png

And here's the output without the NOT:

Screenshot 2024-10-17 at 10.09.15 AM.png

See Solution in Thread

3 Replies 3
TheTimeSavingCo
18 - Pluto
18 - Pluto

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

Screenshot 2024-10-17 at 10.07.46 AM.png
Screenshot 2024-10-17 at 10.08.20 AM.png

And here's the output without the NOT:

Screenshot 2024-10-17 at 10.09.15 AM.png

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

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!