Jump to content


Caspio Ninja
  • Posts

  • Joined

  • Last visited

  • Days Won


Everything posted by GoodBoy

  1. 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/
  2. 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!
  3. 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!
  4. 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/ -
  5. Hello @BeffreyJezos, I believe the solution in this post might work for you as well.
  6. Additionally, you may refer to this article about SQL Convert: https://www.sqlshack.com/sql-convert-function/
  7. Yes. Convert first your formula into VARCHAR. For example: CONVERT(VARCHAR(255), [@field:Field1] + ' ' + [@field:Field2])
  8. 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/
  9. 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/
  10. 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/
  11. Hey! You may try to include this code in your email body: <head> <style> table, th, td { border: 1px solid black !important; } th { text-align: center !important; } td { text-align: left !important; } </style> </head> [@variable:TableName] Don't forget to set the body to HTML first, then click the source button and paste the code. Please note that the <head> tag may be removed or be gone once you re-edit the email body, so you need to put it again if that happens. This works on me. Hope this helps!
  12. Just to add, here is the documentation I use as reference: https://howto.caspio.com/troubleshooting/troubleshooting-notification-emails/
  13. Hello~ I experienced this issue last year and I believe whitelisting my domain name is the best solution for it. Some emails are still delayed, but it is not an issue with Caspio anymore but with the email provider like Gmail. Hope you resolve your issue as well.
  14. Hi! Just to add on this, I have found a documentation containing the list of URL encoded characters that you can use as a reference: https://www.degraeve.com/reference/urlencoding.php
  15. Posted July 28 On 7/28/2021 at 9:41 AM, LittleMsGinger said: Hello! Instead of using script to pass parameter with ampersand, you can just use a simple formula. You need to change the ampersand to URL encoded character. Add Calculated Value/ Calculated field and use: replace('[@field:FIELDNAME]','&','%26') Then, pass this field as parameter instead of the actual field. Lastly, hide this field so it will not be visible in the form. https://howto.caspio.com/tech-tips-and-articles/common-customizations/how-to-hide-fields-in-datapages/ Hope this helps. Expand Hi! Just to add on this, I have found a documentation containing the list of URL encoded characters that you can use as a reference: https://www.degraeve.com/reference/urlencoding.php
  16. Hi! Just to add on this, I have found a documentation containing the list of URL encoded characters that you can use as a reference: URL Encoded Characters (degraeve.com)
  17. Hello @pmcfarlain, This forum thread might help you to achieve that:
  18. Hi @scribblemilk, you might want to try this workaround that I discover. First, create a Tabular DataPage and choose your data source. Filter the report using your Date field and set the comparison type to 'Before Now'. Then, choose the fields for your Results page and paste this script to your Footer. This script will automatically redirect you to details page where you can edit the last submitted record. <script> var bulkEditSubmit = document.querySelector('.cbResultSetActionsLinks[data-cb-name=DetailsLink]'); console.log(bulkEditSubmit); setTimeout( () => { bulkEditSubmit.click(); }); </script> Choose your Date field and sort it in descending order. Set the records per page into 1 only. Lastly, enable the Details page and configure the fields you want to be editable. Also, you have the option to disable the navigation to the next or previous records. Here is a sample DataPage I made: https://c0hcv332.caspio.com/dp/3b43900055adaba2de354b22ad43 I hope this helps!
  19. This article might help as well: https://howto.caspio.com/datapages/reports/advanced-reporting/calculations-in-forms-and-reports/
  20. You need to enclose the Yes and No with single quotes since they are string. For example: CASE WHEN [@field:Sample] = 'DROPSHIP' THEN 'Yes' ELSE 'No' END
  21. You can use radio buttons for the 'Time Spent on Activity' rating but I believe it cannot be inserted in an HTML block.
  22. It is stated under this documentation under the 'Pre-requisites' https://howto.caspio.com/tech-tips-and-articles/tech-parameters/how-to-create-a-one-to-many-relational-datapage/
  23. I guess it is because of the related field set as unique. They should not be unique so you can enable the referential integrity.
  24. Hello! Just to add. Caspio has a new documentation regarding reversing the sort order in charts.
  25. Hello @DDLiving, You may refer to this screenshot to achieve that.
  • Create New...