Help

Re: Linked columns in different table

3003 3
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

Screen Shot 2021-08-17 at 2.48.01 pm
Screen Shot 2021-08-17 at 2.48.15 pm

So I have the attached NPS.
“NPS type” column is from CR1 Survey table.
“on a sclae” column is from CR2 Survey table.
I need both of these columns to be showed in a new table.
There is no common field in both tables.

That seems complicated.

Hmm, didn’t you say that the IP address was a field on both surveys? If that’s the case, I’m still sticking with my previous answer: make that a linked field to a new table from both surveys and rollup the 2 fields you need.

Andy_Springer
5 - Automation Enthusiast
5 - Automation Enthusiast

I’ve done this but I still don’t get the good data in CR1 NPS and CR2 NPS columns in the new table.
Please see enclosed.
I needScreen Shot 2021-08-18 at 11.21.31 am
Screen Shot 2021-08-18 at 10.22.46 am
Screen Shot 2021-08-18 at 10.22.39 am
to get the columns that i’ve attached earlier saying “promoter, passive”.

I see from your screenshots that you haven’t added any lookup fields?

Andy_Springer
5 - Automation Enthusiast
5 - Automation Enthusiast

When i create a lookup it shows the data in the same cells. I need them to appear in column in the new table: 1 column CR1 NPS and 1 column CR2 NPS.Screen Shot 2021-08-19 at 9.38.17 am

Then you should add your lookup fields in the other table :slightly_smiling_face:

I don’t understand from which table we’re talking right now.
These are the options i get within CR2 NPS table for example
And my other table with the lookup is named ‘test’, i don’t have it in the dropdown menu

Screen Shot 2021-08-24 at 4.17.12 pm

This is getting really confusing with table and field names… If you could share a view link, that would help a lot.

Andy_Springer
5 - Automation Enthusiast
5 - Automation Enthusiast

No worries!

Let me know if the link works

thanks!

OK, let’s give this another go :slightly_smiling_face:

In your table “CR1 NPS”, double click on your field “IPAddress” and choose “link to another record” as field type. Then select “create a new table”. That way, a new table will be created, with the mentioned IP Addresses being in the primary field.

In your table "CR2 NPS, do the same with your field “IP Address”. Don’t select “create a new table”, but select the newly created table from the step above. These IP Addresses will now also show up in the primary field of that new table.

In that new table, you can then add 2 lookup fields, one referring to the “NPS Type” field in “CR1 NPS” and one to ?? in “CR2 NPS”.

That way, in your new table, you’ll have the IP Address and the 2 data types you want to see in 1 record.

The problem here is that you’ve made your own (single) record in a new table and then linked every other record to it, instead of using the actual IP as a primary field.