I tend to use entity relations instead of single-select fields (because i cannot figure out how to use them in formulas). For instance, i want to assign priorities to Tasks and i do that with a one-to-many Priority-to-Contact relation, which works well, albeit a bit cumbersome to use in formulas wit…

For completeness, here is a link to the announcement where relation sorts were added [image] April 13, 2023 / Nested filters and color coding, relation sorts Changelog nesting_dolls Nested filter groups [filters-groups] Previously, you had to choose whether al…

[image] Mikkling: i cannot figure out how to use them in formulas Perhaps we can help you. What would you ideally want to achieve?

I would like there to be an way to implement a categorization field for entities in DB that is easy to reference in a formula. I mean, the categories should be formula-accessible as Category.Name or Category[index]. Also, they should appear in logical order in the selection drop-down list, rather th…

Select fields act like types, so if you want to reference them in a formula, you need to reference a field, like Name. If I have a database called DB, with a select field called Select, then in a formula, I can get the chosen Select for a given DB entity using the formula Select.Name And when you…

Sorry if i was unclear! The issue of logical order does not concern single-select fields. Say i have an Ideas DB and a Category DB with a many-to-one relation. When i manually select a Category for an Idea, the drop-down list is in alphabetical order. I would like them appear in the logical order i…

Coming back around to say this recommendation is genius. I hope we get this feature soon

I think the best solution would be to have somewhere to define, for each DB, how its entities should be sorted in relation-field pick-lists. The most obvious choices are: by Name alphabetically by internal Rank (as manually ordered in a List view) by Fibery Magic™

[image] Matt_Blais: I think the best solution would be to have somewhere to define, for each DB, how its entities should be sorted in relation-field pick-lists. Today we found out that this is also exactly what we need :sweat_smile: We have a similar situation for a ‘lead status list’; neede…

Sort and Filter in relations is in progress, stay tuned, it will be released in few weeks https://the.fibery.io/@public/Public_Roadmap/Roadmap_Item/Filter-and-sort-in-relation-Field-selector-169

Sort Entity drop-down lists by public ID?

Ideas & Features

Matt_Blais February 10, 2022, 3:48pm 2

Perhaps we could get the hidden “Rank” field promoted to “non-hidden”, so that it could be used in Sorting views?

Topic		Replies	Views
Default Sort per Db as config option Ideas & Features	15	96	May 3, 2025
Sort in Smart folder Get Help	3	153	April 5, 2024
How do I sort a form field created by a relation? Get Help	4	69	January 21, 2025
Sort and filter on the Lookup field Get Help	6	462	September 5, 2025
Sort a form field Ideas & Features form-view	2	63	April 16, 2026

Sort Entity drop-down lists by public ID?

Related topics