I’m working on a multi-site content audit for a University and want to create a separate table for each site and then pull all of the data in to a master table so I can run reports against all of it. I’m thinking I’ll need some separate columns for different sites, but will have enough universal tha…

Hi @Shelley_Keith , No that option is not there but you can create buttons in Table X, Y and Z that create rows in the Master table. Take a look at this example -

@mallika I stumbled across this while building something similar—great tip, by the way! One issue I’ve run into is writing a formula or building the button in a way that it brings in new data added to Table X or Table Y to the Master Table without needing to delete the Master Table contents and pre…

Thanks for this. It’s an option but the overall idea is that edits should take place on the individual tables and a quick push of a button should update the overall master table. I’m pretty close with the above method, just trying to figure out why the button I have for my master table doesn’t do a…

Dear @Kristofer_Udekwu , A good method will be to share a dummy doc of your existing doc and try to explain you expected result. I would say, almost 100% of the times you will get valuable input and or solutions. This is also the way to avoid other community members guessing what could be the prob…

Thanks—I’ll work on getting a version of this that doesn’t have company/private info so I can see where things are going wrong.

Combining multiple tables into a master table (vs. breaking a master into smaller ones with queries)

Saul_MIND_Garcia September 20, 2019, 5:14pm 4

What if you make a master table and make the others views of the master table, I stumbled across this post, I think is what you are trying to do. You just have to arrange your data in a slightly different way.

Topic		Replies	Views
How to combine multiple Tables together into a single big table	6	1976	March 21, 2023
Copy column to a new table	3	1654	September 2, 2022
How to aggregate data from multiple tables- reverse filter	5	659	February 8, 2022
Combine rows from multiple tables into a single table?	22	8854	March 16, 2024
Best practices for "hybrid" master tables?	3	631	April 22, 2021

Combining multiple tables into a master table (vs. breaking a master into smaller ones with queries)

Related topics