Help

How to link two tables automatically?

Solved
Jump to Solution
1184 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Mayank_Agarwal
6 - Interface Innovator
6 - Interface Innovator

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
Alexey_Gusev
13 - Mars
13 - Mars

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
Alexey_Gusev
13 - Mars
13 - Mars

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!