caspio capabilities

[Sam23]

Is Weebly the only web platform that can handle caspio forms other than WordPress? I am finding that Caspio is not compatible with Wix, GoDaddy, Google or any other web page server I can find. 

I am able to post a single page, but cannot pass parameters on anything but Weebly.

Also, am I correct that there is no phone number formatting within Caspio? Such as (999) 999-9999 ? Seems odd. Is this industry standard since foreign phone numbers can have a variable number of digits?

Thanks for the clarification.

Sam

[autonumber]

Hi @Sam23, 

Currently, they are recommending Weebly to handle their forms other than WordPress. For the phone numbers, they don't have this format as their standard feature but you can check this forum post in formatting phone numbers: 

 

[TellMeWhy]

23 hours ago, Sam23 said:

Is Weebly the only web platform that can handle caspio forms other than WordPress? I am finding that Caspio is not compatible with Wix, GoDaddy, Google or any other web page server I can find. 

The others are putting the embedded websites in an iframe container, this prevents the forms from passing the parameters. You can deploy it as iframe, however, it will act independently from the webpage, it will redirect on the iframe only and not the page. Weebly and WordPress does not use these iframe container, I believe Weebly CMS does, but Weebly Website Builder doesn't, I'm not sure.

 

For the Phone Formatting, Caspio's form are extremely simple, but, I guess this is a good feature to do since there are a lot of sources that has the phone formatting for each country anyway. You can create one yourself, tho, through Virtual Fields, your users would just have to input their numbers part by part, and then you can append everything, add the special characters, etc.,  on the actual field (set it to Calculated Value) OR use JavaScript

[Sam23]

Thanks for the info! really helps

Sam

[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

[astroboy]

Hi, if you are still in the process of building your application, I suggest checking this presentation from Caspio regarding the best practices in establishing your table. It was also mentioned in the presentation that numeric values that are never used as numbers such as phone number, social security number, zip code, etc. should always use text (255). You may check the article through this link:

https://howto.caspio.com/tables-and-views/table-and-database-design/

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

[Kurumi]

Hi! You may also check this new post about automatic formatting of SSN/Security Social Numbers in DataPages: