Jump to content

Vitalikssssss

Caspio Rockstar
  • Content Count

    494
  • Joined

  • Last visited

  • Days Won

    49

Everything posted by Vitalikssssss

  1. Hi @Colnocode, Why you cannot use the Message (text 64000) field from Table(2) instead of [ Virtual3] if you want the data to be saved in Table(2) upon submit? Regards, vitalikssssss
  2. Hi @hismaimai8888, Welcome to Caspio Forum. You can find search field at the right part of forum header. Regards, vitalikssssss
  3. Hi @billid, I would suggest taking a look at Triggered Action feature of Caspio. Triggered Actions allow data manipulation, calculations and sending notifications by constructing application logic with a visual interface. They will be executed on specified events to perform actions on data in your tables. Changes in one table can affect data in other tables. Regards, vitalikssssss
  4. Hi @kpcollier , Here is an example of the desired logic of Triggered action: Hope this helps. Regards, vitalikssssss
  5. Hi @Harbinger , You can pass ampersand if you encode your String parameter. You may check the following topic for more information: Stackoverflow Regards, vitalikssssss
  6. Hi there, I have the events app. I would like to use the submission form to register event attendees. The submission form should be unavailable as soon as the number of attendees reached the limit per event. How can I do that? Thanks, vitalikssssss
  7. Hi there guys, How can I change the status of the event (open/close) based on the expiration date in Gallery report datapage? Thank you for looking into this question.
  8. Hi @kvarjavand, Formula field doesn`t support Datepart(week) as far as I know. You need to use a workaround solution from this post: Hope this helps. Regards, vitalikssssss
  9. Hi @kpcollier, Perhaps you can use Tabular Report with Inline insert option enabled in order to add items to the order. You will need to create a submission form to create an order and pass Order ID to the Tabular report Datapage which allows adding items to the order. Hope this helps. Regards, vitalikssssss
  10. Hi @Accountability, What is the datatype of these fields? Thanks, Vitalikssssss
  11. Hi @Apigh1969, You can store images in Caspio Table. You should add a "File" field to your table. Hope this helps. Regards, Vitalikssssss
  12. 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.
  13. 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
  14. 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
  15. 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:
  16. 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
  17. 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
  18. 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>
  19. 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
  20. 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
  21. 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
  22. 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
  23. 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
  24. 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
  25. 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
×
×
  • Create New...