Jump to content


Caspio Evangelist
  • Content Count

  • Joined

  • Last visited

  • Days Won


Everything posted by Vitalikssssss

  1. 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 attac
  2. Hi scottknz, Perhaps this topic might help you to resolve your issue. Regards, vitalikssssss
  3. 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
  4. Hi Alwayslost, You have made a small syntax error which I have highlighted in red. Regards, vitalikssssss
  5. Hi Alwayslost, You can achieve desired functionality with a usage of JQuery library. Please note that you should re-write you Footer script this hide/display section. I have created following solution but only for one image which will execute hide/display function. Place following code in Header: <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script> Place following code into the HTML BLOCK / DISABLED / BEFORE THE SECTION: <div id="button"> <center><img src="YOUR_IMAGE_#1_URL" alt="My button" cl
  6. Hello Rinnet, You can store an external weblink to a file as a simple text (datatype: Text(255)) in Caspio table. You may use HTML block to display an image via a link. Hope this helps.
  7. Hi vikovs, To access and modify the width of columns in Caspio-generated HighCharts chart, you may use the following JS: <script src="https://code.jquery.com/jquery-3.2.1.js"></script> <script> $(document).ready( function () { var chart = Highcharts.charts[0]; chart.update( { plotOptions: { series: { pointWidth: 20 // change the column width here } }, } ); } ); </script> You can place this snippet of code into the Header of Chart datapage. Hope this helps.
  8. Hi everyone, I have been able to create Triggered Action on record insert which identifies duplicate data and creates a new record in another table. Hope this helps.
  9. Hello Phil, I have noticed that you have three possible values which can be assigned to the Calculated field which causes an error. You should specify only two values such as Yes/No or True/False in order to apply the Localization formatting Yes/No. You may use Formula field if you prefer to leave three options within your Case statement. Formula field Case expression should consist of HTML elements in order to change the color of assigned value: CASE WHEN [@field:Q17]=0 THEN '<span style="color:#FF0000;">No</span>' WHEN [@field:Q17]=1 THEN 'Yes'
  10. Hi Scott, I would suggest contacting these guys if you are looking the way to automate emails sending on a monthly basis. Described workflow requires some back-end coding which can be done only by Caspio Professional Service Team. Alternatively, you may consider using Datahub which can send an email with an attachment, however, you should create scheduled task for every email recipients. Hope this helps.
  11. Hi Jeffs88keys, I believe that Conditional Rules is the best option to resolve your case. You have two criteria as I`ve understood based on which you would like to restrict editing of the record. They are User role and checkbox field "comission_paid" (just an assumption). You can create the following set of Rules on Details in order to achieve the desired behavior: 1. Rule to check the User status based on authentication parameter which will set "comission_paid" field to "Display only" form element; 2. Rule to check the "comission_paid" status which will set all edit
  12. Hello mdeevers, First of all, I would recommend you using following relationship structure for your project. You should have separate tables for Students, Events and a joint table which will store corresponding ID`s from tables Students, Events. The joint table should also have a field which will capture an attendance status. You may also utilize Triggered Action feature which can create students records in the joint table upon creation of the new event. Finally, you can build a Tabular Report Datapage based on the joint table with Bulk edit feature enabled in o
  13. 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').
  14. Hi roattw, You should make sure that you have used correct names of table/column (case sensitive). You may try to use the following expression: select count(user_id) from table_name where CME_Category='Value' Hope this helps.
  15. Hi Accountability, Have you put this part in a Header of the Datapage? <div id="datefix"> Can you send me a screenshot from your browser console? Perhaps we`ll be able to trace an error from there. Regards, vitalikssssss
  16. Hi MyNameIsSean, It looks like the issue has been fixed. I have been able to create a Trigger which inserts the Timestamp value from parent table into Date&Time field. Regards, vitalikssssss
  17. Hi 888Washington, You can lookup for reference record in another table by creating a Join with #inserted. It is difficult to offer you a precise solution without table structure or a screenshot of your existing Trigger. By the way, I have recently signed up for the Webinar: Introduction to Triggered Actions. Perhaps you will be able to find an answer or some insights there. You can sign-up via following links: Wed, Oct 25, 2017 3:00 PM - 4:00 PM EEST Wed, Oct 25, 2017 9:00 PM - 10:00 PM EEST Thu, Oct 26, 2017 3:00 AM - 4:00 AM EEST Hope this help
  18. Hi Melwyn, I have a doubt that desired functionality can be achieved with Triggered Actions feature. I have a Trigger in my App which concatenates first and last reference number into a single Text(255) field. You may try to achieve desired functionality on a Datapage level by using the Javascript solution from this Forum topic. It will allow you to store selected values in one field which will be separated by a comma. Hope this helps.
  19. Hi Accountability, Try the following code: <div id="datefix"> <script> function DateCheck() { var dateout = document.getElementById('InsertRecordDefined_Time_Out').value; var datein = document.getElementById('InsertRecordDefined_Time_In').value; if (dateout <= datein) alert("Please enter a date and time OUT after date and time IN "); document.getElementById("InsertRecordDefined_Time_Out").value = null; return false; } document.getElementById('InsertRecordDefined_Time_Out').onchange = DateCheck; </script> </div> I have corrected some minor
  20. Hi Accountability, I have noticed a syntax error in your code where you trying to reference Cascading Elements. Here is an example of the correct syntax for referencing Cascading Elements: Hope this helps.
  21. Hi MyNameIsSean, That is very odd behavior which I believe will be resolved in an upcoming Caspio Bridge release. In the interim, you can try to build the Triggered action as per below as a temporary workaround. Hope this helps.
  22. Hi jrodriguez88, I would suggest combining your functions within a single function. Here is a code: <script> function check() { var x = document.getElementById("EditRecordPHONE_NUMBER").value; var y = document.getElementById("EditRecordMOBILE_NUMBER").value; document.getElementById("EditRecordPHONE_NUMBER").value=x.replace(/[^0-9 ]/g, ""); document.getElementById("EditRecordMOBILE_NUMBER").value=z.replace(/[^0-9 ]/g, ""); } document.getElementById("caspioform").onsubmit = check; </script> Hope this helps.
  23. Hello Accountability, I would suggest using following code if you prefer to restrict form submission if the condition "dateout <= datein" is met: <div id="datefix"> <script> function DateCheck() { var dateout = document.getElementById('InsertRecordDefined_Time_Out').value; var datein = document.getElementById('InsertRecordDefined_Time_In').value; if (dateout <= datein) alert("Please enter a date and time OUT after date and time IN "); document.getElementById("InsertRecordDefined_Time_Out").value = null; return false; } document.getElementById('InsertRe
  24. Hi jrodriguez88, You can use the following snippet of code to remove special characters from a user input: <script> function check() { var x = document.getElementById("EditRecordYOUR_FIELD").value; document.getElementById("EditRecordYOUR_FIELD ").value=x.replace(/[^a-zA-Z ]/g, ""); } document.getElementById("caspioform").onsubmit = check; </script> Please place this code into the Footer of your Details Datapage.
  25. Hello wdandrews, You can use conditional rules in order to hide search fields based on user authentication information. You may also use record-level security feature to restrict an access to the search result records based on user role. Hope this helps.
  • Create New...