We have a custom record type that we use in various single-select drop-downs, in particular it’s used for several Item Options on transactions. The list is mostly (but not entirely) dollar values. Over the years we keep having to add new entries, and it’s getting super annoying to find the right entries since they appear in the order they were added as opposed to any other sensible order. Anyone know how to change the order that the options appear in the drop-down select? Note that these are not child records.

your list order is what will be reflected here unfortunately.

fooo this is getting worse and worse

I'm guessing you have already, but if not, you could try changing this setting to a really small value. Then at least you get the type-ahead drop-down. It doesn't work on all drop-downs though, so unsure if it would make any difference here.

But that would affect ALL drop downs…

It would yeah. Do you have a reason you wouldn't want to do that? You can do it on a user-by-user basis of course so it's only affecting people who use this selector. Personally I hate those "old style" drop-downs where you can't easily type ahead. I have that set to like 5 in any instance I log in to.

Maybe rename the list items with a prefix and sort alphabetically? Like 'Time -' , 'Currency -', 'Dollar- ' etc. Then they are at least grouped together?

Two problems with that approach. a) numbers won’t properly sort alphabetically

Ah. Well, crud.

indeed

what about create another list type field and each records in that list (use custom record not custom list) would be your bands. In those record reference your current list values in a multi select field. Then source/filter the current field based on the new custom field values. This way when you select your band current dropdown field will only show the values selected in the band record - bit convoluted but for sure would work. Canadianweed in action eh!!

I don’t really want to create a separate field

If you use custom list then you can sort them alphabetically, but lists are not flexible in other way

Yeah, we unfortunately use this custom record for things where we need more than just a name.

Messy but... Hide the "real" field in any editable view. User Event before load adds a custom list field. Perform search on custom records, order the results anyway you like, assign the values to the list in the order you want them. UE before submit captures cutspage_field value and sets it on the "Real" field.

I wouldn’t even know how to do that in the Set Options popup…