
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 10, 2023 05:02 AM
Hello,
I would like create a table with summary results of all the base.
For exemple, for a base with different tables like :
1 - Suppliers
2 - Products
3 - Customers
4 - Sales
I would like have in a table (to use in a app built with softr) global datas like :
- the number of records in the supplier's table or of customers
- the average turnover
- the total average
...
How can i do that ?
Thanks 😃
(I know it is possible with blocks "extensions" but it is not possible to have datas blocks in softr ... )
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 10, 2023 05:07 PM
If I were you I'd create a new table with a single record, and link all of the records from the other tables to that one record. After that, I'd use rollups / lookups / formula fields to get the data I want (averages etc), and then display those formula fields in the other app
