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
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 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?
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
And here’s the google sheet:
