Thursday, November 20, 2008 ..:: Forums ::.. Register  Login
 Forums Minimize
SearchForum Home
     
  Mainstream Forums  Developers  Telephone Numbe...
 Telephone Number Validation
 
AndyBrew
3 posts
Joined
8/28/2008

Telephone Number Validation
Posted: 28 Aug 08 6:32 AM
Hi

We have just started to evaluate the CRM product and have stumbled across our first problem where we do not seem to be able to enter a telephone number into the Account creation form, not a good start LOL!! Anyway I have looked everywhere for the RegExp to allow any format to be entered into the field and have traced a few instances of the code but still no effect.

So is there some setting that I am missing or are UK users not really expected to use the system as is???

Thanks in advance

Andy
support
2098 posts
1st
Joined
1/3/2006

Re: Telephone Number Validation
Posted: 28 Aug 08 1:26 PM

The expressions are stored in the FIELD_VALIDATORS table.  You can use the Admin Layout editor to remove the validation on phone numbers.

The phone number expression was taken from:

-- http://www.regexlib.com/
-- Expression :  ^(?:(?:[\+]?(?<CountryCode>[\d]{1,3}(?:[ ]+|[\-.])))?[(]?(?<AreaCode>[\d]{3})[\-/)]?(?:[ ]+)?)?(?<Number>[a-zA-Z2-9][a-zA-Z0-9 \-.]{6,})(?:(?:[ ]+|[xX]|(i:ext[\.]?)){1,2}(?<Ext>[\d]{1,5}))?$
-- Description:  This allows the formatting of most phone numbers.
-- Matches    :  [1-800-DISCOVER], [(610) 310-5555 x5555], [533-1123]
-- Non-Matches:  [1 533-1123], [553334], [66/12343]

AndyBrew
3 posts
Joined
8/28/2008

Re: Telephone Number Validation
Posted: 29 Aug 08 1:44 AM Modified By AndyBrew  on 8/29/2008 1:45:01 AM)

Hi

Many thanks for that I have removed the RegExp from the FIELD_VALIDATORS table and it now works, incidentally the phone number that I was trying to enter was 01604 686736 for your reference.

I did find the layout editor but I could not see anywhere that I could amend the RegExp, had another look and still can't???

Anyway first hurdle over onwards and upwards, first impressions the product looks great :)

Regards

Andy

  Mainstream Forums  Developers  Telephone Numbe...

Forum Home  Search       

Copyright (c) 2006-2008 SplendidCRM Software, Inc. All Rights Reserved.   Terms Of Use  Privacy Statement
DotNetNuke® is copyright 2002-2008 by Perpetual Motion Interactive Systems Inc.
SplendidCRM and SplendidCRM Software are trademarks of SplendidCRM Software, Inc. SugarCRM is a trademark of SugarCRM Inc. in the United States, the European Union and other countries. All other trademarks used in this web site are the property of their respective owners.