IP Library Granted Patent US 10,748,093
Granted Patent B2
US 10,748,093 · App. 16/141,837 · Granted Aug 18, 2020

Card view interface with automatically generated calculated value

Inventors: Christopher James Barrows (Kirkland, WA); Jonathan Sandler (Renton, WA)
Assignee: Smartsheet Inc.
G06Q10/06311
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 10,748,093
App. No.
16/141,837
Granted
Aug 18, 2020
Kind
B2
Abstract

Embodiments of the present disclosure present a calculated value within a card view presentation in order to overcome technical problems in presenting useful card view presentations on mobile computing devices. In some embodiments, the calculated value is a summary, analysis, or other type of information generated based on data associated with cards that are in a given lane. In some embodiments, further technical problems relating to the limitations of the interface of the mobile computing device in adjusting calculated view settings are addressed by presenting a simplified configuration interface. The simplified configuration interface presents a mobile-friendly view of limited configuration settings to allow the user to easily change settings relevant to the calculated value and/or the card view, and thereby adjust the card view despite the limitations of the interface of the mobile computing device.

Claims (71)

1. A computer-implemented method of displaying, by a mobile computing device, compact summaries of data within a table, wherein the table includes a plurality of rows and a plurality of columns, and wherein the plurality of columns includes a first column and a second column, the method comprising:

determining a set of lanes representing the data by retrieving a set of values stored in the first column, wherein each lane provides a presentation of a set of cards associated with rows having a given value of the retrieved set of values;

retrieving a first subset of rows from the plurality of rows that have a first value of the retrieved set of values in the first column, wherein the first value is associated with a first lane of the set of lanes;

generating a first set of cards based on the retrieved first subset of rows, wherein each card of the first set of cards represents a row of the first subset of rows;

providing the first set of cards for presentation by a display on the mobile computing device as part of the first lane;

determining a calculated value for the first lane based on values in the second column for the first subset of rows; and

providing the calculated value for presentation by the display on the mobile computing device.

2. The method of claim 1 , further comprising:

detecting a move of a card from the first lane to a second lane; and

determining an updated calculated value for the first lane.

3. The method of claim 1 , further comprising:

providing a set of calculated value types for presentation by the display on the mobile computing device;

receiving a selection of a calculated value type; and

determining a new calculated value for the first lane using the selected calculated value type.

4. The method of claim 3 , wherein the set of calculated value types includes a sum calculated value type, a mean calculated value type, a median calculated value type, a max calculated value type, and a min calculated value type.

5. The method of claim 1 , further comprising:

providing column identifiers of the plurality of columns for presentation by the display on the mobile computing device;

receiving a selection of a column identifier associated with a third column; and

determining a new calculated value for the first lane based on values in the third column for the first subset of rows.

6. The method of claim 1 , further comprising:

providing column identifiers of the plurality of columns for presentation by the display on the mobile computing device;

receiving a selection of a column identifier associated with a fourth column; and

determining a new set of lanes representing the data by retrieving a set of values stored in the fourth column.

7. The method of claim 1 , wherein the mobile computing device is a smartphone.

8. A computer-readable medium having computer-executable instructions stored thereon that, in response to execution by one or more processors of a computing device, cause the computing device to perform actions for displaying, by a mobile computing device, compact summaries of data within a table, wherein the table includes a plurality of rows and a plurality of columns, and wherein the plurality of columns includes a first column and a second column, the actions comprising:

determining a set of lanes representing the data by retrieving a set of values stored in the first column, wherein each lane provides a presentation of a set of cards associated with rows having a given value of the retrieved set of values;

retrieving a first subset of rows from the plurality of rows that have a first value of the retrieved set of values in the first column, wherein the first value is associated with a first lane of the set of lanes;

generating a first set of cards based on the retrieved first subset of rows, wherein each card of the first set of cards represents a row of the first subset of rows;

providing the first set of cards for presentation by a display on the mobile computing device as part of the first lane;

