Help

Loop through all records and perform

Topic Labels: Integrations
3742 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Dan_Fein
5 - Automation Enthusiast
5 - Automation Enthusiast

Is it possible to basically run a For loop through all records?

Say I have two tables:

One that will be populated from a form, and one that will hold some data.

For simplicity:
Let’s say Table 1 (T1) is Things
Let’s say Table 2 (T2) is Colors

For all colors in Table 1, submit X for Table 1. For instance:

For Red from T2, describe a Red Thing in T1.
For Orange from T2, describe an Orange Thing in T1.

If there exists an item in T2 that hasn’t been described in T1, make a cell in T1 show incomplete.

2 Replies 2

Hi Dan

Airtable doesn’t have any built in features for looping through records - you may want to check out Integromat for doing this. This is a very visual tool for automating and integrating web applications and can access multiple database records using criteria to select the ones you want.

Having said that, I am not quite sure what you mean with your description of your requirement - can you elaborate or show some screen shots?

Julian

I’d like to loop over all records in a table (task template) every night, evaluate the date condition using a script and then, if necessary, create a record in another table (task instance).

Now that we have automation I’d like to ask the same question:

Using either search action or script, I can pull up to 100 records at a time.
So how do I get the next page?

Cheers