JolliBeng

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

This screenshot might also help:

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

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

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

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

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

Additional info: You can also configure the content of the DataTip by clicking the Edit button. -JolliBeng

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

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

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

Hi @joneslovescaspio, You may refer to this sample Task: Then, configure it to run on your preferred time: -JolliBeng

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

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

Hi, You can also modify the Styles using Source Code, you just need to click the "Source" tab. -JolliBeng