Jump to content


Caspio Rockstar
  • Posts

  • Joined

  • Last visited

  • Days Won


Reputation Activity

  1. Like
    LWSChad reacted to iren in Calculated Field - Count, Datepart   
    Hi Chad,
    You can use following code in aggregation field: 
    COUNT(CASE WHEN (DATEPART(hh, DateTime) >= 10 AND DATEPART(hh, DateTime) <= 16) THEN DateTime ELSE NULL END)
    DateTime should be changed on your value.
    Hope it helps.
  2. Like
    LWSChad reacted to LWSChad in Reload Iframe From Different Window (Not Child) - Javascript   
    I found a solution.
    1) I name the main page 
    <a href="url" target="lic">  2) refer to it from the non-child popup onunload
    <script> window.onunload = refreshLic;     function refreshLic() {         window.open('javascript:window.ifrVehicle.location.reload()','lic');     } </script>
  3. Like
    LWSChad got a reaction from prlsol in Multi-Layer Relationship   
    Thanks for your reply!
    I'll submit a request to add a feature to enable views as sources for views.... IMHO that would be much easier than duplicating the User table every time a new user is added or user info is changed.
  4. Like
    LWSChad got a reaction from Thomasea in Format On Display   
    I have been storing phone numbers with the special characters ( ) - and I would prefer to store numbers only and format the data into phone numbers on display.
    I can format one per page, but only the first one.
    Can anybody help me with this?
  5. Like
    LWSChad reacted to Jan in Format On Display   
    Hello CHAD,
    What type of DataPage do you use?
    And how you format one per page? Could you please provide the Java Script code?
  6. Like
    LWSChad reacted to Jan in Format On Display   
    Hello CHAD,
    There is a Java Script solution for Submission Forms.
    But I am afraid, I do not understand clearly what is your goal.
  7. Like
    LWSChad got a reaction from jonathanr in Delete Multiple Records - Autosubmit   
    OK, cool.
    In that case I'll wait until that is complete.
    In the meantime I'll simply mark leads for deletion and do it either with SQL on my local machine or by directly manipulating the Caspio tables.
  8. Like
    LWSChad got a reaction from jonathanr in View Vs. Table   
    Cool, thanks for the explanation.
    I use multiple datapages in many of my webpages, and every user interaction (up to 75 / hour / user) must process multiple auto-submitting datapages.
    A tenth of a second per datapage load might add up... we'll see.
  9. Like
    LWSChad reacted to Jan in Calculated Dates Precision   
    Hello EIQ,
    Please, try
    As far as I know, Calculated Fields try to display result in the DataType that are used in calculations. For example, you divide by "60" - and the Result is Integer. If I understand correctly, if you divide by "60.00" - Result will be General, like 0.25.
    By the Formatting button you can define how many digits after decimal will be displayed.
  10. Like
    LWSChad reacted to Jan in Calculate A Percentage   
    Hello EIQ,
    As far as I know, aggregate functions cannot work with several fields. I mean, COUNT_NON_BLANK [@tblActionLog_ActionCompletionDT]) / (MIN [@pUser_QFGoalWeek] is the same as COUNT_NON_BLANK / MIN and this formula is applied to all fields that are added to the right-hand panel.
    If I understand correctly, the DataType of your pUser_QFGoalWeek field is Text255 or Integer. If you change the DataType to Number/General, the result should be 500% but note that values of the same field are counted as "non blank".
  11. Like
    LWSChad reacted to Jan in Dynamic Data Source   
    Hello EIQ,
    There is the standard feature Record Level Security allows to restrict access to records based on the current user’s profile data. For example, based on AccountID. You can see the video about this Feature.
    It seems, it can help.
    Also, you can create user-specific redirect after login (video), but in this case it requires to create a separate DataPage for every DataSource.
    As far as I know, it is impossible to dynamically set the data source of a DataPage.
  12. Like
    LWSChad reacted to Jan in Dynamically Choose Lookup Table For Dropdown List   
    Hello EIQ,
    Maybe, you can use a Conditional Form?
    You can create two fields, Opt1Child and Opt2Child.
    If a user selects Opt1, Opt2Chils is hidden and vice versa.
  13. Like
    LWSChad reacted to Jan in Disable Autocomplete   
    Hello Eiq,
    As far as I know, you can add the Header&Footer element and enter the following code to the Footer:
    <script type= "text/javascript"> document.getElementById("caspioform").autocomplete = 'off'; </script> I hope it helps.
  14. Like
    LWSChad reacted to Jan in Field Type Size Comparisons   
    I tried define types using maximal values.
    General Number - allows 15 digits, probably, type is float = 8 bytes per record
    Integer Number - from -2147483648 to 2147483647, probably, type is int = 4 bytes per record
    Currency Number  - from -922337203685477.5808 to 922337203685477.5807, probably, type is money =  8 bytes per record
    Yes/No - probably, 1 byte per record
    Text(255) and Text(64000) - as far as I know, if you can use Unicode, it is probably ntext for Text64000 and probably nvarchar for Text255 (because with long string the size of a table growth faster) - so, I think, storage size, in bytes, is two times the string length that is entered for both types.
    But I am not sure about answers
  15. Like
    LWSChad reacted to caspio in Js: Auto-Submit A Datapage   
    JavaScript Solution: Auto-Submit a DataPage
    Feature Description:
    This JavaScript solution shows how to auto-submit a DataPage. Caspio DataPage only submits to one table so if you need to perform submission to multiple tables you can use another DataPage and the following JavaScript to auto submit.

    This solution can be used "as-is", without any changes if 
    a. It is used in a Submission, Single Record Update, or Details DataPage and
    b. The DataPage is the only one Caspio DataPage deployed on your web page.
    c. The "progress_bar" image exists on your site: www.yoursite.com/images/progress_bar.gif. Or the URL should be adjusted to where your file is located.

    To use this solution, copy the code below and paste inside the HTML Header section of the DataPage using the Caspio Bridge DataPage Wizard.
    <div align="center"> <p>Processing...</p> <img src="images/progress_bar.gif" alt="Progress Bar" width="200" height="15" /> </div>  
    Then insert an HTML Block, copy the code below and paste inside the HTML Block section:
    <script type="text/javascript">   if(document.getElementById("caspioform")) {   document.getElementById("caspioform").style.display = 'none';   setTimeout('document.forms["caspioform"].submit()',1000); }  </script>  
    In  submission successful message area, click on Source button and paste the code below.
    <style type="text/css"> #processing{ display:none; } </style>  
    Tested Browsers
    This JavaScript solution was tested on the following platforms and Internet Browsers only.
    # MS Windows - IE 10, Firefox 25.0.1, Chrome 31.0.1650.57, Safari 5.1.7

    Disclaimer: Use these JavaScript solutions at your own risk! They are provided to assist you in the customization of your programs and while we believe they work properly, by using them you accept all responsibility about them and confirm that they are not a feature of Caspio's platforms and as such are provided "as is" without any warranties, support or guarantees. 
  • Create New...