Jump to content

Merge Fields with conditional separator marks in between


kmninbox
 Share

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

Recommended Posts

Hello friends,

how do I have a separator mark such as ":", or "-" in between merge fields, only if the merge field contains a value

So:

CustomerName John, StoreName Acme would look like

John - Acme

But CustomerName Jane, with no store name would plainly look like

Jane

TIA

Link to comment
Share on other sites

I think that this would have to be done as a separate calculation field like

Name & If(not IsEmpty(Storename); " - " & Storename; "")

and this calculation field put on the layout as a merge field

Or have the calculation field as simply

If(not IsEmpty(Storename); " - " & Storename; "")

and put that on the layout as the merge field instead of the storename merge field

Link to comment
Share on other sites

This topic is 4327 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
 Share

×
×
  • Create New...

Important Information

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