Jump to content


Caspio Guru
  • Content Count

  • Joined

  • Last visited

  • Days Won


Everything posted by ezIQchad

  1. Just drop the ELSE WHEN [@calcfield:5]<= 0 THEN '[@app:URL_11_0]' edit... or maybe you just need a THEN in the ELSE ELSE THEN '[@app:URL_11_0]' I don't know for sure, but it'd be worth a try
  2. Very easy. In the "Advanced" tab, check "On exit: Pass field value as param" Auto Submit - http://forums.caspio.com/index.php/topic/4314-js-auto-submit-a-datapage/
  3. I would suggest the footer.** Put this code in the "Source" of the Footer by clicking the "<>" button, or disable the HTML editor as you mention. **Code in the Footer often helps performance. **Code in the Header allows you to do stuff before the pages loads.
  4. Check out this trick I stumbled upon. Put Caspio Variables into your Classes so you can use CSS to dynamically style your pages. (js not required) Div to dynamically format <div class="action[@field:action]"></div> css .actionCall { background-image: URL("../img/call.png"); } .actionEmail { background-image: URL("../img/email.png"); } .actionText { background-image: URL("../img/text.png"); } Dynamic Elements - load all options, and hide all but needed <a class="btnFile fileName[@field:FileName]" href="../some/dir/[@field:FileName]">Download</a
  5. You need to put the DataPage which you want to refresh in an iframe. See my approach to this below parent <body onload="setIframeSource()"> <div id="frmSummary1" class="licFr"> <div class="divHeader"> <h2>Summary</h2> <a onclick="window.ifrLeadSummary1.location.href = 'lic-leadSummary.html'"></a><!-- refresh button --> </div> <div id="ifrDiv"> <iframe name="ifrLeadSummary1" class="licIframe" id="ifrLeadSummary1"></iframe> </div> </div> <script> //set
  6. Try Faking the Click CSS to hide the search button #searchID { display: none; } JS to click the hidden button document.getElementById('dropdownID').onchange = function(){ document.getElementById('searchID').click(); }
  7. Hi, I'd like to share a performance tweak I discovered this morning. Filter your data at the Data Page, not the View. In a View, I filtered out values based on the criteria of time-stamped values from the last 30-days. The Data Page that used this view took ~9 seconds to load. I switched to Filtering a DataPage, and now it loads in <1 second. Think Easy CHAD
  8. Use some CSS or JS to move things around... though pointing at an aggregate value is difficult as they don't have IDs. something like #caspioform td:nth-child(2), #caspioform td:nth-child(3), #caspioform td:nth-child(4) { position: absolute; top: 48px; }
  9. 1) Is there a way for the logout link to show in the action bar at the top, where the 'Download Data' link is, instead of having to put it in the header? Try right clicking the logout button and "Inspect Element". Then add some CSS (or maybe JS) to move it where you need. 2) When I hover over the logout link or the download data link, the URL shows as https://eu1.caspio.com/xxxxx. I would prefer for this not to mention caspio, as this is customer facing. Is there a way to do this? 3) When I download data, it prompts me to accept to download from eu1.caspio.com. Same as above: is there a w
  10. Use two pages to search. A Search page & a Results page. You can then send an Acknowledgement or Notification after the search params are submitted. See how to do that --->>> http://howto.caspio.com/tech-tips-and-articles/parameters/how-to-separate-search-page-and-results-page-into-two-different-webpages/
  11. Search for a character that could be messing with the import. I encountered this before, and I think it was an apostrophe. Search for and omit... ' (apostrophe) , (comma) ; (semi-colon) ` (tilde) There could be more, but I bet it's a special character problem
  12. I don't know anything about Omniture, but I know you could create a custom solution that use Auto-Submitted data pages to create records in a User Log table.
  13. I don't do anything special. Check out my code... Parent Page - leadinfocenter.html (LIC) <html> <head> <meta charset="utf-8"> </head> <body onLoad="setIfrSrc()"> <!-- frmPerson --> <div id="frmPerson" class="licFrame fr1"> <div class="divHeader dh2"> <h5>People</h5> <a href="javascript:showHide('ifrPerson')" id="btnHide" class="btnShowHide"></a> <a onclick="window.ifrPerson.location.href = 'lic-person.html'" class="ifrRefresh"></a> <a onclick="
  14. Something like this function salCalc() { var annSal = document.getElementById('EditRecordAnnualSalary').value; var calcF3 = document.getElementById('calcField3').value; var calcF5 = document.getElementById('calcField5').value; var answerEle = document.getElementById('answerElementID'); var answerVal = (annSal - calcF3)/(calcF5 - calcF3) answerEle.innerHTML = answerVal; }
  15. Pass a parameter from the first form, in which they selected a search preference to an External Param. If the search preference is selected once and remembered forever, add that info to the Auth table
  16. I use iframes. They load quickly, and you can refresh one datapage rather than an entire web page. Difficult, but awesome
  17. In Tables: Use relationships to link the tables and turn on "Cascade record delete"
  18. Use a Cascading dropdown for the County dropdown They're pretty straightforward once you know that what to choose.
  19. Hi, I need to retain a Primary Key while resetting an Email Parameter cbResetParam is too broad for a specific scenario Is there a way to reset a specific parameter? Thanks
  20. I decided to use TinyMCE again TinyMCE - https://www.tinymce.com/ Using TinyMCE,,, Browser Spellcheck works Rich Text editing on Android works Cut Copy Paste is more powerful Check it out if you need a fully functional Rich Text editor It's Awesome //load tinyMCE tinymce.init({ selector:'textarea#InsertRecordEmailBody', statusbar: false, plugins: "autolink charmap code textcolor contextmenu emoticons fullscreen hr image imagetools link nonbreaking paste spellchecker", toolbar: [ 'fullscreen | undo redo | cut copy paste | alignleft aligncenter alignjustify
  21. Thank you for the suggestion. I reached out to Caspio support, and they said I should add it to the IdeaBox. (?!?) http://ideabox.caspio.com/forums/164206-caspio-bridge/suggestions/10970004-rich-text-editor-spell-check
  22. Hi Gurus! A while back I switched from TinyMCE to Caspio's Rich Text editor , and recently noticed the native browser Spell Check doesn't work . (I tested in Chrome, Edge, and Firefox) The spell check works in "Source", but not in the "Rich Editing" mode. Anybody know how to get around this? Thanks
  23. Hi, As usage is increasing, I'm getting more and more ErrCode 367 & 368 / Failed Data Integrity Check. I assume this is from the sequential nature of the PK Autonumber, but before I change all my tables to a different PK generator, please help me understand Random ID. If I switch the PK from Autonumber to Random ID, will I still be able to maintain imported values, like I can with Autonumber? Thanks!! CHAD
  24. For now, as a workaround, try: 1) export table 2) in excel add the text(64000) 3) REPLACE rather than UPDATE
  25. Thanks, IDK how I overlooked that... is it new? Either way, that's exactly what I need.
  • Create New...