Help filtering Airtable

Hi All,

I build this flow where I am searching the exact name from an Airtable but I do not want that the Airtable returns so many data because if not Chat Gpt explodes

image

As you can see for each query Airtable brings back all the table instead of the fields I am just looking for

This is the 10 places I am looking

Can you help me?

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:

N8n Version 1.74.3
Operating System Windows
Running by cloud
Databse Airtable

Hi Camilo

Are you trying to output only the reponses (id, createdTime, Cod, kiosk…) that contains “Vasco da Gama” in the “Kiosk” field?

Hi Carlos,

I created a double IA so that the first interpretated the name the user is searching and just give back the possible names and then the second to just search this possible as an example just Vasco Da Gama isntead of cheking the other 10000 posible locations.

And Yes I only want this respond from the Airtbale that have Vasco Da Game in the field Kiosk

Have you tried adding the Airtable’s search record node after que first AI Agent and filtering it by the output value from the first Agent?

I am not sure how to apply the filter as you say. As it dosent have an option to filter

image

Use the “search”

I have tried but it dosent work. Not sure how to go around or do somethign else

Can you send the workflow and the airtable base? So I can do some testing here?

I do not find the way of sharing it to you

Hey Camilo, I did some changes to the workflow. Simplified it and instead of using airtable I transfered all the data to google sheets. There I had to remove the euro sign from all the values in ventas, removed the “.” then changed the “,” for “.”

Check your n8n, I saved it there.

Here I sent “cascais” and got the correct sum
image
image

And here’s the google sheet:
image

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.