I’d like to use Airtable Get All Records from a table, and then perform actions on each record. I assume I should be using Looping by Zapier, but it’s not clear to me how I’d configure it. Specifically, it asks me to indicate what “variable to loop”. What do I put there such that I have access to all fields of a record in subsequent steps?
Best answer
Is there a way to loop through all Airtable Records without using Code?
- Beginner
Best answer by SamB
Hi there
Specifically, it asks me to indicate what “variable to loop”. What do I put there such that I have access to all fields of a record in subsequent steps?
You’d need to select all the different fields from the Get All Records action that you want to use in the subsequent action steps. In the Values to Loop section you’d type in the field name on the left and select the corresponding Airtable field (from the Get All Records action) on the right. Then, in the actions within the loop you’d select the fields from the Looping action (the ones you defined in that Values to Loop section). This allows loops to be set up for each Airtable record and for the subsequent actions within each loop to access the field values for relevant Airtable record.
As the Get All Records action will output the records data as line items make sure you use the Create a loop from line items (Looping) action. Also, be careful not to select the preview_loop_values fields, as they are just for testing purposes to show you the values that would be passed to each loop and won't work when your Zap runs live.
You can learn more about how to set up loops here: Create a loop from line items
Hope that helps. Keep us posted on how you get on with this, happy to get if you get stuck at all!
+14- Zapier Orchestrator & Solution Partner
Hi
Depends on how many records are in the Zapier Table.
Airtable has pagination of 100 records per page.
https://airtable.com/developers/web/api/introduction
Looping by Zapier has 500 iteration limit.
+11- Community Manager
- Answer
Hi there
Specifically, it asks me to indicate what “variable to loop”. What do I put there such that I have access to all fields of a record in subsequent steps?
You’d need to select all the different fields from the Get All Records action that you want to use in the subsequent action steps. In the Values to Loop section you’d type in the field name on the left and select the corresponding Airtable field (from the Get All Records action) on the right. Then, in the actions within the loop you’d select the fields from the Looping action (the ones you defined in that Values to Loop section). This allows loops to be set up for each Airtable record and for the subsequent actions within each loop to access the field values for relevant Airtable record.
As the Get All Records action will output the records data as line items make sure you use the Create a loop from line items (Looping) action. Also, be careful not to select the preview_loop_values fields, as they are just for testing purposes to show you the values that would be passed to each loop and won't work when your Zap runs live.
You can learn more about how to set up loops here: Create a loop from line items
Hope that helps. Keep us posted on how you get on with this, happy to get if you get stuck at all!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.