Help

create a table "summary results" of the base

Topic Labels: Data Formulas
634 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Savin_Perrine
4 - Data Explorer
4 - Data Explorer

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 ... ) 

1 Reply 1

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