insert a mask into a field

[Hena Hajderasi]

(09-26-2019, 12:21 AM)rslemer Wrote: In past did ask a coreBOS time to develop for us a validation for use in business map to allow only a valid numbers for the tax number used in Brazil

This function does not allow my user to enter a wrong tax number ID in registry. This function as used thru business map

Now, user wish to see this number with a mask, and because an integration with my PBX, I need this number is written in database with a mask too.

I wish changed this original code, besides a checked number validation write in database number with mask too, like as 999.999.999-99

I don't know how I wrote this code, I means how I can   get a record ID and call a UPDATE SQL

And I like to know, if there is a better option or I need created a custom function and called since a workflow

Can you create a workflow that applies the format you want?