Jump to content

Vitalikssssss

Caspio Rockstar
  • Content Count

    409
  • Joined

  • Last visited

  • Days Won

    41

Everything posted by Vitalikssssss

  1. Hi @Accountability, What is the datatype of these fields? Thanks, Vitalikssssss
  2. Hi @Apigh1969, You can store images in Caspio Table. You should add a "File" field to your table. Hope this helps. Regards, Vitalikssssss
  3. Vitalikssssss

    Bulk Edit

    Hi @Heather, You can only use the Bulk edit option for records which displayed on the page as far as I know. You may increase the number of records per page up to 999 records if it helps.
  4. Hi @roattw, You can implement the solution from this topic . 1. Disable AJAX loading of Datapage; 2. Place the following code into Datapage Header: <style> .wrapper1, .wrapper2 { width: 100%; overflow-x: scroll; overflow-y: hidden; } .wrapper1 { height: 20px; } .wrapper2 {} .div1 { height: 20px; } .div2 { overflow: none; } </style> <script src="https://code.jquery.com/jquery-1.9.1.js"></script> <div class="wrapper1"> <div class="div1"></div> </div> <div class="wrapper2"> <div class="div2"> 3. Place the following code in Datapage Footer: </div> </div> <script> $(function () { $('.wrapper1').on('scroll', function (e) { $('.wrapper2').scrollLeft($('.wrapper1').scrollLeft()); }); $('.wrapper2').on('scroll', function (e) { $('.wrapper1').scrollLeft($('.wrapper2').scrollLeft()); }); }); $(window).on('load', function (e) { $('.div1').width($('table').width()); $('.div2').width($('table').width()); }); </script> Make sure that you disable HTML editor otherwise it breaks the code in the Header. Hope this helps. Regards, vitalikssssss
  5. Hi David, I think there is a misunderstanding on your end of Formula field functionality. Please note that you cannot write values in other fields with a Formula field. You would like to capture a Year part of "End_of_Project_Date" or "Doc_Creation_Date" conditionally as far as I understood. In this case you should try the following formula: CASE WHEN [@field:End_of_Project_Date]<[@field:Doc_Creation_Date] THEN Datepart(Year, [@field:End_of_Project_Date]) ELSE Datepart(Year, [@field:Doc_Creation_Date]) END Hope this helps. Regards, vitalikssssss
  6. Hi @JoseM, I would suggest using Triggered action in order to achieve the desired functionality. You should have two fields to capture the date (Date inserted/Date updated) and also two fields which will capture owner/user id. Here is an example of Trigger:
  7. Hi @kpcollier, I can say that your "Contractor_ID" field has 1,017,901 records with blank (Null) value based on the output of your chart, so you would definitely need to check your source View. Please send me a copy of your View in private message, so I could look deeper. It is hard to help with building charts without seeing actual data. Regards, vitalikssssss
  8. hi @Corpcat, Please note that you use Dateadd() function wrong. This function can produce a new date which results from the addition of the specified number to datepart. Here is an example of the expression which adds one year: CASE WHEN [@field:End_of_Project_Date]<[@field:Doc_Creation_Date] THEN Dateadd(Year,[@field:End_of_Project_Date],1) ELSE Dateadd(Year,[@field:Doc_Creation_Date], 1) END Please let us know the business logic of formula expression, so we could help. Regards, vitalikssssss
  9. The issue was in Round function which actually accepts only one parameter and rounds the number to the nearest integer. The correct script should look like following: <script type="text/javascript"> document.addEventListener('BeforeFormSubmit', function (event) { var v1 = document.getElementById("EditRecordlab_fee").value; var v2 = document.getElementById("EditRecordc_discount").value; var v3 = document.getElementById("EditRecordcredit_charge").value; var v4 = v2 + v3 - v1; document.getElementById("EditRecordTotalFee").value = Math.round(v4 * 100) / 100; }); </script>
  10. Hi @Corpcat, You can utilize CASE expression in the formula field in order to achieve the desired functionality. https://howto.caspio.com/datapages/reports/advanced-reporting/calculations-in-forms-and-reports/ Hope this helps. Regards, vitalikssssss
  11. Hi @jacky, I have found a small syntax error in your code. One closing bracket was missing. Please try this code: <script type="text/javascript"> document.addEventListener('BeforeFormSubmit', function (event) { var v1 = document.getElementById("EditRecordlab_fee").value; var v2 = document.getElementById("EditRecordc_discount").value; var v3 = document.getElementById("EditRecordcredit_charge").value; var v4 = v2 + v3 - v1; document.getElementById("EditRecordTotalFee").value = Round(v4,2); }); </script> If it doesn`t help please inform me which form elements for each field you are using (lab_fee, c_discount, credit_charge). Regards, vitalikssssss
  12. Hi @Berti, I have found a solution which might work for your case. You need to place following snippet of Javascript code into Chart Datapage footer: <script type="text/javascript"> var int = setInterval(updateChartOptions, 100); function updateChartOptions(){ if(typeof Highcharts == "undefined" || !Highcharts.charts.length) return; Highcharts.charts[0].update({plotOptions: { column: { zones: [{ value: 10000, // up to this value color of column will be blue color: 'blue' }, { value: 30000, // if column is more than 30000 it will be green color: 'green' },{ color: 'red' // if value if above 30000 it will be red }] } }}); clearInterval(int); } </script> Hope this helps. Regards, vitalikssssss
  13. Hi @JoseM, You can use Timestamp system parameter instead of Javascript. You can check this article for further information: https://howto.caspio.com/tech-tips-and-articles/common-customizations/stamp-the-time-url-or-ip-address-to-new-and-updated-records/ Hope this helps. Regards, vitalikssssss
  14. Hi @roattw, Perhaps you have mixed new/old Datapage deploy code on your web-page. https://howto.caspio.com/deployment/caspio-site-vs-account-subdomain-deployment/ Did your user try to clear their browser cache? Regards, vitalikssssss
  15. 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
  16. 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'; } else{ isi.parentNode.parentNode.style.backgroundColor = '#FFFFFF'; } }); </script> You can find more details about Caspio event handlers in the following article. https://howto.caspio.com/deployment/ Hope this helps. Regards, vitalikssssss
  17. 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
  18. 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_multiple_records_date_range_1_0_2018-Sep-28_1423.zip
  19. 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
  20. 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
  21. Hi @JaredL, You can find a solution in this forum topic:
  22. 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
  23. 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
  24. 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
  25. 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.
×
×
  • Create New...