Hey, Apologies if this is not the correct channel - not sure where is best to post (formula/sql help), Im trying to create a workflow to send invoices to customers (some of which have multiple email addresses they want the invoice sent to); i have followed the suite answer “Add multiple Recipient on Send Email action”; all is working well except my formula that joins the emails to send errors if one of the email fields is blank as there is a “;;‘. i.e.
abc@xyz.com;def@xyz.com;;jkl@xyz.com (sql formula {email} || ‘;’ || {custentity_email2} || ‘;’ || {custentity_email3} || ‘;’ || {custentity_email4} || ‘;’ || {custentity_email5}). any direction or assistance would be appreciated - thanks.