Dropdown order of References?

Grist Feedback
1

I find it very confusing that there is no way to lock the order of a reference field.

Everytime you open it, it is a little different based on the previous choice… and sometimes it doesnt appear to be alphabetical at all.

What is the order here for example? It’s not alphabetical as Muito Baixo is before Alto.
image

Anyway, there should be some options when creating a reference

KEEP LIST SAME (so even if there is already an item selected, it doesn´t go to the top when you click the dropdown again)

Order by Column. So you can choose any column of the table where you got the reference column, including the reference column itself, as a source of ordering, up or down.

Thus there would be no need to add numbers in the reference to follow an order.

2 Likes
2

Btw, when selecting references, you don´t always want to allow creating new ones if user starts typing something that doesn´t exists.

Would be really great if we could LOCK this. When doing so, the reference field could maybe show an icon kind of a blend between reference and Options (dropdown)

1 Like
3

Also, when the dropdown is numeric, it is sorted alphabétically. For example, if I have the value from 1 to 50, it will be 1,10,11,12,…,2,20,21,22 …,3, 30,31… There should be a way to specific to sort numerically.

3 Likes
4

Great ideas for improving the reference dropdown! :tada:

1 Like