Jump to content

IamNatoyThatLovesYou

Caspio Ninja
  • Posts

    82
  • Joined

  • Last visited

  • Days Won

    1

Everything posted by IamNatoyThatLovesYou

  1. Hello Everyone,! Just an update: Caspio has finally released a feature to show DISTINCT records on Reports (Tabular/List/Gallery). It is available in R30 version. You can check it here.
  2. Hello Everyone,! Just an update: Caspio has finally released a feature to show DISTINCT records on Reports (Tabular/List/Gallery). It is available in R30 version. You can check it here.
  3. Hello Everyone,! Just an update: Caspio has finally released a feature to show DISTINCT records on Reports (Tabular/List/Gallery). It is available in R30 version. You can check it here.
  4. Hello Everyone! Just to add, if the file was submitted before and you just want to see the file when logged in, you can try using RLS on your reports. https://howto.caspio.com/authentications-and-connections/authentication/record-level-security/record-level-security/
  5. Hello everyone! I also checked that Caspio has documentation related to this. https://howto.caspio.com/tech-tips-and-articles/advanced-customizations/how-to-dynamically-change-the-background-of-a-results-page/
  6. Hello! You can also try passing the parameter via query string to get the specific id. You can refer to this documentation. https://howto.caspio.com/parameters/parameters-as-query-string-values/
  7. Hello everyone! I saw this forum post that can also be of help.
  8. You may also refer to this documentation for more information. https://howto.caspio.com/datapages/reports/interactive-reporting-options/?_ga=2.19117051.257110338.1637533393-1670990073.1637533393
  9. Hello everyone! Just to add more information, if you are using a reports datapage and want to download the resultsas csv or excel, you can just go to the Advanced tab of the Search and Report Wizard - Results Page Options and select it. Hope this helps.
  10. Hello everyone, if you have based the data to a reports datapage, you can try uploading it there instead of going to your tables. You mag check here for more information.
  11. Hello everyone! Just to add more information, Caspio has logs now for the email if it has been sent or not on their 29.0 release. you may check herefor more information.
  12. Hi everyone! Additionally, you can check here for information regarding FileStor CDN. However, this is not available for all the plans. https://www.caspio.com/pricing/
  13. Just to add more information. You can also check their documentation regarding triggers here and also check their webinars -Natoy
  14. Hello @SuperNam, Triggers can be made for this. You will just need to base it from the checkbox being unchecked from your table. You can check this image for the trigger. -Natoy
  15. Just to add more information. You may also check this link for reference regarding Case Statements. -Natoy
  16. Hello @SuperNam, You can try creating a Formula or calculated value/field then insert the code below. CASE WHEN ( (Month('[@cbParamVirtual1]')) >= 3 ) AND ( (Month('[@cbParamVirtual1]')) <= 5 ) THEN 'Spring' WHEN ( (Month('[@cbParamVirtual1]')) >= 6 ) AND ( (Month('[@cbParamVirtual1]')) <= 8 ) THEN 'Summer' WHEN ( (Month('[@cbParamVirtual1]')) >= 9 ) AND ( (Month('[@cbParamVirtual1]')) <= 11 ) THEN 'Fall' WHEN ( (Month('[@cbParamVirtual1]')) <= 2 ) OR ( (Month('[@cbParamVirtual1]')) = 12 ) THEN 'Winter' END -Natoy
  17. Hello everyone, this documentation may be of help regarding automatically refreshing the datapage. https://howto.caspio.com/faq/reports-datapages/how-to-auto-refresh-a-page/ - Natoy
  18. Hi everyone! To know more regarding the replace function, you can check their documentation here. - Natoy
  19. Hello Every one, you can also check this link for more information regarding the aggregations. https://howto.caspio.com/datapages/reports/advanced-reporting/totals-and-aggregations/ - Natoy
  20. Hello Everyone, just to add information. As mentioned above you can create another DataPage and use an href on where you will insert its deployment code with parameters as a query string. You may refer to their documentation here. - Natoy
  21. Hi everyone, they also have a documentation that you can refer to. You can check it here. -Natoy
  22. That's great. They also have a Documentation for triggers. You can check it here.
  23. Hi @SuperNam, I have here a trigger you can insert to your table that has the checkbox. This will update your table with the status to complete when all of the checkbox related to the id has been checked. I hope this helps! - Natoy
  24. Hi @SuperNam, this is doable if you are going to use a trigger. You will need to have a trigger that runs on update and select the "Send Email". You need it to select the inserted data and join it in the table. You can have a concatenation field for the message and insert a Case When where if the previous values is not equal to the inserted value, show the inserted value. Here is a sample that you can check. You can also refer to this link for reference. -Natoy
×
×
  • Create New...