Convert Base 10 to base 36
Is there a way in QuickBase to convert a number from base 10 to base 36 using a formula? For example: Base 10 Base 36 100 2S 2000 1JK 5000 3UV 20,000 FFK 25,000 JAG 50,000...
Forum Discussion
>Not with a formula, but with a code page yes.
This is easy to do with native formulas. You will have to extend the pattern of the formulas to convert decimal numbers that are larger than 36^4 - 1 = 1,679,615.
Feel free to add you own records to test:
Convert Bases ~ List All
https://haversineconsulting.quickbase.com/db/bmvutfx28?a=td
Pastie Database
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=587
Base 10 to Base 36 Conversion Utility
http://www.unitconversion.org/numbers/base-10-to-base-36-conversion.html
This is easy to do with native formulas. You will have to extend the pattern of the formulas to convert decimal numbers that are larger than 36^4 - 1 = 1,679,615.
Feel free to add you own records to test:
Convert Bases ~ List All
https://haversineconsulting.quickbase.com/db/bmvutfx28?a=td
Pastie Database
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=587
Base 10 to Base 36 Conversion Utility
http://www.unitconversion.org/numbers/base-10-to-base-36-conversion.html
