Overview
The Functions node enables you to perform mathematical calculations, apply formulas, and execute complex functions within your workflows. This node supports Excel-compatible functions and allows you to define custom variables, making it ideal for data processing, mathematical operations, and computational tasks.
Formula Configuration
Formula Input
Enter your mathematical expressions and formulas:
Formula Field: Input your calculation using standard mathematical syntax
Placeholder: "Enter a formula" guides formula entry
Connection Point: Can receive formulas from other workflow nodes
Syntax: Uses standard mathematical operators and Excel-compatible function syntax
Formula Examples
Common formula formats:
Basic Math:
2 + 3 * 4With Variables:
varOne * 2 + 10Excel Functions:
SUM(varOne, varTwo, varThree)Complex Expressions:
SQRT(varOne^2 + varTwo^2)
Variable Management
Advanced Section
Access variable configuration through the Advanced section:
Expandable Interface: Click the arrow to reveal variable options
Variable Creation: Define custom variables for use in formulas
Dynamic Variables: Variables can receive values from connected workflow nodes
Variable Configuration
Set up custom variables for your formulas:
Variable Names: Define variables like "varOne", "varTwo", etc.
Value Input: Enter numbers or text values for each variable
Placeholder: "Enter number or words" accepts various data types
Connection Points: Variables can receive values from other workflow nodes
Variable Usage
Integrate variables into your formulas:
Exact Syntax: Variable names in formulas must match exactly as defined
Case Sensitivity: Ensure proper capitalization and spelling
Data Types: Variables can hold numbers, text, or data from connected nodes
Function Library
Excel-Compatible Functions
The Functions node supports a comprehensive library of Excel functions:
Mathematical Functions: ABS, SUM, AVERAGE, SQRT, POWER
Trigonometric Functions: SIN, COS, TAN, ASIN, ACOS, ATAN
Financial Functions: ACCRINT, PMT, FV, PV
Logical Functions: AND, OR, NOT, IF
Text Functions: CONCATENATE, LEFT, RIGHT, MID, LEN
Function Reference
Access the complete function library:
Help Icon: Click the "?" icon next to the Advanced section
Function Documentation: Opens comprehensive list of available functions
Implementation Status: Shows which functions are currently available
Categories: Functions organized by type (Math, Financial, Text, Logical, etc.)
Function Examples
Common function implementations:
SUM:
SUM(varOne, varTwo, varThree)IF Statement:
IF(varOne > 10, "High", "Low")Mathematical:
ABS(varOne - varTwo)Text Operations:
CONCATENATE(varOne, " ", varTwo)
Execution and Output
Run Function Button
Execute your configured formula:
Run Function: Click to process the formula with current variable values
Processing: Calculates results using defined formulas and variables
Error Handling: Reports formula errors and syntax issues
Output Display
View calculation results in the Output section:
Result Display: Shows the calculated result of your formula
Data Types: Outputs numbers, text, or boolean values based on formula
Connection Point: Results can be passed to other workflow nodes
Error Messages: Displays helpful error information for debugging
Use Cases and Applications
Mathematical Calculations
Data Analysis: Process numerical data with statistical functions
Financial Calculations: Compute interest, payments, and financial metrics
Engineering Calculations: Apply mathematical formulas to technical data
Scientific Computing: Execute complex mathematical operations
Data Processing
Value Transformation: Convert and manipulate data values
Conditional Logic: Use IF statements for decision-based calculations
Text Processing: Manipulate and format text data including string extraction and parsing
Data Validation: Check data against specified criteria
API Integration: Extract specific data from authentication tokens, JSON responses, and structured data
String Manipulation: Parse and extract substrings from complex data structures
Workflow Integration
Dynamic Calculations: Receive variables from other workflow nodes
Real-time Processing: Calculate results as data flows through workflows
Conditional Workflows: Use calculation results to drive decision paths
Data Enrichment: Add calculated fields to existing datasets
Best Practices
Formula Design
Clear Syntax: Use proper mathematical operators and function syntax
Variable Naming: Choose descriptive variable names for clarity
Error Checking: Test formulas with various input values
Documentation: Comment complex formulas for future reference
Variable Management
Consistent Naming: Use systematic variable naming conventions
Data Validation: Ensure variable values match expected data types
Default Values: Provide fallback values for optional variables
Range Checking: Validate that numerical inputs fall within expected ranges
Performance Optimization
Efficient Formulas: Use optimized functions when possible
Minimal Complexity: Break complex calculations into simpler steps
Resource Management: Consider computational load for large datasets
Testing: Validate results with known test cases
The Functions node provides powerful computational capabilities within FluxPrompt workflows, enabling sophisticated mathematical operations, data transformations, and analytical processing with Excel-compatible function support.