+- 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