Allowing in-line edit to data table of linked data of a data store

Patent metadata

Field	Value
Publication number	US-10896192-B2
Application number	US-201615339522-A
Country	US
Kind code	B2
Filing date	Oct 31, 2016
Priority date	Sep 8, 2016
Publication date	Jan 19, 2021
Grant date	Jan 19, 2021

Abstract

In an example, a database system may be configured to download to a user system an application configured to generate a data table from records stored in a data store, wherein the data table includes: a plurality of rows, wherein each row corresponds to at least one record of the records; and each row including a plurality of cells, each cell corresponding to a different grouping of data fields of its respective one(s) of the records; receive a communication from the application, the communication corresponding to at least one user input to a displayed cell of the data table; determine whether to feedback the at least one user input to the displayed cell of the data table to a corresponding data field of a corresponding record of the data store; and update the corresponding record in the data store based on a result of the determination.

First claim

What is claimed is:

1. A database system, comprising:
a processing system; and
a memory device coupled to the processing system and including instructions stored thereon that, in response to execution by the processing system, perform operations comprising:
downloading to a remote user terminal an application configured to generate a data table from records stored in a data store, wherein the data table includes:
a plurality of rows, wherein each row corresponds to at least one record of the records; and
each row including a plurality of cells, each cell corresponding to a different grouping of data fields of its respective one(s) of the records;
wherein at least one of the plurality of cells comprises an editable concatenated cell that is driven by more than one data field of a record of the records;
wherein each individual cell of the plurality of cells of the data table includes a plurality of user controls, wherein a first user control of the plurality of user controls is arranged to toggle focus from the data table to the respective individual cell, and a second user control of the plurality of user controls is arranged to trigger display of a popover on the data table at the respective individual cell for editing corresponding record(s) of the records, wherein each second user control corresponds to a portion of an area of the respective individual cell, and wherein each first user control comprises a remaining portion of the area of the respective individual cell;

in the case that a communication is received from the application on the remote user terminal to edit the editable concatenated cell, correlating a value from the communication to an individual data field of the more than one data field of the record and selectively feeding back a value of the communication to the correlated individual data field.

2. The database system of claim 1 , wherein the data store comprises a multi-tenant database.

3. The database system of claim 2 , wherein the data table includes a subset of records that correspond to a same tenant.

4. The database system of claim 3 , wherein operations further comprise:
correlating the value of the communication to first validation rules based on the correlating the value to the individual data field, wherein the first validation rules correspond to a respective tenant of the tenants; and
applying any correlated one(s) of the first validation rules to the value of the communication, wherein the selectively feeding back the value of the communication to the individual data field is based on the correlated one(s) of the first validation rules.

5. The database system of claim 4 , wherein the first validation rules are tenant-specific and the operations further comprise:
correlating the value of the communication to second global validation rules based on the correlating the value to the individual data field; and
applying any correlated one(s) of the second global validation rules to the value of the communication, wherein the selectively feeding back the value of the communication to the individual data field is based on the correlated one(s) of the first tenant-specific validation rules and the second global validation rules.

6. The database system of claim 1 , wherein each second user control comprises text, wherein each second user control is based on a field value of a respective one of the groupings of data fields.

7. The database system of claim 1 , wherein each second user control is arranged to trigger the display of the respective popover on user selection of the respective text, wherein the first user control is arranged to toggle focus to the respective individual cell on user selection of the remaining portion of the area.

8. The database system of claim 1 , wherein the popover of the editable concatenated cell includes at least one of top two corners squared off and aligned to a top of the row of the editable concatenated cell, a top left or top right corner aligned to the top left or right corner of the selected cell, or a lower edge and opposing side extendable beyond the table cell boundaries with at least one of a dropshadow or lower rounded corners.

9. The database system of claim 1 , wherein the operations further comprise first operations, and wherein the application is configured to, in response to execution by a processing system of the user terminal, perform second operations comprising:
identifying a selection of a row of the data table; and
responsive to the selection, performing at least one of display a portion of cell borders of the selected row differently than a portion of cell borders of unselected ones of the individual cells or display a background of the selected row differently than a background of the unselected ones of the individual cells;
wherein the portion of the cell borders comprises horizontal cell boundaries.

10. The database system of claim 9 , wherein the second operations further comprise:
determining a selection of one of the individual cells; and
displaying a background of the selected individual cell differently than the background of the other individual cells of the selected row on a screen of the user terminal.

11. The database system of claim 10 , wherein a characteristic of the background of the selected individual cell includes at least one of negative highlighting or matches a background of an unselected row.

12. A database system, comprising:
a processing system; and
a memory device coupled to the processing system and including instructions stored thereon that, in response to execution by the processing system, are operable to:
download to a user system an application configured to generate a data table from records stored in a data store, wherein the data table includes:
a plurality of rows, wherein each row corresponds to at least one record of the records; and
each row including a plurality of cells, each cell corresponding to a different grouping of data fields of its respective one(s) of the records;
wherein at least one cell of the data table comprises an editable concatenated cell that includes values of more than one data field of a record of the records;
wherein each individual cell of the plurality of cells of the data table includes a plurality of user controls, wherein a first user control of the plurality of user controls is arranged to toggle focus from the data table to the respective individual cell, and a second user control of the plurality of user controls is arranged to trigger display of a popover on the data table at the respective individual cell for editing corresponding record(s) of the records;

receive a communication from the application, the communication corresponding to at least one user input to one of the individual cells;
determine whether to feedback a value of the at least one user input to the individual cell to a corresponding data field of a corresponding record of the data store; and
update the corresponding record in the data store based on a result of the determination;
wherein states for each of the individual cells are selectable from a group including:
active cell with focus in the data table, and
active cell without focus in the data table, and

wherein the application is configured to use:
a first display style for a corresponding individual cell when the corresponding individual cell is in the active state and a user interface of the user system is currently controlling the data table, and
a second display style that is different than the first display style when the corresponding individual cell is in the active state and the user interface is currently controlling a navigation control that is outside

Assignees

• Salesforce Com Inc

Inventors

• Schoppe Owen Winne
• Schoen Ian
• Hausler Jesse

Classifications

• G06F40/18

  of spreadsheets (form-filling G06F40/174) · CPC title

• G06F16/252 Primary

  between a Database Management System and a front-end application · CPC title