Hi all,
I am creating a zap where it will pull data from a spreadsheet and send an email. In my spreadsheet, I have a “Guest 1 First Name” field and a separate “Guest 2 First Name” field.
In my email body, I want it to say “Hello [Guest 1 First name] and [Guest 2 First Name” but only if there is an actual name for guest 2. If the Guest 2 Field is blank, it would only say “Hello [Guest 1 First Name]”.
I am trying to add the word “and” only if there is a guest 2 first name. If I add the and in the actual email and there is no guest 2 first name, it would say “Hello [Guest 1 First Name] and” which is weird.
I have tried to split to two fields and then join them with a word but its not working. Not sure what else in formatter I can use.
Thank you in advance!