Enforce Field Formats for Sugar

Field Mask will be your greatest ally in formatting your SugarCRM data. This module improves the reliability of your data and saves time for your whole team by allowing you to use input templates to your information fields (zip code, phone number, etc.).

Free 30 day trial

Try it Now

By clicking you consent to share your profile with the developer

#652 - Optional characters in input mask

Closed General Question created by phil 10 years ago

Please advise how to create an input mask with optional characters in it e.g. a phone number prefix could have between 2 and 4 characters.

If this is not possible then please refund asap as the product does not meet our requirements.

Thanks

Phil

synolia Verified Purchase
10 years ago

Hello Phil,

You can specify optional part with bracket [] like by example: 999 999 9999[-9999]

Best regards,

reply
synolia Verified Purchase
10 years ago

Hello Phil,

Did you have the time to test our proposal ?

Thanks,

reply
- jason
  10 years ago
  
  Email from Phil:
  
  I haven't tried yet but certainly have the confidence now that it will work! Thanks for your follow up .. I'll let you know if it doesn't turn out as we need when I get back to it around the end of the week,
  
  Cheers
  
  Phil
  
  reply
- synolia Verified Purchase
  10 years ago
  
  Thanks Jason and Phill,
  
  We close this case however do not hesitate to back to us if you have any additional question.
  
  Best regards,
  
  reply
phil
10 years ago

Hi Guys - I have just tested and still struggling with this.

I'm trying to load a mask for the E164 international phone number format. Having no success with pattern:+[99]9([99]9)[9]999-[9]999 which is intended to allow optional 2 chars at front of country code, optional 2 chars at front of area code, and then optional chars to allow for 6 or 8 digit local number.

The mask isn't allowing data entry of what I would have thought were legit numbers e.g. +1 415 444 5555 for US or +64 7 888 9999 for NZ Any thoughts on whether I have an error in the mask of if you know of a better way to handle this phone format?

Thanks

Phil

reply
- synolia Verified Purchase
  10 years ago
  
  Hello Phil,
  
  You are right, it's not currently supported in our released version. That is on our features list for a next major release.
  
  Best regards,
  
  reply