# \[✔️DONE\] Fuller handling of number and currency in Number Field **URL:** \ **Category:** Ideas & Features\ **Created:** [February 17, 2021, 2:40pm UTC](https://community.fibery.io/t/done-fuller-handling-of-number-and-currency-in-number-field/1378 "2021-02-17T14:40:25Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![B\_Sp](https://avatars.discourse-cdn.com/v4/letter/b/e8c25b/32.png) [@B\_Sp](https://community.fibery.io/u/B_Sp)\ **Post date:** [February 17, 2021, 2:40pm UTC](https://community.fibery.io/t/done-fuller-handling-of-number-and-currency-in-number-field/1378/1 "2021-02-17T14:40:25Z")
In reading the discussion here: > [@Internationalization on the roadmap?](https://community.fibery.io/t/internationalization-on-the-roadmap/389/5): > > Why do you have to prove anything? To whom? What idea? There is some talk of the limitations of the current Number Field. Not only does not have a currency option, but there are no decimals available and I’ve spoken with support about this and simply that functionality is not built yet as I understand. So I wanted to post the specific request to build that Field out some more so it would have more robust capability, like in a lot of other nocode apps that have a “number” type column. This is also related to and out-and-out dedicated Currency-type Field, requested here already: > [@\[DONE\] Number Field Formatting Options - Currency](https://community.fibery.io/t/planned-number-field-formatting-options-currency/1114): > > I am currently using the decimal formatting option with 2 decimal precision for a currency value. This works but still reads as a decimal value. It would be great to add a currency format similar to the decimal format workaround described in line with how currency amounts are normally displayed in applications e.g. $ 1,123,456.78 or in Fibery style: 1,123,456.78 $ Obviously if we ultimately had a separate Currency Field that would be fine, or if Currency was rolled into the Number Field as a configuration option, either solution solves the problem. Thanks! ---
**Author:** ![Oshyan](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/oshyan/32/11431_2.png) [@Oshyan](https://community.fibery.io/u/Oshyan)\ **Post date:** [February 17, 2021, 4:23pm UTC](https://community.fibery.io/t/done-fuller-handling-of-number-and-currency-in-number-field/1378/2 "2021-02-17T16:23:47Z")
Although it is not a massive drain on our productivity, as a real estate company we could definitely use a currency field, and would also love to see decimal and comma separator (I guess configurable for how they’re used differently in different countries). More number field functionality is a must long-term. ---
**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 17, 2021, 4:50pm UTC](https://community.fibery.io/t/done-fuller-handling-of-number-and-currency-in-number-field/1378/3 "2021-02-17T16:50:49Z")
> [@B\_Sp](#): > > there are no decimals available Fibery supports decimals, right? or am I misunderstanding your need? As for the currency option, do you mean that you want the symbol to prefix the number instead of suffix? Of course, the thousands separator is useful in some cases, and that would be nice to have… ---
**Author:** ![B\_Sp](https://avatars.discourse-cdn.com/v4/letter/b/e8c25b/32.png) [@B\_Sp](https://community.fibery.io/u/B_Sp)\ **Post date:** [February 17, 2021, 6:26pm UTC](https://community.fibery.io/t/done-fuller-handling-of-number-and-currency-in-number-field/1378/4 "2021-02-17T18:26:12Z")
Hey Chris! What I mean is if I write a number to the hundredths, let’s say, it disappears after I enter the data. Maybe that’s a bug? Also, I cannot put in larger numbers. I track invoices in Fibery so that limit is problematic for sure. > [@Chr1sG](#): > > Fibery supports decimals, right? or am I misunderstanding your need? > As for the currency option, do you mean that you want the symbol to prefix the number instead of suffix? > Of course, the thousands separator is useful in some cases, and that would be nice to have… ---
**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 18, 2021, 8:40am UTC](https://community.fibery.io/t/done-fuller-handling-of-number-and-currency-in-number-field/1378/5 "2021-02-18T08:40:37Z")
That sounds a bit odd. I have no problems writing decimals, and I have checked that I can enter numbers in the billions, so there should be no problems with invoices (unless your business is doing extraordinarily well!) ---
**Author:** ![B\_Sp](https://avatars.discourse-cdn.com/v4/letter/b/e8c25b/32.png) [@B\_Sp](https://community.fibery.io/u/B_Sp)\ **Post date:** [February 19, 2021, 3:01am UTC](https://community.fibery.io/t/done-fuller-handling-of-number-and-currency-in-number-field/1378/6 "2021-02-19T03:01:10Z")
@Chr1sG , too funny! I’m actually referring to bills I receive (for my Vendors they are “invoices), they have all sorts of lengths, etc. which my Vendors control. I get this when trying to put in a long number: ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/9/9466954060c347e143ed28efc223f35361ed22cc.jpeg) Alternatively I get this error at times, too. ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/3/35e3d1cfb76c503a1236fb3e7c392398f596c22b.jpeg) Generally I think it’s odd the way you set up the Number Field, which a really essential one for custom field use in any app. I think more conventional is to have the ability to dictate what decimal level you have in a Number Field, and not have to choose whether the number has a decimal or not. I think you’ve used Coda - they do this very simply. Not Rocket Science and I wish we had that handling here. This issue reminds me of the [Awkward Date Picker](https://community.fibery.io/t/approved-minor-improvements-fixes-to-date-picker/980) which cause me angst on a daily basis since you can’t simply write in times in Natural Language, or any language for that matter! As when you try to put in a time value in a Date that isn’t written precisely as “MM:HH”, the entire calendar moves around and you have to go and redo the date itself. Thanks! ---
**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 19, 2021, 8:15am UTC](https://community.fibery.io/t/done-fuller-handling-of-number-and-currency-in-number-field/1378/7 "2021-02-19T08:15:09Z")
I think it sounds like you would be better served by using a string (text) field for the ‘bill number’ since I’m guessing you don’t actually perform any arithmetic on the data. It’s really just a string of characters that is limited to using numeric digits, right? You know that it’s possible to choose decimal instead of integer (and thus define precision) right? ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/3/3a541b757652c287317da3902bc385781fb86a7e.png) Also, you said this: > [@B\_Sp](#): > > have to choose whether the number has a decimal or not Are you saying that you’d like all numbers to be stored internally as decimals, but be able to control the number of decimal places that are shown? I’m not sure how useful that is…maybe you have a use case that I don’t. I definitely think it’s a shame that many fields are in some ways not editable after creation, but the decimal precision is one of the few things that can be changed after creation. ---
**Author:** ![B\_Sp](https://avatars.discourse-cdn.com/v4/letter/b/e8c25b/32.png) [@B\_Sp](https://community.fibery.io/u/B_Sp)\ **Post date:** [February 20, 2021, 7:12am UTC](https://community.fibery.io/t/done-fuller-handling-of-number-and-currency-in-number-field/1378/8 "2021-02-20T07:12:58Z")
Yes I’m aware you can input a full string of any numerals in the “Text” Type Field. I think that’s an unnatural way to handle this need, and a workaround of sorts. My team has found the way the “Number Field” works in Fibery a problematic area that affects Quality of Life. I’d simply expect that field to operate like just about all other Number Fields I’ve encountered work. Here are some examples of how other popular tools handle Number Fields: Wrike: ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/e/ea3a52657adf4aee8757d1ee7c0b5a54055f0329.png) ClickUp: ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/e/e435f14ffe0fbef0b94056ef306e9cf024ac95c4.png) Notion: ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/4/4db9408e2e489575afb3e8306cc9dfc9acee13d2.png) Coda: ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/f/f643479e518dbb1e21da6bea770188c73cb7866b.png) **None** make a differentiation between whether the number is an “integer” or “decimal.” In fact I think that’s actually linguistically incorrect, and confusing. Isn’t a “decimal” the part of the number after the “period” so to speak? From Wikipedia: ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/5/556a1fd4b1848a874102c7c6201658c2d375755e.png) These are just more natural, intuitive ways to add a Number Field. I feel like a lot of the users are reflecting this with the requests around better Number handling, which is why I created a unique post for it. I may be wrong, I guess we’ll see if this post gets traction, and whether your, or my, take on the situation are better supported. I am trying to highlight an area of Fibery that I think could use better UX handling so it’s more user friendly for teams coming in. I hope that’s useful. ---
**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 20, 2021, 10:17am UTC](https://community.fibery.io/t/done-fuller-handling-of-number-and-currency-in-number-field/1378/9 "2021-02-20T10:17:44Z")
I agree that there is no logical reason why the user should have to choose between ‘integer’ and ‘decimal’, since the former is logically a subset of the latter. I suspect that it relates to how they are internally stored. I agree that it would be nice to be able to define the thousand separator and whether or not the symbol precedes or succeeds the numbers. As a side note, when using formulas, I think there might be a difference in functionality between the cases when the result is an integer or decimal, in that the former implements rounding, whereas the latter doesn’t (it just alters the presentation). I think this can have consequences if those numbers are then used elsewhere. For me, I don’t use numbers enough for the problems to be a QoL issue, but on the other hand, some of the handling of dates (like what happens if you use ‘Date.End’ in a formula) is problematic for me, but that’s another story for another time 🙂 ---
**Author:** ![Polina\_Zenevich](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/polina_zenevich/32/480_2.png) [@Polina\_Zenevich](https://community.fibery.io/u/Polina_Zenevich)\ **Post date:** [February 22, 2021, 2:38pm UTC](https://community.fibery.io/t/done-fuller-handling-of-number-and-currency-in-number-field/1378/10 "2021-02-22T14:38:01Z")
Hi all! Thanks for rising the theme. ✨ So, here are some points. 1. We suggest using Number fields for cases when the number is countable. So, in most cases, like - article number, invoice number, etc. - better to use a Text field. 2. We do also hope someday to allow converting fields - like from integer number to the decimal one. We have to make more clear p.1 logic and make human-friendly errors 🙂 ---
**Author:** ![mdubakov](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/mdubakov/32/10_2.png) [@mdubakov](https://community.fibery.io/u/mdubakov)\ **Post date:** [June 3, 2021, 10:01am UTC](https://community.fibery.io/t/done-fuller-handling-of-number-and-currency-in-number-field/1378/11 "2021-06-03T10:01:11Z")
Money formatting is in progress, soon it will be possible to select Money formatting, select currency, decimals representation, and thousands separator. ---
**Author:** ![B\_Sp](https://avatars.discourse-cdn.com/v4/letter/b/e8c25b/32.png) [@B\_Sp](https://community.fibery.io/u/B_Sp)\ **Post date:** [June 7, 2021, 4:34pm UTC](https://community.fibery.io/t/done-fuller-handling-of-number-and-currency-in-number-field/1378/12 "2021-06-07T16:34:00Z")
Thanks Michael. Any news on when this will be done: > [@\[DONE\] Phone number field/extension](https://community.fibery.io/t/implement-phone-number-field-extension/439): > > I am building up a contact list app that I can then link to my meeting notes and action items. It would be great if we could have fields designed for phone numbers that could format and validate the content. It would be great if they could also trigger call behaviour on smartphones. The email field seems to provide validation but there doesn’t seem to be a way of triggering the default mail application to compose a new message. That would be a great addition as well. Apologies for inundating t… Really need it for CRM we are trying to set up in Fibery to go along with the Product Mgmt we do. Thanks! ---
**Author:** ![cannibalflea](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/cannibalflea/32/318_2.png) [@cannibalflea](https://community.fibery.io/u/cannibalflea)\ **Post date:** [June 23, 2021, 1:51am UTC](https://community.fibery.io/t/done-fuller-handling-of-number-and-currency-in-number-field/1378/13 "2021-06-23T01:51:46Z")
I hope I am not stealing the team’s thunder by posting, but it seems this feature is almost done as I just saw new options for number fields 🥰 Thanks again for implementing this. I did have one question though: will we be able to do anything with the actually currency type (e.g. be able to convert from one to another in formulas, possibly [using this](https://twitter.com/fibery_io/status/1398327833198485513?s=20)) at some point in the future or is it just a display setting? Also, if it will carry some meaning, will there be a possibility in the future for users to possibly choose/change currency on a per entity basis (with a default preset)? I wanted to thank you and then couldn’t resist asking for another thing. I’ll show myself out 🤦‍♂️ 😏 🤓 ---
**Author:** ![mdubakov](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/mdubakov/32/10_2.png) [@mdubakov](https://community.fibery.io/u/mdubakov)\ **Post date:** [June 24, 2021, 1:15pm UTC](https://community.fibery.io/t/done-fuller-handling-of-number-and-currency-in-number-field/1378/14 "2021-06-24T13:15:36Z")
Money formatting is implemented in latest release > [@CHANGELOG: June 24 / Group permissions (beta), Currency formatting, World app](https://community.fibery.io/t/changelog-june-24-group-permissions-beta-currency-formatting-world-app/1718): > > Group permissions (beta) Thus far you had to give users access to Fibery Apps one by one, and it was a nightmare for any serious company. Now you can create Groups and assign people to Apps via Groups. Here is a [detailed guide about Group permissions](https://help.fibery.io/en/articles/5350066-permissions). [image] NOTE: Access section in App setting is gone, now you should use Share button to give access to users. Check our approach to permissions in this article. [https://fibery.io/blog/group-permissions/](https://fibery.io/blog/group-permissions/)Money/Currency formatting for Number fie… ![2021-06-24 16.03.33](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/3/32f7ef7010d0ea42e2830ee475fe214c661ea844.gif) ---
**Author:** ![Oshyan](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/oshyan/32/11431_2.png) [@Oshyan](https://community.fibery.io/u/Oshyan)\ **Post date:** [June 24, 2021, 7:50pm UTC](https://community.fibery.io/t/done-fuller-handling-of-number-and-currency-in-number-field/1378/15 "2021-06-24T19:50:26Z")
Great! Unfortunately I have a little issue when I try to implement it: I can’t set decimal the way I want on some fields with data in them already. I am guessing that it tries to preserve any existing data when changing field configuration, which is a good thing. But I can’t find any existing data that has a decimal point. Yet still I am unable to select 0 decimal points. See GIF where I check each existing value, showing no .0 decimals (it shows decimals before clicking because the currency field settings are for 1 decimal place), then I open the Type and attempt to edit the Field for 0 decimal, but it is grayed out: ![X3zWWKzz1n](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/3/3cdd49cacbac298be6e544adb1e9fa6eb73dae50.gif) ---
**Author:** ![rothnic](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/rothnic/32/1850_2.png) [@rothnic](https://community.fibery.io/u/rothnic)\ **Post date:** [June 24, 2021, 8:41pm UTC](https://community.fibery.io/t/done-fuller-handling-of-number-and-currency-in-number-field/1378/16 "2021-06-24T20:41:59Z")
I wonder if that issue is related to having data with decimal values or that there is some underlying use of integers for no decimal value vs decimal/float for numbers with 1 or more decimal values. In general, it seems like fibery doesn’t let you change the field too much after first definition of it, which can be a pain. ---
**Author:** ![B\_Sp](https://avatars.discourse-cdn.com/v4/letter/b/e8c25b/32.png) [@B\_Sp](https://community.fibery.io/u/B_Sp)\ **Post date:** [June 25, 2021, 3:12am UTC](https://community.fibery.io/t/done-fuller-handling-of-number-and-currency-in-number-field/1378/17 "2021-06-25T03:12:40Z")
> [@rothnic](#): > > In general, it seems like fibery doesn’t let you change the field too much after first definition of it, which can be a pain. This is a great point. I hope the new Entity changes on the horizon we just heard about today: > [@Individual Layouts for a node, hide fields etc](https://community.fibery.io/t/individual-layouts-for-a-node-hide-fields-etc/995/47): > > We have this in mind as Important fields. Overall, we are discussing **major** Entity View re-work, that includes new 2-panel navigation, blocks, primary/secondary info sections, etc. Will rectify this. In particular I get stuck with not being able to edit relations, even those of the same type - so changing an one-to-one to another one-to-one, not to a Many-to-one, which understandably is a more complex issue. ---
**Author:** ![gb\_carbone](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/gb_carbone/32/5345_2.png) [@gb\_carbone](https://community.fibery.io/u/gb_carbone)\ **Post date:** [August 3, 2022, 9:51pm UTC](https://community.fibery.io/t/done-fuller-handling-of-number-and-currency-in-number-field/1378/18 "2022-08-03T21:51:22Z")
I have the same issue: - I can create a new field and set it to 0 decimal - An existing field currently set to 2 decimals cannot be changed to 0 decimal (grayed out) Is this tied to a dependency somehow? Wen through the different relationships and there didn’t seem to be any. Also, this is in the default Agency workspace (which I am currently playing with) 🙂 ---
**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 4, 2022, 6:38am UTC](https://community.fibery.io/t/done-fuller-handling-of-number-and-currency-in-number-field/1378/19 "2022-08-04T06:38:07Z")
It’s a technical issue: 0 decimal places → stored as integer 1 or more decimal places → stored as decimal Unfortunately, it’s not possible to convert a number field from decimal to integer. ---
**Author:** ![mdubakov](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/mdubakov/32/10_2.png) [@mdubakov](https://community.fibery.io/u/mdubakov)\ **Post date:** [November 22, 2022, 3:35pm UTC](https://community.fibery.io/t/done-fuller-handling-of-number-and-currency-in-number-field/1378/20 "2022-11-22T15:35:33Z")