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
My friend, you are awesome!
I have been following all your information, and I try to use most of your material, but I think I am not so smart when it comes to quickbase.

I am creating a field url formula, I paste your code there, but it always shows me error messages. I think i need to learn still how to apply all your codes, which fields to use etc.

Is there a video somewhere that i could learn how to use your codes in my applications? I have searched the whole internet and cant find one that shows me the step by step. Or a guide would work too.
Thank you so much and enjoy your show!