Jump to content

NailDyanC

Caspio Rockstar
  • Posts

    409
  • Joined

  • Last visited

  • Days Won

    11

Posts posted by NailDyanC

  1. To achieve your desired result, please try to use this formula:


    CASE
    WHEN [@field:TimeAssigned] Is Null
    THEN ''
    ELSE
    CAST((DATEDIFF(HOUR, [@field:Time], [@field:TimeAssigned]) / 24) AS VARCHAR)
    + ':' +
    CAST((DATEDIFF(HOUR, [@field:Time], [@field:TimeAssigned]) % 24) AS VARCHAR)
    + ':' +
    CASE WHEN DATEPART(SECOND, [@field:TimeAssigned]) >= DATEPART(SECOND, [@field:Time])
    THEN CAST((DATEDIFF(MINUTE, [@field:Time], [@field:TimeAssigned]) % 60) AS VARCHAR)
    ELSE
    CAST((DATEDIFF(MINUTE, DATEADD(MINUTE, -1, [@field:TimeAssigned]), [@field:TimeAssigned]) % 60)
    AS VARCHAR)
    END
    + ':' + CAST((DATEDIFF(SECOND, [@field:Time], [@field:TimeAssigned]) % 60) AS VARCHAR)
    END

    The output will be dd:hh:mm:ss.

  2. Hi,

    There are two ways to achieve your workflow, first is by using standard option, just duplicate your DataPage then in the "Search and Report Wizard - Search Type" you may choose the "Filter data based on your pre-defined criteria" option so that you will not have a search form in your tabular report.

    Make sure as well not to include fields in the search filtering once you choose that option. The second option is by using custom CSS to hide the Search form. You may try and check this code:

    div[id^="cbOuterAjaxCtnr"]:nth-child(1) {
        display: none !important;
    }

  3. Hi @MattAuer, that error message is shown when one or more resources (for example emails, storage or data transfer) utilized by your DataPages has reached its daily or monthly limits. As you mentioned you have also reached your maximum DataPages. I once have a Free Account then my solutions consultant advised me to avail or upgrade my free account to a paid plan to increase my limits.  I suggest to contact your solutions consultant to get more information about this. 

  4. You may try this formula:


    CASE WHEN
    [@field:FirstName1] = ' '
    THEN
    IsNull([@field:LastName1], ' ') + ' ' + IsNull([@field:FirstName2], ' ') + ' ' + IsNull([@field:LastName2], ' ')
    WHEN
    [@field:LastName1] = ' '
    THEN
    IsNull([@field:FirstName1], ' ') + ' ' + IsNull([@field:FirstName2], ' ') + ' ' + IsNull([@field:LastName2], ' ')
    WHEN
    [@field:FirstName2] = ' '
    THEN
    IsNull([@field:FirstName1], ' ') + ' ' + IsNull([@field:LastName1], ' ') + ' ' + IsNull([@field:LastName2], ' ')
    WHEN
    [@field:LastName2] = ' '
    THEN
    IsNull([@field:FirstName1], ' ') + ' ' + IsNull([@field:LastName1], ' ') + ' ' + IsNull([@field:FirstName2], ' ')
    END

     

    Just change the fields that I usedepending on the fields that you are using. I hope that helps you.

     

  5. Hi @KAPITYAN,

    You may try this workaround. Add a Header/Footer to your form and add the following code in the footer:

    <script>
    function setSearchIssue(){
    var issue = document.querySelector('input[id*="cbParamVirtual8"]').value;

    document.getElementById("InsertRecordName").value = issue;
    }
    document.querySelector('input[id*="cbParamVirtual8"]').onchange = function() {setSearchIssue()};
    </script>

    Also refer to https://forums.caspio.com/topic/4377-js-guide-caspio-form-elements/ for help on addressing different form elements.

     

  6. Hi Roderick,

    Can you please try to use this formula:
    SELECT Field_Name FROM Table WHERE '[@cbParamVirtual2]'= target.[@field:ID]

    Just get the "[@field:ID]" in the field picker of your Calculated Values- Formula field. Also, just make sure that the value of the "[@cbParamVirtual2]" is equal to your "[@field:ID]" for you to get your desired result.

    I hope that helps.

     

     

  7. Hi, just to update this post. I believe that Caspio can save a video file in the table (Single file upload via DataPage submission is 50 MB) but it will not or cannot be played in the DataPage once you play it because I think they don't have a player for that. But you may try this code that I get from this link:  

    <video width="400" controls>
      <source src="[@field:Video_File/]" type="video/mp4">
      Your browser does not support HTML5 video.
    </video>
  8. Hi, just to update this post. I also have the same issue before, I believe that Caspio can save a video file in the table (Single file upload via DataPage submission is 50 MB) but it will not or cannot be played in the DataPage once you play it because I think they don't have a player for that. But you may try this code that I get from this link: 

     

    <video width="400" controls>
      <source src="[@field:Video_File/]" type="video/mp4">
      Your browser does not support HTML5 video.
    </video>
  9. Hi. I have two workaround that I can suggest for this workflow. One is you can have a year field in your table together with the student information and their grades then use that table as your Data source in your Details DataPage. You can have a Search filtering in your Details DataPage so that you can search it by year or any fields that you would like to use as a filtering to arrive with your desired result.

    The other workaround would be if you are using two tables. You can connect the two tables (i,e Student _Information table and the Student_Grades table which contains the Grade and year) using Relationships like StudentID from the main table would be the foreign key to the other table(The StudentID would be the connecting field between the two tables). After, create a view to join the two tables and use that View as your Data source in your Details DataPage. Same as in the first workaround, you can have a Search filtering in your Details DataPage so that you can search it by year or any fields that you would like to use as a filtering..

    I hope that helps.

  10. Hi,

    Just to add from the previous comment above. Caspio  enables you to quickly create powerful online applications without or less programming. Caspio is a Rapid Application Development, unlike manual programming that will take you months to finish a certain application or program but in Caspio you can do it just by days or weeks. 

    And they have video tutorials and HowTo documentations that you can refer to:

    https://www.youtube.com/user/CaspioInc
    https://howto.caspio.com/

    They also have Ready-made applications that showcase the features of the platform. You may want to visit them at https://www.caspio.com/apps/ to find workflows that may suit your application needs.  

    By the way, they offer free instructor-led training sessions multiple times per week. These online training helps you get up and running quickly. You can sign up in these training session here: https://www.caspio.com/training/ or watch the pre-recorded training sessions at http://howto.caspio.com/pre-recorded-live-training/  

    Those online training really helped me a lot in building my desired application.

    Moreover, for me what makes them standout among other database platform is the support they gave to us. They always make sure that we get and achieve what we really want to do with our application. They always provide a high class support. And I think Caspio Support is available 24/7 but weekend support is limited to live chat, tickets, and emails. And you can easily reach them through these contact details: 

    Support Number: 650 691 0900 and choose Option 2 to reach Caspio Technical Support line. 
    Email: support@caspio.com

    Hope this will help you. 

  11. Hi,

    I just want to add to the previous comment above, this is just based on the information provided to me by a Caspio expert when I also inquire to them about this issue.

    Caspio count how much data “leaves” the Caspio database as the DataPage is rendered. If the DataPage has a lot of lookups, dropdowns, cascade elements or Ajax editing abilities, you will see an increase in data transfer. 

    This is a good resource of best practices: http://howto.caspio.com/datapages/best-practices-in-creating-caspio-applications/. Using browser tools (F12 and Net Tab) is a good way to estimate the size, but the actual size might not be exactly what is counted from the systems. Below is more information that can help to understand the areas contributing to data transfer:

    Activities performed inside Caspio Bridge that incur data transfer include:

    1. Preview Submission Form and you submit data and files.
    2. Preview Search and Report DataPage and you Search. When you get results with many rows and images, sorting and paging, and click to details and go back to results.

    Activities performed inside Caspio Bridge that doesn't incur data transfer include:
    1. Creating and accessing objects
    2. Import of apps/tables/DataPages
    3. Export of objects
    4. Upload and Download of files
    5. Preview of Submission form without lookup dropdowns
    6. Preview of Report DataPage, direct to results (or details) that do not display images nor paging activities

    Moreover, whenever your end users submit or retrieve data through your apps, data is transferred between Caspio’s servers and the user. The accumulation of data transferred in each interaction through apps, APIs, and import/export determines your monthly data transfer. Each package includes pre-allocated data transfer. If the data transfer limit for the month is approached, you will receive a courtesy email so that you can decide whether you want to add more data transfer as an add-on to save money. 

    Also, you can check the number of used resources within your Caspio Bridge account if you select from the top menu bar "Account"-->"Usage and billing".

  12. If you have created a "Submission" or "Single Record Update"  DataPage then that's a correct behavior of a radio button on an update page not to be able to set a default value as the value of the radio button is being fetched from the Table , so you can NOT have a default value for the Radio button.

    Only on the Submission DataPages you are able to set the default value for either radio buttons or checkboxes. In other words, the check button on the radio button is grayed out due to this reason, this field is already populated therefore neither the "Select" nor any other radio button values can be set initially as the default but the value already saved in the table for that field.

    Please note that the default option for a dropdown menu, checkboxes and radio buttons is disabled on an "Update DataPage" as it gets its values from the data source table. And the field that you have selected already has a default value since it is a text field (in your case, it is making 0 as the default value because it is retrieving the record from your data).
     

    I hope that helps.

×
×
  • Create New...