Why do pipelines have a 12 digit limit for numerical fields?

Question

As the title says. For companies like us who deal with ICCID's, Serials, MAC's, etc., the 12 digit limit just does not work. Though I am curious to find out if this will effect something like an ICCID if we have it in a text field vs. a numerical field?

------------------------------
John Ross
------------------------------

MarkShnierYou · Answer

You must never use a numeric field type to hold "numbers" longer than 12 digits. You must use a text field. All computers have a limit on the size of a number they can hold. If you enter numbers in QuickBase longer than 12 digits then the number actually gets rounded and converted to maybe some crazy scientific notation. And you lose accuracy. So the solution is to convert the field to a text field but before you do that you have to consider the implications of it in terms of look up fields and things like that.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

Sign up

Login to the community