This guide helps you resolve common issues when working with Calcs Builder templates. If you encounter an error not covered here, please contact support.Documentation Index
Fetch the complete documentation index at: https://calcs.com/docs/llms.txt
Use this file to discover all available pages before exploring further.
Widget-Related Errors
”Widget not appearing in template”
Symptoms: Widget is configured but doesn’t show up in the template. Solutions:- Check Save Status: Ensure you’ve saved your template after adding the widget
- Verify Section/Page: Confirm the widget is placed in the correct section and page
- Check Permissions: Ensure you have edit permissions for the template
- Refresh Browser: Try refreshing the page or clearing browser cache
”Invalid formula syntax”
Symptoms: Equation widget shows error or doesn’t calculate. Common Causes:- Missing parentheses:
2 + 3 * 4should be(2 + 3) * 4if you want addition first - Invalid variable names: Use only letters, numbers, and underscores
- Missing operators:
2 3should be2 * 3 - Unmatched quotes: Ensure all text strings are properly quoted
- Check Formula Syntax: Verify all parentheses, operators, and quotes
- Validate Variable Names: Ensure all variables exist and are spelled correctly
- Test Incrementally: Build complex formulas step by step
- Use Formula Helper: Use the built-in formula editor for guidance
“Variable not found”
Symptoms: Formula references a variable that doesn’t exist. Solutions:- Check Variable Names: Ensure exact spelling and case
- Verify Widget Order: Variables must be defined before they’re used
- Check Scope: Ensure variables are accessible in the current section/page
- Review Dependencies: Some widgets depend on others being configured first
Input Validation Errors
”Input value out of range”
Symptoms: User gets error when entering values. Solutions:- Check Validation Rules: Review min/max values in input widgets
- Update Defaults: Ensure default values are within valid ranges
- Add Help Text: Provide guidance on acceptable input ranges
- Test Edge Cases: Verify validation works for boundary values
”Required field missing”
Symptoms: Template won’t calculate due to missing inputs. Solutions:- Set Default Values: Provide reasonable defaults for required inputs
- Add Validation: Use conditional validation to highlight missing fields
- Improve Instructions: Clearly indicate which fields are required
- Use Placeholders: Show example values in input fields
Calculation Errors
”Division by zero”
Symptoms: Calculation fails when input values result in division by zero. Solutions:- Add Validation: Check for zero values before division
- Use Conditional Logic:
IF(denominator != 0, numerator/denominator, 0) - Set Minimum Values: Ensure inputs have reasonable minimum values
- Add Error Handling: Provide meaningful error messages
“Infinite loop detected”
Symptoms: Template gets stuck in calculation or browser becomes unresponsive. Solutions:- Check Circular References: Ensure no widgets reference each other in loops
- Simplify Complex Formulas: Break complex calculations into steps
- Remove Redundant Calculations: Eliminate unnecessary equation widgets
- Test Incrementally: Add complexity gradually and test frequently
”Calculation timeout”
Symptoms: Complex calculations take too long or fail to complete. Solutions:- Optimize Formulas: Simplify complex mathematical expressions
- Use Intermediate Variables: Break calculations into smaller steps
- Limit Iterations: Avoid recursive or iterative calculations
- Consider Python Solvers: Use custom solvers for complex calculations
Lookup Widget Errors
”Data not found in lookup”
Symptoms: Lookup widget can’t find matching data. Solutions:- Check Data Source: Verify the lookup table contains the expected data
- Review Matching Logic: Ensure lookup criteria are correct
- Add Default Values: Provide fallback values when lookup fails
- Update Data: Ensure lookup tables are current and complete
”Lookup table not loading”
Symptoms: Lookup widget shows empty or doesn’t populate. Solutions:- Check Permissions: Ensure you have access to the lookup data
- Verify Connection: Check if the data source is accessible
- Clear Cache: Refresh the template or clear browser cache
- Contact Admin: Request access to the lookup table
Template Structure Errors
”Section/page not found”
Symptoms: Navigation or links don’t work properly. Solutions:- Check Section Names: Ensure exact spelling and case
- Verify Page Structure: Confirm pages are in the correct sections
- Update Links: Fix any broken internal links
- Test Navigation: Verify all navigation paths work correctly
”Template won’t save”
Symptoms: Changes aren’t being saved or template becomes read-only. Solutions:- Check Permissions: Ensure you have edit permissions
- Verify Connection: Check internet connection and server status
- Clear Cache: Refresh browser or clear cache
- Try Different Browser: Test in a different browser or incognito mode
Performance Issues
”Template loads slowly”
Symptoms: Template takes a long time to load or respond. Solutions:- Reduce Widget Count: Limit the number of widgets per page
- Optimize Calculations: Simplify complex formulas
- Use Lazy Loading: Load content only when needed
- Minimize Lookups: Reduce the number of lookup widgets
”Browser becomes unresponsive”
Symptoms: Browser freezes or becomes slow when using template. Solutions:- Close Other Tabs: Free up browser memory
- Restart Browser: Clear memory and cache
- Check System Resources: Ensure adequate RAM and CPU
- Simplify Template: Reduce complexity temporarily
Export and Print Issues
”PDF export fails”
Symptoms: Unable to generate PDF reports. Solutions:- Check Browser: Use Chrome or Firefox for best compatibility
- Disable Extensions: Try disabling browser extensions
- Clear Cache: Clear browser cache and cookies
- Check File Size: Large templates may timeout during export
”Print layout issues”
Symptoms: Printed output doesn’t match screen display. Solutions:- Use Print Preview: Check layout before printing
- Adjust Page Settings: Set appropriate margins and orientation
- Test Different Browsers: Try different browsers for printing
- Use PDF Export: Generate PDF for consistent printing
Best Practices for Error Prevention
Template Design
- Start Simple: Begin with basic functionality and add complexity gradually
- Test Frequently: Test calculations after each major change
- Use Clear Names: Use descriptive variable and widget names
- Document Assumptions: Include notes about calculation assumptions
User Experience
- Provide Defaults: Set reasonable default values for all inputs
- Add Validation: Include input validation with helpful error messages
- Give Feedback: Show progress indicators for long calculations
- Include Help: Add tooltips and instructions for complex inputs
Maintenance
- Regular Testing: Test templates periodically to ensure they still work
- Update Dependencies: Keep lookup tables and data sources current
- Version Control: Use version control to track changes
- Backup Templates: Keep backups of important templates
Getting Help
Self-Service Resources
- Widget Reference - Complete widget documentation
- Best Practices - Design guidelines
- Template Examples - Working examples
Contact Support
If you can’t resolve an issue using this guide:- Document the Problem: Note the exact steps to reproduce the issue
- Include Screenshots: Capture error messages and relevant screens
- Provide Context: Include template name, browser, and operating system
- Contact Support: Email support@calcs.com with detailed information
For more advanced troubleshooting, see our Performance Tips and Best Practices guides.