What I’m trying to do
Using DB Folder, I have everything set up the way I want. The only problem is, I use a color emoji system to “rank” certain things (think of a habit tracker that’s a 0-5 scale instead of a yes/no).
The problem is the entries in the dropdown do not appear in the same order I’ve set them. The order should be ![]()
![]()
![]()
![]()
![]()
, but they show up in the dropdown in a different order (and not always in the same different order.
I’ve tried deleting and re-creating the options, but that didn’t change anything. I suspected there was some kind of auto-sorting going on, but the displayed order is not in alphabetical order either…(white, red, blue, orange, yellow, green).
Any ideas?
Programmed:

Displayed:
