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
QuickBase has a built in function for formula fields! ToText([field])
------------------------------
Katlyn Allen
------------------------------
------------------------------
Katlyn Allen
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendRight, so that is why I did this in my original response.
var text MyBarCode = ToText([my bar code field]);
IF(not begins($MyBarCode, "00"), "00" & $MyBarCode, $MyBarCode)
My second simpler response was incorrect.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
var text MyBarCode = ToText([my bar code field]);
IF(not begins($MyBarCode, "00"), "00" & $MyBarCode, $MyBarCode)
My second simpler response was incorrect.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------