Executing formulas written using formula language

Patent metadata

Field	Value
Publication number	US-11010143-B2
Application number	US-201816146630-A
Country	US
Kind code	B2
Filing date	Sep 28, 2018
Priority date	Sep 28, 2018
Publication date	May 18, 2021
Grant date	May 18, 2021

Abstract

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.

First claim

What is claimed is:

1. A method comprising:
receiving, by a server computing system, a formula from a client computing system, the formula being written in a formula language and being associated with at least one record of a plurality of records of an object stored in a database;
transpiling, by the server computing system, the formula to a program code in a programming language, the programming code including instructions that modify the at least one record stored in the database based on the formula and that commit the modifications to the database when the programming code is executed by the server;
transmitting, by the server computing system, the program code to a browser associated with the server computing system;
retrieving, by the browser, content of the at least one record of the object stored in the database;
executing, by the browser, the program code to perform operations included in the formula using the retrieved content of the at least one record without modifying the content of the at least one record stored within the database;
displaying, by the browser, results of the execution of the program code by the browser; and
modifying, by the server computing system, the content of the at least one record within the database by the server executing the program code.

2. The method of claim 1 , wherein said executing the formula based on the program code comprises interpreting the program code.

3. The method of claim 1 , further comprising performing, by the server computing system, syntax verification on the formula prior to said transpiling the formula.

4. The method of claim 3 , wherein said transpiling the formula is performed based on the syntax verification producing no syntax error.

5. The method as in claim 1 , wherein receiving the formula written using the formula language comprises:
receiving formula input based on the formula language in a formula interface associated with the browser for concurrent display of a plurality of fields of the at least one record of the object stored in a database; and
the method further comprising:
displaying a result of executing the formula based on the program code in the formula interface, the formula interface concurrently displaying the plurality of fields of the record and the result.

6. The method as in claim 5 , wherein concurrently displaying the plurality of fields of the record comprises:
accessing the object in the database;
receiving a selection of the at least one of the accessed object's plurality of records for display in the formula interface; and
displaying the at least one select record in the formula interface while receiving the formula input and displaying the result of executing the formula.

7. The method as in claim 6 , wherein accessing, by the browser, content of the at least one record stored in the database comprises accessing data in at least one of the plurality of fields of the select record.

8. The method as in claim 7 , wherein the object of the database comprises:
one of a contact object or a customer object.

9. The method as in claim 7 , wherein executing the formula with the accessed data comprises:
displaying the result of executing the formula with the accessed data in the formula interface.

10. 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, by the server computing system, a formula from a client computing system, the formula being written in a formula language and being associated with at least one of a plurality of records of an object stored in a database;
transpile, by the server computing system, the formula to a program code in a programming language, the programming code including instructions that modify the at least one record stored in the database based on the formula and that commit the modifications to the database when the programming code is executed by the server;
transmit, by the server computing system, the program code to a browser associated with the server computing system;
retrieve, by the browser, content of the at least one record of the object stored in the database;
execute, by the browser, the program code to perform operations included in the formula using the retrieved content of the at least one record without modifying the content of the at least one record stored within the database;
display, by the browser, results of the execution of the program code by the browser; and
modify, by the server computing system, the content of the at least one record within the database by executing the program code.

11. The system of claim 10 , further comprising instructions, which when executed, cause the one or more processors to perform syntax verification on the formula prior to said transpiling the formula.

12. The system of claim 11 , wherein said transpiling the formula is performed based on the syntax verification producing no syntax error.

13. A computer program product comprising computer-readable program code to be executed by one or more processors when retrieved from a non-transitory computer-readable medium, the program code including instructions to:
receive a formula from a client computing system, the formula being written in a formula language and being associated with at least one record of a plurality of records of an object stored in a database;
transpile the formula to a program code in a programming language, the programming code including instructions that modify the at least one record stored in the database based on the formula and that commit the modifications to the database when the programming code is executed by the server;
transmit the program code to a browser;
retrieve, by the browser, content of the at least one record of the object stored in the database;
execute, by the browser the program code to perform operations included in the formula using the retrieved content of the at least one record without modifying the content of the at least one record stored within the database;
display, by the browser, results of the execution of the program code by the browser; and
modify the content of the at least one record within the database by executing the program code.

14. The computer program product of claim 13 , wherein said executing the formula based on the computer-readable program code comprises interpreting the computer-readable program code.

15. The computer program product of claim 13 , further comprising instructions, which when executed, cause the one or more processors to perform syntax verification on the formula prior to said transpiling the formula, wherein said transpiling the formula is performed based on the syntax verification producing no syntax error.

Assignees

• Salesforce Com Inc

Inventors

• Rich Alexander
• Bakthavachalam Ramachandran
• Menon Vinay

Classifications

• G06F8/51

  Source to source · CPC title

• G06F16/972

  Access to data in other repository systems, e.g. legacy data or dynamic Web page generation · CPC title

• G06F8/315

  Object-oriented languages · CPC title

• G06F8/4441

  Reducing the execution time required by the program code · CPC title

• G06F9/54

  Interprogram communication · CPC title