Phone number Formatting

[jafranklin77]

Hello Community,

 

I found this link on how to format your phone numbers on a submission form (Step) but i am unable to get it to work? is it still valid? i tried multiple times and check to make sure i copied ir right but still no go. new to Caspio so any help i thank you.

[MayMusic]

In this link, you can find how to refer to an element on different DataPage types

 

[MayMusic]

Are you trying the code on an update form or submission form? the format of the IDs you are referring to on an update/details page is different from submission. What is the link to the page where you have this code on which is throwing an error?

[cheonsa]

Hi @jafranklin77,

 

You may also check the solution provided in this link: 

 

 

Hope this helps. 

 

-kristina

[cheonsa]

Hi @jafranklin77,

 

I found another forum post that is quite similar to your inquiry. You can check it here: 

 

 

Thanks.

 

-kristina

[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]

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

[futurist]

 Hi, you might also want to check this Forum post if you want to enforce the formatting for your phone fields but not make it a require field (allow empty values):

 

 

[wimtracking2]

On 7/8/2022 at 7:55 PM, Kurumi said:

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!

I've implemented these instructions (Enhancing Phone Number Fields With Formatting and Validation - Caspio Online Help) into my update datapage and changed  step 5: in the pasted code, replace InsertRecord prefix with EditRecord. The script works on the initial load of the page. However, after an update has been made and the page is refreshed, the script isn't running. See screenshot of what the field shows upon initial page load versus after the data has been updated.  Anyone else experience this and find a solution?

[CoopperBackpack]

Hello @wimtracking2,

May I know if you use the 'Same form' destination on the Details DataPage? 

[wimtracking2]

Hi @CoopperBackpack- Yes, I am using 'Same Form' as the destination after record update.

[CoopperBackpack]

@wimtracking2, I see, thank you! I encounter the same issue when I use the 'Same form' destination.

For now, I cannot find a solution to resolve the issue. I will continue checking the options and let you know once I find one. 

[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/

 

[ParkLoey]

Hello everyone! For those who are interested in using Extensions, it's available for certain plans:

https://www.caspio.com/pricing/#:~:text=--,Extensions,-Enhance the functionality

But it also can be purchased as an add-on:

https://www.caspio.com/add-on-resources/#:~:text=per 10%2C000 calls-,Extensions actions,-%2415