Jump to content


Caspio Evangelist
  • Content Count

  • Joined

  • Last visited

  • Days Won


Everything posted by Vitalikssssss

  1. Hi @jacky, Please note that "onsubmit" Javascript event is not supported by Caspio after 13.0 Caspio Bridge release. Replace the onsubmit event with Caspio’s built-in event handler, as shown below: <script type="text/javascript"> document.addEventListener('BeforeFormSubmit', function (event) { // do something }); </script> You can check this article for more information: https://howto.caspio.com/release-notes/caspio-bridge-13-0/13-0-impacted-areas/ Also, make sure that you place your code in Datapage Footer. Regards, vitalikssssss
  2. Hi @Medron, Please make sure that you use correct event handler instead of a default Javascript event handler "on load". You need to something like this: <script type="text/javascript"> document.addEventListener('DataPageReady', function (event) { <a id="visi[@field:Patient_Name]"> <script> var isi = document.getElementById("visi[@field:Patient_Name]"); if('[@Calculated_Field_1]' > 30){ isi.parentNode.parentNode.style.backgroundColor = '#efe173'; } else if('[@Calculated_Field_1]' > 1440){ isi.parentNode.parentNode.style.backgroundColor = '#ef7f73'; }
  3. Hi @ministry, You can achieve the desired functionality with standard functionality of Caspio. You need to create a separate authentication for each user group: "Normal", "Admin" and use this authentication on Datapages which are relevant to each group. You may check this video for more insights: https://www.youtube.com/watch?v=YEzM1c624Jk Hope this helps. Regards, vitalikssssss
  4. Hi @Alison, You can design Trigger in such a way which allow you to achieve the desired functionality. You need to make sure that: 1. Your parent/child table has one-to-many relationship; 2. You create a special table which will be used as insert template. 3. Please note that you would need to list the same number of records in insert template as the number of days which you could have in the date range. 4. You need to create a Trigger. You may import my example into your account and check the structure there. Regards, vitalikssssss Submit_multi
  5. Hi @Berti, I can say that Caspio uses HighChart library to render the chart. I don`t have a solution for your described case but perhaps you can try to use a solution from this topic: Stackoverflow Regards, vitalikssssss
  6. Hi @rgiljohann Please note that Caspio form does not support on load event handlers and you need to use Caspio built-in event handlers. The onload event should be replaced with Caspio built-in event as shown below: <script type="text/javascript"> document.addEventListener('DataPageReady', function (event) { // do something }); </script> You can find more details in this article: https://howto.caspio.com/deployment/ Hope this helps. Regards, Vitalikssssss
  7. Hi @JaredL, You can find a solution in this forum topic:
  8. Hi @Harbinger, You may try to use Formula field to concatenate values from two fields. The formula field is available as a field for RLS. https://howto.caspio.com/tables-and-views/data-types/formula-fields/ Regards, vitalikssssss
  9. Hi @kpcollier, Perhaps you can try to achieve the desired join with Full outer join type in View. You can also use filtering criteria in order to show only certain records. Full Outer Join – Includes all records in both tables, even when there are no matching records on the other side. In this case you will have both properties without agents and agents without properties. https://howto.caspio.com/tables-and-views/what-are-views/creating-a-view-to-join-tables/ Hope this helps. Regards, vitalikssssss
  10. Hi @yballan3, As far as I know, you can initiate a scheduled task with REST API call. I am not sure if you will be able to implement REST API call from Wordpress web-page, because it requires some back-end coding. https://howto.caspio.com/web-services-api/rest-api/older-rest-api-versions/datahub-operations/ Hope this helps. Regards, vitalikssssss
  11. Hi @rgiljohann, I would highly recommend creating a separate trigger for on "Update" event which will delete the updated record if criteria met. You currently have all events enabled (Insert, Update, Delete) which might create a lot of confusion after you try to test the Trigger. Also, you need to change "Delete from" clause to #inserted if you would like to delete only updated record if criteria is met. Hope this helps.
  12. Hi @Stepford, You can find this information in the HowTo library. https://howto.caspio.com/apps/importing-an-app/ Regards, vitalikssssss
  13. Hi @rgiljohann, You can delete a record with "Delete" action block. You can also set a "Where" condition in order to delete records conditionally. Hope this helps. Regards, Vitalikssssss
  14. Hi @Stepford, Perhaps exported copy of my datapage will provide you a better understanding. Ples Please refer to Datapage named "Company_table_conditional pop_up" and check the code from HTML block. Regards, vitalikssssss CaspioData_2018-Sep-06_1315.zip
  15. Hi @edujobs2k18, You may try to use the following Javascript solution: <script type="text/javascript"> document.addEventListener('BeforeFormSubmit', function(event) { var entered_value = document.getElementById("InsertRecordDate0").value; var entered_date = new Date(entered_value); var permitted_date = new Date(); permitted_date.setDate(permitted_date.getDate()); if(entered_date < permitted_date) { alert("Cannot be a date in the past"); return false; } }); </script> This solution is designed for Submission form with AJAX enabled. Also, field name
  16. Hi there! Does anyone have a JS/Jquery solution to restrict the user to be able to enter only time value in a field (Text255)? I have a Tabular Report datapage with inline edit enabled. Thanks, vitalikssssss
  17. Hi @Scott17, You can use simple Javascript code to copy the value from one field into another. You may use this snippet of code as an example: <SCRIPT LANGUAGE="JavaScript"> function copy() { var date1 = document.getElementById("ValueX_Y").value; // X_Y values based on the layout of your fields document.getElementById("ValueX_Y").value = date1; // X_Y values based on the layout of your fields } var date1 = document.getElementById("ValueX_Y").onchange=concatenate; </SCRIPT> - ValueX_Y - X is the form element order, which starts at 1 an
  18. Hi @edujobs2k18, I believe that you are not able to validate your expression because of your field name under SUM function. Please note that you should use the name of the field from your table "Student_Master" and be careful since the system is case-sensitive. Hope this helps. Regards, vitalikssssss
  19. Hi @edujobs2k18, You can restrict editing of the field with Conditional Rules. Please check this topic for more insights:
  20. Hi @MrsMedia, You can set predefined filtering criteria based on autonumber field and set a range as follow: Criteria 1: Greater than or equal 1 Criteria 2: Less than or equal 10 and it will return only the first 10 records. Hope this helps.
  21. Hi @cdutoit62 , Please note that only editable fields available in Conditional Rules. It doesn`t make a difference if you use standalone Details page i.o. Details section from Tabular report from my example. Hope this helps. Regards, vitalikssssss
  22. Hi @cdutoit62, I can suggest following steps to create your workflow: 1. Create a field in your table which will store an expiration date. You can use DateAdd() function in the Formula field. https://howto.caspio.com/function-reference/ You can use Triggered action or Calculated Value form element if you don`t want to set expiration date manually. 2. Create a Сonditional Rule on Details section of your Tabular Report. You need to set up a Rule which compares the current date with the expiration date. Please add a Virtual field and assign a hidden form
  23. Hi @MrsMedia, I can suggest using multiple Datapages (Gallery) on the single web-page. You can specify custom text in the Header of each Datapage. Hope this helps. Regards, Vitalikssssss
  24. Hi @Stepford, What datapage do you use? I have a Tabular Report datapage with an HTML block in which I have a JS which display the link to a pop-up based on the condition. Here is an example of Javascript code I`ve used: <div id='record[@cbRecordIndex#]'></div> <script type="text/javascript"> document.addEventListener('DataPageReady', function (event) { if ("[@field:Name]" == "Jalian Corp") { document.getElementById("record[@cbRecordIndex#]").innerHTML="<a class='cbMenuItem' href='#' onclick='window.open(\"https://c3fot067.caspio.com/dp/498C
  • Create New...