Can I get some help with this please?
None of these are working. Even in your embedded example, it’s not ordered numerically.
I want it to number rows by visual order, regardless of grouping or sorting; instead, I’m just getting a ‘visual’ ordering as if it was ungrouped; this is not what I want, it’s random and wrong and I don’t want to have to manually order every item in the list for it to work correctly. That’s the whole point of grouping and sorting.
I can’t autosort without grouping, either, because the groups are in a custom order, and are not alphabetic. So I don’t know how to do this except numbering them manually, which I do not want to do.
And on top of that, it wouldn’t fix the issue where it will auto order on a referencing table. (Table A is messed up when ungrouped and unsorted; when table B references that table, and I tell it to sort by how it’s ordered, it’s doing it by the messed up sorting which is stupid and unintuitive. It should read how it’s actually sorted/grouped, right?)
So I have [table 1] which is grouped by [Categories] B, A, C, and should have numbered [items] 1, 2, 3, 4, 5, 6… Their row ID’s aren’t ordered correctly, and I expect them to be moved/changed/added to/etc. Since I added half of them while grouped, their actual ordering without groups is something like 7, 8, 2… so their calculated ‘visual order’ ends up like that, not numerical based on how the rows are grouped and sorted.
Table 2 references [Items], and groups/categorizes other things based on it, and because [table 1]'s ‘visual’ order is wrong without grouping, it gets the [items] order wrong when grouping by them.
…it’s also annoying that I can’t change the select items’ names without having to reselect them. Is there a way to do this? I’m looking for Airtable’s functionality here. I’d rather not have 3 tables for each type of relation.