Hello, I’m new to Coda.io and still learning how to use the platform. I’d like to know if it’s possible to merge two tables into one using formulas.
For example, I have two employee tables, both with the same columns: Name, Position, and Department. My goal is to create a third table that combines the data from these two but only displays two columns: Name and Company.
Name Column: To show the person’s name.
Company Column: To indicate which company they belong to.
It would be similar to a MERGE TABLE function in other tools.
Is this possible in Coda.io? If so, could you guide me on how to achieve it?
HI @Jhorman,
Welcome to Coda, and welcome to the community!
What you are asking is possible, but cumbersome.
The recommended approach would be to have a single table, and then split the information into different views.
3 Likes
Hello @Jhorman
You can use the Merge Table Pack or Formula Tables Pack for a more dynamic solution. However, if you simply want to copy data from two tables into one, you can achieve this using formulas and a button.
Best Regards,
Arnhold
2 Likes
Hi @Jhorman ,
I’m assuming you don’t necessarily want to copy the data, hence having it duplicated, but to be able to visualize in a single view data from different tables.
This can be achieived in many ways using ‘Relations’ in Coda, please take a look at this link and if you still have questions, don’t hesitate to follow up on this thread: Connect tables with relation columns | Coda Help Center
Hope this helps,
Pablo
2 Likes