Jump to content

NailDyanC

Caspio Rockstar
  • Content Count

    288
  • Joined

  • Last visited

  • Days Won

    4

NailDyanC last won the day on September 5

NailDyanC had the most liked content!

1 Follower

About NailDyanC

  • Rank
    Advanced Member

Recent Profile Visitors

608 profile views
  1. You check these video tutorials about triggered action:
  2. You may consider also checking this video tutorial on how to achieve that using triggered action:
  3. 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
  4. Just to add, you may also use triggered action to calculate the total of one column. You may check the links below:
  5. 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 VARCH
  6. 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; }
  7. Hi, just want to add. You may check these video tutorials about importing data:
  8. 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.
  9. 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([
  10. 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
  11. 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.
  12. 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/
  13. 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/
  14. 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
×
×
  • Create New...