Formula Transpiler for Real-Time Syntax Validation

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Current formula implementation in multi-tenant environments lacks real-time feedback and efficiency when executing formulas written in formula languages, as it does not provide immediate syntax checking and execution based on program code.

Innovation Solution

A transpiler is used to convert formulas written in formula languages into program code in a programming language like JavaScript, allowing for immediate syntax verification and execution without committing changes to the database, enabling real-time feedback and improved efficiency.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Ease of operation

If administrators use a formula editor to generate formulas using business logic, then the ease of operation is improved, but the productivity deteriorates due to lack of real-time feedback requiring manual testing

Engineering Contradiction:

Improveease of formula creationVSAvoidformula development efficiency

Core Design Contradiction:

Ease of operationVSProductivity

Solution Approach 1:

The system provides real-time syntax checking and compilation feedback during formula creation in the editor, allowing administrators to immediately see errors and corrections without manual testing, thus maintaining ease of operation while improving productivity

Inventive Principle:

Principle #23Feedback

Solution Approach 2:

The system performs preliminary syntax validation and compilation checks before the formula is deployed to production, preventing errors early in the development process and eliminating the need for repeated manual testing cycles

Inventive Principle:

Principle #10Preliminary action

2Reliability

If formulas are executed directly in the database environment, then the reliability is maintained, but the speed of formula validation deteriorates due to lack of immediate feedback

Engineering Contradiction:

Improveformula execution reliabilityVSAvoidformula validation speed

Core Design Contradiction:

ReliabilityVSSpeed

Solution Approach 1:

The system introduces an intermediary transpiler and validation layer between the formula editor and database execution environment, enabling fast syntax checking and compilation validation without compromising the reliability of actual database execution

Inventive Principle:

Principle #24Intermediary (Mediator)

3Measurement precision

If administrators test formulas by committing changes to the database, then the accuracy of formula validation is improved, but the loss of time increases due to production data risks and rollback requirements

Engineering Contradiction:

Improveformula validation accuracyVSAvoidtime for testing and rollback

Core Design Contradiction:

Measurement precisionVSLoss of time

Solution Approach 1:

The system performs preliminary compilation and syntax validation in the editor before database commitment, allowing administrators to verify formula accuracy without actually committing changes to production, thus eliminating validation time and rollback requirements

Inventive Principle:

Principle #10Preliminary action

Data Source

PatentUS11010143B2Executing formulas written using formula language

Publication Date: 2021.05.18 SALESFORCE INC

AI summary

Systems and methods for executing a formula written using a formula language may include receiving a formula written using a formula language, the formula associated with a record of a database; transpiling the formula in the formula language to a program code in a programming language; and executing the formula based on the program code.