AnsweredAssumed Answered

Conditional Merging

Question asked by MattPaul on May 31, 2011
Latest reply on May 31, 2011 by MattPaul


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,