Jump to content

Nuke354

Caspio Ninja
  • Content Count

    55
  • Joined

  • Last visited

  • Days Won

    4

Nuke354 last won the day on August 28

Nuke354 had the most liked content!

1 Follower

About Nuke354

  • Rank
    Advanced Member

Recent Profile Visitors

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

  1. This article may help you on this: https://howto.caspio.com/web-services-api/rest-api/authenticating-rest/ Please try to use: grant_type=client_credentials&client_id=<Client ID>&client_secret=<Client Secret>
  2. To further visualize, here's a sample Task
  3. Perhaps you can convert the fields to a specific data type like this: CASE WHEN IsNull((CONVERT(FLOAT, [@field:SchoolYearDaysAttended])),0)/(IsNull((CONVERT(FLOAT, [@field:EXC_ABS_CUR])),0)+ IsNull((CONVERT(FLOAT, [@field:UXC_ABS_CUR]])),0)+IsNull((CONVERT(FLOAT, [@field:SchoolYearDaysAttended])),1))> 0.95 THEN 'Excellent' ELSE 'Not Excellent' END CONVERT(FLOAT, [@field:SchoolYearDaysAttended]) This is what I usually do when I encounter data type incompatibility. Hope this works on yours too. For reference, you may want to check this: https://docs.microsoft.com/en-us/sql/
  4. I think a screenshot will help greatly so we can understand more on this. For the calculated subqueries: https://howto.caspio.com/datapages/reports/advanced-reporting/calculations-in-forms-and-reports/ You can also try using a tabular report and see if you're able replicate the same output
  5. Perhaps these links could help. https://www.benmarshall.me/responsive-iframes/ http://www.mograblog.com/2013/02/how-to-make-post-message-support-multi-origins-and-multi-messages.html https://stackoverflow.com/questions/16266474/javascript-listen-for-postmessage-events-from-specific-iframe It will be tricky to implement multiple messages from different iframes instead of one.
  6. Hi @braxwell You can try using this example: https://c0dcd456.caspio.com/dp/ad9b7000f144a76884d34da090ed Virtual4 is dependent on Virtual3. Type in Apple + Pie separately on Virtual1 and Virtual2 <script> document.getElementsByClassName("cbFormTextField")[0].addEventListener("change", function(){ var v1 = document.getElementsByName("cbParamVirtual1")[0]; var v2 = document.getElementsByName("cbParamVirtual2")[0]; var v3 = document.getElementsByName("cbParamVirtual3")[0]; v3.value = v1.value + v2.value; var event = new Event('change'); v3.dispatchEvent(event); }) </scrip
  7. This link might help you with this: https://www.chronoengine.com/forums/posts/t105980/form-submits-on-enter-key-when-using-autocomplete
  8. You can use CSS to style it: You will put this on your header. <style> tspan.highcharts-text-outline { stroke: red !important; } </style> You can also try to modify it via JS using HighChart API Put this on your header: <script src="https://code.jquery.com/jquery-3.2.1.js"></script> <script src="https://code.jquery.com/jquery-migrate-3.0.0.js"></script> Footer: <script type="text/javascript"> jQuery(window).load(function() { Highcharts.charts[0].update({ series: { dataLabels: { style: {
  9. Hi Mitch, perhaps you can use a Trigger/Task to move the un-pivoted data version of the table to another. You can then create a loop to insert records for each column. As of now, the "un-pivot" feature is not available.
  10. Hi @Farnsbarnes, perhaps you can change the zoom level on your browser and see if that helps.
  11. You can modify the chart via JS using HighChart attributes, HighCharts is what Caspio use to generate charts. You just need to add this to your header and footer. (Disable HTML Editor first) Header: <script src="https://code.jquery.com/jquery-3.2.1.js"></script> <script src="https://code.jquery.com/jquery-migrate-3.0.0.js"></script> Footer: <script type="text/javascript"> jQuery(window).load(function () { Highcharts.charts[0].update({ xAxis:{ reversed: false } } ); }
  12. You may want to check this stackoverflow post: https://stackoverflow.com/questions/10626885/passing-data-to-a-bootstrap-modal Are you also deploying this in your HTML page where your DataPages are deployed?
  13. These links might help you on this: Getting the element: Setting up the JS code: https://www.universalwebservices.net/web-programming-resources/javascript/change-input-element-type-using-javascript/
  14. This will need Javascript customization to alert users when they leave an incomplete form. Here's stackoverflow discussions about it: https://stackoverflow.com/questions/11844256/alert-for-unsaved-changes-in-form https://stackoverflow.com/questions/7317273/warn-user-before-leaving-web-page-with-unsaved-changes
×
×
  • Create New...