How to use the Main column and link to other sheets

Question

I’m looking for some help in how to set this up properly.
My main table has the 1st column that is an App.
Table 1:
App1
App2
App3
I’d like to to have another table where the main 1st column is directly linked and the same as on Table 1.
App1
App2
App3
without just copying and pasting them over.
I have another Table that is “Company” that has all the data on the company that created the App1 which is simple to link via relational because the column 1.

Mohamed_Swella1 · Accepted Answer

Hi @Roland_Ligtenberg,Welcome to Airtable Community!  :slightly_smiling_face: It doesnt seem right to have 2 tables with exactly the same info in the Primary Field. In addition to that, the primary field cannot be linked to another table, the way around it is to have the link in the 2nd field and then have the primary field as a formula that reads from the this field.If you want to avoid copy paste then you have to use Zapier to make it automatic.Hope this helps. If it does, please mark it as Solution so others can see it.BR,Mo

Roland_Ligtenbe · Answer

Hi @Roland_Ligtenberg,Welcome to Airtable Community!  :slightly_smiling_face: It doesnt seem right to have 2 tables with exactly the same info in the Primary Field. In addition to that, the primary field cannot be linked to another table, the way around it is to have the link in the 2nd field and then have the primary field as a formula that reads from the this field.If you want to avoid copy paste then you have to use Zapier to make it automatic.Hope this helps. If it does, please mark it as Solution so others can see it.BR,MoThanks Mo! I guess I should get used to views/filters/hidden fields if I want it all in one big table.

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded