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?
+18Hello @Pratik_Shah,
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.
Here’s a short video of what you might consider in setting this up in your base: Screen Recording 2021-05-05...
Cheers~~
Hello @Pratik_Shah,
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.
Here’s a short video of what you might consider in setting this up in your base: Screen Recording 2021-05-05...
Cheers~~
@Adam_Minich Thank you for reply and taking your time for video.
I guess I missed to explain my query.
You can see screenshot below of what I want to achieve.
This can be achievable in google sheet using formula.
Can you please help if I can achieve this in Airtable?
I want this merge column to automatically keep updating.
+18Hey @Pratik_Shah,
You’re welcome. Thanks for the clarification.
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…
Link to delay automation article: Delay an automation from running – Airtable Support
Hey @Pratik_Shah,
You’re welcome. Thanks for the clarification.
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…
Link to delay automation article: Delay an automation from running – Airtable Support
@Adam That’s great. Thank you so much. I will try and will let you know
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
