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

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

Recommended Posts

  • Newbies
Posted

Hi group. Hope someone can help me with this. I'm designing a layout which has numerous fields, most of which have defined value lists. I'm trying to get it so I can merge them onto a pre-written form letter. They need to be such that there are commas between words and periods after sentences. My fields are such that the user may need to choose more than one value. I've placed the <<merge>> parentheses in the appropriate location, but cannot pre-place commas because the fields may not always have values.

Any suggestions on using merged fields more efficiently?

Regards,

Confused

Posted

This is always a difficult one! The only way around it that I have found is to have calculated fields for the commas. e.g;

Comma 1: If(Field 1 = "", "" , ", ")

Comma 2: If(Field 2 = "", "" , ", ")

etc.

Not very neat but it will work.

This topic is 8676 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.