I have 2 tables each have one common column i.e website. How can I generate 3rd table which will be intersection of table 1 and table 2?
Note: I am using airtable free plan
Solved
Intersection of two tables?
+3Best answer by Matthew_Lanni
If you go ahead and make a third table, you can then turn your website fields into linked fields and link them to the third table.
That should do what you want, though I'm unsure about free plan limitations in this area.
+18If you go ahead and make a third table, you can then turn your website fields into linked fields and link them to the third table.
That should do what you want, though I'm unsure about free plan limitations in this area.
+3If you go ahead and make a third table, you can then turn your website fields into linked fields and link them to the third table.
That should do what you want, though I'm unsure about free plan limitations in this area.
Is there any way to move records from table A to table B with one click?
Currently I have to select all records and then Ctrl+C + Ctrl V to new table. Instead can I just group and filter records and then move in single click?
+18Is there any way to move records from table A to table B with one click?
Currently I have to select all records and then Ctrl+C + Ctrl V to new table. Instead can I just group and filter records and then move in single click?
If you turn your website fields into linked fields, that should auto-populate your third table with data without you having to move anything manually.
Here's an example base: https://airtable.com/shrM1Q8ApOCxWyzDL
If you want to see additional info from tables 1 and 2 within table 3, you'll need to use lookup fields.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.