Help

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

How to link two tables automatically?

Solved
Jump to Solution
359 2
cancel
Showing results for 
Search instead for 
Did you mean: 

So I have a base with 2 tables - one containing the funding round details (FRD) which includes name of Startup, amount and investor

And another table solely for investors - which I wish to import data from Investors column in FRD table.
Now, the investor in FRD is input as a long text which is comma separated.

I wanted the Investor table to automatically import this data from investor column - and import it into separate rows - with startup name on the side.

I know something like linked record exists, but even there I have to manually select the investor - whereas I simply copy and paste data from the net, thats why I want the investor column data to automatically be imported in the other table.

How can I make it happen? Sharing link for sample base for your reference, please guide.

1 Solution

Accepted Solutions

Hi,

add new field in FRD, choose type ‘Link to another record’
copy-paste investor column in it.
now switch to other table

See Solution in Thread

2 Replies 2

Hi,

add new field in FRD, choose type ‘Link to another record’
copy-paste investor column in it.
now switch to other table

Thanks for the help Alexey!