AnsweredAssumed Answered

Text Conditional Concat

Question asked by MikeHaddon on Dec 9, 2010
Latest reply on Dec 9, 2010 by FentonJones


Text Conditional Concat


Does anyone know how or if I can do a conditional text concatenation?  Here is the scario.  I have a table with three fields, each containing a committee name.  The individuals in the table may be on one, two, or three different committees, which is why I have the three fields.  On a layout, I am trying to include a text field that shows the committees the individual participates on.  I figured out how to use a merge field to include all three fields in one text item.  However, because people may belong to only one or as many as three committees, the format doesn't look as professional as I would like.  For example, a person who is a member of only one committee will be displayed on my layout like the following:  committee 1, ,

I'm looking to dig deeper and make this merge field more conditional, so it evaluates whether or not the field containing the committee is empty.  If it is empty, it not only is not included, but it also doesn't include the comma separator - which just makes it look messy.  Here are some examples of what it does and what I would like it to do:

Member of only one committee
What I get currently:  committee 1, ,
What I would like to have:  committee 1

Member of two committees
What I get currently:  committee 1, committee 2,
What I would like to get:  committee 1, committee 2

Does this make sense, and does anyone know if/how to do it?  Thanks!