Help

Re: How to use the Main column and link to other sheets

Solved
Jump to Solution
422 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Roland_Ligtenbe
4 - Data Explorer
4 - Data Explorer

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.

1 Solution

Accepted Solutions
Mohamed_Swella1
13 - Mars
13 - Mars

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

See Solution in Thread

3 Replies 3
Mohamed_Swella1
13 - Mars
13 - Mars

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

Thanks Mo! I guess I should get used to views/filters/hidden fields if I want it all in one big table.

That is definitely one of the most powerful tools of Airtable :slightly_smiling_face: you should use views as much as possible.