📝 Overview
When retrieving records, you may get multiple records that match specific conditions. However, these records cannot be processed all at once.
This article explains how to break down and process records individually using a loop command.
📍Note: This feature is only available in the paid plans
🔹 Examples of Use Cases
📧 Example 1: Sending emails to multiple contacts
Trigger: Manual start
Action: Retrieve multiple records from the Yoom database and send an individual email to each contact.
📋 Example 2: Using form responses to process multiple records
Trigger: Yoom form submission
Action: Retrieve records based on form responses and send an email to each contact.
🛠️ Step-by-Step Setup for Example 1: Sending Emails to Multiple Contacts
⬇️ Overall Flowbot Structure
Step 1: Create a table in YoomDB.
Prepare a database table in YoomDB.
In this example, we register contact names and email addresses to send emails.
(Alternatively, use Data Connect to sync data from other tools).
Step 2: Retrieve multiple records
Select the database app. In this example, we select YoomDB.
Choose "Get multiple records (up to 500)" under the "manage database" to retrieve multiple records that match the conditions.
(If using Example 2, insert search values from form responses.)
Step 3: Use the repeat command to process the records one by one.
Set up a loop to process each record individually.
The loop target should be a unique value to avoid duplication.
(In this example, the unique Yoom record ID is used.)
Step 4: Retrieve a single record inside the loop
Use the same table from Step 2.
Embed the loop variables from Step 3 as the search value.
This step retrieves one record at a time as the loop runs.
This is the core process when using repeat loops!
Step 5: Embed the retrieved values into an email operation
Select your Gmail > Send Email.
Set the retrieved email address in the "To" field.
Personalize the message by embedding the retrieved name or contact person's name in the email subject or body.
🎯 Summary
By following these steps, you can process multiple retrieved records one by one using the repeat command.
📚 Related Articles
How to Use the “Loop” Function in Yoom - View Guide
Related Keywords
Related Keywords
Repeat, Loop, Automation, Settings, Details, Workflow, Processing