More Powerful Formulas
Release notes
Release notes
v0.2.2 More Powerful Formulas
Added: Configurat for numeric inputs: min and max value, min and max decimal digits.
Added: Support for using numeric inputs as variables in formulas.
Improved: Formula editor now lists available variables with better usability.
Added: Click-to-insert variable names when editing formulas.
Added: Ctrl + Space shortcut to browse variables with keyboard.
Added: Support for math functions (min, max, PI, etc.).
Added: coalesce() function to safely handle null values in formulas.
Fix: anchors for 3D file were always shown in quotable item form, even if the item had no file
Improved: show tax and discount fields only when they apply to reduce clutter in forms/summaries
Inputs just got smarter
Set Validation Rules for Numeric Inputs
Numeric inputs can now be configured with min/max values and min/max decimal places, helping ensure users enter values that make sense for your use case. Whether you're collecting measurements, tolerances, or other specs, this makes your forms both smarter and safer.
This configuration happens right in the input setup — alongside the new variableName field — making it easier to link precise inputs with flexible formulas.
Use Inputs as Formula Variables
You can now use numeric inputs as variables directly inside your formulas. Each input defines a clean, reusable variable name — visible in the editor — that lets you build calculations based on customer or internal data.
From basic dimensions to advanced specs, these inputs now play a central role in your pricing logic. The formula editor shows all available variables and makes it easy to include them in calculations.
This unlocks powerful scenarios where quotes automatically adapt to each part or order — helping you stay fast, accurate, and competitive.
Built for Speed and Power
Productivity upgrades for every workflow
The formula editor now includes smart enhancements to help both casual users and power users work faster:
- 🖱️ Click-to-insert: Click any variable name to inject it into your formula.
- ⌨️ Keyboard-friendly: Press "Ctrl + Space" to open a popover with the full list of available variables. Press Tab to focus it, and use the arrows or type the variable name to select them.
- 📚 Built-in functions: Use standard functions like min, max, and math constants like PI.
Whether you’re tweaking a simple margin or building something advanced, formulas are now more intuitive and efficient.
Handle Missing Data Gracefully
When building formulas, it’s common to rely on inputs that may not always be filled — like optional customer fields or file parameters that weren’t detected. That’s where the new coalesce() function shines.
Until now, if a variable didn't have a vale, 0 would be used in the calculations. Now they will have a null value, that will be converted to 0 be default, but that lets you define a fallback value to avoid broken formulas or unwanted behavior:
coalesce(maybeNull1, maybeNull2, 3)
This will use the first non-null variable or fall back to 3. It’s perfect for building robust, fault-tolerant pricing logic.
This makes your calculations robust and flexible, even when not every input is mandatory.
Note that coalesce will only ignore the null values, any other numeric values such as 0 or negative numbers will be returned