Need to format ALL phone numbers in SuiteCRM

💬 General Discussion
1

We have a need to have all our entered phone numbers as such 1xxxyyyxxxx We have a new module that works with our Asterisk phone system that will look for the numbers in the system and get the account or contact info. I am pretty sure I can run a sql query to change all the entries that exist, but how can I change the new numbers being added. There are no calculated fields that could do this automatically?

Thanks

2

Use Logic Hook

3

Do you have any example?

5

Here is the documentation on how to implement logic hooks. You can use the before_save and apply the logic.

6

@dtosun, please create new topics in the future instead of posting on old ones.

7