# Public ID's numbering should go in order of entity creation

**URL:** <https://community.fibery.io/t/public-ids-numbering-should-go-in-order-of-entity-creation/2900>\
**Category:** Get Help\
**Tags:** entity-view\
**Created:** [June 2, 2022, 5:41am UTC](https://community.fibery.io/t/public-ids-numbering-should-go-in-order-of-entity-creation/2900 "2022-06-02T05:41:49Z")\
**Posts on this page:** 1\
**Showing post:** 14

<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:** [September 5, 2026, 8:16am UTC](https://community.fibery.io/t/public-ids-numbering-should-go-in-order-of-entity-creation/2900/14 "2026-09-05T08:16:59Z")

</div>

> [@CivicScribe88](#):
>
> 1. Why should I NOT be allowed to sort by Public ID? It’s a column, like any other

You can. But it is text, so it doesn’t sort the way you might expect for numbers.

> [@CivicScribe88](#):
>
> 1. WHY can I not transform the string into a number? So I can then sort numerically, without padding - if you are unwilling to budge on question 1?

It’s a feature that we haven’t implemented yet.

> [@Convert text to number or date with formulas](https://community.fibery.io/t/convert-text-to-number-or-date-with-formulas/2375):
>
> Hi, I think Fibery should let users convert a text to a number or date, using formulas. I have a Period type, which I named as ‘Q’ + Quarter + ‘-’ + Year: I.E: Q1-2022, for referring to the First Quarter of 2022. If I have this feature, I could fill their date range with automation or formulas, instead of manually.

> [@CivicScribe88](#):
>
> 1. WHY has the evidence presented by B\_Sp, from over 4 years ago, not been addressed? Showing that Creation Dates do not track the ascending numbers of Public ID. This eliminates the argument that Creation Date is the same as Public ID.

We couldn’t find anything to indicate that the designed behaviour of public IDs (incremented im order of each entity creation) is not being followed.  
B\_Sp might have experienced an anomaly/bug back in 2020 - we just have not been able to reproduce.  
(I should have posted that back in June 2022)

---

_[View the full topic](https://community.fibery.io/t/public-ids-numbering-should-go-in-order-of-entity-creation/2900)._