Jump to content


Caspio Ninja
  • Content Count

  • Joined

  • Last visited

  • Days Won


CoopperBackpack last won the day on July 7

CoopperBackpack had the most liked content!

About CoopperBackpack

  • Rank

Recent Profile Visitors

88 profile views
  1. Hello @ChristopherNORD, As an option, you may apply your custom styles to the th tag to change the view of the table headers. Just add the code at the top of in the message body and render Email as HTML. <style> th { //your custom values for the CSS properties } </style> Screenshot for visualization: In order not to display "Expression1", please replace the Table Variable with the Variable to store the count. In this case, you will receive the count as an integer instead of the table with the title "Expression1" and value below it. Hope this helps.
  2. Hello @BillW, Please try the following code to get the value of the ODE_Labyrinth_Tol field: let tol = document.querySelector('div input[id^="InsertRecordODE_Labyrinth_Tol"]').value; Also, the "style. backgroundColor" property may be overridden with the basic CSS styles on the DataPage. If so, you may try to apply the color to the background property: document.getElementById("InsertRecordODE_Fan_TIR").style.background = 'red'; Feel free to write back if you have questions.
  3. Hello @SteveVZ, You are correct, you need to update the View and DataPage as well. Please note, that when you add new fields to the tables they are not included in the existing View by default. First, you need to edit the View and include these new fields in this View. You may check the "Include field in View" checkbox or the "Include All" checkbox depending on the required list of fields (please see the screenshot ). After that you need to add the new fields on the DataPage as well. The screenshot with the example is below. It`s a Report DataPage. Just move the new field to the Selected Fields to be able to see it on the DataPage. Hope this helps.
  4. Hello, I have a Submission form DataPage , one of the fields is set to the Calculated value. And I need to display the value from this field in the HTML block. How can I achieve this?
  5. Hello @crionsynx, I am afraid, that it is possible to count distinct values on the Pivot Report only in Totals & Aggregations. You may use Custom formula with the SELECT statement. However, it`s possible to filter results only by the fields that are used as Rows on the Pivot Report. For example: Hope this helps.
  6. Hello @vanderLeest, Please try this code: <script type="text/javascript"> document.addEventListener('DataPageReady', function (event) { let title = document.querySelector('#cbParamVirtual2').value; let title1 = document.querySelector('#cbParamVirtual3').value; if (title == title1) { document.querySelector('h4').innerHTML="Add your Invoice"; } else { document.querySelector('h4').innerHTML="Add your Invoice and the Financial Statement Report"; } }); </script> The code should work properly if: 1) you have only one <h4> tag on the DataPage 2) Virtual2 and Virtual3 values are present on the DataPage once it is loaded. Feel free to write back in case you have additional questions.
  7. Hello @techguy, Please try to use difference in days between your date field and timestamp. You may set the timestamp to your timezone. Hope this helps.
  8. Hello @DesiLogi, Please try to use the LIKE operator with '%' wildcards. For example: SELECT COUNT (ItemID)FROM _V_Items Where Assigned_To LIKE '%[@authfield:Users_CID_StaffID]%' Hope this helps.
  9. Hello @techguy, You may automatically place the cursor on the first field of the form using standard Caspio feature. Please refer to this screenshot: Hope this helps.
  10. Hello @hmsmorgan, If you use this statement in the Formula field in the table, please try this formula: CASE WHEN [@field:Date_Created_in_Caspio] BETWEEN CONVERT(datetime, '01/08/2020', 101) AND CONVERT(datetime, '01/12/2020', 101) THEN 'Cycle 1' END This should work if the [@field:Date_Created_in_Caspio] field has Date/Time or Timestamp DataType. Please note that the BETWEEN operator is inclusive: begin and end values are included. Hope this helps.
  11. Hello @ttanemori, Since the formula in the Aggregations has the same logic for Totals and groups, please try this JavaScript code. This code replaces the value in the Total Due with the sum of values that you receive in the groups (in your example it summarizes -1700 and -1300). <script type="text/javascript"> document.addEventListener('DataPageReady', sumGroups); function sumGroups() { const totals = []; document.querySelectorAll("td[class*='cbResultSetGroup1LabelCellNumberDate']").forEach(elem => { totals.push(elem.innerText); }); const result = totals.reduce( (accumulator, currentValue) => parseFloat(accumulator) + parseFloat(currentValue) ); document.querySelector('tr[data-cb-aggregation="Aggregate1"] > .cbResultSetTotalsData').innerText = result; document.removeEventListener('DataPageReady', sumGroups); }; </script> Replace Aggregate1 with the Aggregate2, etc. depending on the number of your Aggregate field. Add this code to the Header section on the "Configure Results Page Fields" screen of your DataPage. Do not forget to disable HTML editor before pasting the code.
  12. Hello @Corpcatalog, Try to add this snippet of code to the Header section of your Submission form: <style> div[class^='cbFormBlock'] { align-self: end; } </style> Do not forget to disable HTML editor before pasting the code. Hope this helps.
  13. Hello @DougH, The easiest way to implement this is the following: 1) Add the HTML block on the Configure Results Page Fields screen of your Report DataPage. 2) In the HTML block place a link to your Submission form DataPage and pass the event ID as a parameter. For example: <a href="https://c1aaa111.caspio.com/dp/9fae7000db8d9f6958d84c15b418?Event_ID=[@field:Event_ID#]">Register for this event</a> 3) On the Submission form DataPage receive the Event_ID parameter. Please replace the [@Event_ID] with you local field name. Hope this helps.
  14. Hello @vanderLeest, I would like to add, that when you click the expand button, you will be able to add a table: It is possible to select the number of columns and rows, adjust border size, alignment, etc. And when the table is added, you may click the right mouse button to have access to the Table and Cell Properties. Using these properties you may style the table as you like.
  15. Hello, I have created a Submission form that has a field to upload files. Is it possible to get the file size and to submit this value to the table? Any help would be greatly appreciated.
  • Create New...