Help

Linked columns in different table

Topic Labels: Sync
3011 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

Hi @Andy_Springer and welcome to the community!

Is there a data entree that is identical in both surveys (eg client name)? Maybe you could make that field in both surveys link to a 4th table with that data and then use 2 lookup fields to get that info?

Just a first thought here :man_shrugging:

Andy_Springer
5 - Automation Enthusiast
5 - Automation Enthusiast

Hey thanks for your answer!
Unfortunately no, it’s 2 different surveys for different client and made by different people so i don’t have twice the same data.
The only common data between the 2 tables is “ip address”. This is a terminology that is used in both surveys but the column’s name are not the same in both tables. I hope it’s clear!

Well, then you could make a new table with the ip address as primary field and make a linked field out of the “ip address” field (name doesn’t matter) in both survey tables. That way you could lookup/rollup all the data you need.

Andy_Springer
5 - Automation Enthusiast
5 - Automation Enthusiast

How can I put the IP address as a primary field please?
Because when I do a lookup it will not search the correct data i think as in the column IP Address it only displays “IP address” in every cells…

From 1 of your existing IP address field, you can just double click the field name and change the field type to “link to another record” and then choose “create a new table”. The data in your IP address field will now be converted to the primary (= first) field of that new table.

image

Then, do the same for the other IP address field in the other table, but instead of choosing “create a new table”, choose the new table you just made.

Thanks for your explanation. Unfortunately I don’t get the date i’m looking for when doing this.Screen Shot 2021-08-09 at 11.29.27 am

i need the NPS type from table CR1 NPS and CR2 NPS. I’ve tried to do a lookup but it didn’t work.

So “NPS type” is a field in both NPS tables?

How did you try?

Andy_Springer
5 - Automation Enthusiast
5 - Automation Enthusiast

NPS type is what i’m looking for but this is not the same column name in both tables. I think that’s why i can’t do a lookup
I’e tried to do a lookup with the NPS and it’s just giving me the wrong data in. It gives me the 1st data of 1st column of each table. The tables are linked too. CR1 NPS linked with NPS Report and CR2 NPS linked with NPS Report.

Hmm, confusing. You can have a lookup field for every linked record. You did specify the field that you want to look up, right?

image

Could you add some screenshots from what you’re trying to do?