Interface for generating and testing formulas using a formula language

Patent metadata

Field	Value
Publication number	US-11003427-B2
Application number	US-201816146550-A
Country	US
Kind code	B2
Filing date	Sep 28, 2018
Priority date	Sep 28, 2018
Publication date	May 11, 2021
Grant date	May 11, 2021

Abstract

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.

First claim

What is claimed is:

1. A method comprising:
receiving, by a server computing system, a formula written using a formula language, the formula including a set of operators to operate on one or more fields associated with a record in a database, and the formula displayed in a formula input area of a user interface;
based on the received formula:
causing, by the server computing system, the one or more fields associated with the record and a value associated with the one or more fields existing in the record to be displayed in a field area of the user interface, and
enabling, by the server computing system, the value associated with the one or more fields to be modified within the user interface by a user, wherein the modified values are not updated within the record in order to test different formulas without committing the updates to the database; and

causing, by the server computing system, a result generated based on execution of the formula to be displayed in a result area of the user interface and based on the modified value within the user interface, the result area to be visible concurrently with the formula input area and the field area, execution of the formula comprising execution of a run code of a programming language, the run code performing operations transpiled from operations included in the formula.

2. The method of claim 1 , further comprising:
verifying, by the server computing system, syntax of the formula; and
causing, by the server computing system, a syntax message to be displayed in a syntax area of the user interface based on said verifying the syntax of the formula, the syntax area to be visible concurrently with the formula input area and the field area.

3. The method of claim 2 , wherein said displaying of the result in the result area is in real time and based on the formula verified to have no syntax error.

4. The method of claim 3 , wherein said displaying of the syntax message in the syntax area is in real time and based on the formula verified to have syntax error.

5. The method of claim 1 , wherein said execution of the run code is configured to enable displaying the result in the result area without updating the record in the database.

6. A system comprising:
one or more processors; and
a non-transitory computer readable medium storing a plurality of instructions, which when executed, cause the one or more processors of a server computing system to:
receive a formula written using a formula language, the formula including a set of operators to operate on one or more fields associated with a record in a database, and the formula displayed in a formula input area of a user interface;
based on the received formula:
cause the one or more fields associated with the record and a value associated with the one or more fields existing in the record to be displayed in a field area of the user interface, and
enable the value associated with the one or more fields to be modified within the user interface by a user, wherein the modified values are not updated within the record in order to test different formulas without committing the updates to the database; and

cause a result generated based on execution of the formula to be displayed in a result area of the user interface and based on the modified value within the user interface, the result area to be visible concurrently with the formula input area and the field area, execution of the formula comprising execution of a run code of a programming language, the run code performing operations transpiled from operations included in the formula.

7. The system of claim 6 , further comprising instructions which when executed, cause the one or more processors to:
verify syntax of the formula; and
display a syntax message in a syntax area based on said verifying the syntax of the formula, the syntax area to be visible concurrently with the formula input area and the field area.

8. The system of claim 7 , wherein the result is displayed in the result area in real time and based on the formula verified to have no syntax error.

9. The system of claim 8 , wherein the syntax message is displayed in the syntax area in real time and based on the formula verified to have syntax error.

10. The system of claim 6 , wherein said execution of the run code is configured to enable displaying the result in the result area without updating the record in the database.

11. A computer program product comprising a non-transitory computer readable medium having a computer-readable program code embodied therein to be executed by one or more processors, the program code including instructions to:
receive a formula written using a formula language, the formula including a set of operators to operate on one or more fields associated with a record in a database, and the formula displayed in a formula input area of a user interface;
based on the received formula:
cause the one or more fields associated with the record and a value associated with the one or more fields existing in the record to be displayed in a field area of the user interface, and
enable the value associated with the one or more fields to be modified within the user interface by a user, wherein the modified values are not updated within the record in order to test different formulas without committing the updates to the database; and

cause a result generated based on execution of the formula to be displayed in a result area of the user interface and based on the modified value within the user interface, the result area to be visible concurrently with the formula input area and the field area, execution of the formula comprising execution of a run code of a programming language, the run code performing operations transpiled from operations included in the formula.

12. The computer program product of claim 11 , further comprising instructions to:
verify syntax of the formula; and
display a syntax message in a syntax area based on said verifying the syntax of the formula, wherein the syntax area is to be visible concurrently with the formula input area and the field area.

13. The computer program product of claim 12 , wherein the result is displayed in the result area in real time and based on the formula verified to have no syntax error.

14. The computer program product of claim 13 , wherein the syntax message is displayed in the syntax area in real time and based on the formula verified to have syntax error.

15. The computer program product of claim 11 , wherein said execution of the run code is to enable displaying the result in the result area without updating the record in the database.

Assignees

• Salesforce Com Inc

Inventors

• Rich Alexander
• Bakthavachalam Ramachandran
• Menon Vinay

Classifications

• G06F8/315

  Object-oriented languages · CPC title

• G06F8/40 Primary

  Transformation of program code · CPC title

• G06F40/174

  Form filling; Merging · CPC title

• G06F40/111

  Mathematical or scientific formatting; Subscripts; Superscripts · CPC title

• G06F8/42 Primary

  Syntactic analysis · CPC title