US 11,893,366 B2
Spreadsheet-based software application development
Thomas Stachura, Edmonton (CA)
Filed by Thomas Stachura, Edmonton (CA)
Filed on Aug. 5, 2022, as Appl. No. 17/881,790.
Application 17/881,790 is a continuation of application No. 17/102,993, filed on Nov. 24, 2020, granted, now 11,442,707.
Application 17/102,993 is a continuation of application No. 16/254,155, filed on Jan. 22, 2019, granted, now 10,877,736, issued on Dec. 29, 2020.
Application 16/254,155 is a continuation of application No. 15/455,909, filed on Mar. 10, 2017, granted, now 10,216,494, issued on Feb. 26, 2019.
Claims priority of provisional application 62/429,749, filed on Dec. 3, 2016.
Prior Publication US 2022/0374213 A1, Nov. 24, 2022
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 8/38 (2018.01); G06F 8/30 (2018.01); G06F 40/18 (2020.01); G06F 40/109 (2020.01); G06F 8/34 (2018.01); G06F 40/186 (2020.01)
CPC G06F 8/38 (2013.01) [G06F 8/30 (2013.01); G06F 8/34 (2013.01); G06F 40/109 (2020.01); G06F 40/18 (2020.01); G06F 40/186 (2020.01)] 25 Claims
OG exemplary drawing
 
1. A computer implemented method for generating an interactive web application comprising a display of data records from a spreadsheet, the method comprising:
determining one or more data sources within a spreadsheet, each data source having zero or more data records, wherein the data sources comprise a first portion of the spreadsheet;
determining at least one first user interface template, within the spreadsheet, corresponding to a first web page of the interactive web application and comprising a layout or formatting for data records to be included in the first web page, wherein the first user interface template is defined at least in part by one or more cells of a second portion of the spreadsheet;
generating the first web page of the interactive web application based on the first user interface template, wherein the first web page references at least one first data source identified based on the first user interface template;
generating an input control, as part of the interactive web application, based on one or more rules defined in the first user interface template and configured to receive user input comprising an update to the content of a data record of the first data source, wherein the rules are defined using at least one formula native to a spreadsheet application that generated the spreadsheet;
responsive to a first request for a presentation of the first web page of the interactive web application, generating the presentation of the first web page including one or more first data records of the first data source, wherein the one or more first data records are identified based on and formatted according to the first user interface template corresponding to the first web page;
responsive to receiving user input via, the input control of the interactive web application, comprising an update to the content of at least one first data record included in the presentation of the first web page, determining whether the update to the content of the at least one first data record satisfies the one or more rules; and
responsive to determining that the update to the content of the at least one first data record satisfies the one or more rules, updating at least one corresponding data record of the spreadsheet.