Summing amounts from all user tables

Hi, I have in the section , “data” 10 tables of users and in them are the totals of their costs. I would like to make a special “screen from data” in the application to summarize all the costs of customers. I need to have one place in the application, which will just present such a summary of the whole. I am very much asking for help and thank you !

Do all 10 tables have a similar data structure?
If yes, then the first thing you should do is combine them all into one single table, and include a column that identifies a User. This will make your task much, much, much easier.

2 Likes

Thank You so much, I am a beginner and I could ask you to describe step by step how to make such one general table? How to combine when they are similar ?
Thank you in advance !

Hello Michael Joshua, welcome to Glide :wave:

It would be helpful to anyone trying to help you if you could share screenshots:

  • of the entire builder, not bits of the screen
  • make sure to blur out or hide any sensitive information you don’t want to make public
  • Darren’s suggestion is related to your data structure, so screenshots of the data editor including the list of tables on the left would be helpful.

I think Darren’s question is asking why would you have 10 tables of users? It’s best to have the same “objects” in the same table. For instance, if your app displayed information about employees, their locations and business units, then you would have 3 tables for these 3 objects (employees, locations, business units). You would not have a table for employees in location A, another table for employees in location B and another table for employees in location C. Instead, you would have one employees table with an additional column called “location” and this column would be used to give further information about each employee in the table. Then you could create a relation between the employee and location tables.

A good place to start if you are starting out: Glide Docs

3 Likes

Good video to throw out here again.

4 Likes