📝 Overview
Database trigger allows you to launch a Flowbot when a specific event occurs such as adding, updating, deleting, or manually selecting records in any Yoom database.
This guide explains how to set up these triggers by:
✔️ selecting the target database
✔️ specifying trigger conditions
✔️ setting up actions for your Flowbot
💁♀️ Usage Examples
Automatically create a client in an invoice tool when a new customer is added
Create a customer list database.
When a new customer is added, you can automatically create a client in services.Automatically update employee management apps when employee information is updated
Create an employee list database.
When employee information is updated (e.g., due to marriage or relocation), you can automatically update the information in services.
Mass sending to manually selected customers
Use filters on the customer list database to narrow down records, then send emails or other communications to the selected customers at any time.
1️⃣ Set Up Method 1: From the Flowbot Creation Screen
1. Navigating to the Database Trigger Selection Screen
Go to the Flowbot tab from any project in the side menu and click + Create button.
Then, click Create from scratch.
Click Trigger from an app event and select the app that contains your database.
2. Setting the Trigger Conditions
Under database triggers, select the trigger type you want.
📍 Example:
If you select Yoom:
✔️ Trigger when a record is selected
✔️ Trigger when a new record is created
✔️ Trigger when a new record meets specific conditions
✔️ Trigger when a record is updated
✔️ Trigger when a record update meets specific conditions
✔️ Trigger when a record is deleted
✔️ Trigger when a record deleted meets specific conditions
3. Setting the Record Conditions
After selecting the trigger type, set up the following details:
Title: Enter any trigger name.
Project: Select the project where the target database is stored.
Database: Select the target database name.
Table: Select the target table name.
Column Name: Choose the column name.
Condition Expression: Set the condition.
Value: Select the value.
2️⃣ Set Up Method 2: From the Database Screen
1. Access the Database Screen
From any project, go to the database and click the Flowbot button in the upper right corner.
2. Selecting Action/Template
Choose the action or app template you want to execute.
Related Keywords
Related Keywords
Database, YoomDB, Yoom, DB, Settings, Trigger, Basics, Basic