Combine Text in Portal Fields only if not empty

Discussion created by osninc on Jun 24, 2017
Latest reply on Jun 24, 2017 by osninc



I have a portal that I want to concatenate two text fields contextually into a new field and have the results based on the contents of one of the two fields.  I need to do this for all the records in the portal but ONLY if one of the fields ("Value") contains text.   For example, in the screenshot below I would want the  new combined field to contain this result: To,+16508625999,From,+12012543808,Body,1st test message.  Essentially I need to have it ignore combining the fields if the "Value" field is empty.  I'd like to do this in a calculation vs a script or SQL if possible as I am a bit of a newbie.  Thanks!