Jump to content


Caspio Evangelist
  • Content Count

  • Joined

  • Last visited

  • Days Won


Everything posted by Vitalikssssss

  1. Hi brandon, You can enable a confirmation field in field settings. regards, vitalikssssss
  2. Hi mdav20, You can use filter the records based on pre-defined criteria via authentication parameter "jobsite" and use " If empty, ignore criteria" filtering option in order to allow managers to view all records. Hope this helps. Regards, vitalikssssss
  3. Hi Moritz, 1. You can hide submit button by placing following CSS code in Datapage header. <style> .cbSubmitButton { display:none; } </style> 2. You can use an HTML block and display the message via innerHTML Property. Hope this helps. Regards, vitalikssssss
  4. Hi vanderLeest, This can be achieved by using Joins with #inserted and table which has multiple records under same Id`s as inserted but "Select distinct" will restrict the output only to one record. Here is an example of the Triggered action which will insert unique records into the separate table: Hope this helps. Regards, vitalikssssss
  5. Hi DesiLogi, I am afraid that you cannot use Update block with the same table as the one on which you have built Trigger Action with event "update" because it will create an infinitive loop of Trigger execution. Regards, vitalikssssss
  6. Hi DesiLogi, You should use an Update block instead of Insert block if you would like to set the field 'Use_This' to 'True' for the new, inserted record. Here is an example: This Trigger should do the trick. I am afraid I have no idea of such Trigger behavior for another issue which you have discovered. I think it is better to ask Caspio Team about the reason for this odd behavior. Regards, vitalikssssss
  7. Hi DesiLogi, You should use Join with #inserted instead of Where condition in order to replicate the desired behavior. Hope this helps. Regards, vitalikssssss
  8. Hi DesiLogi, We screenshot of your existing Trigger will help us to find the reason of the issue. cheers, vitalikssssss
  9. Hi vanderLeest, Perhaps you can use a Pivot table datapage which can give you the desired output and layout. https://howto.caspio.com/getting-started/create-a-pivot-table-report/ Hope this helps. vitalikssssss
  10. Hi PDSRQ, Please note that all fields used in Javascript should be editable hence you can use "Text field" form element. You will not be able to use field value if you have used Display only/Hidden etc. form elements. Regards, Vitalikssssss
  11. Hi DanLiesik, You can implement the desired behavior with Conditional Rules formatting which is available on Details section of Report Datapage. You should make Details page editable by default and enable conditional rule which will use authentication parameter in order to make fields "Display only" for users from group B. Hope this helps. Regards, vitalikssssss
  12. Hi braxwell, Please note that field should be editable in order to insert a record via JS. I would suggest hiding the field from the user with HTML table tags and display calculated value for a user through HTML block via innerHTML. Hope this helps. Regards, vitalikssssss
  13. Hi Scott, You can achieve the desired layout if you use "No labels" settings and "Continue next element on the same line" field option. You should insert Labels names in HTML block and place it on the top of fields which will be displayed in the first row. Hope this helps.
  14. Hi PDSRQ, You do not use correct syntax to reference Datapage fields. I believe that following Javascript will do the trick: <SCRIPT LANGUAGE="JavaScript"> function insert() { var x= document.getElementById("EditRecordPBAEmployeeTable_EmployeeEmail").value; document.getElementById("cbParamVirtual1").value = x; } document.getElementById("EditRecordEmployeeTable_YearLastNotified").onchange=insert; </SCRIPT> Hope this helps.
  15. Hi Corey, You can use a method described in this tutorial article: https://howto.caspio.com/tech-tips-and-articles/tech-parameters/results-and-details-on-two-separate-web-pages/ Hope this helps. Regards, vitalikssssss
  16. Hi DesiLogi, I have been working on this issue for a while and came up a new JS solution as per your comment. Please place the following code in Report Datapage Footer: <script> function convert_date(){ var col = 2; // please replace digit with YOUR_DATE column sequence number (starts from "0") var options = { year: 'numeric', month: 'numeric', day: '2-digit' }; var cas_table = document.querySelectorAll('table[id^="cbTable"]')[0]; var cas_rows = cas_table.getElementsByTagName("tr"); for(var rowIndex=1; rowIndex < cas_rows.length; rowIndex++) { var cells = cas_rows[rowIndex].getElementsByTagName("td"); v_rev = new Date(cells[col].innerHTML); if ("[@authfield:Company_Country]" == "Australia") { cells[col].innerHTML= v_rev.toLocaleString("en-GB", options); } else { cells[col].innerHTML= v_rev.toLocaleString("en-US", options); } } } convert_date(); </script> Hope this helps. Regards, vitalikssssss
  17. Do you use the code in Submission Form? Have you placed the code in Footer of the Datapage? Please make sure that you have specified a correct name of the field. You can send me a deploy URL of Datapage via PM, in order for me to have a brief look at the issue via browser developer tools. Regards, vitalikssssss
  18. Hello DavidKennett, You should convert your dates with toLocaleDateString() method in order to compare two dates with different locals. This code should do the trick. <script> function pastDateValidation() { var d=new Date(document.getElementById("InsertRecordClient_AML_Date").value); var c = new Date(); if(c.toLocaleDateString() > d.toLocaleDateString()) { alert("Select a date which is before now"); document.getElementById("InsertRecordClient_AML_Date").value=""; } } document.getElementById('InsertRecordClient_AML_Date').onchange = pastDateValidation; </script> Regards, vitalikssssss
  19. Hello Corpcat, Perhaps you can try to use Bulk edit i.o. Grid edit. https://howto.caspio.com/datapages/reports/data-editing-options-in-reports/ Hope this helps.
  20. Hello DesiLogi, What kind of Datapage do you use in described case? Anyway, I have been using the following solution in my Tabular Report Datapage. I have an HTML block which displays the date and consist of the following code: <div id="demo[@cbRecordIndex#]"></div> I have placed the following Javascript code into Footer to assign the date format based on authentication field: <script> var d = new Date('[@YOUR_DATE_FIELD*]'); //short format should be used var options = { year: 'numeric', month: 'numeric', day: 'numeric' }; // output date only via digits if ( '[@authfield:Country]' == 'Europe') { var divs = document.getElementsByTagName("div"), item; for (var i = 0, len = divs.length; i < len; i++) { item = divs[i]; if (item.id && item.id.indexOf("demo") == 0) { item.innerHTML = d.toLocaleString("en-GB", options); // outputs date in UK format } } } else { var divs = document.getElementsByTagName("div"), item; for (var i = 0, len = divs.length; i < len; i++) { item = divs[i]; if (item.id && item.id.indexOf("demo") == 0) { item.innerHTML = d.toLocaleString("en-US", options); // outputs date in US format } } } </script> Hope this helps.
  21. Hello telepet, Please note that Search button can be referenced by id "searchID" and this id is not dynamic. You can use following script to hide the Search button: <script> document.getElementById("searchID").style.visibility = "hidden"; </script> You can find the id for referencing Caspio standard buttons in the following topic. Hope this helps.
  22. Hi MyNameIsSean, That is a very weird behavior of Caspio Datapage. I would recommend reporting about this case to Caspio Support Team, so they could investigate the issue. Regards, vitalikssssss
  23. Hi DavidKennett, I have used following JS in my Tablular Report Datapage (inline insert enabled) which hides/disables the "Add" button if uploaded file has any other extension except the following: .pdf, .doc, .docx, .xls, .xlsx. <SCRIPT LANGUAGE="JavaScript"> var v_file = document.getElementById('InlineAddPhoto'); var v_btn = document.getElementById('Mod0InlineAdd'); v_file.addEventListener('change', function(v_e){ var v_ext = (v_file.value || '').split('.').pop().toLowerCase(); if (!['pdf', 'doc', 'docx','xls','xlsx'].contains(v_ext)){ v_btn.disabled; alert('Please attach a document with following extension: .pdf, .doc, .docx, .xls, .xlsx'); // pop-up alert message v_btn.style.display="none";} else {v_btn.style.display="inline-block";} }); </SCRIPT> Please paste this snippet of code into the Footer. Hope this helps. Regards, vitalikssssss
  24. Hi scottknz, Perhaps this topic might help you to resolve your issue. Regards, vitalikssssss
  • Create New...