Deliver Awesome UI with the most complete toolboxes for .NET, Web and Mobile development
Automate UI, load and performance testing for web, desktop and mobile
A complete cloud platform for an app or your entire digital business
Detect and predict anomalies by automating machine learning to achieve higher asset uptime and maximized yield
Automate decision processes with a no-code business rules engine
Optimize data integration with high-performance connectivity
Connect to any cloud or on-premises data source using a standard interface
Build engaging multi-channel web and digital experiences with intuitive web content management
Personalize and optimize the customer experience across digital touchpoints
Build, protect and deploy apps across any platform and mobile device
Rapidly develop, manage and deploy business apps, delivered as SaaS in the cloud
I am trying to add a validation trigger where I am attempting to compare the phone number entered on my current object against two other objects for uniqueness. I'm trying to use the rbv_selectQuery API in the trigger and what I'm running into is no matter what I do, it appears the format of the phone is returned in the query, not just the value of the actual phone number. Is this something that can be accomplished? Forcing the format via code is unreliable as it doesn't get applied until leave of the phone field and many of the records we are trying to evaluate are created via import.
Any suggestions would be greatly appreciated.
Could you please try this? The following code get the phone value without special symbols.
var originalPhonenumber=rbv_api.selectQuery("SELECT phoneField FROM ABC where name='xyz'",10);
var phoneNumber= originalPhonenumber.replaceAll("[^0-9]", "");