Re: I need a formula to format a numeric field to show like this 051.801.264/0001-85
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
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
