When presenting information you sometimes come in a situation where you want to add a comma, point, or something else, depending on the content of a field. Is the only possible way to do this by creating calculation fields?
The Merge text on a layout could look like this:
<<Client Name>>, <<Location>>.
...and would be presented like this:
Apple, Cupertino CA.
But, let's say I don't know the location, then I neither want the comma nor the space to show, ie;
This could be solved by a calculation like this:
Client Name & If(Location; ", " & Location) & "."
Since this could happen a couple of times in a normal solution, I think it's stupid to create separate calculations only for this simple situation.
Is there an easier way that I have missed?