Jump to content


Caspio Rockstar
  • Posts

  • Joined

  • Last visited

  • Days Won


Everything posted by LittleMsGinger

  1. For additional details about SQL functions, check out this article: https://howto.caspio.com/function-reference/
  2. In addition to the previous comments, here's a video tutorial on how to create Conditional Forms Using Caspio.
  3. Hello! In addition to the previous comment, here are the helpful articles regarding Triggered Actions and Tasks. https://howto.caspio.com/tables-and-views/triggered-actions/ https://howto.caspio.com/tasks/
  4. Hi all, With the current features of Caspio, you now have an option to Update the data on your Table from your file. Please refer to this link: https://howto.caspio.com/tables-and-views/importing-data/ Hope this helps.
  5. Hello! I just wanted to share with you the best practice and tips in Scheduled Tasks. Please refer to this article: https://howto.caspio.com/tables-and-views/scheduled-import-and-export/scheduled-tasks-datahub/ Hope this helps!
  6. For more reference, here's the link to the list of available formula: https://howto.caspio.com/function-reference/
  7. Hello! For additional information regarding formula, you can check this link: https://howto.caspio.com/function-reference/
  8. In addition, here's the link to Function Reference: https://howto.caspio.com/function-reference/. You may see here the list of available formula.
  9. Hi @EmmePGN, Triggered Actions allow data manipulation, calculations and sending notifications by constructing application logic with a visual interface. They will be executed on specified events to perform actions on data in your tables, either insert, update or delete. Here is a sample Trigger that will insert a record to Table B upon insert in Table A. You may check this link for reference: https://howto.caspio.com/tables-and-views/triggered-actions/
  10. Hi @EmmePGN, Make sure that third party cookie is enabled in your browser. As per Caspio's system requirements, third party cookies should be enabled for you to use the DataPages properly and to remove the popup warning. Check this link for more details: https://howto.caspio.com/system-requirements/ Hope this helps!
  11. For the list of formula available in Caspio, you may check this article: https://howto.caspio.com/function-reference/
  12. In addition, based on the Function Reference, GetUTCDate() is not available in the Formula field. You will get an error if you apply this in the Formula field in the Table. If you are using a Calculated Field/ Calculated Value, then, the formula should work. Cheers!
  13. Hello! Just to update, if [@field:coauthor] is blank, there's another way to hide Coauthor. You can also use SQL Formula instead of script. In Submission Form/ Details, you can add virtual field and use Calculated Value as Form Element. CASE WHEN [@field:coauthor] ='' THEN '' ELSE 'Coauthor:[@field:coauthor]' END Then, you can display the result of this Virtual field in the HTML Block. Hope this helps!
  14. I know this is an old post, but just to update, you can use the following settings in the DataPage to open the Details link in a new window: Hope this helps!
  15. There's a new article in Caspio's Howto Page that contains steps to generate daily reports via Email. You may check this link: https://howto.caspio.com/tech-tips-and-articles/common-customizations/generate-daily-reports-via-email/ You can now directly display a report in a tabular format in your email instead of redirecting your users to a Reports DataPage. This is accomplished through the use of variables. There are two types of variables available in Tasks and Triggered Actions. (1) User-defined variables - used to store static values or calculation results. (2) Table variables - used to store a series of records that may then be utilized as the data source for other Action blocks. You can apply the same criteria provided above to filter out the result of the Table Variable. Hope this helps!
  16. You can also insert the code directly into the DataPage. Go straight to "Configure Fields for Bulk Edit", add Header/Footer and disable HTML Editor in the Header before pasting the CSS code.
  17. Hello! To add to the previous response, instead of updating the Style, you can add some CSS directly to the DataPage if you only want to make the modifications to a particular DataPage. Below is the sample code that you can use: <style> th[class*="cbResultSetHeaderCell"] { text-align:center !important; } td[class*="cbResultSetData"] { text-align:center !important; } </style> Hope this helps!
  18. Hi all, According to my experience, the trigger is executed first, followed by the formula field. You can recreate the formula in your Trigger so you can copy and save it to other Table.
  19. Hi @Miguel, Could you perhaps give a screenshot of your View's configuration? You may also check this link on how to create a View: https://howto.caspio.com/tables-and-views/what-are-views/creating-a-view-to-join-tables/
  20. For more details, you can check this function reference: https://howto.caspio.com/function-reference/
  21. You can add a virtual field and set it as Calculated Value. You can have a formula to get the Name or the Display Value depending on the ID selected in the dropdown. Sample Formula: SELECT (NAME) FROM TABLE WHERE ID=target.[@Field:ID] Then, pass this virtual field as parameter. You can also hide this Virtual 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/
  22. You can actually receive parameter in Inline Add function. The form element must be Hidden.
  23. Hi all, Instead of using script to pass parameters with '&', you can just use simple formula to convert or replace it in its corresponding URL encoded character. For more details, you may refer to this post:
  24. 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.
  25. Hello Hayley, You can add a field either Calculated Field or Calculated value to replace '#' in the value to URL encoded character '%23' replace([@field:FIELDNAME],'#','%23') Then, pass this value as parameter. You can also hide this calculation, 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.
  • Create New...