work flow to manipulate phone number

💬 General Discussion
1

we have a phone field, when users are filling it in, they are using the national format : 01234 555555 but we need it in international format +44 1234 555555 for our click to dial code to work.

I can create the logic in work flows, on new or modified record, if number starts with a 0 then …

This is the bit i am stuck on, Is there any option to modify a field? So remove the first digit and add +44 ?

I can do this in mysql, but not sure how to get this to run on only newly created or edited records.

Any help would be great.

Thanks

Version 7.10.7
Sugar Version 6.5.25 (Build 344)

2

I think you need to use Calculated Fields, have a look in the Docs under that section.

You’ll have to try and see if you can make it work for your case.