insert a mask into a field

[rslemer]

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

[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?

[rslemer]

I am learning how to change code now, and would like to know if there is any difference in using or creating function to called in BP or the new custom function

A routine for use in BP seemed to me a lot easier to develop.

[joebordes]

there are many ways of doing things right, just choose the one that you are good with