Jump to content


Caspio Guru
  • Content Count

  • Joined

  • Last visited

  • Days Won


JolliBeng last won the day on July 7

JolliBeng had the most liked content!

About JolliBeng

  • Rank
    Advanced Member

Recent Profile Visitors

318 profile views
  1. Hi @TMeyer, You can hide the chart when there are no records found, using JavaScript. You need to add a Header& Footer and you can use the following code: For the Header: <div class="chart-container"> For the Footer: </div> <script type="text/javascript"> document.addEventListener('DataPageReady', function (event) { if (document.getElementsByClassName("highcharts-no-data").length > 0) { document.getElementsByClassName("chart-container")[0].style.display = "none"; } }); </script> -JolliBeng
  2. JolliBeng

    Input Time

    This screenshot might also help:
  3. JolliBeng

    Input Time

    I see. You can enable the data grouping per your date field then show the totals per group. Data Grouping:https://howto.caspio.com/datapages/reports/advanced-reporting/data-grouping/ -JolliBeng
  4. JolliBeng

    Input Time

    You can use Totals and Aggregations to calculate the total number of hours. https://howto.caspio.com/datapages/reports/advanced-reporting/totals-and-aggregations/ -JolliBeng
  5. JolliBeng

    Input Time

    HI @Role21, The DateDiff formula will not work on Formula fields, because formula fields do not accept SQL subqueries. If you want to download the records as an excel file, you can do that via report DataPage. You just need to enable the download options as Excel. It will also include the values from calculated fields. You may check this sample Report. -JolliBeng
  6. JolliBeng

    Input Time

    Hi @Role21, You can do that using a DateDiff function. You need to use a Calculated Field on your report and enter the following formula: (Datediff(MINUTE,[@field:Start_Time],[@field:End_Time])) /60 -JolliBeng
  7. JolliBeng

    Input Time

    Hi @Role21, Yes, Caspio does not have a time picker option. What you can do is separate the input fields for your date and time fields. That will require some javaScript, you may refer to this Tech Tip for more details. You may also check this sample Time Sheet Web Form. -JolliBeng
  8. Additional info: You can also configure the content of the DataTip by clicking the Edit button. -JolliBeng
  9. Hi @Role21, Yes, there is a way to do that. You can set that under the Configure Chart Options -> Values (X Axis) and change the Value Label to Both. -JolliBeng
  10. Hi, To be more familiarized with Caspio's charts, you may check the Feedback Management Ready-Made Application for reference. It contains different types of charts. -JolliBeng
  11. JolliBeng


    Hi @Role21, You can achieve that by deploying your report DataPage as an iFrame, then deploy it the footer of your Submission Form. Set the Destination of your Submission form to "Same Form" and disable the AJAX loading. The output should look like this: -JolliBeng
  12. Hi @joneslovescaspio, You may refer to this sample Task: Then, configure it to run on your preferred time: -JolliBeng
  13. Hi @Batchini, You can also modify the background color of the button without entering a source code. You may refer to the screenshot below: -JolliBeng
  14. Hi @Elderberg, You can change the font of your HTML block under the HTML editor. You may refer to this screenshot: Then, choose the font that matches the font of your fields/labels, which you may see on your Styles: -JolliBeng
  15. Hi, You can also modify the Styles using Source Code, you just need to click the "Source" tab. -JolliBeng
  • Create New...