Formula Interface for Real-Time Syntax Validation and Testing
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current formula implementation in multi-tenant environments lacks real-time feedback, making it inefficient for administrators to generate and test formulas.
Innovation Solution
A server computing system provides an interface to display formulas, fields, and results concurrently, enabling real-time syntax error detection and modification of field values without committing changes to the database, using a transpiler to convert formula language to programming language for execution.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Productivity
If current formula implementation is used, then administrators can generate formulas using an editor, but real-time feedback is not provided making the process inefficient
Solution Approach 1:
The system provides real-time feedback by displaying syntax errors and execution results immediately as administrators type or modify formulas. The interface shows error messages in a syntax error area and execution results in a result area, allowing instant validation without manual testing cycles.
Solution Approach 2:
The system performs preliminary syntax validation and execution testing before the formula is saved to the database. This preliminary action detects syntax errors and tests formula execution in advance, preventing errors from propagating to production data and eliminating the need for separate testing phases.
2Ease of operation
If formulas are tested by modifying field values in the database, then testing can be performed, but production data may be affected by accidental changes
Solution Approach 1:
The system creates a virtual copy of the database record structure for formula testing purposes. Field value modification areas allow administrators to test formulas with sample data without actually modifying the production database. The testing environment is a sandbox that replicates database behavior without persistent changes.
Solution Approach 2:
The system performs preliminary execution testing of formulas using virtual field values before any actual database changes occur. This preliminary execution in a safe environment ensures that formula logic is validated without risking production data integrity.
3Ease of operation
If field values are modified to test formulas, then formula testing is enabled, but the modified values are not retained after testing
Solution Approach 1:
The system displays current field values in a field area before testing begins. These displayed values serve as the test input data and are automatically used when the formula executes. The field values are preserved in the testing context throughout the formula development process.
Data Source
AI summary
Systems and methods for generating and testing formulas written using a formula language may include receiving, by a server computing system, in a formula input area a formula written using a formula language, the formula associated with a record in a database; displaying, by the server computing system, one or more fields in a field area based on the one or more fields being included in the formula, the one or more fields associated with the record; enabling, by the server computing system, a value associated with the one or more fields to be modified based on the one or more fields being included in the formula; and displaying, by the server computing system, in a result area a result generated based on execution of the formula, wherein the result area is to be visible concurrently with the formula input area and the field area.