Spreadsheet-based software application development

An apparatus for generating an interactive web application comprising display of data records from a spreadsheet, the apparatus comprising:

• one or more processors;
• and
• memory storing instructions that, when executed by the one or more processors, cause the apparatus to:
• determine one or more data sources within the spreadsheet, each data source having zero or more data records, wherein the data sources comprise a first portion of the spreadsheet;
• determine a plurality of user interface templates within the spreadsheet, wherein each user interface template corresponds to a different version of a same first web page of the interactive web application and comprises a layout or formatting for data records to be included in the respective version of the first web page, wherein each user interface template is defined at least in part by one or more cells of one or more second portions of the spreadsheet distinct from the first portion of the spreadsheet;
• generate a plurality of versions of the first web page, each based on a respective user interface template of the plurality of user interface templates, wherein each version of the first web page references at least one same first data source and comprises a respective layout defined based on the respective user interface template;
• receive a request for a presentation of the first web page of the interactive web application from a user device, wherein the request identifies device attribute or capability information associated with the user device;
• responsive to the request for the presentation of the first web page:
• select a first version of the first web page based on the device attribute or capability information identified in the request;
• generate 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 formatted according to the respective user interface template corresponding to the selected first version of the first web page;
• and
• responsive to receiving user input, via an 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, update at least one corresponding data record.

A non-transitory computer-readable medium storing instructions that, when executed by one or more processors, cause a computing device to perform steps comprising:

• determining one or more data sources within the spreadsheet, each data source having zero or more data records, wherein the data sources comprise a first portion of the spreadsheet;
• determining a plurality of user interface templates within the spreadsheet, wherein each user interface template corresponds to a different version of a same first web page of the interactive web application and comprises a layout or formatting for data records to be included in the respective version of the first web page, wherein each user interface template is defined at least in part by one or more cells of one or more second portions of the spreadsheet distinct from the first portion of the spreadsheet;
• generating a plurality of versions of the first web page, each based on a respective user interface template of the plurality of user interface templates, wherein each version of the first web page references at least one same first data source and comprises a respective layout defined based on the respective user interface template;
• receiving a request for a presentation of the first web page of the interactive web application from a user device, wherein the request identifies device attribute or capability information associated with the user device;
• responsive to the request for the presentation of the first web page:
• selecting a first version of the first web page based on the device attribute or capability information identified in the request;
• 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 formatted according to the respective user interface template corresponding to the selected first version of the first web page;
• and
• responsive to receiving user input, via an 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, updating at least one corresponding data record.