Optimal presentation and editing of business data in a browser-based user interface of an integrated web-based business information system is described, including a browser at a user computer in dynamic communication with a web server allowing database editing and updating without browser page refreshes. For optimizing the data input/editing experience of the user, an array of features in various combinations is provided including: single-click instantiation of cell editing in a table displayed by the browser; single off-click or keyboard commits instantiating cell-wise data transfers; bulk editing allowing group modification of data elements across a plurality of adjacently-displayed or non-adjacently displayed records; client-side, location-based caching of old cell values allowing selective go-back for any edited or bulk-edited cell, in any order desired by the user, prior to a page-refreshing input event; and easy establishment/modification of sub-records associated with any of a displayed list of records using sub-record access icons, rollover menus, and auxiliary browser windows.

Facilitating data manipulation in a browser-based user interface of an enterprise business application

Systems and methods for hosting variable schema data such as dynamic tables and columns in a fixed physical database schema. Standard objects, such as tables are provided for use by multiple tenants or organizations in a multi-tenant database system. Each organization may add or define custom fields for inclusion in a standard object. Custom fields for multiple tenants are stored in a single field within the object data structure, and this single field may contain different data types for each tenant. Indexing columns are also provided, wherein a tenant may designate a field for indexing. Data values for designated fields are copied to an index column, and each index column may include multiple data types. Each organization may also define custom objects including custom fields and indexing columns. Custom objects for multiple tenants are stored in a single custom object data structure. The primary key values for the single custom object table are globally unique, but also include an object-specific identifier which may be re-used among different entities.

Custom entities and fields in a multi-tenant database system

In accordance with embodiments, there are provided mechanisms and methods for publicly providing web content of a tenant using a multi-tenant on-demand database service. These mechanisms and methods for publicly providing web content of a tenant using a multi-tenant on-demand database service can allow the web content to be published by a tenant using the multi-tenant on-demand database service for use by non-tenants of the multi-tenant on-demand database service.

System, method and computer program product for publicly providing web content of a tenant using a multi-tenant on-demand database service

In accordance with embodiments, there are provided mechanisms and methods for performing one or more actions based on determined access permissions for a plurality of users. These mechanisms and methods for performing one or more actions based on determined access permissions for a plurality of users can enable improved data collection and analysis, enhanced client knowledge of system access, etc.

System, method and computer program product for performing one or more actions based on a determined access permissions for a plurality of users

An approach for debugging site errors in a multi-tenant database system is disclosed. An example method can include receiving a request from a site administrator to access an enhanced error message and determining if the site administrator is approved for viewing the enhanced error message by evaluating exceptions associated with the enhanced error message, the request, and the site administrator. The example method further includes modifying a detailed error message related to the request for generating the enhanced error message, and providing the enhanced error message to the site administrator based on the approval determination.

Debugging site errors by an admin as a guest user in a multi-tenant database environment

A method, system, computer program product, and related business methods for concisely communicating real-time business information to end users in an enterprise network is described. An integrated business system having at least ERP and CRM functionality is accessed via a browser-based user interface. A plurality of portlet windows are simultaneously displayed within a browser window, each portlet window occupying a relatively small area therein. The portlet windows are selected and arranged according to a customizable user profile for each user, and include reporting portlets displaying up-to-date business results retrieved from the integrated business system. Each reporting portlet further comprises report access links associated with at least one of the business results that, when selected by the user, invoke browser-based displays of up-to-date business data underlying those business results. Preferably, in accordance with a user-customizable alert setting stored in the user profile, regular electronic mail messages are sent to the user communicating up-to-date versions of those business results. Preferably, data labels that identify business items within the browser-based user interface and on the electronic mails are expressed in a business vernacular tuned to each user according to customizable business vernacular settings in their user profiles.

Luke A. Braud

Papers

Facilitating data manipulation in a browser-based user interface of an enterprise business application

Concise communication of real-time business information in an enterprise network