Send a mail to all the children of an object

[Theo]

Hi

In my database, I have for exemple the objects above :

• Entity who has a list of Users
• User who
  • have on mail adress
  • belong to one Entity

When an object is created in the application, I want to send a mail (and not a notification) to all the Users of this entity (one unique mail with to : all the Users of the entity, cc the Looged in user).

I dont know how to send all users email separated with “;” to zapier.

Do you know how to do this ?

Thanks

[Victor]

Hi @Theo,

As for me, a countdown timer + custom action of email sending may help. The principles of bulk update could be seen here:

Bulk operations and Timer Tricks, part 3: mass update for the records

Please see another trick which could be done with the help of countdown timer: mass update for records in the collection. This could be useful when you want to change the value of one property for all/some of the records, and don’t want to do it one-by-one. The example is pretty simple, but the same logic could be applied to more different cases. Enjoy! [Adalo hints: how to "mass update" records in the collection with the help of countdown timer]

Please note, with this solution you’ll send X emails for X users, not one for them all.

Similar question was discussed here:

Bulk custom action

Is this possible? Here’s the scenario: I have a custom list of Classes, let’s say. Each Class record in the list is associated with one or more Users (students in the class). I would like to have a toggle button above the list, which enables/activates visibility of a Send Message button. Clicking the Send Message button would trigger one Sendgrid custom action sending an email to all students in all classes. A variant of this would be allowing my app users to select specific classes in the li…

As for creating a single string composed of several records (email addresses) - there is no easy way to do it in Adalo, unfortunately.

Best regards, Victor.

[Theo]

Hi,
Thanks for your answer.
I have already seen your method (maybe I will use it to send notifications) but the fact of not being able to send an email to all entity users with the user logged in in copy annoys me a bit.
I think to be more complete Adalo should include triggers and database-side scripts.
Regards,
Théo