2 Replies Latest reply on May 31, 2011 8:46 AM by MattPaul

    Conditional Merging



      Conditional Merging


      This is my first post, I have tried the search function but I couldn't find anything that matched my question.

      Within my Art Gallery database I have created separate fields for Y, X. Z dimensions of the artworks. I did it because I need the values to bo converted automatically in inch and cm.

      Now I'd like to have a field that contains the three values separated by the symbol x, for example: 123 x 34 x 70 - this can be done withj merge field, but I also want to hide the last part if the Z value is empty 123 x 34 (deleting also the symbol x before 70).

      I am sure is something really basic to ask, but I have no clue of how to do it!

      Many thanks for your help,