Jump to content

LWSChad

Caspio Rockstar
  • Posts

    259
  • Joined

  • Last visited

  • Days Won

    34

Reputation Activity

  1. Like
    LWSChad got a reaction from Jan in Acknowledgement Email Multiple Emails Via Parameters   
    Try a Notification email rather than an Acknowledgement
  2. Like
    LWSChad got a reaction from Xiang in Recording "record Count" Into Data Table?   
    You could pass that as a parameter to an "Update Data Page" that auto-submits, but DON'T DO THIS
     
    This is poor database design. Use a view to count the records on display.
  3. Like
    LWSChad got a reaction from Jan in Hide A Submitbutton In The Header.   
    It looks like you have an extra closed bracket, but also try...
     1. Drop dropping in some alerts throughout to see where it's breaking.
     2. I recommend style.display = 'none' over style.visibility = 'hidden'
     
     
     
    <SCRIPT LANGUAGE="JavaScript">
    alert('Hi - test1');
    var eigenaar='[@s_id]';
    alert(eigenaar);
    var aanmaker='[@authfield:user_tabel_user_id]';
    alert(aanmaker);
    }
    if (eigenaar!=aanmaker)
    {
    alert('Not equal!');
      document.getElementById("Voeg_toe").style.visibility = 'hidden';
    alert('Visibility set to hidden. Is it hidden?');
       }
    </script>
  4. Like
    LWSChad got a reaction from MayMusic in Conditional Formatting Trick   
    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. Like
    LWSChad got a reaction from svitlanataran in Conditional Formatting Trick   
    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.
  6. Like
    LWSChad got a reaction from aam82 in Performance On Filtered Data - View Criteria Vs. Data Page Filters   
    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
  7. Like
    LWSChad got a reaction from Aurora in Performance On Filtered Data - View Criteria Vs. Data Page Filters   
    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. Like
    LWSChad got a reaction from Xiang in Tabbed Interface: Js Vs Iframe?   
    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'; } } 
  9. Like
    LWSChad got a reaction from Xiang in How To Monitor App User Activity?   
    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.
  10. Like
    LWSChad got a reaction from Xiang in Error Inserting Row   
    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
  11. Like
    LWSChad reacted to amayne in Import From Excel To Text(64000) Data Type.   
    Same result with REPLACE, but i found a fix...
     
    The import (update) with text(64000) field works fine from the older '.xls' excel format, but not from an .xlsx workbook.
     
    thanks
    ~allen
  12. Like
    LWSChad got a reaction from Aurora in Deleted Rows In 2 Tables   
    In Tables:
    Use relationships to link the tables and turn on "Cascade record delete"
  13. Like
    LWSChad reacted to Walter in Rich Text Field - Spell Check   
    Hi Chad,
     
    Livejournal has the same problem.
    You can disable Editor, than spell checkers should work, if it works for you.
  14. Like
    LWSChad got a reaction from reazul113 in Rich Text Field - Spell Check   
    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
  15. Like
    LWSChad got a reaction from derekcaldwell in Automation   
    Hello all!
     
    I have a brain twister here     .... there's gotta be a way. CCarls3 got very close with Email Trigger of Multiple Records, but rather than simply sending email notifications, how can we automatically create multiple records based on the results of a query (or displayed on a DataPage)?
     
    I hope to automate the scheduling of Tasks.
     
    Please consider the following scenario:
     
    ScheduledTask
     - ScheduledTaskID
     - Scheduled Activity
     - Due Date
     
    Workflow (Parent table that describes an automated workflow)
     - WorkflowID
     - WorkflowName
     
    WorkflowStep (Child)
     - WorkflowStepID
     - WorkflowID
     - Scheduled Activity
     - Days from Today (easily converts into DueDate)
     
     [Workflow -< WorkflowStep / One - to < Many]
     
    Worklows are groups of WorkflowSteps
    WorkflowSteps create ScheduledTasks
     
    Any puzzle solvers have a good idea how to accomplish this? (without sending emails to Zapier's parser)
     
    Thanks!!
  16. Like
    LWSChad got a reaction from derekcaldwell in Automation   
    B-bump it up
  17. Like
    LWSChad got a reaction from derekcaldwell in Loading Forms While Embedded.   
    Use iframes
     
    IFRAME:
    <iframe name="ifrPerson" class="licIframe" id="ifrPerson"></iframe> HTML...
    <!doctype html> <html> <head> </head> <body onload="resizeFrame('ifrPerson')"> <div id="ifr" class="ifrContent killHeader"> <!-- caspio snippet --> <script type="application/javascript" src="xxx"></script> <script type="application/javascript">try{f_cbload("xxxxxxxxxxxxx","http:");}catch(v_e){;}</script> <!-- caspio snippet --> </div> </body> </html> I use a script to set iframe source...
    document.getElementById('ifrPerson').src = 'lic-person.html?LeadID='+varLeadID;  and this one to resize the container... (must be called from the iframe)
    //resize LIC iframe on iframe load function resizeFrame(ifrName) { // Find the height of the iframe var ifrContentH = document.getElementById('ifr').scrollHeight; // is it too tall to be empty? if (ifrContentH > 32) { // yup, then tell the parent to give it some room window.frameElement.ownerDocument.getElementById(ifrName).style.height = ifrContentH+'px'; } else { // no, keep it 0px tall,,, or make it 0px after deleting a record. window.frameElement.ownerDocument.getElementById(ifrName).style.height = '0px'; } } Hope it helps
  18. Like
    LWSChad reacted to Aurora in Redirect If Not Logged In   
    Hello Chad!
     
    You could edit the Advanced Setting of your Authentication and set time limit for Timeout and TimeOut Redirection. 
     
    In this article you can see the procedure for LogOut button and use the same approach for TimeOut.
     
    Aurora
  19. Like
    LWSChad reacted to Jan in Email Trigger Of Multiple Records   
    Hello everyone,
     
    I have found a solution, but it requires additional steps.
     
    Select the field with id or with any unique value, on the Advanced tab, select the Pass field value as parameter checkbox and copy the name of the parameter (for example, "[@id]"). Add a Virtual field, select the Hidden Form element, select the External Parameters "On load, receive", paste the name of the parameter from step 1 (for example, "[@id]"). Add the second Virtual field, select the Hidden Form element, select the Data Source Field "On load, receive", select the field with id or with any unique value, the field from step 1. Add the Header&Footer element, select the Footer element, click the Source button and enter the following script: <script type="text/javascript"> if(document.getElementById("caspioform")) { if(document.getElementById("cbParamVirtual1").value==document.getElementById("cbParamVirtual2").value)   {           document.getElementById("caspioform").style.visibility = 'hidden';      document.write('<font face="arial" color=red size="5">Email Notifications have been Sent!');        } else   setTimeout('document.forms["caspioform"].submit()',1000); } </script> I hope, it works. And it is not too complex
  20. Like
    LWSChad got a reaction from menathansmith in Automation   
    Hello all!
     
    I have a brain twister here     .... there's gotta be a way. CCarls3 got very close with Email Trigger of Multiple Records, but rather than simply sending email notifications, how can we automatically create multiple records based on the results of a query (or displayed on a DataPage)?
     
    I hope to automate the scheduling of Tasks.
     
    Please consider the following scenario:
     
    ScheduledTask
     - ScheduledTaskID
     - Scheduled Activity
     - Due Date
     
    Workflow (Parent table that describes an automated workflow)
     - WorkflowID
     - WorkflowName
     
    WorkflowStep (Child)
     - WorkflowStepID
     - WorkflowID
     - Scheduled Activity
     - Days from Today (easily converts into DueDate)
     
     [Workflow -< WorkflowStep / One - to < Many]
     
    Worklows are groups of WorkflowSteps
    WorkflowSteps create ScheduledTasks
     
    Any puzzle solvers have a good idea how to accomplish this? (without sending emails to Zapier's parser)
     
    Thanks!!
  21. Like
    LWSChad got a reaction from ycollier in How To Determine If The User Is Currently Logged In?   
    If a DataPage that requires authentication is not authenticated it won't populate; so you can test for the presence of elements within said DataPage.
     
    Create a DataPage that requires authentication that contains the following div
    <div id="loggedInTestDiv">Hi</div> Embed and hide it.
    <div id="loggedInTestPage"> <script ... Caspio Data Page ...></script> </div> #loggedInTestPage { display: none; } Determine the Div's existence and show or hide the Side Bar.
    http://stackoverflow.com/questions/10886190/check-if-a-div-does-not-exist-with-javascript
    var mySideBar = document.getElementById('sideBar'); var myTestElem = document.getElementById('loggedInTestDiv'); if (myTestElem == null) { //user not logged in mySideBar.style.display = 'none'; } else { //user logged in mySideBar.style.display = 'inline': } Hope it Helps
  22. Like
    LWSChad reacted to Jan in Friendly Link For Files   
    Hi Chad,
     
    As far as I know, you can use the following format:
     
    URL/dpImages.aspx?appkey=APPKEY&file=/FILENAME
     
    For example,
    https://bx.caspio.com/dpImages.aspx?appkey=xxx&file=/image.png
     
    "/" before filename is required.
     
    Is it a "friendly" link?
  23. Like
    LWSChad reacted to Jan in Hint Moves Down When Page Scrolls   
    Hi Chad,
     
    What browser do you use?
    I have checked in Firefox, Internet Explorer and Chrome and the issue does not reproduce.
     
    Could you provide the URL of your page? Maybe, I will be able to find the reason of the issue.
  24. Like
    LWSChad got a reaction from Kennethflit in Hint Moves Down When Page Scrolls   
    Hello Caspio Ninjas!
     
    I've noticed when the page scrolls down the Hint Popup moves an equal distance down from the element producing the hint. When scrolled down more than a few lines the Hint popup moves all the way off the screen.
     
    I just tested it in a "preview" mode, and noticed that it only happens on embedded Data Pages. I removed all of my javascript for testing, and it didn't fix it. I even removed all markup except the script for a DataPage Where would i begin trying to diagnose this problem? What might be affecting the Caspio Hint popup from my page?  
    Thanks

  25. Like
    LWSChad got a reaction from thanhvu in Sites - Connection Problems   
    Hello All!
     
    My daily backup quit working a week ago.
     
    I have FTP access set up on with my host, and I regularly access it with Dreamweaver and FileZilla.
     
    I've tried Caspio FTP access and HTTP access both with the same results.
     
    When I first click TestConnection it tells me "Connection Failed", when I try again it works.  If I wait a period of time after success it eventually goes back to "Connection Failed" for one attempt then works again.  This happens whether I stay on the Sites settings page or leave and come back.
     
    I'm very confused... any ideas?
     
    Thanks
     
    UPDATE:
    I'm using an Email site so I can backup my data, but that is far from ideal.
×
×
  • Create New...