IP Library Granted Patent US 8,862,632
Granted Patent B2
US 8,862,632 · App. 12/985,316 · Granted Oct 14, 2014

Customizing standard formula fields in a multi-tenant database system environment

View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 8,862,632
App. No.
12/985,316
Granted
Oct 14, 2014
Kind
B2
Abstract

In a method, system, and computer-readable medium having instructions for customizing standard formula fields, at least a portion of a formula is received for a standard database field of a standard database entity in a multi-tenant database and the standard database entity is used by a plurality of tenants, a date range is stored for maintaining at least the portion of the formula, information on one or more variables of the formula is received, a value is calculated for the standard database field with at least the portion of the formula and information on the one or more variables of the formula and one or more database entities depend on the value for the standard database field, and the value is stored for the standard database field.

Claims (46)

1. A method for customizing standard formula fields in a multi-tenant database system, the method comprising:

receiving at least a portion of a formula for a standard database field of a standard database entity in a multi-tenant database, wherein the standard database entity is used by a plurality of tenants;

storing a date range for maintaining at least the portion of the formula;

receiving information on one or more variables of the formula;

calculating a value for the standard database field with at least the portion of the formula and information on the one or more variables of the formula, wherein one or more database entities depend on the value for the standard database field; and

storing the value for the standard database field.

2. The method of claim 1 , wherein at least the portion of the formula is a formula for a variable for a total price value in a customer relationship management database entity.

3. The method of claim 1 , further comprising:

retrieving a formula for the standard database field valid for a current date.

4. The method of claim 1 , further comprising:

suppressing execution of at least a portion of user defined code, where the portion of user defined code produces unexpected results with the value calculated for the standard database field.

5. The method of claim 1 , further comprising:

storing the value after executing user defined code for the standard database field.

6. The method of claim 1 , wherein a database entity that depends on the value for the standard database field is a forecasting database entity.

7. The method of claim 1 , wherein at least the portion of the formula is a formula for a total price value in a customer relationship management database entity.

8. A computer-readable storage medium having one or more instructions thereon for customizing standard formula fields in a multi-tenant database system, the instructions when executed by one or more processors causing the one or more processors to carry out:

receiving at least a portion of a formula for a standard database field of a standard database entity in a multi-tenant database, wherein the standard database entity is used by a plurality of tenants;

storing a date range for maintaining at least the portion of the formula;

receiving information on one or more variables of the formula;

calculating a value for the standard database field with at least the portion of the formula and information on the one or more variables of the formula, wherein one or more database entities depend on the value for the standard database field; and

storing the value for the standard database field.

9. The computer-readable storage medium of claim 8 , wherein at least the portion of the formula is a formula for a variable for a total price value in a customer relationship management database entity.

10. The computer-readable storage medium of claim 8 , the instructions to further carry out:

retrieving a formula for the standard database field valid for a current date.

11. The computer-readable storage medium of claim 8 , the instructions to further carry out:

suppressing execution of at least a portion of user defined code, where the portion of user defined code produces unexpected results with the value calculated for the standard database field.

12. The computer-readable storage medium of claim 8 , the instructions to further carry out:

storing the value after executing user defined code for the standard database field.

13. The computer-readable storage medium of claim 8 , wherein a database entity that depends on the value for the standard database field is a forecasting database entity.

14. The computer-readable storage medium of claim 8 , wherein at least the portion of the formula is a formula for a total price value in a customer relationship management database entity.

15. A system for customizing standard formula fields in a multi-tenant database system, the system comprising:

a processor; and

one or more stored sequences of instructions which, when executed by the processor, cause the processor to carry out:

receiving at least a portion of a formula for a standard database field of a standard database entity in a multi-tenant database, wherein the standard database entity is used by a plurality of tenants;

storing a date range for maintaining at least the portion of the formula;

receiving information on one or more variables of the formula;

calculating a value for the standard database field with at least the portion of the formula and information on the one or more variables of the formula, wherein one or more database entities depend on the value for the standard database field; and

storing the value for the standard database field.

16. The system of claim 15 , wherein at least the portion of the formula is a formula for a variable for a total price value in a customer relationship management database entity.

17. The system of claim 15 , the instructions to further carry out:

retrieving a formula for the standard database field valid for a current date.

18. The system of claim 15 , the instructions to further carry out:

suppressing execution of at least a portion of user defined code, where the portion of user defined code produces unexpected results with the value calculated for the standard database field.

19. The system of claim 15 , the instructions to further carry out:

storing the value after executing user defined code for the standard database field.

20. The system of claim 15 , wherein a database entity that depends on the value for the standard database field is a forecasting database entity.

Assignments (2)
CHANGE OF NAME Recorded Oct 24, 2024
From: SALESFORCE.COM, INC.
To: SALESFORCE, INC.
Reel/Frame 069270/0650 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Jan 6, 2011
From: ZIEMANN, TYLER; LEVINE, SUSAN S.; AHUJA, NEERAJ
To: SALESFORCE.COM, INC.
Reel/Frame 025596/0732 →