Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Combining first and last name fields


forbade
 Share

Recommended Posts

Is there a way I can have the text from a First Name field and a Last Name field combined to a third field that will have both the first and last names in it

 

ex.

 

First name [ John ] + Last name [ Doe ] output to > Full Name [ John Doe ]

 

I would like the Full Name field to be automaticly generated on submission of the last name. Is there any caluclation methods that would help me with this?

 

So I will have three fields, First Last and full.

 

Help!

Link to comment
Share on other sites

Use: First_Last as a calc field with the calculation of:

 

First Name & " " & Last Name

 

Thanks alot, man your a life saver.

 

 

Do you know of any books that would teach me calcuations?

Link to comment
Share on other sites

Don't know about books but there are many online sources. VTC has what looks like good training CD's: Beginner, Intermediate and Advance

 

http://www.vtc.com/cd/fmpro8-bundle.htm

 

Also checkout Scripology: http://www.scriptology.com/

 

And:

 

http://www.nightwing.com.au/FileMaker/

 

And:

 

http://forum.filemakermagazine.com/forum-48.html

 

And:

 

http://www.briandunning.com/

 

These should get you started

Link to comment
Share on other sites

Hi,

 

just a thought, if the first name field is empty you'll end up with a space at the beginning of the full name field. Use the trim( ) function. Looks neater in a report:

 

Trim(Firstname&" "&Lastname)

 

If you want to make sure there are no trailing or leading spaces at all, then:

 

Trim(Firstname&" "&Trim(Lastname))

 

For horsing around with calculations, download the file in post number 6 in this thread:here

 

maarten

Link to comment
Share on other sites

If you want to make sure there are no trailing or leading spaces at all, then:

 

Trim(Firstname&" "&Trim(Lastname))

 

A misplaced parenth will allow an extra space AFTER the first name in the above example. I'm sure kjoe meant:

 

Trim ( Firstname) & " " & Trim ( Lastname )

 

But there is an even more efficient way - wrapping it all with:

 

TrimAll (Firstname &" "& Lastname ; 0 ; 0 )

 

TrimAll() has been a godsend. It will remove ALL spaces except those added within the calc which removes possibility of one sneaking in on long concatenations. smiley-smile

 

LaRetta

Link to comment
Share on other sites

A misplaced parenth will allow an extra space AFTER the first name in the above example. I'm sure kjoe meant:

 

Trim ( Firstname) & " " & Trim ( Lastname )

 

But there is an even more efficient way - wrapping it all with:

 

TrimAll (Firstname &" "& Lastname ; 0 ; 0 )

 

TrimAll() has been a godsend. It will remove ALL spaces except those added within the calc which removes possibility of one sneaking in on long concatenations. smiley-smile

 

LaRetta

 

smiley-laughing thanks LaRetta.

I appreciate your willingness to help me out.

 

Thanks for the download Kjoe.

Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share



×
×
  • Create New...

Important Information

Terms of Use