Jump to content


Caspio Guru
  • Content Count

  • Joined

  • Last visited

  • Days Won


WatashiwaJin last won the day on July 24 2019

WatashiwaJin had the most liked content!

About WatashiwaJin

  • Rank
    Advanced Member

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Hi @ServiceBreez, As I know there is no Grouping feature in the "List DataPage" in a standard way. Here's what I think you can do: Sort the records by the field you want instead, for them to be ordered: Create a multiple List DataPage that is filtered base on your Groupfield (not recommended) Or you can do a custom code(JavaScript) that display the HTML Block below in every first occurrence per/base on GroupField. (If you do this, make sure that the record is sorted as well) I hope the suggestions helps.
  2. Hello @FinTheHuman, Yes, this is possible. You may try this JavaScript code that will get your record's geolocation and PIN it to the Google Map itself. <p><div id="Location"></div></p> <script type="text/javascript" src="https://code.jquery.com/jquery-latest.min.js"></script> <script type="text/javascript"> $("#Location").html('<a href=" '+ 'https://www.google.com.ph/maps/dir/' + '[@field:Latitude],[@field:Longitude]/' + ' " > Get the Coordinate in Google Map </a>'); </script> You can test it out here: https://c1ab
  3. Hi @ServiceBreez, The workaround to use a Text(6400)/Text area field in the Group By on the Tabular Report DataPage is to add a Formula field in your table and convert the Text(6400) field like this: CONVERT (VARCHAR(255), [@field:6400]) And then use that newly added Formula field to Group By your Tabular report. -------- As for the SQL, you can only use the Group By function if you are using SELECT with aggregation. Like this: (SELECT COUNT(ID) FROM TABLENAME GROUP BY DATE) I hope this helps!
  4. Hi @zlii0133 - Just to add in the instruction above, as I know you also need to enable this 2 API option and the billing of the API key: You may also check the attached step-by-step instruction of creating the map mashup. I hope this helps Map Mashup presentation.pdf
  5. Hello @VincenzoCocciolo - Based on what I experinced, you need to call the actual field in the DataSource that you use in the DataPage or a file that is located in the App parameter in order to use it in your HTML image code. So basically, you cannot use the image file that is attached in your authentication parameter. I hope this makes things clear.
  6. Hi @SteveRHC, As I know based on the Caspio's System requirements (https://howto.caspio.com/system-requirements/) you might resolve the issue by doing these steps:
  7. Hi @Carioca -- Just want to inform you that Caspio's SMS feature only supports US & Canada phone number for now. You can check this article and video tutorial for more details: ============ https://blog.caspio.com/tip-sms-notifications-from-caspio-apps/ https://blog.caspio.com/send-automatic-sms-alerts-using-twilio/ ~WatashiwaJin~
  8. You can also try to check this helpful documentation about dates and calculations: https://howto.caspio.com/faq/reports-datapages/calculated-fields-and-datediff-function/ https://howto.caspio.com/datapages/reports/advanced-reporting/totals-and-aggregations/ https://howto.caspio.com/function-reference/
  9. Hi @NeoInJS -- if that is the case then I suggest that you follow these steps: - Add a "Virtual field" that uses "Calculated value" as the form element and paste the formula: CONVERT(DATETIME, (CAST(Month(SysUTCDateTime()) AS VARCHAR) + "/01/" + CAST(Year(SysUTCDateTime()) AS VARCHAR)), 101) - You can also hide the Virtual field -> go to the advance option then check "Hide Field: - Now, we are going to create a script that will get the value form the formula. For us to do that we need to add a "Header and Footer" -> then in the footer paste this code: <scr
  10. Hello @NeoInJS, For you to be able to get the first day of the month, you should use "calculated value" as the form element then paste this formula: CONVERT(DATETIME, (CAST(Month(SysUTCDateTime()) AS VARCHAR) + "/01/" + CAST(Year(SysUTCDateTime()) AS VARCHAR)), 101) I hope this helps. ~WatashiwaJin~
  11. Hey @waltmayo as I know Caspio offers an Expert session that will help you with your issue with scripts or complex functionality. An Expert Session is a 1-hour session that is conducted via screen share by a Caspio Support Engineer. It also has a cost of $250/hr. If you want to continue, just contact Caspio support: https://www.caspio.com/support/
  12. Hi, just to update this post. Here are the new and updated links that you can use and refer: Caspio's Ready-Made-Applications: https://www.caspio.com/apps/
  13. Hi, just to update this post. Here are the new and updated links that you can use and refer: Custom Hide fields in Submission form: https://howto.caspio.com/tech-tips-and-articles/common-customizations/how-to-hide-fields-in-datapages/
  14. Hey @oceaim have you tried to use the "responsive code" in your DataPage? This might solve your issue, check it out: https://howto.caspio.com/tech-tips-and-articles/responsive-datapages-overview/ ~WatashiwaJin~
  15. Hi @TroyPurdue, Please note that you cannot use the Aggregated functions directly in the Formula or Calculated fields: For more information, check this documentation: https://howto.caspio.com/function-reference/ ~WatashiwaJin~
  • Create New...