Looking for tips please for the best way to tackle this seemingly easy challenge:
Consider my App will have a data sheet, like the one below:
The goal is to allow the user to
- Select which attributes (top row) are of interest (1 or more)
- Select the values of those attributes to use as a filter (1 or more)
then show the count of people that match.
e.g. If I am interested in people with favorite flavor vanilla then the count is 2.
e.g. if I am interested in YOUNG people with favorite flavor vanilla then the count is 1.
A key restriction is that in reality the table of data is not based on a fixed database. Users will need to be able to work with a fresh table (in practice I will import this into the Google sheet). The layout of the table will be the same (people down the side and attributes across the top), however the number & definition of the attributes may vary considerably.
Is there a way to achieve this without formulas in the Google sheet?
I have managed the first hurdle, selecting attributes and picking which of their values are needed. But once the filters are defined, I’m getting stuck with the final count step. Is it too much for Glide since relations cannot easily be filtered without creating template columns? That doesn’t seem feasible because of the scale.
If the best option is using a Google formula, can anyone suggest the formula please?!