Jump to content

ezIQchad

Caspio Guru
  • Content Count

    238
  • Joined

  • Last visited

  • Days Won

    32

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> <a class="btnLink fileLink[@field:FileLink]" href="[@field:FileLink]">View File</a> css /*-- when [@field:***] is null, hide the div --*/ .fileName, .fileLink { display: none; } Hope this helps Think Easy CHAD -I know the Title of this Forum is "Ask....", but IDK where else to share stuff like this.
  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 iframe source function setIframeSource() { varLeadID = getQueryVariable("LeadID"); document.getElementById('ifrLeadSummary').src = 'lic-leadSummary.html?LeadID='+varLeadID; } </script> child <div id="ifr" class="ifrContent ifrLeadSummary"> <script type="application/javascript" src="https://b5.caspio.com/scripts/e1.js"></script> <script type="application/javascript">try{f_cbload("***","http:");}catch(v_e){;}</script> </div>
  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 way to not show this? I doubt this is possible w/o hosting your own data. White Labeling Caspio doesn't move it to your own servers, it just hides the branding. If you're actually downloading something, the location cannot be hidden for security reasons.
  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="popupWindow('addPerson.html', 438, 720)" class="addRecord"></a> </div> <div id="ifrDiv"> <iframe name="ifrPerson" class="licIframe" id="ifrPerson"></iframe> </div> </div><!-- frmPerson --> <script> //set iframe source function setIfrSrc() { varLeadID = getQueryVariable("LeadID"); document.getElementById('ifrPerson').src = 'lic-person.html?LeadID='+varLeadID; document.getElementById('ifr***').src = 'lic-***.html?LeadID='+varLeadID; } </script> </body> </html> Child Page - lic-person.html <html> <head> <meta charset="utf-8"> </head> <body onload="resizeFrame('ifrPerson')"> <div id="ifr" class="ifrContent killHeader licIfr"> <script type="application/javascript" src="http://b5.caspio.com/scripts/e1.js"></script> <script type="application/javascript">try{f_cbload("88appKey88","http:");}catch(v_e){;}</script> </div> <script src="js.js"></script> </body> </html> javascript to size the iframe //resize LIC iframe on iframe load function resizeFrame(ifrName) { // Call out to the parent iframe. var ifrContentH = document.getElementById('ifr').scrollHeight; if (ifrContentH > 32) { window.frameElement.ownerDocument.getElementById(ifrName).style.height = ifrContentH+'px'; } else { window.frameElement.ownerDocument.getElementById(ifrName).style.height = '0px'; } }
  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. ezIQchad

    Reset Parameter

    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 alignright', 'bold italic underline superscript subscript | forecolor backcolor | fontselect fontsizeselect', 'image link | charmap emoticons | hr nonbreaking | removeformat | code'], menubar: "", contextmenu: "cut copy paste | image link | bold italic underline | hr nonbreaking | spellchecker", default_link_target: "_blank", browser_spellcheck: true, font_formats: 'Arial=arial,helvetica,sans-serif;'+ 'Arial Black=arial black,avant garde;'+ 'Comic Sans MS=comic sans ms,sans-serif;'+ 'Courier New=courier new,courier;'+ 'Georgia=georgia,palatino;'+ 'Impact=impact,chicago;'+ 'Tahoma=tahoma,arial,helvetica,sans-serif;'+ 'Times New Roman=times new roman,times;'+ 'Trebuchet MS=trebuchet ms,geneva;'+ 'Ubuntu=Ubuntu,verdana,sans-serif;'+ 'Verdana=verdana,geneva;' }); -CHAD
  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...