Jump to content


Caspio Evangelist
  • Content Count

  • Joined

  • Last visited

  • Days Won


Everything posted by Vitalikssssss

  1. Hi wdandrews, You may consider using drop-down Virtual field instead of two text fields one of which is cascading. Here is the link to an article which describes the concept: https://howto.caspio.com/tech-tips-and-articles/common-customizations/dynamic-redirects-after-form-submission/ Regards, vitalikssssss
  2. Hi cldb2016, Perhaps you can utilize formula field with substring function instead of custom JavaScript Solution. Here are some links to articles about formula field and its function: https://howto.caspio.com/tables-and-views/data-types/formula-fields/ https://howto.caspio.com/function-reference/ Regards, vitalikssssss
  3. Hi brandon, You can enable a confirmation field in field settings. regards, vitalikssssss
  4. 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
  5. 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
  6. 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
  7. 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
  8. 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
  9. Hi DesiLogi, You should use Join with #inserted instead of Where condition in order to replicate the desired behavior. Hope this helps. Regards, vitalikssssss
  10. Hi DesiLogi, We screenshot of your existing Trigger will help us to find the reason of the issue. cheers, vitalikssssss
  11. 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
  12. 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
  13. 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
  14. 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
  15. 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.
  16. 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.
  17. 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
  18. 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++) {
  19. 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
  20. 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').onch
  21. 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.
  22. 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 dig
  23. 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.
  24. 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
  • Create New...