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

Create groups based on information from another table

Topic Labels: Base design
289 0
Showing results for 
Search instead for 
Did you mean: 


I am trying to set up a database/table where on the first page/table I have all the information set out in various columns/rows and one or two of the columns will be a group or category table.

In these groups you can choose different options, let say, A,B,C,D etc.
I then want to set up a new tables for these individual groups, 1 table per group. When you choose a group or a category for that row, I want certain cells from that row, not necessary all, to be copied into cells in the corresponding table.
So rows that are given group A will all be copied into table A etc. All updates are done in the main table and all other tables get their information from the first table.

Can this be done?

Any help will be much appreciated.

0 Replies 0