Jump to content

Vitalikssssss

Caspio Evangelist
  • Content Count

    522
  • Joined

  • Last visited

  • Days Won

    52

Everything posted by Vitalikssssss

  1. Hi @dmyoungsal, I think you will be able to resolve this case by creating a one-to-many relationship. https://www.youtube.com/watch?v=IstAk982ntA You can create a self-join View if your table have a one-to-many relationship. https://howto.caspio.com/tables-and-views/what-are-views/self-join-views/ Hope this helps. Regards, vitalikssssss
  2. Hi @roattw, Please check your Datapage header. I think below "div"s were closed by HTML editor. <div class="wrapper2"> <div class="div2"> You should disable the HTML editor prior inserting the snippet of code. Hope this helps. Regards, vitalikssssss
  3. 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
  4. Hi @hismaimai8888, Welcome to Caspio Forum. You can find search field at the right part of forum header. Regards, vitalikssssss
  5. 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
  6. Hi @kpcollier , Here is an example of the desired logic of Triggered action: Hope this helps. Regards, vitalikssssss
  7. Hi @Harbinger , You can pass ampersand if you encode your String parameter. You may check the following topic for more information: Stackoverflow Regards, vitalikssssss
  8. 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
  9. 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.
  10. 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
  11. 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
  12. Hi @Accountability, What is the datatype of these fields? Thanks, Vitalikssssss
  13. Hi @Apigh1969, You can store images in Caspio Table. You should add a "File" field to your table. Hope this helps. Regards, Vitalikssssss
  14. 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.
  15. 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 followin
  16. 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
  17. 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:
  18. 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
  19. 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
  20. 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&
  21. 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
  22. 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 fo
  23. 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' },
  24. 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
  25. 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
×
×
  • Create New...