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.