# Sort Entity drop-down lists by public ID?

**URL:** <https://community.fibery.io/t/sort-entity-drop-down-lists-by-public-id/2526>\
**Category:** Ideas & Features\
**Created:** [February 10, 2022, 2:29pm UTC](https://community.fibery.io/t/sort-entity-drop-down-lists-by-public-id/2526 "2022-02-10T14:29:30Z")\
**Posts on this page:** 1\
**Showing post:** 5

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [February 11, 2022, 2:30pm UTC](https://community.fibery.io/t/sort-entity-drop-down-lists-by-public-id/2526/5 "2022-02-11T14:30:26Z")

</div>

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 say

> [@Mikkling](#):
>
> they should appear in logical order in the selection drop-down list

then it should be the case that the possible options for select drop-down are returned in the order in which they have been configured (not alphabetical order).  
 ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/1/1b815c87a8d84222a3946bd04d7ac6199cae44df.png)

You can rearrange the order using the ‘handle’ → ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/f/f61984bf4d59999adf39840f2f8b2f3aa796f722.png)

> [@Mikkling](#):
>
> Say i have an if() automation for Contacts that should return the single-select field value “Tier 1” on true and “Tier 2” on false, how do i reference them in the formula?

I’m not sure I understand what you’re trying to achieve here. Do you mean that you want to be able to set the value of a select field using an automation?  
If so, then you’ll want to read this:

> [@Button formula: How to update a single-select field](https://community.fibery.io/t/button-formula-how-to-update-a-single-select-field/2193/11):
>
> A good way to visualise it (literally) is to actually open a single-select value (alt-click on its name) and you will see all its properties (colour, icon and linked entities). Try it slight_smile

---

_[View the full topic](https://community.fibery.io/t/sort-entity-drop-down-lists-by-public-id/2526)._