This seems like there must be a way to do this, as powerful as Coda is, but I’m only a few days into working with it so maybe I just don’t know how.
What I want is, I think, what this person was asking How to sort Select Items? but the answer given doesn’t seem to really solve it, and the thread ends there.
I have a column that is a dropdown select. I made my own custom list of options, and I can drag-and-drop these items to customize the order that they appear in the dropdown, which is great.
But when I order my table by that column, my only options are to order it alphabetically either ascending or descending. I’d like to order it by the custom order I assigned for the options.
Anybody have any insight on this? I feel like surely I can’t be the first person to try to accomplish this…
I think the person that replied on the original thread I mentioned may have misunderstood the question that person was asking. Either that or I am. But their answer explains how to customize the order of the OPTIONS in the list when you are picking the option for a row. I want to know how to sort the rows by that column, not alphabetically by the first letter of the options selected, but in the custom order I have assigned to those options.
Basically, I’d expect to see a third option in the Direction dropdown, which would be Select Order or Table Order (based on if your column is a Select or a Lookup into another table).
Have you found any reasonable way in the meantime? This seems like a very basic functionality that is lacking, I’m honestly baffled at the amount of hoops one needs to go through to achieve something so simple
