Jump to content

JolliBeng

Caspio Guru
  • Content Count

    174
  • Joined

  • Last visited

  • Days Won

    13

Everything posted by JolliBeng

  1. Hi, For future reference, you may check this video on how to build a Job Posting application: ~JolliBeng
  2. Hi, Just to update this post, after the release 19.0, the IsNull() Function in your formula might not work. Using IsNull() in Formula Fields, Calculated Values and Calculated Fields will only accept date/time values for the replacement value. Please see the link below for more details: https://howto.caspio.com/release-notes/caspio-bridge-19-0/19-0-impacted-areas/ ~JolliBeng
  3. The submission form will serve as your search page. You will just need to add virtual fields so that the entered data will not be saved to the table. You may also refer to this article. ~JolliBeng
  4. Hi, I'm assuming that you're unable to sort your report by date because the data type of your field is Text. If that is the case, you'll need to convert it first to a datetime field. Here's a formula that you may use: CONVERT(DATETIME, [@field:], 101) You'll need to add a Formula field first where you can insert the formula provided above. After that, you can now select that Formula field from the Sorting options on your report. ~JolliBeng
  5. JolliBeng

    PDF Report Page

    Hi, Just to add on @AtayBalunbalunan's comment, if you have a copy of your layout saved as a Word document, you can use the Paste from Word option on your HTML block. In that way, you'll be able to print the details with your desired layout. Here's a screenshot: Also, here's the DataPage I created using that workaround. Click this link. ~JolliBeng
  6. Hi, Just to update this post, after the release 19.0, the IsNull() Function in your formula might not work. Using IsNull() in Formula Fields, Calculated Values and Calculated Fields will only accept date/time values for the replacement value. Please see the link below for more details: https://howto.caspio.com/release-notes/caspio-bridge-19-0/19-0-impacted-areas/ ~JolliBeng
  7. Hi @Jorozcorosado, Can you provide some screenshots of your expected output? ~JolliBeng
  8. Hi, You can also follow the steps on this post: Then, change the code to the following: text-transform: uppercase; ~JolliBeng
  9. Hi, You can also add a simple CSS code on your Style to enforce Uppercase in the input fields of your Submission form. You just need to follow these steps: Edit the Style that you are using. On the DataPage Elements, go to Form Details -> Fields Click Source tab, Look for .cbFormTextField and add this code: text-transform: uppercase; ~JolliBeng
  10. Hi, Just to add on @Barbie's comment, here's a useful guideline on SQL functions that are accepted in Caspio: ~JolliBeng
  11. Hi @matstein, If you want to send email to multiple users who meet a certain criteria, yes that is possible. You can add the criteria under your WHERE clause. You may refer to this sample Task: For further information regarding Task, you may click this link. ~JolliBeng
  12. Hi JamesMobiloo, Yes, that is correct. You can use Calculated Fields on Report DataPages. Aside from that, you can also use SQL functions on Calculated values on Submission forms and Triggered Actions on the table level. You may also check the Function Reference document to see the functions that are accepted in Caspio. ~JolliBeng
  13. Hi @SteveT, If you want to add filters, you can add search fields on your Search page and you can also set your form to have the search and results on the same page so you can see the filtered records right-away upon searching. Also, make sure that the logic that you are using is "AND". You may refer to the screenshots below: -JolliBeng
  14. Hi @Role21, Yes, there's a way to do that. You just need to use the following formula on your calculated field: (DATENAME(month, [@field:DATE])) -JolliBeng
  15. Hi, You can also try use the following formulas: To calculate the hours worked: CAST(DATEDIFF(second, [@field:Start_Time],[@field:End_Time]) / 60 / 60 % 24 AS NVARCHAR) +':'+ CAST(DATEDIFF(second, [@field:Start_Time],[@field:End_Time]) / 60 % 60 AS NVARCHAR) For the total hours, insert the following on your aggregation field: CONVERT(varchar(5), DATEADD(minute, SUM([@calcfield:6]), 0), 114) For calc field6: DATEDIFF(minute, [@field:Start_Time],[@field:End_Time]) You may click on this sample DataPage for your reference. Test credentials Email: test@caspio.com Pass: 1234 -JolliBeng
  16. Hi @Role21, This can be done using custom script. <script> if ('[@field:Active]' == 'Yes') { $('.check-[@field:ID]').hide(); } </script> Just change the .check-[@field:ID] to the class name of your button and ID. -JolliBeng
  17. Hi @telly, The solution that @SunakoChan provided is correct. You'll need JavaScript coding to prevent submission. For more details, you may also check this forum post: -JolliBeng
  18. 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
  19. JolliBeng

    Input Time

    This screenshot might also help:
  20. 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
  21. 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
  22. 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
  23. 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
  24. 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
  25. Additional info: You can also configure the content of the DataTip by clicking the Edit button. -JolliBeng
×
×
  • Create New...