Jump to content

NailDyanC

Caspio Rockstar
  • Posts

    392
  • Joined

  • Last visited

  • Days Won

    9

Everything posted by NailDyanC

  1. Hi, just to add to the previous comment above, you may try to check this link: https://howto.caspio.com/tech-tips-and-articles/common-customizations/how-to-generate-link-menus-and-popup-windows/
  2. The first step in creating a web-based application is to build a normalized table. Make sure that the tables are well-architected accordingly to the needs of your application. You can click the links below: Introduction to Table and Table Design Data Normalization: https://www.youtube.com/watch?v=oexOYUUyQik One-to-Many Relationships: https://www.youtube.com/watch?v=IstAk982ntA Many-to-Many Relationships: https://www.youtube.com/watch?v=7D8u6Lb2BKU Caspio also has training materials that can help you in building your applications. You may want to visit them: https://howto.caspio.com/ https://howto.caspio.com/getting-started/ https://www.youtube.com/CaspioInc And if you have any platform related questions, I think Caspio Support is available 24 hours a day, 7 days a week now. Weekend support is limited to live chat, tickets, and emails. You can reach them through this contact details: Support Number: 650 691 0900 and choose Option 2 to reach Caspio Technical Support line.
  3. Hi All, here's the new release notes for the upcoming new Caspio Version which is Caspio Bridge 24.0: https://howto.caspio.com/release-notes/caspio-bridge-24-0/
  4. Hi All, here's the new release notes for the upcoming new Caspio Version which is Caspio Bridge 24.0: https://howto.caspio.com/release-notes/caspio-bridge-24-0/
  5. You check these video tutorials about triggered action:
  6. You may consider also checking this video tutorial on how to achieve that using triggered action:
  7. Hi @KAPITYAN, Just to add from my previous comment above, you may try use this one as well: CASE WHEN [@field:TimeAssigned] IS NULL THEN ' ' ELSE CONVERT(VARCHAR(MAX),(Datediff(day, [@field:TimeAssigned], [@field:Time]))) + CONVERT(varchar(5), DATEADD(minute, DATEDIFF(MINUTE,[@field:TimeAssigned], [@field:Time]), 0), 114) END
  8. Just to add, you may also use triggered action to calculate the total of one column. You may check the links below:
  9. 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.
  10. 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; }
  11. Hi, just want to add. You may check these video tutorials about importing data:
  12. 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.
  13. 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.
  14. Hi @Batchini You may also try this formula: CASE WHEN [@field:Prefix] = ' ' THEN IsNull([@field:FirstName], ' ') + ' ' + IsNull([@field:LastName], ' ') ELSE [@field:Prefix] + ' ' + IsNull([@field:FirstName], ' ') + ' ' + IsNull([@field:LastName], ' ') END
  15. 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.
  16. Here's the new update about Caspio's new version release which is 23.0: https://howto.caspio.com/release-notes/caspio-bridge-23-0/
  17. Here's the new update about Caspio's new version release which is 23.0: https://howto.caspio.com/release-notes/caspio-bridge-23-0/
  18. Hi, it seems that your workflow requires API integration. You may consider checking this link: https://howto.caspio.com/web-services-api/ https://zapier.com/apps/caspio-cloud-database/integrations/sql-server
  19. 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.
  20. Just to update this post, here's the new and updated link for creating a cascading dropdown: https://howto.caspio.com/datapages/datapage-components/cascading-elements/
  21. 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>
  22. 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>
  23. 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.
  24. Hi, this would be possible using Triggered action. You may try to check this article from Caspio: https://howto.caspio.com/tables-and-views/triggered-actions/
×
×
  • Create New...