Skip to main content
All Collections🤖 Flobot FeaturesPath SettingsLoop
How to Process Multiple Retrieved Records One by One Using the Loop Command
How to Process Multiple Retrieved Records One by One Using the Loop Command
Yoom Customer Service avatar
Written by Yoom Customer Service
Updated over a week ago

📝 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

Repeat, Loop, Automation, Settings, Details, Workflow, Processing

Did this answer your question?