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

Patent metadata

Field	Value
Publication number	US-2018067976-A1
Application number	US-201615339522-A
Country	US
Kind code	A1
Filing date	Oct 31, 2016
Priority date	Sep 8, 2016
Publication date	Mar 8, 2018
Grant date	—

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, 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;
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 a value of 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,

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 the determination includes:
correlating the value of the at least one input to first validation rules based on correspondence of the value to a data field of the data fields, 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, wherein the associated record in the data store is updated based on a result of the applying.

5 . The database system of claim 4 , wherein the determination includes:
correlate the value of the at least one input to second validation rules based on correspondence of the value to the data field of the data fields and apply any correlated one(s) of the second validation rules to the value, wherein the associated record in the data store is updated based on a result of said applying.

6 . The database system of claim 1 , wherein at least one cell of the table includes a first user control to select said cell.

7 . The database system of claim 6 , wherein at least one cell of the table includes a second user control to edit a value of the cell.

8 . The database system of claim 7 , wherein the cell includes text of the value and a graphical user interface, wherein the first user control is to be activated by selection of the text and the second user control is to be activated by selection of the graphical user interface.

9 . The database system of claim 1 , wherein the application is configured to:
in response to receipt of a user input to indicate navigation from said cell to another cell, wherein only one of the first and second user controls is highlighted at a time of the user input, highlight only a corresponding one of first and second user controls of said another cell.

10 . The database system of claim 1 , wherein the application is configured to cause a first user controls to be displayed, and wherein the application is configured to:
cause a second user control that is different than the first user controls to be displayed on a selected cell of the data table in response to receipt of a user input corresponding to the selected cell,

11 . The database system of claim 10 , wherein the second user control comprises a popover including text, wherein the text of the popover is dynamically generated based on a current value of the selected cell.

12 . The database system of claim 11 , wherein the popover includes at least one of top two corners squared off and aligned to a top of the row of the selected 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.

13 . The database system of claim the application is further configured to:
identify a selection of a row of the data table; and responsive to the selection, perform at least one of display a portion of cell borders of the selected row differently than a portion of cell borders of unselected cells or display a background of the selected row differently than a background of the unselected cells; wherein the portion of the cell borders comprises horizontal cell boundaries.

14 . The database system of claim 13 , wherein the application is further configured to:
determine a selection of a cell of the selected row; and display a background of the selected cell differently than the background of the other cells of the selected row.

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

16 . The database system of claim 1 , wherein states for each cell of the data table are to be selected from a group including grid focused and unfocused, row cell and target hover states, active highlight, cell and target focus, row selected, cell edited, cell errored, and locked cell.

17 . The electronic device of claim 1 , wherein the application is further configured to:
determine whether focus is in the data table; in response to determining that focus is in the data table, display the selected cell with at least one of a first border or a first background; in response to determining that the focus is not in the data table, display the selected cell with at least one of a second different border or a second different background.

18 . The database system of claim 17 , wherein the application is further configured to display the unselected cells with the first background, and wherein the second different border is has visibility only along row boundaries.

19 . The database system of claim 18 , wherein the data table is a web data table and when focus is not in the data table a user interface of the user system is to control the browser.

20 . The database system of claim 1 , wherein the instructions are further operable to:
identify a first level error if an error is identified based on applying first validation rules to the value of the at least one input; identify a second level error if an error is identified based on applying second different validation rules to the value of the at least one input; and cause error messaging to be displayed on the data table, wherein error messaging for any identified second level error(s) is displayed on a data table overlay and error messaging for any identified first level error(s) is displayed in the data table on a row that corresponds to the value.

21 . The database system of claim 20 , wherein the error messaging for the first level error includes at least one of a row level error message, a cell level error message, or a field level error message.

22 . The database system of claim 1 , wherein the cells are resizable in a row direction by displaying a label displayed in a cell to be resized.

23 . The database system of claim 22 wherein a selected value for the label determines a width of the label.

Assignees

• Salesforce Com Inc

Inventors

• Schoppe Owen Winne
• Schoen Ian
• Hausler Jesse

Classifications

• G06F3/0482

  Interaction with lists of selectable items, e.g. menus · CPC title

• G06F3/04845

  for image manipulation, e.g. dragging, rotation, expansion or change of colour · CPC title

• G06F3/04842

  Selection of displayed objects or displayed text elements (G06F3/0482 takes precedence) · CPC title

• G06F17/30339 Primary

  Physics · mapped topic

• G06F17/30377

  Physics · mapped topic