CoreBOSBB
insert a mask into a field - Printable Version

+- CoreBOSBB (https://discussions.corebos.org)
+-- Forum: Support (https://discussions.corebos.org/forumdisplay.php?fid=17)
+--- Forum: Administrator Support (https://discussions.corebos.org/forumdisplay.php?fid=8)
+--- Thread: insert a mask into a field (/showthread.php?tid=1601)



insert a mask into a field - rslemer - 09-26-2019

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


RE: insert a mask into a field - Hena Hajderasi - 09-26-2019

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


RE: insert a mask into a field - rslemer - 09-26-2019

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.


RE: insert a mask into a field - joebordes - 09-28-2019

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