Q:
Can I sum numeric data retrieved from multiple records into a single output?
A: Yes, it is possible!
You can easily retrieve multiple records, sum the numeric values in a specific column, and get a single output. Here's how you can do it using the Yoom database.
📍 Configuration Example
Goal:
Retrieve multiple records from the Yoom database, sum the numbers in a column, and get a single output.
🛠️ Step by Step Guide
1. Prepare Your Database
First, create a database with the column that contains the numeric data you want to sum.
2. Set the Trigger
Set up any trigger in the Flowbot (e.g., when a record is added or updated).
3. Retrieve Records
Under the trigger, add the following action to retrieve the records:
App Selection: Yoom
Action: Get multiple records (up to 500)
Project/Database/Table: Choose the table you will use.
Conditions: Set the conditions for the records to be retrieved (e.g., where the Product Number column is not empty).
4. Sum the Values
After retrieving the records, you'll need to add up the numbers. Add a new action to convert the data.
Action: Data Conversion
Action Type: Replace data
Text to Replace: Embed the values from the column you want to sum (e.g., Product Number).
Replacement Pattern: Replace commas (
,) with the addition (+).
Replacement String: Use
+to sum the values.
5. Perform the Calculation
Finally, add another action to perform the calculation.
Action: Calculation
Calculation Type: Calculate (Basic Arithmetic)
Calculation Formula: Use the transformed output from step 4 to calculate the sum
6. Test & Save
After setting everything up, run the test to check if it correctly sums the values. Once the test is successful, save your Flowbot configuration.
⭐️ Key Takeaways:
Retrieve multiple records with a condition.
Transform the data to replace commas with a plus sign.
Perform basic arithmetic to sum the values.
📚 Related Guides
How to Set Up Calculation Actions - View Guide Here
Search Keywords
Search Keywords
sum, multiple, records, retrieve, calculation, database