Jump to content


Caspio Evangelist
  • Content Count

  • Joined

  • Last visited

  • Days Won


Everything posted by Vitalikssssss

  1. Hi roattw, You should place each report within single CB in Squarespace and paste the script from the article below Datapages deploy code. This should resolve the issue. Regards, @Vitalikssssss
  2. Hi emarchewka, You can create a Tabular Report Datapage based Table B and add Calculated fields with SQL expression which will sum scores from Table A. Here is an example of SQL expression to sum values from score table: SELECT SUM(Score) FROM Table_A WHERE Company_ID = target.[@field:Company_ID] AND Reporting_Period = target.[@field:Reporting_Period] You can find more information about Calculated field SQL usage in this article. Regards, @Vitalikssssss
  3. Hi JEllington, Have you tried to disable a Search again link in Datapage wizard?
  4. Hi TippyTV2018, I can suggest creating a View based on UserTips2 table in order to filter records based on current month. You can reference the View in your SQL query in order to aggregate total of itemamount for the user. The following syntax can be used to reference a view: _v_viewname Here is an example of SQL query: SELECT Sum(My_table_Sales) FROM _v_Current_month WHERE My_table_Sale_rep = target.[@field:Sales_rep]
  5. Hi roattw, What kind of datapage do you use and what kind of form element have you assigned to the field in which you would like to display default value? This code works fine for submission form with default value assigned to a dropdown. <script type="text/javascript"> function f_default(){ document.getElementById("InsertRecordField_name").value = "Default"; } document.addEventListener('DataPageReady', function (event) { f_default(); }); </script> Hope this helps.
  6. Hi Bill, Have you tried adding criteria to your date field? This article shows how you can use criteria in order to filter date field by range: https://howto.caspio.com/faq/reports-datapages/how-to-add-today-to-after-now-or-next-x-days-criteria/ Hope this helps.
  7. Hi Corey, There is a standard feature in Caspio called "Conditional Rules" which allows you to create collapsible sections without Javascript. Here is an article and video: https://howto.caspio.com/datapages/forms/conditional-forms/ https://www.youtube.com/watch?v=T_Ivf-oqiQg Hope this helps.
  8. Hi renpar218, You should place Cond-C /Cond-D /Cond-E within the OR block to resolve the issue. Please refer to attached screenshot for further information: Regards, @Vitalikssssss
  9. Hi Carlson, You can create desired formula field expression if you convert field datatype to varchar text type. Here is an example: CASE WHEN Len(CAST ([@field:File_field] AS varchar)) > 1 THEN 'Not empty' ELSE 'Empty' END Hope this helps. Regards, Vitalikssssss
  10. Hi jnordstrand, Make sure that you have disabled HTML editor before inserting URL link to the details page. https://howto.caspio.com/faq/caspio-bridge-8-4/inserting-code-in-html-blocks-and-header-footer/ Hope this helps.
  11. Hi PdeVIT, You can put Javascript with regex expression in the Footer of the datapage. This topic explains how you can reference various datapage form elements in Javascript. https://forums.caspio.com/forum/49-caspio-javascript-solutions/ Also, do not forget to disable HTML editor before pasting the code: https://howto.caspio.com/faq/caspio-bridge-8-4/inserting-code-in-html-blocks-and-header-footer/ Regards, vitalikssssss
  12. Hi MHDslagelse, Please note that Datepart(week) function is not supported in Formula field because it is non- deterministic. You may use the workaround described in this post . Regards, vitalikssssss
  13. Hi bookish, Please note that bulk edit is treated as a single update event in Triggered Action as you have already discovered. I would suggest using COUNT expression in order to count the number of records updated with a bulk edit and add this value to existing value from SCHEDULES table. So, you Triggered Action will look similar to this one: Hope this helps.
  14. Hi geoffdude, You may try to use a method described in this topic in order to pass an external parameter to the iframe. Please note that your iframe source should have the same domain address as your web-page. Hope this helps. regards, vitalikssssss
  15. Hi geoffdude, I know that onload event in no longer supported in Caspio after 10.0 release because of restriction applied by new deployment method. https://howto.caspio.com/release-notes/caspio-bridge-10-0/ A workaround solution described at the bottom of this article: https://howto.caspio.com/deployment/ Regards, vitalikssssss
  16. Hi telepet, You can hide cascading fields from a user with HTML blocks. You may refer to this article for further information: https://howto.caspio.com/tech-tips-and-articles/common-customizations/how-to-hide-fields-in-datapages/ Hope this helps.
  17. Hi cpcbsa, I believe that you can achieve the desired layout of the report with a simple SQL expression which you should place in the calculated field. You may find some SQL examples in this article: https://howto.caspio.com/datapages/reports/advanced-reporting/calculations-in-forms-and-reports/ Alternatively, you may try to use Triggered Action to update a field in information table based on information from transaction table. https://howto.caspio.com/tables-and-views/triggered-actions/ Hope this helps.
  18. Hi AdamS, I am afraid that you cannot pass Total & Aggregation field value. I would recommend using calculated field with SQL expression in order to display table sum value in Datapage which has a different datasource table. Here is an example of SQL expression: SELECT SUM(Sales) FROM Sales_By_Region_TBL WHERE SaleRep_ID = target.[@field:SaleRep_ID] Hope this helps. Regards, vitalikssssss
  19. Hi AdamS, You can set the authentication advanced setting called "Login redirection on success" to the "Same form" if you would like the user to remain on the same page which initiated the login. Regards, vitalikssssss
  20. Hi ChristineM, I suppose that you have forgotten to press "Source" button in HTML editor before inserting the code. The issue described in this article: https://howto.caspio.com/faq/caspio-bridge-8-4/inserting-code-in-html-blocks-and-header-footer/ Regards, Vitalikssssss
  21. Hi DesiLogi, You can convert date/time field to a String with the following expression: LEFT(CONVERT(VARCHAR, [@field:Date], 120), 10) Regards, vitalikssssss
  22. Hi everyone, I have revised the initial Javascript solution so it could meet the requirements of recent Asynchronous deployment method which do not support window.onload() event. <iframe id="iframe_pdf" style="width:80%; height: 1100px; display: none;" align="middle" frameborder="0"></iframe> <script> document.addEventListener('DataPageReady', function (event){ if(!("[@field:Document/]" == "")){ embed_pdf(); } }); function embed_pdf(){ var google_link= "https://docs.google.com/gview?url="; var google_param = "
  23. Hi brunobonna, You can enabled image re-sizer if you check highlighted checkbox.
  24. Hi stansmith12345, A screenshot of your existing Trigger will help to understand the source of an issue.
  25. Hi wdandrews, You can use Record-Level-Security to restrict options list in the drop-down if your Datapage is authenticated. https://howto.caspio.com/authentications-and-connections/authentication/record-level-security/filter-lookup-dropdown-or-listbox-based-on-user-or-role/ Hope this help.
  • Create New...