Help

Linked columns in different table

Topic Labels: Sync
2850 21
cancel
Showing results for 
Search instead for 
Did you mean: 
Andy_Springer
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi,
I’ve created an Airtable with 3 different tables.
-1 table for survey 1
-1 table for survey 2
-1 table to summarise both surveys

In my “summary” table I need to get data from 1 column in survey 1 and from 1 column in survey 2. I’ve tried lookup and link record but couldn’t manage to do it.

The surveys tables are made of copy/paste data from CSV files that I update when i need by doing more copy/paste.
Columns name and order in both surveys table are different.

Do you have any ideas on how I can manage this?

Many thanks for your help1

21 Replies 21
Andy_Springer
5 - Automation Enthusiast
5 - Automation Enthusiast

thanks for the explanations :slightly_smiling_face: I think we’re getting there.
My only problem now is that I need to get 1 data per row, not everything in the same cell.Screen Shot 2021-09-06 at 10.26.25 am

Andy_Springer
5 - Automation Enthusiast
5 - Automation Enthusiast

I’ve found the way to do it!
Thanks for your help all the way! really appreciate it