Jump to content

Nuke354

Caspio Ninja
  • Content Count

    71
  • Joined

  • Last visited

  • Days Won

    4

Nuke354 last won the day on August 28 2020

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 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/
  2. Have you also tried to enclose the virtual field parameter with single quotes like this? CASE WHEN '[@cbParamVirtual1]' = 'Yes' THEN 1 ELSE 0END
  3. 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-report
  4. For Pivot Reports, you can use this: <style> form#caspioform { text-align: -webkit-center; } </style>
  5. Hi @aaronfreed May I know what comparison are you using for the Rules? This post may give you some ideas in converting the datatypes:
  6. 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.
  7. 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.
  8. 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.
  9. 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/
  10. 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).
  11. @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
  12. <style> .cbFormData { display: flex !important; } </style> Perhaps you can use this CSS code to override the CSS styles for radio buttons.
  13. 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
  14. 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
  15. 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
×
×
  • Create New...