Formula Block
About Formula
Formula, a logic block category that empowers users to create custom functions designed for precise calculations and transformations across various data types. Whether you're working with numbers, texts, or date/time values, Formula's ensures you can input data optionally and always anticipate a consistent output.
As an added benefit, when crafting your custom reusable function, the FlowOn recommendation system seamlessly offers built-in functions that align with the chosen formula's return type, assisting in the function building process.
Supported Data Types
Below is a comprehensive table detailing the various data types supported by Formula, along with links to the available built in functions tailored for each specific return type:
| Supported Data Types | Specifics | Associated Built in Functions |
|---|---|---|
| Numbers | Integers, Decimals, Floats, Money | Collection functions, Control functions, Math functions, Date functions, Text functions |
| Date/Time | Date calculations, Time intervals, Date-time manipulations | Date/Time functions, Control functions |
| Text | String manipulations, Text-based computations | Text functions Control functions |
| Boolean | Logical conditions, True/False evaluations | Boolean functions |
Now that we've explored the data types and associated functions, it's time to see them in action. Next, we'll walk through some examples to better illustrate these concepts in practical use.
Practical Examples
Here are some examples demonstrating different formula types including math, text, boolean, and date/time in action. For detailed examples about each function within the formula types, refer to the tutorials section.
Example 1 - Math Formula
A mathematical formula block that adds up new inputs. Using the built in add function, we take three numbers from the user and show their total.
Figure 1: Math Formula Block Example
Example 2 - Text Formula
A text formula block that combines the user's first and last name. By using the built-in concatenate and uppercase functions, it then displays the full name in all capital letters.
Figure 2: Text Formula Block Example
Example 3 - Boolean Formula
A boolean formula block to assess a student's final grade. By leveraging the greater than or equal function, combined with the if condition, we determine whether the student passes or fails.
Figure 3: Boolean Formula Block Example
Example 4 - Date/Time Formula
A date/time formula that processes a given source date & time. Using convert time zone function, it seamlessly translates the input to a target time zone, such as EST.
Figure 4: Date/Time Formula Block Example
What's Next?
Having delved into the formula blocks, it's time to shift our focus to another essential component: the Validation Block. In the upcoming section, we will explore how to utilize validation blocks to ensure data integrity and accuracy in our processes.