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.
_anomDiebolt_'s avatar
_anomDiebolt_
Qrew Elite
8 years ago
Many of my solutions involve using JavaScript which is not the same as QuickBase's formula language. The problem you are having is that you are attempting to paste my JavaScript code directly into the formula definition. 

The way to use the script is to set up a special rich text field and place it on the form using a technique called the image onload technique (IOL technique) and described here:

https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=294

There are hundreds of similar scripts in the pastie database which use the IOL technique (and other scripting techniques). If you need help beyond the resources in the forum or the pastie database you can ask further questions here and I will answer as time permits or you can contact me directly using the info in my profile:

https://getsatisfaction.com/people/dandiebolt