KAPITYAN

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.
 

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.
 

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?
 

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? 

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.