# Help with Invoice number formula

**URL:** https://community.fibery.io/t/help-with-invoice-number-formula/9410
**Category:** Get Help
**Created:** [August 14, 2025, 8:58am UTC](https://community.fibery.io/t/help-with-invoice-number-formula/9410 "2025-08-14T08:58:54Z")
**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: [August 14, 2025, 9:11am UTC](https://community.fibery.io/t/help-with-invoice-number-formula/9410/5 "2025-08-14T09:11:40Z")

</div>

> [@Eva\_Folch](#):
>
> how can I increase automatically, and add one more when a new row is created?

Well, you have a couple of options: you can either utilise the Public Id field (which is unique and increments each time an entity is created) or you can make an automation rule to write a number field each time an entity is created, and then use ToText on that number when necessary.

Note: due to the way Public Id works, it is not guaranteed to be exactly one higher than the current highest value. See [here](https://community.fibery.io/t/public-ids-numbering-go-in-order-of-entity-creation/2900/2)

---

_[View the full topic](https://community.fibery.io/t/help-with-invoice-number-formula/9410)._