How to seperate thousand of number digits while typing in input form

[hien_nguyen]

Hi Team Dev,

How can we sepererate thousands of digits while typing in input form?

[WillowMobileSys]

There is a property on numeric columns to show/hide the separator.  Well, I tried to load an image but its not happening right now.  Simply go in to Edit the column and you will see the property named "Show thousands separator".

[hien_nguyen]

Yeah, I am looking forward to waiting your new solution for this cause.

[Marc_Dillon]

You can't.

You're showing a photo from the input fields on a Form view. You can't automatically/dynamically modify an inputted value while the user remains in the View in any way, including adding a thousands separator. You can modify them to your hearts content once the record is saved, in various ways (although you don't need to here).

The "show thousands separator" option that John mentioned is a simple formatting tool that only applies when viewing saved values, like in Detail or Table Views.

[WillowMobileSys]

@hien_nguyen 

I apologize.  Marc is correct.  I didn't think you meant it literally as a person was typing the value in but was more interested in the result after.

[hien_nguyen]

I can modify this feature very easy with VBA Excel form or HTML input form, but I can't do it by Google Appsheet. If users write a billion with more than 12 number digits, they have to manual count how many digit every typing until eough qty. Sometimes they meet a misktake because it is very difficult to count and group to define thousand, million and billion quickly if the app doesn't support seperatting group digits.

[hien_nguyen]

I think it is very nesscessary for very large numbers or currency like VNĐ, we have working million and billion vnd everyday, but I the app can not seperate to thousand group of digit, it is very inconvinency for user. For example, if I want to typing 1.55 billion VNĐ. I have to type 1550000000 and count every number to enough total... if the app can seperate to group of thousand as 1,550,000,000 I can easier count an define when typing.

[WillowMobileSys]

Honestly, typing in all those zeros is probably more of a pain. 

If it is common for the users of your app work in scales of Thousands, Millions. Billions, it might be even more user friendly to provide Scale Factor buttons.  The user would enter the shifted value (e.g. 1.55) and then select the Scale Factor button - K for (thousands), M for (millions), B for (billions), T for (trillions).

Your app would convert the value to the raw number (I would store this in its own column) used in calculations.  But display the value in its shortened form - 1.55 B

[Koichi_Tsuji]

I suggest you throw a feature request for this, to get the optional control for form view to show/hide thousands separators.

[hien_nguyen]

Yes, I have requested new feature but team dev have not confirmed it.

[hien_nguyen]

Hi @Steve, can you consider updating this feature? It is really nesscessary for account need more digits, for example ₫ 460030302000000 instead of ₫ 460,030,302,000,000 user very difficult to define how much value when typing until they saving the form

[Steve]

There is nothing I personally can do. Posting a Feature Idea is the best you can do, but I don't believe anyone actually looks at those currently.

[Arthur_Rallu]

@hien_nguyen Can you post the link to the feature request in this thread?

Thank you

[hien_nguyen]

Hi @Arthur_Rallu , I've posted last month https://www.googlecloudcommunity.com/gc/Feature-Ideas/Auto-Show-thousands-separator-when-typing-numb... 

[hien_nguyen]

Hi, @Arthur_Rallu please follow up on these features. It is necessary for every user when typing a number. For example, for 342300000000, it is complicated to count and define how much it to type correctly before saving if it doesn't have a separate thousand number

[WillowMobileSys]

@hien_nguyen 

I mentioned this is a previous post above,  I highly recommend using scaled values, for entry and display, to allow users to avoid typing in and reading all those zeros in the first place...period!

Maybe this works differently in your country?  Here is the US it is very common for financial applications to use scaled values when operating on values in Millions, Billions or Trillions. 

For instance, a user is asked to insert values in Billions - Price (in Billions).  Inserting a value of 2.575 would be transformed into 2,575,000,000 as the raw data value.  In some systems, even the raw data value is recorded in its scaled form because the entire system operates (even calculates) on the scale - so 2.575 would be saved as the raw value.