So I’m finding Baserow quite nice for creating tables of data, and for basic linking between tables. However, one area I’m finding almost no functionality is actually using that data outside of the context of a filtered table.
What I really want to be able to do, is create a view that shows summary data with a little more sophistication than the bottom row of a Grid view. Something akin to a “report” or “dashboard”.
For example, let’s say I have a table describing a large number of items. Each item might have a variety of “tags” assigned via a Multiple Select field, a couple of notes in a Text field, and maybe some Boolean and Number fields for good measure.
Now I want to know:
- For each Multiple Select tag, how many items are assigned to it?
- How many items have a certain keyword mentioned in their notes?
- How many items have a value in that Number field, between a certain range
- And so on, for anything you might want to write a formula for.
In other words, if I’m making any sense, I’d really like some sort of general purpose report view functionality for tables.
With a conventional database, I’d just write a handful of queries to get the information I want, and then display it.
With Baserow, I can’t think of any way to do this besides writing some out-of-band script that uses the REST API to pull things together.