sms Formatting a mobile phone number

[LisaMee]

I am wanting to pass a customers mobile phone number to twilio via zapier. However twilio wants it in a very specific format. it needs the country code then the mobile number without the zero.

So my customers will enter the number as 075xxxxxxxx

and i need it as 4475xxxxxxx

can anyone give me the javascript in order to do this? Thanks

[Vitalikssssss]

On 7/18/2017 at 8:25 PM, LisaMee said:

I am wanting to pass a customers mobile phone number to twilio via zapier. However twilio wants it in a very specific format. it needs the country code then the mobile number without the zero.

So my customers will enter the number as 075xxxxxxxx

and i need it as 4475xxxxxxx

can anyone give me the javascript in order to do this? Thanks

Hi LisaMee,

I would suggest using Formula field to modify users input.

Hope this helps.

[RuisiHansamu]

Hello LisaMee, I am not quite sure if this could be helpful since you wanted to format the numbers. I suggest you take a look at these articles provided by Caspio. 

https://howto.caspio.com/localizations/formatting-options/

https://howto.caspio.com/faq/caspio-bridge-8-4/different-formatting-when-using-field-parameter/

 

[PotatoMato]

Hi @LisaMee, you can also refer to this Caspio forum post: 

Hope it helps.

-Potato

[NailDyanC]

Hi, just to add in the previous comments above, phone formatting is also possible using calculated fields, calculated values or even in Formula fields.  You may use this formula:

CASE WHEN
[@field:Phone_Number] != ' '
THEN
'(' + SUBSTRING([@field:Phone_Number], 1, 3) + ') ' + ' ' + SUBSTRING([@field:Phone_Number], 4, 3) + '-' + SUBSTRING([@field:Phone_Number], 7, 4)
ELSE
[@field:Phone_Number]
END

[Kurumi]

Hi! Just an update on this, Caspio has a new Tech Tip called: Format Phone Number in DataPages. You may visit it here: https://howto.caspio.com/tech-tips-and-articles/advanced-customizations/format-phone-number-in-datapages/

Hope it helps!

[Kurumi]

You may also check this post for multiple fields of phone number: 

 

[Kurumi]

Hi All - In relation to Caspio's new feature of Worldwide SMS Notifications, if you would like your input phone number fields to be automatically formatted - you can use the International Telephone Input plugin. This JavaScript plugin is used for entering and validating international telephone numbers. It adds a flag dropdown to any input, detects the user's country, displays a relevant placeholder, and provides formatting/validation methods. To know more of the customization, you can check this link: https://github.com/jackocnr/intl-tel-input

Here's a sample result in DataPage:

After submission in table:

Related articles:

https://howto.caspio.com/notifications/sms-notifications/configuring-the-sms-enabled-countries/
https://howto.caspio.com/release-notes/caspio-32-0/

Hope it helps!

[PotatoMato]

Hi! Just to add, you may also check this article: https://howto.caspio.com/tech-tips-and-articles/enhancing-phone-number-fields-with-formatting-and-validation/

 

-Potato

[NailDyanC]

You can also check this forum post: 

[Kurumi]

Hi! Caspio now offers integration with OpenAI, so you can use extensions to leverage AI to update your data based on a prompt. Here's a sample use case to format phone number fields.

Request:
Change the format of the phone number of "[@field:Phone_Number]" to (XXX)-XXX-XXXX or US format.
Return only the final result.

Result:

Change the 'Phone_Number' field to your right field name.

To learn more about Extensions, you can check it here: https://howto.caspio.com/integration/extensions/