Thanks Tim. So in your screenshot there are 12 records total matching the current filter, right – but just ten records displayed per page? And if there were 1200 records matching the current filter, that gray box you outlined would say “1200 Records” right?
If so, that solves one important problem.
But then there are the other problems involving calculations like totals by group and totals of some other value like a “Price” field.
For example, say I built a Tadabase app that a company was going to use to track sales. In the SALES table, there’d probably be fields like Date Sold, Product, and Price, and a connected field for Rep (the name of the company rep who gets credit for the sale). I’d want to be able to do monthly or quarterly reports that showed sales within the specified time range, grouped by Rep, and I’d want to get two total values – COUNT (number of sales made in that quarter by the rep) and TOTAL of the Price field by rep. And of course, I’d want a grand total for each of these values at the top and bottom of the report.
Am I to understand that, at the moment, there’s no way to do that in Tadabase? What about if the perspective were moved to another table, like say, Reps?