Jump to content


Caspio Rockstar
  • Content Count

  • Joined

  • Last visited

  • Days Won


Everything posted by Vitalikssssss

  1. Hi @JSLane, It is doable in Caspio. You should use separate form (Submission Form Datapage) which passes a parameter to the Report Datapage. The trick here is that you will have multiple fields in report datapage which receive a single parameter. This concept described in the following article: https://howto.caspio.com/faq/reports-datapages/how-to-do-keyword-search-across-multiple-fields/ I would also suggest watching the following tutorial video which explains how to pass parameters between separate form embedded on single web-page. https://www.youtube.com/watch?v=K3CKFjuSIt4 Hope this helps. Regards, vitalikssssss
  2. Hi @DTINVN, I am afraid that you cannot use SQL in HTML blocks. SQL code can be only used in Calculated values\fields. I would recommend using a JS code in order to achieve described behavior. 1. Add the following code into HTML block: <p id="[@cbRecordIndex#]"></p> 2. Add the following JS into Datapage Footer: <script type="text/javascript"> document.addEventListener('DataPageReady', function (event) { let el = document.querySelectorAll('td>p'); let par = '[@BU]'; el.forEach(element => { if(par=='8') element.innerHTML = '<span month_year="[@field:Month_Year*]" sub_type="[@field:Function_Subtype#]">[@field:MPBU_HC]</span>'; else if (par=='6') element.innerHTML = '<span month_year="[@field:Month_Year*]" sub_type="[@field:Function_Subtype#]">[@field:MicBU_HC]</span>'; else element.innerHTML = '0'; }); }); </script> Please make sure that you disable HTML editor before inserting the code. Regards, vitalikssssss
  3. Hi @guardmetrics, Formula field performs calculation within a record and it cannot be used for cross table calculation. You should consider using Calculated fields on Report/Details datapages with SQL in order to perform cross-table calculation. Here is an article which explains how to use SQL in Calculated fields: https://howto.caspio.com/datapages/reports/advanced-reporting/calculations-in-forms-and-reports/ You may use Task/Triggered action feature if you would like to store value of cross-table calculation on table level. Here is an article: https://howto.caspio.com/tables-and-views/triggered-actions/ Hope this helps. Regards, vitalikssssss
  4. @kpcollier, You can use the following JS code if you decide to use a custom code. <script type="text/javascript"> function calculate() { var subTotal = isNaN(parseFloat(document.getElementById("InsertRecordSubtotal").value)) ? 0 : parseFloat(document.getElementById("InsertRecordSubtotal").value); var markUp = isNaN(parseFloat(document.getElementById("InsertRecordMarkUp").value)) ? 0 : parseFloat(document.getElementById("InsertRecordMarkUp").value) ; var countyTax = isNaN(parseFloat(document.getElementById("InsertRecordCounty_Tax").value)) ? 0 : parseFloat(document.getElementById("InsertRecordCounty_Tax").value); var miscPerc = isNaN(parseFloat(document.getElementById("InsertRecordMisc_Percent").value)) ? 0 : parseFloat(document.getElementById("InsertRecordMisc_Percent").value); var freight = isNaN(parseFloat(document.getElementById("InsertRecordFreight_Total").value)) ? 0 : parseFloat(document.getElementById("InsertRecordFreight_Total").value); var markUpTotal = document.getElementById("InsertRecordMarkUp_Total").value = (subTotal) * (markUp); var countyTaxTotal = document.getElementById("InsertRecordCountyTax_Total").value = (subTotal) * (countyTax); var miscPercTotal = document.getElementById("InsertRecordMisc_Percent_Total").value = (subTotal) * (miscPerc); document.getElementById("cbParamVirtual1").value = (subTotal) + (markUpTotal) + (countyTaxTotal) + (miscPercTotal) + (freight); } setInterval(calculate, 1500); </script> Regards, vitalikssssss
  5. Hi @kpcollier, Why do not you use Calculated value to perform such calculation? You can use isNull function in Calculated value in order to replace null with zero. IsNull([@field:Number], -0) Hope this helps. Regards, vitalikssssss
  6. Hi @BFuchs No, user will be routed automatically to the Submission Form. User does not have to click second time. I doubt that it will be possible. You may customize Tabular report with inline insert, however it will require some sophisticated JS code to cover all possible scenarios. Regards, vitalikssssss
  7. Hi @BFuchs, I can suggest the following: 1. Create Details/Single record update DP and use it as a link in on your another datapage. 2. Don`t forget to put a parameter (unique identifier of a record) at the end of link. 3. Create a Submission DP to submit a record. 4. Create a new Localization with a simple JS i.o. "No records found" message. Hope this helps. Regards, vitalikssssss
  8. This might help: https://howto.caspio.com/tech-tips-and-articles/common-customizations/separate-input-fields-for-datetime-parts/ Regards, vitalikssssss
  9. Hi @roattw, You can use the following expression in Caspio: CASE WHEN Len([@field:YOUR_FILED]) =3 THEN Left([@field:Text],1) +':'+Right([@field:Text],2) WHEN Len([@field:YOUR_FILED]) > 3 THEN Left([@field:Text],2) +':'+Right([@field:Text],2) END Hope this helps. Regards, vitalikssssss
  10. Hi @AmyBelote, You are right, List_string datatype is not supported in advanced features like Calculated field, Triggered action or Tasks. There is a feature request in Caspio IdeaBox: Link As a workaround, you may export/import your table with List - String field as into Text(255) field in order to have a string with comma delimited values. Hope this helps. Regards, vitalikssssss
  11. Hi @ssneni, This feature is not available in Triggered Action. Caspio IdeaBox says that this feature is planned for upcoming releases: Using-file-field-in-triggered-actions. You can vote for this idea in order to increase the chance it to be included in next release. Regards, vitalikssssss
  12. Hi @Roosta, Can you send me an exported copy of Datapage along with dependencies or URL of the Datapage? You can use Private messages for sharing exported file. Regards, vitalikssssss
  13. Hi @Roosta, I assume that you see "Error in Formula" because one of the divisor results in zero. You need to add CASE check in order to avoid division by zero. It can look like this: ([@calcfield:1]/ (CASE THEN [@calcfield:9] = 0 THEN 1 ELSE [@calcfield:9] END) )*100 Hope this helps. Regards, vitalikssssss
  14. Hi everyone, How can copy the text from the selected drop-down element to the text field? Thanks for looking into. Regards, vitalikssssss
  15. Hi @davidhshugar, I do not think it is related to XML of the Datapage. Do you see this issue on Datapage direct URL? Can you try applying a different theme for the Datapage and verify the result? Regards, vitalikssssss
  16. What is the purpose of this script? Sorry, it does not make any sense to me. Regards, vitalikssssss
  17. Hi @Elderberg, I am not sure why you need Date to be saved as String, but anyway you can simple change the datatype for the field "Date". Regards, vitalikssssss
  18. Hi @geoffdude, It is available in 20.0 Caspio Bridge version. Probably your site has not been updated yet to 20.0 Caspio Bridge version. You can check your Caspio Bridge version within your account: from the top menu bar HELP --> About Caspio Bridge. Also, you can check Caspio Twitter for latest information about system updates. Regards, vitalikssssss
  19. Hi @lypoextract, You can use import/export of application if you would like to transfer it to different account. Here is a documentation: https://howto.caspio.com/apps/exporting-an-app/ Hope this helps. Regards, vitalikssssss
  20. Hi @Ed727, I assume that you have both Datapages deployed on a web-page with an embed method. You can use a JS which clicks on Submit button if my assumption is correct. Here a a code which you can use on web-page: <script> function submit () { document.querySelector("input[id*='Submit']").click(); } setTimeout(submit, 5000); </script> Hope this helps. Regards, vitalikssssss
  21. Hi @Johnn, Yes, it is possible with CSS. Here is an example of CSS code. It should go into Datapage Header and also make sure that you disable HTML editor. <style> input#InsertRecordYOUR_FIELD_NAME { background: #008000; } input#InsertRecordYOUR_FIELD_NAME { background: #00bfff; } </style> Replace "YOUR_FIELD_NAME" with your actual fields name and change the color according to your preferences. You can use this color picker. Hope this helps. Regards, vitalikssssss
  22. Hi @Elderberg, I can suggest using a simple Dropdown or Listbox for date selection and a lookup table which will be updated via Tasks on daily basis. Here is an example of Task which adds yesterdays, current date, and tomorrows date on daily basis. You may also import this Task from attached archive. Hope this helps. Regards, vitalikssssss CaspioData_2019-Dec-02_1638.zip
  23. Hi @BFuchs Did you place the code into Datapage Header? HTML editor was disabled? This code is designed for Tabular report Datapage. Send me a URL of the web-page via private message, so I could take a look. Regards, vitalikssssss
  24. Hi @BFuchs, Try using complex css selectors as per below: <style> td.cbResultSetData.cbResultSetTableCellNumberDate.cbResultSetCalculatedField { color: blue; font-size: 20px; font-weight: 1000; } </style> Hope this helps. Regards, vitalikssssss
  25. Hi @davidhshugar, I think I will be able to help you with this. Please send me an exported XML of the Datapage. Regards, vitalikssssss
  • Create New...