FormulaMap: From textfield >> list >> adding the single items to a new table

2

Hi @Ainara_Bilbao ,

To take the list of email addresses in the “Members” column and add a new row for each one in the “mailing_member” table, this formula should work for the button action.

thisRow.[Members].List().Split(", ").FormulaMap(AddRow([mailing_member], [mailing_member].email,CurrentValue))

Here’s the breakdown of the formula:

  • thisRow.[Members].List().Split(", ") is the email address column split into a list
  • FormulaMap() is going to be the formula that we run for each item in the list
  • AddRow() is the action we want to take for each item in the list
  • Inside AddRow() we have the table we want to target, the column we want to target, and the value we want to add to that column
2 Likes