How to handle country codes

[ActraiserVII]

Good day,

I've searched the forums exhaustively, and have yet to find a solution to what I want to do. I want to find a way to use a dropdown to append a country code to the beginning of the phone number field. I'm completely open to accomplishing this by any means. Whether the dropdown be Javascript, or built with Sugar.

I'm fairly novice, so any help or input would be appreciated very much.

Thank you.

EDIT: Also, I am using Sugar CE 5.5.1 with PHP 5.2.10 and MySQL 5.1.37.

[kbrill]

Is this dropdown to be automated in any way? If not then just create a dropdown custom field in studio and add a list of codes to it.

[ActraiserVII]

Is this dropdown to be automated in any way? If not then just create a dropdown custom field in studio and add a list of codes to it.

I want the dropdown to append a value to the beginning of the phone number field. For example, if I made the dropdown in Studio, I would have a dropdown list where the "display label" would be a country, and the "item name" would be a code. So if I selected Tanzania, it would append 255 to the beginning of what is already in the phone number field. It is important that the country code and the rest of the phone number are kept in the same field.

Thanks for your response!

[christianknoll]

You will have to create a custom field type. We typically do exactly what you are asking for and have this in our standard template. The whole thing is not very tricky but will require some php skills as well as a decnet understanding on sugarcrm.

regards, christian.

I want the dropdown to append a value to the beginning of the phone number field. For example, if I made the dropdown in Studio, I would have a dropdown list where the "display label" would be a country, and the "item name" would be a code. So if I selected Tanzania, it would append 255 to the beginning of what is already in the phone number field. It is important that the country code and the rest of the phone number are kept in the same field.

Thanks for your response!

[ActraiserVII]

You will have to create a custom field type. We typically do exactly what you are asking for and have this in our standard template. The whole thing is not very tricky but will require some php skills as well as a decnet understanding on sugarcrm.

regards, christian.

Thanks for your response. Are you saying I'll have to create a custom field type for both the dropdown and the phone number field? Or only for one or the other? I assumed I was going to have to use PHP to produce the dropdown. You say "we" and "our standard template", could I have a little more information please?

Thanks again.

[datasponge]

Hi ActraiserVII,

You could convert the country field to a dropdown and write a before_save logic hook to update the phone numbers.

See this thread for how to convert the country field to dropdown.

The logic hook could be simple or complex depending on how much error checking and replacing you want to do. If you keep it simple like:

1. look for a '+' at the start of phone.
2. if missing add + and country code
3. if already a '+', parse to first space and replace old code with new

After that you can get as fancy as you like formatting and fixing the string, adding area codes, etc, but it starts to get complicated.

Of course you will need a table or dropdown that lists all the countries and their country code so you can look them up with a query.

Phil

[ActraiserVII]

Hi ActraiserVII,

You could convert the country field to a dropdown and write a before_save logic hook to update the phone numbers.

See this thread for how to convert the country field to dropdown.

The logic hook could be simple or complex depending on how much error checking and replacing you want to do. If you keep it simple like:

1. look for a '+' at the start of phone.
2. if missing add + and country code
3. if already a '+', parse to first space and replace old code with new

After that you can get as fancy as you like formatting and fixing the string, adding area codes, etc, but it starts to get complicated.

Of course you will need a table or dropdown that lists all the countries and their country code so you can look them up with a query.

Phil

Thanks for your response. I will look into this post. You all have been helpful.