Jump to content


Caspio Guru
  • Content Count

  • Joined

  • Last visited

  • Days Won


WatashiwaJin last won the day on April 15

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 @FinTheHuman, I have found a workaround to accomplish this without using JavaScript. But in this process, you need to disable the "AJAX Loading" of the DataPage. On this workaround, we will call the CSS inside the formula in order for us to do the conditioning. You can try the following steps : Step 1: Add a Virtual field in the search form that will identify the column(s) to hide. (Recomend: Dropdown) Like this: Note: (I use (1, 2, 3, etc.) as value to simplify the conditioning in the next steps ) Step 2: In the Advance option, pass the parameter of the virtual field
  2. Hi @FinTheHuman, You may try checking this article for hiding a column in the tabular DataPage. As for the hiding it conditionally, it needs use a JavaScript code to accomplish. But let me check if there is a workaround for this
  3. Hello @ServiceBreez, Sorry for the delay, please check the steps below regarding to the 3rd suggestion: Important Field(s) to accomplish this: ID (Autonumber) GroupField (Text255) The idea here is to display the Group field in every first occurance of the group in the report, using a Calculated field and HTML. Step 1: Create a table containing the mentioned fields Step 2: Create a List DataPage and use the table. Step 3: Add a HTML Block, that will display the GroupField Like this: <h3 style="background: rgb(238, 238, 238); border: 1px so
  4. Hi @sbrown106 - You can also check this techtips tutorial about creating a different navigational menu: https://howto.caspio.com/tech-tips-and-articles/advanced-customizations/create-tabbed-navigation-for-multiple-datapages/ https://howto.caspio.com/tech-tips-and-articles/advanced-customizations/tech-tip-creating-a-floating-navigation-menu/ I hope this helps
  5. Thank you @ServiceBreez What I suggesting in the second part is "Multiple DataPage on a WebPage" (This is not recommended because it will cause you a lot of DataPage depending on your Group(s)) but if you want to do this, you need to do a seperate search and report DataPage (https://howto.caspio.com/tech-tips-and-articles/tech-parameters/how-to-separate-search-page-and-results-page-into-two-different-webpages/) and alter the system message "No Records found" so when you search for a specific group, that message won't appear in the other DataPage. Check here on how to change it: https://f
  6. 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.
  7. 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
  8. 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!
  9. 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
  10. 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.
  11. 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:
  12. 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~
  13. 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/
  14. 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
  15. 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~
  • Create New...