-
Posts
1,117 -
Joined
-
Last visited
-
Days Won
43
Kurumi last won the day on September 27
Kurumi had the most liked content!
Recent Profile Visitors
The recent visitors block is disabled and is not being shown to other users.
Kurumi's Achievements
-
Convert from one time zone to another time zone
Kurumi replied to Kurumi's topic in AI-Powered GPT Connect
Hi @Heather - Glad it helped! Adding a time zone field and automating the conversion sounds like a smart move It would definitely save a lot of manual adjustments and ensure accuracy across regions. -
Kurumi reacted to a post in a topic: Convert from one time zone to another time zone
-
Heather reacted to a post in a topic: Convert from one time zone to another time zone
-
Kurumi changed their profile photo
-
JolliBeng reacted to a post in a topic: Convert from one time zone to another time zone
-
Here's a sample use case to convert timestamps or Date/Time to another timezone. In this case, convert Pacific Time to Central and Eastern. Central Timezone Request: Convert the following date and time from "[@field:Date_Submitted]" which is Pacific Standard Time (PST) to Central Standard Time (CST). Change to the format of mm/dd/YYYY, HH:MM AM or PM Return only the final result. Result: Eastern Timezone Request: Convert the following date and time from "[@field:Date_Submitted]" which is Pacific Standard Time (PST) to Eastern Standard Time (EST). Change to the format of mm/dd/YYYY, HH:MM AM or PM Return only the final result. Result: Change the 'Date_Submitted' field to your right field name. You may also change the format of the date and time based on your location.
-
As Caspio now offers integration with OpenAI, you can now use extensions to leverage AI to update your data based on a prompt. Here's a sample use case to format phone number fields similar to this Tech Tip: https://howto.caspio.com/tech-tips-and-articles/format-phone-number-in-datapages/ 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://marketplace.caspio.com/extensions/ai-powered-gpt-connect
-
DesiLogi reacted to an answer to a question: Display Time
-
why phone number field is use as text255 data type in triggered action
Kurumi replied to SadAko's question in General Questions
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/ -
Phone number formatting and e-mail validation
Kurumi replied to deemuss's topic in User JavaScript and CSS Discussions
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/ -
Formatting a numbers field
Kurumi replied to DavidBRX's topic in User JavaScript and CSS Discussions
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/ -
Auto format a phone number field javascript
Kurumi replied to mcates's topic in User JavaScript and CSS Discussions
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/ -
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/
- 7 replies
-
- js
- JS: Format Phone Number
-
(and 1 more)
Tagged with:
-
Convert Text Number To Phone Format.
Kurumi replied to perland's topic in User JavaScript and CSS Discussions
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/ -
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/
-
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/
-
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/
-
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/
-
Time stamp duration between records in hrs
Kurumi replied to Sherif's question in Calculations and Aggregations
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 get the total worked hours based on Time In and Time Out fields. Request: Calculate the total working hours for the following time entries: Time In: [@field:Clock_In] Time Out: [@field:Clock_out] The format should be HH:MM Insert 'File a leave' if there are no values in: Time In: [@field:Clock_In] Time Out: [@field:Clock_out] Return only the final result. Result: Change the 'Clock_In' and 'Clock_out' fields to your right field names. To learn more about Extensions, you can check it here: https://howto.caspio.com/integration/extensions/ -
DateDiff Calculation adding hour in error
Kurumi replied to Breee's question in Calculations and Aggregations
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 get the total worked hours based on Time In and Time Out fields. Request: Calculate the total working hours for the following time entries: Time In: [@field:Clock_In] Time Out: [@field:Clock_out] The format should be HH:MM Insert 'File a leave' if there are no values in: Time In: [@field:Clock_In] Time Out: [@field:Clock_out] Return only the final result. Result: Change the 'Clock_In' and 'Clock_out' fields to your right field names. To learn more about Extensions, you can check it here: https://howto.caspio.com/integration/extensions/- 3 replies
-
- time
- calculation
- (and 8 more)