I have a use case where on my Inks page, I would like to see which bottled inks I haven’t used recently. So if I sort by last usage, then by type, it forgets I ever sorted by last usage and show the list only sorted by type. Same case if I want to sort by color, and then by type.
Adding a filter to the tables, or teaching to recognise multiple sort criterias would solve this problem. Sometimes I just want to fill from my bottles and not my samples.
My attempted workaround is to Export the data out into the CSV. When exported, the CSV file looks like this when opened in Excel.
I workaround this by importing it in Google Sheets, which somehow reads the CSV format in a different way and shows it correctly. But them, the “Last Usage” date is not exported. And of course the color sorts but doesn’t visualise properly.
Just realised that a request for filters have been posted before. This one does address one other feature request “multiple sort”, an issue with the CSV format, and a missing column in the export though.
yeah the missing columns in the export are a bummer. That shouldn’t happen. I will have a look at at that. And Excel should be able to let you configure the columns separator, but I guess it’s a moot point if the data is missing.
I’ll add the multi-sort / search by column etc. to the backlog (again). That definitely is a big missing feature, too.
Thanks so much! I can now treat some older bottles that haven’t been used in a while with more fairness hahahahah. Must love all my children (somewhat) fairly.
Btw I figured out the column separator thing - I just search delimiter in Excel actions and now I can stick to Excel for a quick sort instead of firing up Google Sheets. Quick enough.