Merge data field contents and display

[grriii]

Is there a technique available that would take the contents of two fields and combine them? I have one First Name field and one Last Name field. I want to be able to take the contents of those two fields as entered by the user and create a third field with contents Last Name, First Name. Is this possible?

[Bangalore]

You could use the steps mentioned here :http://forums.caspio.com/viewtopic.php?f=14&t=12233 to concatenate two fields

[grriii]

Thank you very much! I will try that.

[tclemendor]

I have this exact problem, but the link posted as the original solution seems to be gone.  Is there an updated version of this solution?

 

T

[Jan]

Maybe, this article.

[tclemendor]

Jan,

 

Thank you, but there is one detail...  I got the JS to work from the article you mentioned, but I want to have a space between the first name and the last name.  I tried creating a field called "Space" and giving it a default value of " ", but the system doesn't seem to want to hold a default value of a single space.  When I tried this, I made Space=Position2 and used 1,2, & 3 in the code above, but I still got "FirstNameLastName" instead of "FirstName LastName."  Any solutions?

 

Thanks again.