Jump to content


Caspio Evangelist
  • Content Count

  • Joined

  • Last visited

  • Days Won


Everything posted by Vitalikssssss

  1. Hi DesiLogi, We screenshot of your existing Trigger will help us to find the reason of the issue. cheers, vitalikssssss
  2. 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
  3. 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
  4. 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
  5. 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
  6. 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.
  7. 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.
  8. 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
  9. 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++) {
  10. 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
  11. 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
  12. 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.
  13. 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
  14. 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.
  15. Hi cgonzalezalcala, I have been able to make this solution work in my Datapage. You should do following steps: 1. Datapage Header Insert following code: <script src="//code.jquery.com/jquery-1.11.3.min.js"></script> <div id="contain"> <style> #contain { height: 100px; overflow-y: scroll; } #table_scroll { width: 100%; margin-top: 100px; margin-bottom: 100px; border-collapse: collapse; } #table_scroll thead th { padding: 10px; background-color: #ea922c; color: #fff; } #table_scroll tbody td { padding: 10px; background
  16. Hi Imooring, You can try to use the following code on your Submission Form in order to insert "+1 day" value into your Expire Date field upon user select the date in End Date field: <script> function DateAdd() { var a = new Date(document.getElementById('InsertRecordYOUR_FIELD_End_Date').value); a.setDate(a.getDate() + 1); var dd = a.getDate(); var mm = a.getMonth()+1; var yy= a.getFullYear(); var b = mm + '/' + dd + '/'+yy; // you should change an order if you use non-US localization in your Submission Form document.getElementById('InsertRecordYOUR_FIELD_Expiration_Date').
  17. Hi Sudesh, It looks to me that you have used Data/Time data type. You should use Text(255) datatype for the field in question. Hope this helps.
  18. Hello NeoInJS, Perhaps you can try to replicate the desired layout with Pivot table. http://howto.caspio.com/datapages/reports/pivot-table/ Hope this helps.
  19. Hi Newgoblin49, You can create a relational database in Caspio. You may find more details here: http://howto.caspio.com/tables-and-views/relationships/ Hope this helps.
  20. Hi rickin21, You may try to change the triggering event to ".onsubmit". <SCRIPT LANGUAGE="JavaScript"> function calculate() { var v_hours = parseFloat(document.getElementById("InsertRecordRegular_Hours").value); var v_hoursot = parseFloat(document.getElementById("InsertRecordOT_Hours").value); var v_rates = parseFloat(document.getElementById("InsertRecordRates").value); var v_ratesot = parseFloat(document.getElementById("InsertRecordRate_OT").value); var v_amount = ((v_hours * v_rates)+(v_hoursot * v_ratesot)); document.getElementById("InsertRecordAmoun
  21. Hi NikkiC, I`ve made some modification to your JS. Try to use a snippet of code below. It should resolve all described issues. Hope this helps. <div id="el" class="c-rating"></div> <script src="http://www.cambridgedata.org/Testboard/manager/five-star-rating-master/js/dist/rating.min.js"></script> <script> // target element var el = document.querySelector('#el'); // current rating, or initial rating var currentRating = '[@field:QA_Tester_Rating#]'; // max rating, i.e. number of stars you want var maxRating= 5; // callback to run after setting the
  22. Hi Mark, I believe that it is possbile. You may customize JS solution from this post: https://forums.caspio.com/index.php?/topic/3200-js-concatenatecombine-two-fields-into-one-field/ You need to change element_id to reference Virtual field(correct syntax: cbParamVirtualX ). You may also need to change an event trigger i.o. onsubmit. Hope this helps.
  23. Google viewer frame will display embed document from Caspio if you encode the URL link of file stored inside Caspio account: So, URL link will look like this: https%3A%2F%2Fe1.caspio.com%2FdpImages.aspx%3Fappkey%3D____%26fileID%3D_____ I have used following link to generate the encoded URL. Hope this helps
  24. Hi MattFL, I guess that is a system security restriction which you will not be able to overcome. http://howto.caspio.com/integration/web-services-api/rest-api/special-considerations/ You may try to authenticate the user based on another field type.
  25. Hi roattw, You can concatenate several fields in single value with Formula field: Formula-fields Hope this helps.
  • Create New...