Jump to content

LittleMsGinger

Caspio Rockstar
  • Posts

    338
  • Joined

  • Last visited

  • Days Won

    20

Everything posted by LittleMsGinger

  1. For more reference, here's the link to the list of available formula: https://howto.caspio.com/function-reference/
  2. Hello! For additional information regarding formula, you can check this link: https://howto.caspio.com/function-reference/
  3. In addition, here's the link to Function Reference: https://howto.caspio.com/function-reference/. You may see here the list of available formula.
  4. 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/
  5. 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!
  6. For the list of formula available in Caspio, you may check this article: https://howto.caspio.com/function-reference/
  7. 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!
  8. 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!
  9. 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!
  10. 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!
  11. 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.
  12. 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!
  13. 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.
  14. 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/
  15. For more details, you can check this function reference: https://howto.caspio.com/function-reference/
  16. 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/
  17. You can actually receive parameter in Inline Add function. The form element must be Hidden.
  18. 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:
  19. 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.
  20. 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.
  21. For more details on how to add logout link, please refer to these links: https://howto.caspio.com/authentications-and-connections/authentication/logout-link/
  22. Make sure that Enable cross app login is enabled in the Authentication. Also, deployment codes must be the same for all the deployed DataPages. Since Caspio Release 8.5, they highly recommends enabling Account Subdomains. It is best to redeploy all existing Caspio DataPages to avoid a mix of old and new deployment codes in your applications. Mixed deployment codes can cause usability issues such as preventing cross-app logins. For more details, please check this link: https://howto.caspio.com/deployment/caspio-site-vs-account-subdomain-deployment/
  23. To filter the report and only see all the members under who logs in to the DataPage, you need to apply Record Level Security. For more details, here's the article that you may check: https://howto.caspio.com/authentications-and-connections/authentication/record-level-security/record-level-security/
  24. Hi @Joemac, just to verify, you would like to use two views as the Data Source of one DataPage? If that is correct, unfortunately, it s not possible. You can only select one Table or View as a Data Source. You can just combine the Tables to create one View and use it in the DataPage. Hope this helps!
  25. Here's the sample Tasks that you can create This will update every record in the Table and it will run every day. As best practice, you can try this first in a Test Table or have a back up of your Tables.
×
×
  • Create New...