Jump to content


Caspio Guru
  • Content Count

  • Joined

  • Last visited

  • Days Won


LittleMsGinger last won the day on June 26

LittleMsGinger had the most liked content!

About LittleMsGinger

  • Rank
    Advanced Member
  • Birthday June 8

Recent Profile Visitors

498 profile views
  1. Hi @senicholas, Can you please provide the type of DataPage you are using? If you can provide your DataPage URL that would be helpful. By the way, you can also check this forum post: Cheers!
  2. Hi @Josh1425, Have you already checked this forum post? For this to work, you need to uncheck the Enable Responsive option in the DataPages.
  3. I tried the solution provided above and based on what I observe, it is not working if the responsive option is enabled. I need to uncheck it for this to work. @techguy, you need to insert both script at the Footer of the last DataPage deployed in your web page. @Accountability, if there are required fields in one of the DataPages and you did not insert a value to it, this DataPage will not be submitted. Values from other DataPages will be inserted in the Table.
  4. Hi @ChristopherNORD, You mentioned that when you are manually entering the Timestamp in the Table, the Triggered Actions won't let you do it. May I know the error that you are getting? I tried to replicate your Triggered Action on my end and it seems to be working as expected. Here is what I have: Please check other areas of your Triggered Actions. You can also open a support ticket for this one. Cheers!
  5. Hi @ParrotHead72, I created a sample Triggered Action for your reference: In this scenario, I already have records in the Users Table. Then, upon insert or update in the Computers Table, the AssignedCompter filed in Users Table will update if the FullName is equal to IssuedTo. Hope this helps!
  6. Hi @kgraham2121, You can format the Date/Time filed used in X-axisto display the date only. You may also use Date Roll up Option and choose Date
  7. Hi @aquintanilla, There is another way to achieve your desired result without using JavaScript. But, instead of a button, you can use a checkbox and Rules. You can add a Virtual field in the Details Page, then create a Rule that if the Checkbox is not checked, the fields will be displayed only. Hope this helps!
  8. Hello @Shiro, You may check this howto link for the possible reason: https://howto.caspio.com/faq/authentication/why-datapage-logout-redirects-to-caspio-com/ Cheers!
  9. Hello @HeyItsDoug, To sort the field by the correct sequence of the day, I suggest that you have a calculated field in the form to convert the Day of the Week to an integer. CASE WHEN [@field:DOW] = 'Sunday' Then 1 WHEN [@field:DOW] = 'Monday' Then 2 WHEN [@field:DOW] = 'Tuesday' Then 3 WHEN [@field:DOW] = 'Wednesday' Then 4 WHEN [@field:DOW] = 'Thursday' Then 5 WHEN [@field:DOW] = 'Friday' Then 6 WHEN [@field:DOW] = 'Saturday' Then 7 END Then, hide this calculated using custom CSS. Insert Header/Footer and paste this code: You may refer to this forum post <style> #target table:nth-of-type(1) td:nth-of-type(3) {display: none;} #target table:nth-of-type(1) th:nth-of-type(3) {display: none;} </style> </header> <div id="target"> <header> Lastly, on the Results Page Options, sort the report by this Calculated field. Hoping that this will be your expected result: Cheers!
  10. Hi @telly, You can use this code to prevent a submission form if a certain condition is not met. <script type="text/javascript"> document.addEventListener('BeforeFormSubmit', function () { event.preventDefault(); var a = document.getElementById("InsertRecordFIELDNAME").value; if (a > 100) { alert('Please enter number less than 100.'); } else { document.forms["caspioform"].submit(); } }); </script> Cheers!
  11. Hello @DuongDung, You can use SQL query to remove non-numeric characters from the Text field, then convert it to Number. I tried this formula on my end and it works. CONVERT(float,(LEFT(SUBSTRING([@field:Amount1], PATINDEX('%[0-9.-]%', [@field:Amount1]), 8000), PATINDEX('%[^0-9.-]%', SUBSTRING([@field:Amount1], PATINDEX('%[0-9.-]%', [@field:Amount1]), 8000) + 'X') -1))) + CONVERT(float,(LEFT(SUBSTRING([@field:Amount2], PATINDEX('%[0-9.-]%', [@field:Amount2]), 8000), PATINDEX('%[^0-9.-]%', SUBSTRING([@field:Amount2], PATINDEX('%[0-9.-]%', [@field:Amount2]), 8000) + 'X') -1))) Hoping that this will also work for you.
  12. Hi @DruidCtba, you may try the solution provided in these articles: https://howto.caspio.com/tech-tips-and-articles/advanced-customizations/add-an-option-to-a-public-facing-dropdown/ https://howto.caspio.com/tech-tips-and-articles/advanced-customizations/automatically-add-options-to-dropdowns-and-listboxes/.
  13. Hi @vanderLeest, In order to format the content of the auto-email, I suggest that you select HTML, instead of Plain text. Then, click the expand button to display more options.
  14. Hi All, I was able to make a workaround not to include blank fields in the Automatic email using Calculated Value. I used Virtual fields in this example. Here is the formula: CASE WHEN '[@cbParamVirtual1]' = '' THEN '' ELSE 'Virtual 1: [@cbParamVirtual1]' END + CASE WHEN '[@cbParamVirtual2]' = '' THEN '' ELSE ' Virtual 2: [@cbParamVirtual2]' END + CASE WHEN '[@cbParamVirtual3]' = '' THEN '' ELSE ' Virtual 3: [@cbParamVirtual3]' END + CASE WHEN '[@cbParamVirtual4]' = '' THEN '' ELSE ' Virtual 4: [@cbParamVirtual4]' END You can also test this DataPage. I did not hide the Virtual field 5 for the sake of testing. You may hide it under the Advanced tab. Then, on the Email options, use this VirtualField5. Hope this helps. Cheers!
  15. Hello @FelixArthur, Instead of using HTML DataPage, you can use Update Forms, either Details DataPage or Single Update Record DataPage. This will allow you to get the current information in the table and be able to change the values if needed. Here is the article to explain it further: https://howto.caspio.com/datapages/forms/update-forms/ Cheers!
  • Create New...