Jump to content

KAPITYAN

Caspio Ninja
  • Content Count

    39
  • Joined

  • Last visited

  • Days Won

    1

Reputation Activity

  1. Like
    KAPITYAN reacted to NailDyanC in Concatenate fields without leading spaces   
    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.
     
  2. Thanks
    KAPITYAN reacted to NailDyanC in Set the value from virtual field to text field and be editable for users   
    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.
     
  3. Haha
    KAPITYAN got a reaction from DefinitelyNot31337 in Name formatting using a formula field   
    How can I format the Name in a reverse order by displaying first the first name instead of Last Name. My table has client' last name and first name in the same field, listed with last name first, with a comma, ie, Balot, Kevin. I want to reverse the name, keep them in one field, but put first names first, with no comma, ie, Kevin Balot
    Is there a way to do that automatically so I don't have to make the changes manually?
     
  4. Like
    KAPITYAN got a reaction from Perzival in Adding Media link in Caspio   
    Thank you, all your replies are so helpful. I have a question related to this post,  How can I deploy my application to facebook? Is it possible? 
  5. Like
    KAPITYAN reacted to IMDora in Using a Parameter in an Aggregate field   
    Hi @NJConrcs,
    You can use a Calculated Field instead of Aggregate and use the parameters as is. You should have something like this on your Calculated Field:
    [@dp_budget_amount_P] - [@field:FUNDING]
    Change the [@field:FUNDING] depending on the name of your funding field.
    I hope that helps.
×
×
  • Create New...