7 Replies Latest reply on Apr 24, 2012 1:21 AM by willrollo

    to merge or not to merge with commas


      to merge or not to merge with commas


      I want to be able to display the three address fields I have (House name, Town, Postcode) to appear like this:
      House name, Town, Post code.
      If I do merged fields for this it works fine. ( <>, <>, <> ) (field names go between the <>)

      However, In some records, there is no Town in the field so I end up with a House name, , Post code and this looks wrong. How can I add the commas only if the field has an entry?
      The other problem I am having with this, is that this merged field is part of a line of customer details in a list view, and I have an option for the user to find records based on any of the field entered for a search. I would like the address fields to be used as search fields but as they are merged fields, this cannot be done. As I want commas between these fields then I cannot display the fields as fields, only as merged...
      I have seen the Core 2 invoice solution and i want my list to look and work like theirs but unsure how to do it..
      Many thanks