This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Number field - max number of digits

Posted on 01-17-2022 08:36 AM
Rory_Forde
New Member
Reply posted on --/--/---- --:-- AM

Hello Allโ€ฆ

Quick question. Does anyone know the max number of digits that a Number field type will take? I have a number with 19 digits (and could go to 20 or more) and want to know if I can store this as a number or if I need to treat it as text (would prefer number if possible).

Thanks,

RoryF

0 8 491
Topic Labels
0 Likes
8 REPLIES 8

Posted on --/--/---- --:-- AM
1minManager
Gold 4
Gold 4
Reply posted on --/--/---- --:-- AM

I donโ€™t think there is a limit. Text & Long Text columns can be a few hundred characters so I presume Number type columns are the same.

0 Likes

Posted on --/--/---- --:-- AM
Rory_Forde
New Member
In response to 1minManager
Reply posted on --/--/---- --:-- AM

The reason I ask is that the number is not coming across correctly - it MAY be related to the fact that there is a formatting formula on that cell in Google Sheets. Appsheet picked it up as a number type. If I change the field type to text looks ok, Hence the question.

RoryF

0 Likes

Posted on --/--/---- --:-- AM
SkrOYC
Gold 5
Gold 5
In response to Rory_Forde
Reply posted on --/--/---- --:-- AM

I know that this may not sound like the best advice from your POV but just try and then you can come up to the community if it doesnโ€™t work as expected.
Try adding N number of digits and see if itโ€™s correctly saved and displayed as you expect it to be

Posted on --/--/---- --:-- AM
Marc_Dillon
Platinum 1
Platinum 1
In response to Rory_Forde
Reply posted on --/--/---- --:-- AM

Best practice is to format the entire spreadsheet as plain text.

Posted on --/--/---- --:-- AM
Rory_Forde
New Member
Reply posted on --/--/---- --:-- AM

We MAY be into Bug territoryโ€ฆ

I took the field and formatted as a number in google sheets. Regenerated the structure just in case. On closer inspection the number is just wrong - it has most of the number correct but the last few digits are incorrect.

3X_0_d_0d0746ab081d6a3272af4269d20a42c540a76dbc.png

3X_a_2_a24a660ae6ddc9411483e74cf99a6b8f6024a55e.png

0 Likes

Posted on --/--/---- --:-- AM
Rory_Forde
New Member
In response to Rory_Forde
Reply posted on --/--/---- --:-- AM

I think it IS a bugโ€ฆ

I checked a few other numbers - it is rounding (up/down) based on the last 3 (in some cases 4) digitsโ€ฆ

Not the behaviour I would wantโ€ฆ

0 Likes

Posted on --/--/---- --:-- AM
WillowMobileSys
Platinum 1
Platinum 1
In response to Rory_Forde
Reply posted on --/--/---- --:-- AM

I agreeโ€ฆitโ€™s a bug.

I happened to check this out on a View where I had a QuickEdit setโ€ฆand the value showed correctly in the QuickEdit.

Below is view where I have 2 columns set as Number with the same exact value - one shown as QuickEdit and the second is not.

3X_7_e_7e0ad3db0ace765ab739192410c1ce87b1d6cf76.png

If I add 1 more digitโ€ฆ

3X_1_d_1dbcaee63065c73fc979ebcc1e6f56f9e0863fbb.png

Also, if I switch to Decimalโ€ฆ

3X_1_f_1fb4d2d346b71ea3db97a1529ff94b5088b0facc.png

I went very large on a Number and never received an error message.

Posted on --/--/---- --:-- AM
SkrOYC
Gold 5
Gold 5
In response to WillowMobileSys
Reply posted on --/--/---- --:-- AM

BTW, text column keep displaying it correctly, right? Maybe making the column as Text and use NUMBER() could be a workaround?

0 Likes
Top Labels in this Space