Hello,
I’m currently trying to take my primary field in a table and concatenate based on what applies.
The table itself is pretty basic - using it for client information; i.e. First Name, Middle Initial, Last Name, Spouse First Name, Spouse Last Name, and other basic information.
We have some clients where we want the spouses other last name for whatever reasons.
What I’m wanting to do is have the primary field concatenate certain information when 1 IF applies, OR concatenate different information if the OTHER IF applies.
For Example: IF({Spouse Last Name}!=Blank(), Concatenate({Last Name}, ", ", {First Name}, " & ", {Spouse First Name})) -OR- IF({Spouse Last Name}, Concatenate({Last Name}, ", ", {First Name}, " & ", {Spouse Last Name}, ", ", {Spouse First Name})
My problem is combining those IF statements so that both would apply, so IF it meets criteria of 1, it applies that concatenated formula, or if it meets the criteria of the other 1, it applies that concatenated formula
