LittleMsGinger

For more reference, here's the link to the list of available formula: https://howto.caspio.com/function-reference/

Hello! For additional information regarding formula, you can check this link: https://howto.caspio.com/function-reference/

In addition, here's the link to Function Reference: https://howto.caspio.com/function-reference/. You may see here the list of available formula.

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/

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!

For the list of formula available in Caspio, you may check this article: https://howto.caspio.com/function-reference/

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!

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!

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!

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!

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.

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!

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.

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/

For more details, you can check this function reference: https://howto.caspio.com/function-reference/