And from this I see my info was wrong about every user getting unique filter views, as I can see brakes filtered down to Paul. I’ll dig into that a little more later and see if there’s a default ‘on load’ view.
[quote=akasnowmaaan]I admit, I kinda lose it quickly with stuff like this. Don’t take my low frustration tolerance with too much weight. It’s what makes me a good designer.
Thanks for the docs. I’ll dig in, maybe I can figure it out without too much effort.[/quote]
I was actually hoping your designer/ux chops might provide some tips on how to make it easier/friendlier to use. Fire away with any gripes and perhaps the approach to entry/sorting/display could be improved.
Naw, just edit/add stuff, and as euclid says:
But really, it’s not too much different to add than before, you might just be selecting a drop down for a category as well as typing in some details in extra columns. And gdocs has a great revision history feature, so even if someone totally fucks something up (barring ctrl-a, delete, that’s unlikely) it can be rolled back in time to before the edit easily if a few undo steps don’t fix it.
====
To add new entries to the tarckDB sheets with autofiltered tables, it can be done two ways:
- just enter data into the row immediately under the last entry of the table under the green line, then the table will auto extend to include that entry
- in the middle of the table, insert a row (alt-i, r. or Insert, Row above/Row below) and then type into that row
- For validated/dropdown cells, either start typing and select as the matching options appear, or click the dropdown and select from all the options. Or leave it blank and let someone else fix it later.
If the table doesn’t seem to be showing all the entries, look at the little icons in the header row. If one of them looks like a solid funnel, instead of an inverted triangle made of 3 horizontal lines, there’s a filter on that column that you can turn off (click the icon, click select all, click OK).
Likewise, to filter, click the inverted triangle icon, and then you can:
*sort a->z / z->a
- filter by condition (blanks/nonblanks/text contains/value in a range between x & y…)
- filter by search or manual selection