determining a calculated value for the first lane based on values in the second column for the first subset of rows; and

providing the calculated value for presentation by the display on the mobile computing device.

9. The computer-readable medium of claim 8 , wherein the actions further comprise:

detecting a move of a card from the first lane to a second lane; and

determining an updated calculated value for the first lane.

10. The computer-readable medium of claim 8 , wherein the actions further comprise:

providing a set of calculated value types for presentation by the display on the mobile computing device;

receiving a selection of a calculated value type; and

determining a new calculated value for the first lane using the selected calculated value type.

11. The computer-readable medium of claim 10 , wherein the set of calculated value types includes a sum calculated value type, a mean calculated value type, a median calculated value type, a max calculated value type, and a min calculated value type.

12. The computer-readable medium of claim 8 , wherein the actions further comprise:

providing column identifiers of the plurality of columns for presentation by the display on the mobile computing device;

receiving a selection of a column identifier; and

determining a new calculated value for the first lane using a column associated with the selected column identifier.

13. The computer-readable medium of claim 8 , wherein the actions further comprise:

providing column identifiers of the plurality of columns for presentation by the display on the mobile computing device;

receiving a selection of a column identifier; and

determining a new set of lanes representing the data by retrieving a set of values stored in a column associated with the selected column identifier.

14. The computer-readable medium of claim 8 , wherein the mobile computing device is a smartphone.

15. A system comprising one or more computing devices for causing a mobile computing device to display compact summaries of data within a table, wherein the table includes a plurality of rows and a plurality of columns, and wherein the plurality of columns includes a first column and a second column, the one or more computing devices configured to:

determine a set of lanes representing the data by retrieving a set of values stored in the first column, wherein each lane provides a presentation of a set of cards associated with rows having a given value of the retrieved set of values;

retrieve a first subset of rows from the plurality of rows that have a first value of the retrieved set of values in the first column, wherein the first value is associated with a first lane of the set of lanes;

generate a first set of cards based on the retrieved first subset of rows, wherein each card of the first set of cards represents a row of the first subset of rows;

provide the first set of cards for presentation by a display on the mobile computing device as part of the first lane;

determine a calculated value for the first lane based on values in the second column for the first subset of rows; and

provide the calculated value for presentation by the display on the mobile computing device.

16. The system of claim 15 , wherein the one or more computing devices are further configured to:

detect a move of a card from the first lane to a second lane; and

determine an updated calculated value for the first lane.

17. The system of claim 15 , wherein the one or more computing devices are further configured to:

provide a set of calculated value types for presentation by the display on the mobile computing device;

receive a selection of a calculated value type; and

determine a new calculated value for the first lane using the selected calculated value type.

18. The system of claim 17 , wherein the set of calculated value types includes a sum calculated value type, a mean calculated value type, a median calculated value type, a max calculated value type, and a min calculated value type.

19. The system of claim 15 , wherein the one or more computing devices are further configured to:

provide column identifiers of the plurality of columns for presentation by the display on the mobile computing device;

receive a selection of a column identifier; and

determine a new calculated value for the first lane using a column associated with the selected column identifier.

20. The system of claim 15 , wherein the one or more computing devices are further configured to:

provide column identifiers of the plurality of columns for presentation by the display on the mobile computing device;

receive a selection of a column identifier; and

determine a new set of lanes representing the data by retrieving a set of values stored in a column associated with the selected column identifier.

Assignments (2)
PATENT SECURITY AGREEMENT Recorded Jan 23, 2025
From: SMARTSHEET INC.; BRANDFOLDER, INC.
To: BLUE OWL CAPITAL CORPORATION, AS COLLATERAL AGENT
Reel/Frame 070478/0794 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Sep 26, 2018
From: BARROWS, CHRISTOPHER JAMES; SANDLER, JONATHAN
To: SMARTSHEET INC.
Reel/Frame 046976/0922 →
Continuity (1)
Related Publication 20200097871A1 · Mar 26, 2020