Custom Sort from a Dynamic list in a database

Is there a way to sort a dropdown that pull from a dynamic list in the database and sort it a-z but have one or two of the choice always show at the bottom of the list?

Example:

A 1
B 2
C 3
E 5
F 6
H 8
D 4
G 7

Thanks for any help or guidance.

As i understood , you need to sort a list dynamicly yes you can. follow @AirDev tutorials.

create a Option set with two attribute, one for field name and second for yes or no. use it.

Hey @jamesfranklin, yeah that’s doable. You can sort the dropdown A–Z, then use a conditional filter or a merged list to push those few items you want at the bottom.

Basically: Do a normal search for your options (sorted A–Z). Then do another search for the ones you want at the bottom. Use “merged with” to combine them, the order of the merge controls where they appear.

I’ve set this up before works great if you just need a few exceptions to the sort.

1 Like

No, this will be workflow extensive , you can add multiple sort within a single search and the top one take priority.

Or maybe i ma not understanding the question

Yeah, you’ll need to use 2 merged searches for this.