AppSheet concatenate result on "execute action on a set of rows"

[alexandre-sabot]

Hello,

I would like to send bulk emails based on what I select
The problem is that it opens the email client for each address
I would like to have a kind of join(",", eMailList)

Some ideas?

Thanks a lot and regards,

Alexandre

[Joseph_Seddik]

TEXT([eMailList])

[alexandre-sabot]

Thank you for you feedback but it does not work

Here the definition of the action (I see there is already a "Compose Email"

[alphacp]

You have created an action that does "something" to ALL the records returned by the filter (Referenced Rows). Instead you want to perform an action against the VC that is represented by the related contacts. Depending on your key column, you may have to create a list first and use that. 

[alexandre-sabot]

Thank your for your answer

Despite this, I don't know what to do
Where should I create the VC? Master or child table?
And what should be the formula?
Sorry, it's been 2 days since I started using AppSheet

[Joseph_Seddik]

Your action operates on a set of rows, separately. You should collect the emails from the rows in a list of emails and send it once. Your requirement was <<kind of join(",", eMailList)>>. When you have an eMailList, then simply converting it to text, will separate your email address by comas. 

[alexandre-sabot]

Thank you for your feedback

This is what I did to get around the problem
I had inserted in another table the list of emails
But it was necessary to manage this data, delete before a new selection

I think there are simpler ways but I don't see how

[alexandre-sabot · Accepted solution]

I follow this instruction and review may process

https://www.googlecloudcommunity.com/gc/Tips-Tricks/FAQ-add-row-per-value-in-EnumList/m-p/357133