Jump to content


Caspio Ninja
  • Content Count

  • Joined

  • Last visited

  • Days Won


Everything posted by TellMeWhy

  1. 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.
  2. 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-
  3. 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
  4. This worked for me try style="width:[@calcfield:1#]%" number instead of % instead, then percent outside to append it.
  5. 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%];">
  6. 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
  7. Each request would probably need one submission each.
  8. 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
  9. 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 sibling
  10. 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/
  11. 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 mean
  12. 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
  13. 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.
  14. Oh, alright, sorry about that, thank you for the solution, as well!
  15. 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?
  16. 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.
  17. 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
  18. Not sure, as well, but I have difficulties in using button tag on Caspio as it 'clicks' the submit button, as well. Try to use <input type="button> or <a> tags instead of <button> and just style them the same.
  19. That's strange, can you send your URL for this DataPage? It should be the same for everyone since it's a customized CSS, do you have other styles that can affect this?
  20. I don't think this is possible. Even if you are using List-String, and Multi-select form elements, the report will only show the records with the EXACT data you selected in the multiselect, it does not work as 'If any of the records has any of these values, show' You can create multiple criteria for one field. Each criteria can only hold one value, and the logic for all criteria would be OR. It's not dynamic though, so, you have to set a specific number of criteria.
  21. Unfortunately, you can't do both of those (alert and disable button) without JavaScript. You can try the following <script> document.addEventListener("BeforeFormSubmit", function(event) { var VirtualVal = document.querySelector('select[name="cbParamVirtual1"]').value; if(VirtualVal == '0'){ alert('You have no more classes available.'); event.preventDefault(); } }); </script> This gets the value of your Virtual 1 - (cbParamVirtual1) and if it's 0, it will provide an alert with a custom message, and prevent the form from submitting. T
  22. I think it's more complicated now. You can try this one <style> .flatpickr-calendar{ width:600px; } .flatpickr-innerContainer{ height:350px } .dayContainer{ grid-gap: 20px 0; } </style> First one is width of the whole 'box' second one is the height of the DAY container, it does not include the day labels, month/year, and the section on the bottom Third one is to adjust the gaps between each DAY so they fill the empty space created by adjusting the height.
  23. It would depend on what DataPage are you using. It should be pretty easy on a Reports DataPage, you can just use Select Statement and then directly use the Calculated Field on the query string. If it's a submission, you might need to use JavaScript to set the value in the query string, since you can't use fields in HTML blocks in submission forms
  24. What DataPage are you using? What are you using this QR Code for? Yyou can probably insert the field in the QR CodeURL, squeeze it in there. like qrlink.com?someqrcode[@field:Caspio]&someqrcodeagain
  25. Yes it actually is! DataPageReady reads ALL DataPages, if you have 3, 3 DataPages will be 'ready' so it will do that 3 times. There's a fix using example 2 here https://howto.caspio.com/datapages/ajax-loading/ Just add this after DataPageReady if (event.detail.appKey == 'APPKEY') { Don't forget a closing bracket before the last closing bracket and parenthesis, try adding the following as well EDIT: I forgot there is one already in the original I provided, so you can omit the line here, just add the bracket. event.stopImmediatePropagation(); Ge
  • Create New...