Dynamically materialized views for sheets based data

A computer-implemented method, comprising:

• storing data of an application at least in part within a first logical table of a data sheet, wherein the first logical table comprises a plurality of cells arranged in one or more rows and one or more columns;
• obtaining, via one or more programmatic interfaces, a first filter definition to be used to populate at least a particular cell of the first logical table, wherein the first filter definition comprises (a) an indication of a second logical table and (b) a self-reference function which refers to a row within which the self-reference function is invoked;
• and
• determining at least a first value to be displayed in the particular cell in accordance with the first filter definition, wherein the first value is obtained from the second logical table based on a second value, and wherein the second value is obtained, in accordance with the self-reference function, from a particular row to which the particular cell belongs.

A system, comprising:

• one or more computing devices;
• wherein the one or more computing devices include instructions that upon execution on or across the one or more computing devices:
• store data of an application at least in part within a first logical table of a data sheet, wherein the first logical table comprises a plurality of cells arranged in one or more rows and one or more columns;
• obtain, via one or more programmatic interfaces, a first filter definition to be used to populate at least a particular cell of the first logical table, wherein the first filter definition comprises (a) an indication of a second logical table and (b) a self-reference function which refers to a row within which the self-reference function is invoked;
• and
• determine at least a first value to be displayed in the particular cell in accordance with the first filter definition, wherein the first value is obtained from the second logical table based on a second value, and wherein the second value is obtained, in accordance with the self-reference function, from a particular row to which the particular cell belongs.

One or more non-transitory computer-accessible storage media storing program instructions that when executed on or across one or more processors:

• store data of an application at least in part within a first logical table of a data sheet, wherein the first logical table comprises a plurality of cells arranged in one or more rows and one or more columns;
• obtain, via one or more programmatic interfaces, a first filter definition to be used to populate at least a particular cell of the first logical table, wherein the first filter definition comprises (a) an indication of a second logical table and (b) a self-reference function which refers to a row within which the self-reference function is invoked;
• and
• determine at least a first value to be displayed in the particular cell in accordance with the first filter definition, wherein the first value is obtained from the second logical table based on a second value, and wherein the second value is obtained, in accordance with the self-reference function, from a particular row to which the particular cell belongs.