Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 5418 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies
Posted

I know this should be easy but having trouble locating an answer.

Creating a label layout with

FirstName-LastName on line 1

and (if data exists) Spouse's first & last names on line2.

Address on line3.

To avoid unwanted carriage returns & spaces, I tried using a single merge field for names that has a calculation that looks like below. For some reason the output is creating a blank line where the spouse's name would be, when no spouse first/last name data exists.

Here's the calculation.

First Name & " " & Last Name & "¶" & Second First Name & " " & Second Last Name

FilemakerPro9/Mac OSX 10.6

[email protected]

Posted

Learn about and use the list() function.

List(

trim( First Name & " " & Last Name) ;

trim(Second First Name & " " & Second Last Name);

Address;

City & " " & State & " " & Zip

)

This topic is 5418 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.