Jump to content

Vitalikssssss

Caspio Evangelist
  • Content Count

    508
  • Joined

  • Last visited

  • Days Won

    51

Everything posted by Vitalikssssss

  1. Hi @pgjacob, You can create a custom formula within a single aggregation field in order to sum values from two fields. Here is an example: Hope this helps.
  2. Hi @AussieCaspio, You can create a View which will filter your table with promotion based on start and end date. Here is an example of filter: This article might be useful: https://howto.caspio.com/tables-and-views/what-are-views/creating-a-view-to-filter-data/ Regards, vitalikssssss
  3. 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
  4. 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
  5. Hi JEllington, Have you tried to disable a Search again link in Datapage wizard?
  6. 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]
  7. 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.
  8. 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.
  9. 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.
  10. 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
  11. 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
  12. 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.
  13. 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
  14. 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
  15. 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.
  16. 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
  17. 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
  18. 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.
  19. 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.
  20. 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
  21. 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
  22. 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
  23. Hi DesiLogi, You can convert date/time field to a String with the following expression: LEFT(CONVERT(VARCHAR, [@field:Date], 120), 10) Regards, vitalikssssss
  24. 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 = "
  25. Hi brunobonna, You can enabled image re-sizer if you check highlighted checkbox.
×
×
  • Create New...