Append a value to a column

Yes, this is possible. You can create a joined list of emails in a single column. One approach is:

  • Start with the column that will hold all the emails. Let’s call it “Emails”
  • Create two template columns
    • The first will contain a replacement for the current email to be added to the list
    • The second will contain two replacements: The current value of “Emails”, plus the next email to be added, separated by a comma
  • Finally create an if-then-else column to determine which template to use to write the new value of “Emails”. Use the first one if “Emails” is empty, otherwise use the second one.

Edit: if you also need to be able to remove emails from the list, check out this tutorial

1 Like