Help

Lookup field integration

726 8
cancel
Showing results for 
Search instead for 
Did you mean: 
K21
4 - Data Explorer
4 - Data Explorer

Hello

I would like to know if there is a possibility to add lookup field data from two different tables to a third table and have them appear in the same column? 

 

K21_0-1726660116002.png

Thanks in advance!

8 Replies 8

Hello,

not to my knowledge, but you can add a formula field to concatenate these 2 fields:

Pascal_Gallais_0-1726662813146.png

Last field in this table is a formula:

Pascal_Gallais_1-1726662856059.png

Regards,

Pascal

K21
4 - Data Explorer
4 - Data Explorer

Hello

Thanks for the reply. Your solution does not actually fit my needs. In my case I have tasks from different tables that I would like to conclude into one so called ''master table''. Any ideas how that would work in Airtable?

Regards!

Sorry,

I must be missing something. having the 2 lookup fields coming from the same table or from 2 different tables does not change the way you can concatenate them into the same field.

That's where I must be misundersanding something.

Regards,

Pascal

K21
4 - Data Explorer
4 - Data Explorer

My goal would be to have the different tasks in the same column, but not in the same field. I would like the two tasks to appear in different rows. Any ideas how to accomplish that?

Hello,

I guess that you would need to setup an automation to create 2 records in your "master table" with information coming from the 2 tables.

Question 1 is what event triggers the automation.

Question 2 is what information do you rely on to find the records in table 1 and 2 that have to be inserted in the "master table".

Regards,

Pascal

K21
4 - Data Explorer
4 - Data Explorer

Hello

Thanks for the insight. 

For me the trigger can be time related. 

Does this automation look correct? It doesn't give me any errors if I test it, but the result doesn't look right either... I don't know if it's relevant, but the records from table 1 are linked to Miro. Does it change anything? 

K21_0-1726822882535.png 

This is how it looks like in Mastertable

K21_4-1726823034727.png

Regards

 

 

 

 

 

 

Hello,

To understand how it works, I need to see how the 2 find records and the create record action are set up.

Regards,

Pascal

K21
4 - Data Explorer
4 - Data Explorer

Hello

I am not completely sure, but are these the steps that you are looking for?

K21_1-1727076347288.png

K21_2-1727076440106.png

K21_3-1727076492646.png

 

K21_0-1727076304781.png

 

Thanks in advance!