Looking for help on setting up Concatenate text from multiple fields to a single field.
Field 1 = Material
Field 2 = Finish
Normally I would do “Material – “ & Material & ¶ & “Finish – ” & Finish
The result would be:
Material – CRS
Finish – ZINC CLEAR CHROMATE
But if one of the field has no data, I do not want to show the embedded Text at all.
I’m thinking use “If” statement with “IsEmpty” but not sure how to construct.
OS = XP
FMP server and client =8.0
Thank you so much in advance!