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 ...
FWIW, I wrote that script while binge watching old episodes of CSI Miami (I'm a big fan of David Caruso) and if the script had my full attention there are a number of improvements I could easily have made to it.
In fact, there are libraries such as Square's FieldKit that could be used which do all the hard work for you:
But why stop with using a mere professionally developed library - how about buildingthis feature into your version of QuickBase? After all, are we not Builders?
Here is how you might approach the challenge. Just use a Service Worker to splice a new section into the Field Properties page asking for the necessary properties to define a Validation Rule (shown here as a single conceptual property Mask):
There are some additional details of where you would store the supplemental information in the Validation Section (perhaps in a code page appropriately named and linked to the field). Or perhaps your might arrange to define and store the information in the form where the Validation Rule is used on a case by case basis.
Turns out this is exactly how the WQuzat people of Flubus 5A evolved their QuickBase technology using a concept they called QuickBase Plugins!
