December 9, 200817 yr Newbies Hi, It's been awhile since I've done any programming and that was on filemaker 6... so, I need some retuning. I have two fields, "First Name" and "Nickname" on a contact layout. I have a separate Letter layout. If there is a Nickname, on my Letter layout, I want the Nickname to override the First Name. So, I'm guessing I would need an override field with a calculation that if the Nickname field is notempty, then display it, else show First Name. I can't remember how to do that! Any help would be appreciated. Thanks!
December 9, 200817 yr Hi TexGal, and Welcome to the Forum Try this calc Case ( not IsEmpty ( NicName ) ; NicName ; First )
Create an account or sign in to comment