Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Populate a column from a cell from another table

173 0
Showing results for 
Search instead for 
Did you mean: 

Hi everyone, I know it’s probably a silly question but here I go.
Table 1 ‘Classes’ has ‘Class name’ in col1 and ‘Enrolled Students’ in Col2. (All the enrolled students are listed into 1 cell and automatically populated from the Students table where we indicate which class they’re enrolled in).

| ACTING CLASS | [Liam] [Fred] [Emily] [Ann] |

So far so good.

How do I create a new table for each class where the first column (or second column, doesn’t matter) displays automatically the names of the students enrolled on that class such as:

|Col 1|

Thanks guys.

0 Replies 0