I’m loving Coda but holy freaking chia seeds the filters are making me want to throw my computer across the room! This just should not be so hard. No new basic user should be required to learn the whole other language of formulas just to do a simple filter. My email program and Airtable handle this WAY better! I’ve looked at all the tutorials I can find and I’m still not getting it, nor do I want to keep trying.
Basically I want to see filters work the way the drop down column options do. There should be self-similarity between the way I format a column and the way I set a filter that references the column. As it is now the column options are pretty clear with a cute visual icon and simple description, but as soon as I go to filter it all goes to poop and it’s like I’m expected to know code.
I want to see a filter/formula broken down into sections (maybe with each section having its own drop down with relevant options that dynamically update as you select options). I want the filter to basically read like a sentence I would speak that communicates what I want the filter to do, not this oddly arranged filter-speak code stuff. I also want better tooltip-like descriptions for each of these sections so I can quickly understand what’s happening.
Such an overhaul would also change the way conditional formatting works (for the better).
Another frustration I just encountered as an extension of how things are currently set up is that while I finally figured out how to filter a calendar view of events to only show those that are labeled “day” or “week”, I cannot just toggle these on/off to switch between them. I shouldn’t need to create a whole other view either. But since the filter for this is a string of “filter-code”… thisRow.[Event Type].Contains(“day”, “week”)… you have to edit this nonsense instead of just clicking a toggle button to say “hey, I now just want to just see the day long events or week long events”.