How to select all the data from a list in 1 action

[Newuser]

Good morning,
I am a beginner on Adalo. I currently have a problem I want to create an automatic mailing system with the help of zapier.
I have a group collection with a many-to-many relationship with the users collection and a mailing collection that allows me to create my messages.
I do this in 3 steps. 1st I select my group, then I have a list that displays the users of the group and finally I create my email.
My problem is that I can’t recover all the users when I get to step 2 of the list. I would like to find a way to have access to all users because when I click on an item in the list I can only select that one.

Thanks for your help!

[KelvinKlassen]

Good morning!

I’ll guide you through a possible solution to ensure you can access all users in a group when you get to step 2 of your process.

Step-by-Step Solution:

1. Create a Relationship in Adalo:

Ensure you have the following collections in Adalo:

• Groups: A collection of groups.
• Users: A collection of users.
• Mailing: A collection for your messages.

Make sure you have set up a many-to-many relationship between the Groups and Users collections. This will allow each user to belong to multiple groups and each group to have multiple users.

2. Set Up Your Screens:

1. Group Selection Screen:

• Display a list of groups.
• When a group is selected, navigate to the next screen.

2. User List Screen:

• Display a list of users filtered by the selected group.
• Make sure to pass the selected group information to this screen.

3. Email Creation Screen:

• Create a form to compose your email.
• This screen will handle the logic to send the email to all users in the selected group.

3. Implementing the Logic:

Here’s how you can implement the logic in Adalo and Zapier:

In Adalo:

1. Pass the Selected Group Information:

• When a user selects a group, navigate to the User List Screen and pass the selected group ID.

2. Filter Users by Group:

• On the User List Screen, set up a custom filter on the user list component to show only users who belong to the selected group.

3. Create Email Button:

• Add a button on the User List Screen that navigates to the Email Creation Screen and passes the selected group ID.

In Zapier:

1. Trigger on New Email Creation:

• Set up a trigger in Zapier for when a new record is created in the Mailing collection.

2. Fetch Users from Adalo:

• Use the “Find Record” action in Zapier to fetch all users associated with the group ID passed to the Email Creation Screen.

3. Send Emails to Users:

• Set up an action in Zapier to send emails to the list of users fetched in the previous step. You can use an email service like Gmail, Mailchimp, or any other service that Zapier integrates with.

Example Setup in Zapier:

1. Trigger:

• App: Adalo
• Event: New Record
• Collection: Mailing

2. Action: Find Users in Adalo

• App: Adalo
• Event: Find Records
• Collection: Users
• Filter: Group ID matches the group ID from the Mailing record

3. Action: Send Email

• App: [Your Email Service]
• Event: Send Email
• To: (Insert the list of users’ emails)
• Subject: (Insert subject from the Mailing record)
• Body: (Insert body from the Mailing record)

By following these steps, you should be able to create an automatic mailing system that retrieves all users in a selected group and sends them an email. If you need more specific help with any of these steps, feel free to ask!