Jump to content


Caspio Guru
  • Content count

  • Joined

  • Last visited

  • Days Won


Vitalikssssss last won the day on January 22

Vitalikssssss had the most liked content!


About Vitalikssssss

  • Rank
    Advanced Member
  1. System Date in View?

    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
  2. 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
  3. Insert and Update Sums in other Table

    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
  4. (resolved) Disable "Search Again" link button in details page

    Hi JEllington, Have you tried to disable a Search again link in Datapage wizard?
  5. Use Date Criteria to Calculate Sum

    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]
  6. 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.
  7. Date Range Prompt /Filter

    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.
  8. Collapsing Sections

    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.
  9. configuring filter logic for compound logic

    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
  10. Formula field - case statement for file fields

    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
  11. Report Details is not passing on key to new page via hyperlink

    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.
  12. Datapage text input - regex verification

    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
  13. Week number

    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
  14. Triggered action Update for bulk edit

    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.
  15. 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