# Problem with a field that uses large numeric values

**URL:** <https://community.fibery.io/t/problem-with-a-field-that-uses-large-numeric-values/9981>\
**Category:** Get Help\
**Created:** [November 9, 2025, 4:10pm UTC](https://community.fibery.io/t/problem-with-a-field-that-uses-large-numeric-values/9981 "2025-11-09T16:10:27Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![rabrunos](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/rabrunos/32/13629_2.png) [@rabrunos](https://community.fibery.io/u/rabrunos)\
**Post date:** [November 9, 2025, 4:10pm UTC](https://community.fibery.io/t/problem-with-a-field-that-uses-large-numeric-values/9981/1 "2025-11-09T16:10:27Z")

</div>

I’m trying to create a field with large numbers, but when I put the values ​​into the database, they simply change. Why? Did I enable something wrong?

![20251109-1607-43.8118576](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/6/656c29024a59f928a9afab392865f175dfd2f580.gif)

Remember that this database and workspace are brand new!  
There’s nothing in them, no scripts, nothing!

---

<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:** [November 9, 2025, 4:26pm UTC](https://community.fibery.io/t/problem-with-a-field-that-uses-large-numeric-values/9981/2 "2025-11-09T16:26:45Z")

</div>

If the field is an integer (zero decimal places) then the max number is about 4.3 billion (2^32-1).  
Anything higher will result in an overflow.

If you need higher values, you’ll have to switch it to a decimal field type.

---

<div class="post-metadata">

**Author:** ![rabrunos](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/rabrunos/32/13629_2.png) [@rabrunos](https://community.fibery.io/u/rabrunos)\
**Post date:** [November 9, 2025, 4:34pm UTC](https://community.fibery.io/t/problem-with-a-field-that-uses-large-numeric-values/9981/3 "2025-11-09T16:34:27Z")

</div>

That’s too bad then!

This is an identification number, so I can’t use decimals in it, that would make things way too complicated!

So I’d rather use the field as Text and convert the value to an integer (if possible).

---

<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:** [November 9, 2025, 6:47pm UTC](https://community.fibery.io/t/problem-with-a-field-that-uses-large-numeric-values/9981/4 "2025-11-09T18:47:03Z")

</div>

> [@rabrunos](#):
>
> So I’d rather use the field as Text and convert the value to an integer (if possible).

You can definitely store it as text (which makes sense if it is merely an identifier, and not a nunber for which mathematical calculations are relevant) but there is currently no way to convert text to a number.