Forum Discussion

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

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.

13 Replies