Jump to content


Caspio Ninja
  • Posts

  • Joined

  • Last visited

  • Days Won


Everything posted by Nuke354

  1. <script type = "text/javascript" > var timer = setInterval(function() { //Find if chart exists using rect element every x milliseconds if ($('rect') != null) { //Update Chart UpdateChart(); } }, 500); function UpdateChart() { try { Highcharts.charts[0].update({ xAxis: { reversed: false } } ); //Stop checking clearInterval(timer); } catch (err) { //log errors } }; </script> It seems like the old code is not working for some reason. Here's the new updated code.
  2. Hi @Johan Have you tried deploying the DataPages using a regular HTML page? Do you also have any authentication/redirect in place? A sample link/screenshot may help,
  3. I don't think it will work on Task/Triggers as it requires a valid email address format Perhaps you can use Zapier Integration with Email services. https://zapier.com/apps/categories/email https://zapier.com/apps/caspio-cloud-database/integrations/mailchimp
  4. This HowTo article will also help give you an idea on how passing parameters are used: https://howto.caspio.com/tech-tips-and-articles/tech-parameters/how-to-separate-search-page-and-results-page-into-two-different-webpages/
  5. Have you also tried to enclose the virtual field parameter with single quotes like this? CASE WHEN '[@cbParamVirtual1]' = 'Yes' THEN 1 ELSE 0END
  6. Hello @Johan Is this a Report DataPage? Perhaps you can try this query and add 'target.' prefix to your record fields. Context_AVG_Employees: IsNull((SELECT AVG(Score) FROM Assessment WHERE Company_Size_Employees = target.[@field:Company_Size_Employees]),0) Context_AVG_Revenues: IsNull((SELECT AVG(Score) FROM Assessment WHERE Company_Revenues = target.[@field:Company_Revenues]),0) We usually add 'target.' to make sure we are referencing the current row. You may refer to this article: https://howto.caspio.com/datapages/reports/advanced-reporting/calculations-in-forms-and-reports/
  7. For Pivot Reports, you can use this: <style> form#caspioform { text-align: -webkit-center; } </style>
  8. Hi @aaronfreed May I know what comparison are you using for the Rules? This post may give you some ideas in converting the datatypes:
  9. Perhaps this StackOverflow link may help: https://stackoverflow.com/questions/39331181/how-i-can-keep-the-cursor-in-its-position-in-textarea-after-auto-submitting You may try applying this on a HTML Block/Header and Footer.
  10. Based from my experience, some SQL functions such as DENSE_RANK () are not available within the Caspio Platform. Have you tried using the same OnLoad and OnExit parameters when searching? Perhaps you can give us a sample test DataPage or some screenshots on how you configured it so we can check.
  11. Usually, it means 10k are affected in a single event. For example, if I create a loop that inserts 500 records 10 times on Table A , 500 records 10 times on Table B. We get: 500 x 10 = 5000 500 x 10 = 5000 And we get 10,000 records affected. You can provide a sample trigger so we can check on it.
  12. Hello @mozakuniran These articles may give you some ideas: https://blog.caspio.com/how-caspio-delivers-data-security-and-compliance-across-industries-and-regions/ https://blog.caspio.com/5-data-security-considerations-evaluating-public-cloud-platforms/ https://howto.caspio.com/authentications-and-connections/authentication/authentication/ https://www.caspio.com/dpa/
  13. I would suggest consulting with the Professional Services Team for these kinds of customizations: https://www.caspio.com/services/professional-services/ It also seems like you're using a format similar to an app parameter so I think this is why parameters are being asked on preview (this won't show when deployed).
  14. @ChesCC Have you also tried using Swagger UI to test? https://howto.caspio.com/web-services-api/rest-api/swagger-ui/ I have typed only rows on my end and it is working
  15. <style> .cbFormData { display: flex !important; } </style> Perhaps you can use this CSS code to override the CSS styles for radio buttons.
  16. You can try using an Iframe or force the page to be rendered as desktop: https://stackoverflow.com/questions/36030080/how-to-make-a-responsive-website-render-the-desktop-version-on-a-mobile
  17. Hi Altair you can try this code to iterate though the selected list and append to each field: Here's my table: Here's the code to be added in the Footer: <SCRIPT> document.addEventListener('DataPageReady', assignMultiple); function assignMultiple() { /* You can modify the element ID as needed for x and y via Inspect Element/F12 */ let x=document.getElementById('cbParamVirtual1'); x.multiple=true; x.addEventListener("click", function() { /* You can modify the element ID as needed for y */ let y =document.getElementById('InsertRecordMulti_Email_Input'); y.value =""; var listLength = x.options.length; for(var i=0;i<listLength;i++){ if(x.options[i].selected) y.value = x.options[i].value + ";" + y.value; } }); } </SCRIPT> Sample output: Hope this helps!
  18. Please do note that some requests sent via the API may generate a large amount of data as a response and this can cause a timeout. A value of at least 120 seconds is recommended, but you may need up to 300 seconds (the default HTTP response timeout for most other operations). You may check the following articles for more information on API timeouts: https://help.salesforce.com/articleView?id=000339365&type=1&mode=1 https://stackoverflow.com/questions/47479202/how-to-handle-rest-api-timeout https://www.paypal.com/lv/smarthelp/article/how-do-i-resolve-api-timeout-problems-ts1403
  19. You may use this as a reference: If I use this syntax: { "ListString":"[2,3]" } The Result would be this:
  20. 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>
  21. To further visualize, here's a sample Task
  22. 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/t-sql/functions/cast-and-convert-transact-sql?view=sql-server-ver15
  23. 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
  24. 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.
  • Create New...