Jump to content


Caspio Rockstar
  • Posts

  • Joined

  • Last visited

  • Days Won


Everything posted by Meekeee

  1. Hi - instead of JS, you may try using Calculated Value with CASE WHEN statement to set the criteria. After that, you can check this type of flow: https://howto.caspio.com/tech-tips-and-articles/common-customizations/dynamic-redirects-after-form-submission/
  2. Hi @Frode - this might be late, but you may check these links: http://jsfiddle.net/jaraics/pEG3j/ https://stackoverflow.com/questions/10982593/open-link-in-new-window-or-focus-to-it-if-already-open https://stackoverflow.com/questions/5646506/restrict-link-to-open-same-link-once-again https://stackoverflow.com/questions/31472065/preventing-pages-being-open-in-a-new-tab-window
  3. Hi @jasonkaeb - you may try this code: <script type="text/javascript"> document.addEventListener('DataPageReady', function (event) { document.querySelector("[id*='Value9_1']").addEventListener('change', function() { if (document.querySelector("[id*='Value9_1']").value == 'Yes') { document.querySelector("[name*='Value10_1']").checked = true; } else { document.querySelector("[name*='Value10_1']").checked = false; } }); }); </script> I hope this helps!
  4. Hi @EmmePGN - do you have a sample expected result? You may try using Calculated Values and SQL queries to get/match the value based on the fields in your DataPage. You can check this article: https://howto.caspio.com/datapages/datapage-components/calculated-values/ https://howto.caspio.com/function-reference/
  5. Hi @Elena ! Just an update on this post, you may also check this for solution:
  6. Hi @EmmePGN - can you try this code instead: <script> var v_Knowledge_New = "[@field:Address]" ; var o_Knowledge_New= document.getElementById("EditRecordAddress") ; o_Knowledge_New.multiple = true ; document.addEventListener('DataPageReady', function (event) { if ( v_Knowledge_New.indexOf(",") > 0 ) { for (var i=0 ; i < o_Knowledge_New.options.length; i++ ) { if(o_Knowledge_New[i].value == v_Knowledge_New) { o_Knowledge_New.remove(i); break ; } } var o_st = v_Knowledge_New.split(", ") ; for (var j=0 ; j < o_st.length; j++) { for (var i=0 ; i < o_Knowledge_New.options.length; i++ ) { if(o_st[j]== o_Knowledge_New.options[i].value){ o_Knowledge_New.options[i].selected = true ; break ; } } } } }); document.addEventListener('BeforeFormSubmit', function(event) { var MyListbox = document.getElementsByName("EditRecordAddress")[0]; var number_selections = 0; for (var i=0; i<MyListbox.options.length; i++) { if (MyListbox.options[i].selected) number_selections+=1; } if (number_selections>3) { event.preventDefault(); alert("You can select only " + 3 + " items"); event.stopImmediatePropagation(); } }); </script> I was able to test this on my end and working as expected. Hope this helps!
  7. Hi @kmocabee- for the barcode, are you referring to barcode generator or scanner? Either way, you may check it here from their App Extenstions: https://www.caspio.com/services/app-extensions/?cat=integrations For the other requirement about notes, yes this is possible. You may check this forum post:
  8. Hi! Just an update, you may now use Calculated Value on this. See this link for more information.
  9. Hi! Just an update, Caspio has a new feature called Tasks which is suitable in your workflow. See this link for more information.
  10. Hi! Just an update on this, you may use Cascading Elements and Calculated Values on this. For more information, see these links: https://howto.caspio.com/datapages/datapage-components/cascading-elements/ https://howto.caspio.com/datapages/datapage-components/calculated-values/
  11. Hi @AhmeAlnaqa - you may check this forum post:
  12. Hi @Mikey - You can try to configure the class div#Alert, like this one: Insert this in the Header of your DataPage. <style> div#Alert { background: aquamarine !important; } </style> If you want to change the message, you can configure it in Localizations. Hope it helps!
  13. Hi @Catra - you can change it in Styles -> DataPage Elements: Charts Legend: I hope it helps!
  14. Hi @bpasko - If you run out of space in the Footer, you can use App Parameter -> Type (Long Text) to insert the code. For more than one field, you may check this post as well:
  15. Hi @Lromero1, are you referring to the Search Field? If yes this code will work: You might need to change the Field to the correct element for Search Field just like this one: <script> var field = 'Value1_1'; // Field from your Search Report var input = document.querySelector('#' + field); input.maxLength = 14; input.onkeyup = telephize input.onkeydown = telephize function telephize(v_e) { // this.value = this.value.replace( /\D+/g, "" ).replace( /([0-9]{1,3})([0-9]{3})([0-9]{4}$)/gi, "($1) $2-$3" ); //mask numbers (xxx) xxx-xxxx v_e = v_e || window.event; if (v_e.keyCode >= 65 && v_e.keyCode <= 90) { this.value = this.value.substr(0, this.value.length - 1); return false; } else if (v_e.keyCode >= 37 && v_e.keyCode <= 40) { return true; } var v_value = (this.value.replace(/[^\d]/g, '')); if (v_value.length == 7) { this.value = (v_value.substring(0, 3) + "-" + v_value.substring(3, 7)); } else if (v_value.length == 10) { this.value = ("(" + v_value.substring(0, 3) + ") " + v_value.substring(3, 6) + "-" + v_value.substring(6, 10)); }; } document.querySelector('#caspioform').onsubmit = function(e) { e.preventDefault(); if (input.value.length >= 14){ this.submit(); } else { alert('Please input a valid phone number'); input.focus(); } } </script> Insert this code in the Footer of Search Report. Take note that this will only work when the Search Form option is Show Search Form -> Results on a new page. See this link for Caspio Elements.
  16. Hi @Sherif, If you want to update the value real time using JavaScript, you need to declare an event handler such as DataPageReady. You may check this link for more information: https://howto.caspio.com/datapages/ajax-loading/
  17. Hi @Muslim, These links might help: https://www.freakyjolly.com/convert-html-document-into-image-jpg-png-from-canvas/ http://html2canvas.hertzen.com/
  18. Hi @Catra - you can also download it automatically in your page. See the link here on how: https://help.dropbox.com/files-folders/share/force-download
  19. Hi @Catra - you can try this one: CASE WHEN [@field:DATE_FIELD] >= CONVERT(datetime, 'mm/dd/yyy', 101) AND [@field:DATE_FIELD] <= CONVERT(datetime, 'mm/dd/yyy', 101) THEN 'TRUE' ELSE 'FALSE' END For more information, you may check this article: https://howto.caspio.com/function-reference/
  20. You may check these posts as well:
  21. Hi @OIAFEM - you may check Caspio's Ready Made Applications, you can request it for FREE. Here are the links: https://www.caspio.com/apps/event-registration/ https://www.caspio.com/apps/simple-event-listing/
  22. Hi @Cherry - You can try to use margin-left on this. I created a sample just like yours and this is the result: Before: After: What I did on this is that I find the HTML Container using the browser's inspect and add the CSS in the Header of the DataPage: You can copy the code and just change the class based where your HTML Block is placed in your DataPage. <style> div[class*="cbFormData cbFormBlock5"] { margin-left: -35px !important; } </style> I hope this helps!
  23. Meekeee


    Hi @eJohn - If you want to check what Caspio can do, you can create a trial account so you can navigate and create your own application in minutes without coding. While creating an app, you can review some of their training materials for you to familiarize Caspio's features. https://howto.caspio.com/ https://www.youtube.com/user/CaspioInc https://www.caspio.com/training/ They have Ready Made Applications as well that you can check and request for FREE: https://www.caspio.com/apps/ If you do have questions, I believe they have a great Support team that is always ready to assist you 24/7
  24. You may filter first the table with your desired data and click the Download option. You may check this article for more information: https://howto.caspio.com/tables-and-views/managing-data/filtering-data/
  • Create New...