A READER ASKS: New Field That Combines Two Existing Fields

From Dwayne Wright PMP, PMI-ACP, CSM
Certified FileMaker Developer

WEB: www.dwaynewright.com
EMAIL: info@dwaynewright.com
TWITTER: dwaynewright
YOUTUBE: FileMakerThoughts

A READER ASKS: (actually it was a twitter post)
Trying to figure out how to create new field that combines two existing fields in FileMaker Pro 9. Anyone know how?

Actually, it is quite easy, you will want to make a calculation field and use the concatenate operator between the field. This connects or concatenates two text strings or fields. together.

Field A & Field B

So if field A contains the word “dog” and field B contains the word “cats”. This would give you “dogcats”. Now if you want to have a space in between, put in some literal text with a space such between the quote marks such as ...

Field A & “ “ & Field B

and that would give you “dog cats”.

Here you can see that I’ve highlighted the concatenate operator. The calculation is used to build slap together a company name field, add a hyphen and and then the name of the contact.

I added some IsEmpty branches just in case either the company name or contact fields are empty and I don’t have a dangling hyphen.

© 2010 - Dwayne Wright - dwaynewright.com
The material on this document is offered AS IS. FileMaker Pro is the registered trademark of FileMaker Inc.