Overview
Formula columns in Bitscale are a powerful feature for transforming data and maintaining static text across your grids. They allow you to:- Apply transformation logic to existing data points
- Initialize static values for use across workflows
- Automatically generate complex formulas with AI for advanced use cases
Use Case 1: Static Text Columns
Use a static text formula when you want to maintain a single value across every row in a grid.- Example: Store a Company Blur or a context string to be referenced later by AI enrichments like BitAgent.
- Create a Formula Column → Select Static Text.
- Enter the desired text.
- Run the formula.
- The same value will now be replicated across all rows.
Use Case 2: Transformative Actions
Formula columns also support transformation logic to manipulate or extract values. Example: Extract the domain from a company URL without thehttp://
or https://
prefix.
- Formula:
column_name.split("//")[1]
- This splits the string at
//
and returns the second element (index1
).
- Create a Formula Column.
- Select the column to operate on (e.g., Company URL).
- Apply the formula logic (using standard operators and functions).
- Save and run to generate the transformed values.
AI Formula Generation
Bitscale includes AI-powered formula generation, making it simple to build even complex formulas without prior syntax knowledge. How it works:- Go to Generate Formula with AI.
- Describe the logic in natural language.
- Example: “Check if employee count is more than 100,000”
- Provide the expected output for the first row (e.g., “Yes”).
- AI will generate the correct formula automatically.
- Preview results on the first 5 rows before confirming.
Best Practices
- Static Text: Use for context maintenance across workflows.
- Transformations: Ideal for cleaning, extracting, or classifying raw data.
- AI Generation: Recommended for complex formulas or when unsure of exact syntax.
- Indexing Reminder: Formula indexing starts at
0
(0 = first element, 1 = second, etc.), consistent with most programming languages.