Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.
Juggernaut

Address Label Issue

kwsrlt
in Calculation Engine (Define Fields)

Featured Replies

Hi,

I'm new to the forum and new to Filemaker Pro. My database knowledge is just from this past weekend -- I was able to figure everything out for my database that I will be using for the local animal shelter (keeping track of donors/members). I was able to utilize (with a lot of tweaking) the contact management database, but I have run into an issue with the address label.

I'm trying to figure out how to have names appear correctly on address labels. I thought that I had it with this calculation --

First Name & " & " & First Name 2 & " " & Last Name

It works fine when I want it to show "John & Jane Doe", but if I have only one person, the name line appears like this -- "John & Doe".

Any ideas/suggestions?

Thanks,

Ken

First Name & If(not IsEmpty(First Name 2); " & " & First Name 2) & " " & Last Name

  • Author

It works perfectly! Thank you!

Create an account or sign in to comment

https://fmforums.com/topic/45960-address-label-issue/
Go to topic listing

Important Information

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

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.