Merge Two Columns from different tables into one Column in another Table
Hello,
I have two tables in single Base containing names of different people.
For e.g. in table A, I have a column having names of people (120 entries). I also have another table with column having names of people(50 entries).
I want to automatically merge all these 170 entries into another table column and this should keep syncing.
Any idea how can I achieve probably using formula or integromat?
Adam from Airtable here. Welcome to the community.
There are many ways to approach this (Automations, Sync, etc.). In this case, I think a combination of a formula field, linked record field, and lookup field (or rollup, depending on your specific workflow) can accomplish what you are looking for.
Adam from Airtable here. Welcome to the community.
There are many ways to approach this (Automations, Sync, etc.). In this case, I think a combination of a formula field, linked record field, and lookup field (or rollup, depending on your specific workflow) can accomplish what you are looking for.
Airtable operates a bit differently than traditional spreadsheet software like Google Sheets or Excel. In this case, our Automations feature might be the better route. I will say though, that your setup may be a sign of less-than-ideal base design within Airtable. More here…
Airtable operates a bit differently than traditional spreadsheet software like Google Sheets or Excel. In this case, our Automations feature might be the better route. I will say though, that your setup may be a sign of less-than-ideal base design within Airtable. More here…