I have columns in Airtable named Prompt 1 through Prompt 10, and an Iterator providing output text matching these column names. I’m using Search Record but encountering a “wrong filter condition” error. Attached is my scenario image for reference.
I want to get Data from Each Column and Save it. can anybody help me to solve this problem?
The issue is you are trying to search column prompt that does not exist you need to use the column. You said they are named Prompt 1-10.
@Mr.Make My Airtable column names are as follows:
The values in my iterator are:
I want to retrieve the data from the Airtable columns using the iterator values. For example, when the iterator outputs “Prompt 1,” I want to fetch the corresponding value from the “Prompt 1” column in Airtable.
Searching will give you the entire row of data so you will get all columns of data. Instead you can try using routes or a switch function to get the data based on the value from the iterator.
@Mr.Make Yeah, i know .
How can i use routes or switch function? Can you give any demo scenario it will be very helpfull.
Its saying when the value from your iterate is “Prompt 1” get the value from airtable Prompt1.
Since this is another question open up a new request to keep everything clean. 
@Mr.Make Sure, I have asked in new request
How can I update columns in Airtable using Iterator in Make.com
