Skip to main content

Loop through all records and perform

D

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

J
Forum|alt.badge.img+4

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

M
Forum|alt.badge.img
  • Matte_Silver
  • New Participant
  • 4 replies
  • November 9, 2021
Julian_Kirkness wrote:

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

Reply


Most helpful members this week

Terms & Conditions