Return to FileMaker.com
switching a merge field to print labels
I have fields for first name and first name spouse and last name.
I want the label to print John & Mary Smith, but just John Smith if there is no spouse.
How do I specify not to print the & if there is no spouse first name?
Thanks so much for your help!
create and use a calculation like this
First name & If(not IsEmpty(First name spouse); " & " & First name spouse) & " " & Last Name
Retrieving data ...