Sanitizing Numbers?

[mhoppes]

When someone enters a number in Sugar they might try to put it in like (215) 011-9343 or like 215-011-9343 or like (215)-011-9343 or like something else I can't even think of off hand. Is there any way to get Sugar to sanitize the phone number fields and either correct them, or make sure they are in one format or another?

[SamuelAugy]

You have two choice :

1. Add a javascript function in the EditView.php of your module that you call on the save button in the EditView.html. This function have to be inside

   echo <<<EOQ

   and

   EOQ;

   .
2. Add controls in the handleSave function in the xxxxxFormBase.php file

Samuel Augy
Ysance

[mhoppes]

Ok.. but is that upgrade safe? Won't that be erased when an upgrade is done?

[Angel]

You could also use a logic hook to sanitize the number for you before it is committed to the database.

Check out the Wiki for further info on logic hooks: http://www.sugarcrm.com/wiki

The hook would be upgrade safe, but you wouldn't see the result till the record is saved, whereas through javascript, you could do it on the fly. There is an older thread where I posted some code that will do that and others added to it. Searching the forum for "phone formatting" should yield that thread.

[mhoppes]

You could also use a logic hook to sanitize the number for you before it is committed to the database.

Check out the Wiki for further info on logic hooks: http://www.sugarcrm.com/wiki

The hook would be upgrade safe, but you wouldn't see the result till the record is saved, whereas through javascript, you could do it on the fly. There is an older thread where I posted some code that will do that and others added to it. Searching the forum for "phone formatting" should yield that thread.

A logic hook may be the only way to go.. looked at your code.. looks good. but doesn't look upgrade-safe.

[Angel]

Yes, that's correct, any javascript approach would not be upgrade safe.