I’ve gotten halfway with a simple scenario - now trying to learn how to get an array of data that’s been parsed with Iterator in to Airtable records.
I’ve got a HTTP request that gets data, and it is being parsed with Iterator. When adding a “Update Airtable Records”, it is asking for the Record ID.
When using the search option by the Record ID, I can’t see how to use variables from the Iterator in the search.
Am I doing this the wrong way?
You’ll have to use the Airtable “Search” module before you can map the record ID from the search into that field.
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: Did you know, the concepts of about 70% of questions asked on this forum are already covered in the Make Academy. Investing some effort into it will save you lots of time and frustration using Make later!
Thanks @samliew ! Added a Airtable Search step, and I’m not understanding the formula. I added this as a search step:
But when running it, I get a 422 Error that is telling me that my search formula isn’t correct.
Sorry, I can’t help with Airtable formulas.
I’m guessing you might need to wrap the text in double quotes, and remove the spaces around the equal operator, or type in the field name, or map a correct variable instead of “Team” - which has a background but no module number.
Please refer to the Airtable official documentation for more information on formulas.
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
Hi @Hal_Atkins I can help you with the formula.
you need to wrap the columns name in { } and the key word you are searching in ’ ’
So you need to do {Team} = ‘4.teamName:default’
Team is your column name
Default is the value you are searching for.
