Forum Discussion

SergioSergio's avatar
SergioSergio
Qrew Cadet
8 years ago

I need a formula to format a numeric field to show like this 051.801.264/0001-85

I have a numeric field that is a tax id number field, and the format is all the same. 051.801.264/0001-85 It has dots and dashes and a slash. Some customers use only numbers and others use the dots ...
Ask about Quickbase functionality
_anomDiebolt_'s avatar
_anomDiebolt_
Qrew Elite
8 years ago
So easy:

Tax ID Auto Format ~ Add New Record
https://haversineconsulting.quickbase.com/db/bnfj79i2f?a=nwr

Pastie Database
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=620

Notes:

(1) I did this pretty fast and there are a few things to add. The script is responding to keyup events so if you were to paste a string into the field it will not apply the formatting.

(2) You can enter a misplaced "." ,  "-" or "/" character and it will not be disallowed

(3) maybe some other weird edge cases but they are easy to fix.
SergioSergio's avatar
SergioSergio
Qrew Cadet
8 years ago
Thank you so much. I left you a message on your phone number and also texted you.
I guess I am stuck in the 1st step where i need to insert a "user defined variable". Can you give me a hint here? i feel after that i will be able to follow the other steps.
Thank you!