Skip to main content
Question

Dealing with "Zero"

  • October 26, 2020
  • 0 replies
  • 115 views
Forum|alt.badge.img+5

Hi all:
I have a client id that is 7 numbers long and sometimes starts with Zero.  Is there a way to "force" QB to recognize my ids that start with 0.  Right now, after saving the record, it will truncate it to six digits if the first one is 0.  Sometimes I have ids that begin with two zeros.  

Please advise.

Thanks.



------------------------------
Melissa Freel
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
You will need to change your Client ID# to be a text field after considering the implications of where it is used.  You may want to  to make a duplicate of that field and then change the type to text, fix the ones that need the leading zeros, and then see where the numeric field was used and replace it with the text field in any formulas and lookups.  But if you need it as a lookup, then you need to make a new lookup field as the Type if different (ie text and not numeric)

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Mark Shnier. Your Quickbase Coach
Terms & ConditionsAccessibility statement