# Generate a sequential reference for entries

**URL:** <https://community.fibery.io/t/generate-a-sequential-reference-for-entries/8365>\
**Category:** Get Help\
**Created:** [March 3, 2025, 5:34pm UTC](https://community.fibery.io/t/generate-a-sequential-reference-for-entries/8365 "2025-03-03T17:34:57Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![JP\_Barthet](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/jp_barthet/32/11176_2.png) [@JP\_Barthet](https://community.fibery.io/u/JP_Barthet)\
**Post date:** [March 3, 2025, 5:34pm UTC](https://community.fibery.io/t/generate-a-sequential-reference-for-entries/8365/1 "2025-03-03T17:34:57Z")

</div>

Hi community

I am new to Fibery.

I would like to have a field that automatically generates a sequential reference number (as in GW001, GW002 … GW999) for entries in a database.

How do i go about this please?

Thanks in advance

---

<div class="post-metadata">

**Author:** ![Matt\_Blais](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/matt_blais/32/1464_2.png) [@Matt\_Blais](https://community.fibery.io/u/Matt_Blais)\
**Post date:** [March 3, 2025, 5:40pm UTC](https://community.fibery.io/t/generate-a-sequential-reference-for-entries/8365/2 "2025-03-03T17:40:16Z")

</div>

Can you use the automatically-generated “Public Id” field?

---

<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:** [March 3, 2025, 5:43pm UTC](https://community.fibery.io/t/generate-a-sequential-reference-for-entries/8365/3 "2025-03-03T17:43:56Z")

</div>

`"GW" + Right("00" + [Public Id],3)`

---

<div class="post-metadata">

**Author:** ![Matt\_Blais](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/matt_blais/32/1464_2.png) [@Matt\_Blais](https://community.fibery.io/u/Matt_Blais)\
**Post date:** [March 3, 2025, 5:52pm UTC](https://community.fibery.io/t/generate-a-sequential-reference-for-entries/8365/4 "2025-03-03T17:52:38Z")

</div>

@Chr1sG 's suggestion would be the formula of a new Formula Field you can create in the DB.

---

<div class="post-metadata">

**Author:** ![JP\_Barthet](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/jp_barthet/32/11176_2.png) [@JP\_Barthet](https://community.fibery.io/u/JP_Barthet)\
**Post date:** [March 4, 2025, 8:38am UTC](https://community.fibery.io/t/generate-a-sequential-reference-for-entries/8365/5 "2025-03-04T08:38:04Z")

</div>

Perfect guys - sorted it out. thanks for the immediate help.

---

<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:** [March 4, 2025, 9:13am UTC](https://community.fibery.io/t/generate-a-sequential-reference-for-entries/8365/6 "2025-03-04T09:13:36Z")

</div>