Convert a number to text
I need to pad a number with 2 leading zeros to be able to read a legacy bar code. The ToFormattedText function does not actually convert the number so I can't use the PadLeft function. I know there ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendHow about this as a formula text field.
var text MyBarCode = ToText([my bar code field]);
IF(not begins($MyBarCode, "00"), "00" & $MyBarCode, $MyBarCode)
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
var text MyBarCode = ToText([my bar code field]);
IF(not begins($MyBarCode, "00"), "00" & $MyBarCode, $MyBarCode)
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
- Can you explain a little more please. I am not finding a var text or not begins function in the list. what does $ represent?
------------------------------
Julie Meeker
------------------------------- MarkShnier__YouI'm all about super tidy and readable formuals since in all probability I will be the one who needs to look back at a formula I did years ago to see what it is doing, or if its someone else, the the formulas should be stupid simple to read.
So I like to use Formula Variables. here is some help on them.
https://help.quickbase.com/user-assistance/formula_variables.html
Maybe in this case it was overkill.
You can also just do this
IF(not begins([My bar code field], "00"), "00" & [My bar code field], [My bar code field])
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------- Thank you for the article link. When I use that formula I still get the error that it is expecting text and I gave it a field that is a number.
------------------------------
Julie Meeker
------------------------------
