Jump to content


Caspio Guru
  • Content Count

  • Joined

  • Last visited

  • Days Won


LittleMsGinger last won the day on May 25

LittleMsGinger had the most liked content!

About LittleMsGinger

  • Rank
    Advanced Member
  • Birthday June 8

Recent Profile Visitors

455 profile views
  1. 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/.
  2. 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.
  3. 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!
  4. 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!
  5. Hello @KFab4, If you are using a Details DataPage and you would like to go to the previous search page, you can enable the Link to search form option and insert the URL to you other DataPage. You can also create a hyperlink to the details report. In the HTML block create a hyperlink to the URL of the Results page. You may check this article: https://howto.caspio.com/tech-tips-and-articles/tech-parameters/results-and-details-on-two-separate-web-pages/ Hope this helps!
  6. Hello! Just to share with you my solution on how to open a form in a new tab without closing the previous DataPage upon submitting or updating a record. On the Destination and Messaging, disable HTML editor and paste this code: <script> location.reload(); window.open('URL','_blank'); </script> Hope this helps! -LittleMsGinger
  7. Hi @IamBlossom, If you have a Date/Time field, you can use it instead of this Text(255). Then, Group date by date rollup and choose Month. It will now sort based on the correct order of the month.
  8. Hello, You may also check this howto article: https://howto.caspio.com/tech-tips-and-articles/common-customizations/tech-tip-5-ways-to-customize-the-look-of-your-datapages/ You may go directly to Number 3 - Add your company logo. Cheers!
  9. I tried this code and it seems to be working if the ajax loading is disabled. Sharing with you is the modified script that is working even if the Ajax loading in the DataPage is enabled. <script> document.addEventListener('BeforeFormSubmit', function() { var first= document.getElementById("Value1_1").value; var second = document.getElementById("Value2_1").value; var third = document.getElementById("Value3_1").value; if (( first === 0) & ( second === 0) & ( third === 0)) { event.preventDefault(); window.alert("Please enter a value in a field"); } }); </script> You can also refer to this link: https://howto.caspio.com/datapages/ajax-loading/ Hope this helps!
  10. I also had a workaround that I would like to share with you. Here are the objects in Caspio Bridge that you need to perform the said workflow. * Separate Table to generate the One-time password upon logging in. * Submission form. (This will be a auto submit form.) * Standalone Login Screen. * Details DataPage for submitting the OTP. Attached is a word document with steps and screenshots. Hope this helps. Two Factor Auth - User Level.docx
  11. Hi @jnordstrand, Having a weather widget feature needs API integration and custom programming. However, you can check the links that I found below as your reference: https://rapidapi.com/blog/weather-app-javascript-nodejs/ https://bithacker.dev/fetch-weather-openweathermap-api-javascript
  12. Hi @IamBlossom, For File DataTypes, you need to use SQL's "DATALENGTH" to measure if the field has content or not. It is a behavior that NOT NULL or IS NULL will not work for File Datatype. Use this instead: CASE WHEN DATALENGTH([@field:Images]) = 0 THEN 'No image attached' ELSE 'Image available' END Hope this helps!
  13. Hi @Thewf, Have you tried to disable the Ajax loading for that DataPage?
  14. Hi @Tonie, If you were using a Submission Form, you must use 'InsertRecord' prefix instead of 'EditRecord'. Also, please check if the Ajax loading is enabled. You must disable it first to make your JavaScript to work. I tried this code on my end and it works as expected. <SCRIPT LANGUAGE="JavaScript"> function check() { var p1 = document.getElementById("InsertRecordPrimaryPhone").value; var p2 = document.getElementById("InsertRecordSecondaryPhone").value; if(p1 == '' & p2 == '') { window.alert('Please input at least one phone number'); return false; } else { window.alert(p1+' ' + p2); } } document.getElementById("caspioform").onsubmit=check; </SCRIPT> Hope this helps!
  • Create New...