Jump to content


Caspio Rockstar
  • Posts

  • Joined

  • Last visited

  • Days Won


Everything posted by TellMeWhy

  1. So, I was testing this new HowTo Article I found. It seems that it will not work for the Inline Insert and Inline Edit, so, I made one, if ever anyone needs it INLINE INSERT <script type="text/javascript"> document.addEventListener('input', function(event) { var x = document.getElementById("InlineAddFIELDNAME").value; document.getElementById("InlineAddFIELDNAME").value=x.replace(/[^a-zA-Z0-9 ]/g, ""); }); </script> I set the event listener to input as the Inline Insert and Edit is not a form, this will, however, PREVENT special characters for being typed or pasted into the input INLINE EDIT <script type="text/javascript"> document.addEventListener("click", function(event){ if(event.srcElement.getAttribute("data-cb-name") == 'InlineEdit'){ document.addEventListener('input', function(e){ var x = document.querySelector('input[name="InlineEditFIELDNAME"]').value; document.querySelector('input[name="InlineEditFIELDNAME"]').value=x.replace(/[^a-zA-Z0-9 ]/g, ""); }); } }); </script> These both works for me, just reply if you encounter any issues. Note: I don't know how to restrict just SOME special characters, but, you can search for any regexes that you can use instead of 'replace(/[^a-zA-Z0-9 ]/g, "")'
  2. Yeah that's doable. Main Table, is one Table, the 2nd sheet is another Table. Just use Triggered Action, or, if you're importing the data, you will need to use Application Task first to sum up those value you want to sum up. Triggered Action is for new entries that will be inserted on the main table, it will get added on the 2nd table (or update the 2nd table's values), if something is updated, as well, you can update the 2nd table through triggered action. You can then use that 2nd table for your Pivot DataPage. Look around the forums or HowTo or Youtube videos about triggered actions, tons of references that can get you started
  3. ahh, I don't know, I believe only radio buttons accept images use img tag for the display . i.e. <img src="https://multimedia.3m.com/mws/media/1484762F/3630-61-slategray-swatch.jpg" alt="test" width="50px"/>
  4. Make a different Section with the Title, should be above the section for the fields, so it won't get included in the count for colums. Use Top to bottom Fill order for the section and put all kid1 fields first before kid2, then divide to the column to two, the kid1 fields should have the same number of fields as kid 2, otherwise, you can use html blocks as fillers
  5. No, it should only be import and export. What you can do is create Application Task that will delete every record and time it just before your scheduled task that will update your table. Why would you want the data deleted, is that not risky?
  6. Try clicking on the Logic tab and see if it's set to AND, try to change it to OR, and see if it works
  7. You can use emojis. Would you like the values to be actual colors, as well, instead of text? You can use the emojis for the values, as well, but I wouldn't really recommend that, you might have a hard time if you're gonna use it on other things, but, if not, feel free to do so.
  8. Sandy is right, uncheck the relative. Relative is for the path of the file, not the whole URL, example /admin/index.html
  9. You can still combine all of them in a View, just that it would be OUTER JOIN, nothing is similar. You can create another field in all your tables just to store the table name. Use View as the Data Source for Reports DataPage, and use Keyword Search. https://howto.caspio.com/faq/reports-datapages/how-to-do-keyword-search-across-multiple-fields/ You might encounter some problems with joining all those tables tho, if you have so much records in each one. Setting up the Reports DataPage will be too much work, as well.
  10. Just to confirm, when clicking on the requested Num, does it open the built in details page or a Separate Details Page? You can do this workflow by adding iframe on your Details Page, just deploy that Reports DataPage with inline insert on the Details Page's HTML Block using iframe, and pass parameters using query string. You cannot do that when the link is to the built in Details page, so you will have to separate it https://howto.caspio.com/tech-tips-and-articles/tech-parameters/results-and-details-on-two-separate-web-pages/ https://howto.caspio.com/parameters/parameters-as-query-string-values/
  11. Their developers are probably the ones who will know what's best to integrate into your account. I believe it's free to ask but it's paid when they'll do it for you.iu
  12. This worked for me try style="width:[@calcfield:1#]%" number instead of % instead, then percent outside to append it.
  13. I think it's in this element, aria-valuenow should be the current value (the calc field) you can probably insert this in the DataPage, it will not work in Direct Deployment, but it should work when embedded in your site with the bootstrap included, the style = width:90% should be based on the value of the calc field as well. Try this in your DataPage (valuenow is NOT in percent, width should be in percent) <div class="progress progress-sm"> <div class="progress-bar bg-info" aria-valuenow="[@calcfield:3]" aria-valuemin="0" aria-valuemax="100" style="width: [@calcfield:3%];"><span class="sr-only">[@calcfield:3%]</span></div> </div> Ref: https://getbootstrap.com/docs/4.0/components/progress/
  14. Use something like event.stopImmediatePropagation(); or event.stopPropagation(); Just put that inside. If it does not work, try the Example 2 in https://howto.caspio.com/datapages/ajax-loading/ and restrict it with the DataPage's AppKey, and put the event.stopImmediatePropagation(); or event.stopPropagation(); inside that
  15. Each request would probably need one submission each.
  16. It should work. What worked for me is putting the CDN on the Header of the Results Page instead of the Details Page. It seems that the script is executing faster than the DataPage can include the jQuery library when you include it on the Details page, hence, the $ not defined
  17. I'm not versed in jQuery terms but I got this working with the following. First include the cdn of jquery on your Header, you get no errors, so, that means you already have it included, but for anyone who might need it HEADER > DISABLED HTML EDITOR <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script> FOOTER If you want to go through every input, then use 'input' instead of cbParam What the code in the if does is it goes to the parent element of the current input (it goes to div) then searches the NEXT siblings(other divs, it will not go up) with children who has <input> element, and the first one (.find()) it sees, it will focus. <script> $('input').keyup(function () { if (this.value.length == this.maxLength) { $(this).parent().nextAll().children('input').first().focus(); } }); </script> If only Virtual Fields, cbParam is not used in class, but ids and name, you may use the following: <script> $('input[name*="cbParamVirtual"]').keyup(function () { if (this.value.length == this.maxLength) { $(this).parent().nextAll().children('input[name*="cbParamVirtual"]').first().focus(); } }); </script> I don't really do jQuery, so, I'm sure there's much better way than this, but, this one works, so why not.
  18. You probably want a Details Page, or Gallery Reports DataPage to display images, not a Submission Form. SIngle Record Update would do too, but Details Page is easier to use. Additionally, you can check out this Application Template if this is how you want to be creating https://www.caspio.com/apps/membership-directory/
  19. what do you mean element ID? How are you testing this script? Take note that there is a temporary APPKey for DataPage when you use Preview, the AppKey in its properties is the real appkey when the DataPage is accessed through any deployment method, if that's what you're using, the script will not work in the preview. To get the temporary AppKey, just click preview and copy the value at the end of the URL, do not close this preview, as it will change if you closed it and preview it again. Just to add, don't need this anymore, you're using *= that operator means if the id INCLUDES InsertRecordUWStudentNPI, which, most probably, there's only one field that includes that term, unless there are multiple...
  20. Is this a List DataPage or Gallery? This needs JavaScript, but let me know first what specific type of DataPage, maybe I can help you. Here's an example in a Gallery Report WEB https://c2aby549.caspio.com/dp/83ff800011ea20ceac2f4bc18328 MOBILE
  21. If you want, you can use JavaScript to set a default password, if it's blank, it will be the default password, or if you want to hide the password field and just want the user to change upon first login or whatnot, just set the value of the field to the said default password before submit.
  22. Oh, alright, sorry about that, thank you for the solution, as well!
  23. What happens? Do you have a sample DataPage? nothing happens when my 2 fields are null (2and 3 for timepicker 1 and 2) If I put a value, it appends, Maybe you have some stray script or triggered action?
  24. Well, you can disable the Responsive and implement your own media query on your styles, this will affect everything tho, So, you will have to set a mobile version style for everything.
  25. I see, what I could suggest is if you could replicate the issue on a test DataPage, literally just the calendar with a test table as well, if you can replicate it there, then all the better
  • Create New...