Jump to content


Caspio Ninja
  • Posts

  • Joined

  • Last visited

  • Days Won


Everything posted by GoodBoy

  1. Hi @MarkMayhrai, you might want to check this forum post
  2. Since ampersand (&) is a special character, there is a conflict occurring when you pass a parameter contains ampersand as value in your URL, thus it is getting cut off and the texts after it as well. You may follow the forum post commented by Meekeee to resolves this issue.
  3. Just to add, this workflow works well in standalone Details and Single Record Update DataPages. If you are using it in the Details page from a Results page, I'm afraid the code won't work. However, as a workaround, you may just need to separate the Results Page and Details page and create an HTML block inside the results page that includes the details page URL with the ID parameter on it to pass the data.
  4. Hello! You can just use this article to generate latitude and longitude for your existing records. Just modify the 'InsertRecordFieldName' lines into 'EditRecordFieldName'. Also, please make sure that the field name you used in the table is the same with the inputted in the code. If it is Zip in the table, then it should be Zip in the code as well.
  5. Hello. I have not experienced this behavior since I started using Caspio, but I believe you should try opening a ticket so their support can check your DataPage. ~
  6. Just to add again, it seems that table records can be exported or downloaded as PDF when you use it in a tabular DataPage. I read it here: https://howto.caspio.com/datapages/pdf-download/pdf-download/
  7. I also found this Caspio article about exporting data from tables: https://howto.caspio.com/tables-and-views/exporting-data/
  8. Hi @TimAllison, I believe Caspio tables can only be exported in MS Access, Excel, CSV, and XML formats but not in PDF.
  9. Hello guys! If you are unaware, the PDF feature allows you to set your desired page break every X records.
  10. Hello! Just updating this thread, you can also page break by group when downloading a Report as PDF. Hope this helps!
  11. Hi! Just updating this thread, you can also page break by group when downloading a Report as PDF. Hope this helps!
  12. Hello! If you have collapsible grouping on your Report DataPage and you want to page break it by group when downloading as PDF, then this can be helpful.
  13. GoodBoy

    Page Break By Group

    I believe this is possible by using some JavaScript. You may try the codes below. Header: <script src=https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js> </script> Footer: <script> $( "<div style='clear:both!important;'/></div><div style='page-break-after:always'></div><div style='clear:both!important;'/> </div>").insertBefore( ".cbResultSetGroup1Row:not(:first)" ); </script>
  14. Hello! You may try to create a relationship to achieve that. Here are the links for more information: - https://howto.caspio.com/tables-and-views/relationships/database-relationships/ - https://howto.caspio.com/tables-and-views/relationships/creating-and-managing-relationships/ - https://howto.caspio.com/tables-and-views/relationships/relationship-settings/
  15. Hello! Just to add on this, here is an article about common functions that we can use in Caspio: https://howto.caspio.com/function-reference/ Hope this helps!
  16. Hello! I just want to update this workaround since I have found a way that will show the last submitted record without using any JavaScript. First, delete the existing script I have mentioned in the previous reply. Then, go to the Advanced tab of the Results Page Options window and set the Total Records returned into 1. Then, go to the next window and check this checkbox so that it will automatically skip the results page, and show the details page immediately for the last submitted record. Lastly, save the DataPage. Hope this helps!
  17. Hi @Gigigigi, you may want to check these informative videos as well about triggered actions and tasks. - https://www.caspio.com/webinars/introduction-to-triggered-actions/ -
  18. Hello @BeffreyJezos, I believe the solution in this post might work for you as well.
  19. Additionally, you may refer to this article about SQL Convert: https://www.sqlshack.com/sql-convert-function/
  20. Yes. Convert first your formula into VARCHAR. For example: CONVERT(VARCHAR(255), [@field:Field1] + ' ' + [@field:Field2])
  21. Just updating this thread with these helpful articles about SEO. - https://howto.caspio.com/faq/deployment/seo-deployment/does-seo-deployment-impact-my-data-transfer/ - https://howto.caspio.com/troubleshooting/troubleshooting-search-engine-optimized-seo-deployment/ - https://howto.caspio.com/faq/deployment/seo-deployment/my-website-is-not-coming-up-when-i-search-for-a-keyword/
  22. GoodBoy

    SEO deployment

    Hello! Just want to add these helpful articles from Caspio regarding SEO deployment: - https://howto.caspio.com/faq/deployment/seo-deployment/does-seo-deployment-impact-my-data-transfer/ - https://howto.caspio.com/troubleshooting/troubleshooting-search-engine-optimized-seo-deployment/ - https://howto.caspio.com/faq/deployment/seo-deployment/my-website-is-not-coming-up-when-i-search-for-a-keyword/
  23. Hello. Just want to share these articles about Caspio DataHub. - https://howto.caspio.com/web-services-api/rest-api/older-rest-api-versions/datahub-operations/ - https://howto.caspio.com/faq/scheduled-tasks/do-scheduled-tasks-utilize-data-transfer/
  • Create New...