I need to build reports that have many views into a single table so I’ve adopted a method I saw on this post, Trouble with Pivot Table. I’d like to extend this by having an enable/disable boolean for filters. Since we can’t use a field from the filters table on a view pointed to our projects table, we’ve resorted to using the “id” field in our projects table and creating a formula in our filters table that toggles between 0 and 1,000,000. See picture for logic; however, since we can’t create more complicated logic for filters I’m not even sure it would work with multiple toggleable filters.
I’ve been exploring other ways to do this including creating webhooks for more complicated logic but I’m trying not to tie in another service we need to use. Has anyone had success with other methods creating complex reporting with multiple views and filtering of some sort?
