The Record Listing – sometimes referred to simply as “Table” or “Listing” is a record-by-record (row), column-by-column (field) presentation of the static and dynamic (calculated) content in a database table. While it is possible, and in fact common, to include content from multiple (linked) tables in a single Listing, Listings are referred to according to the Parent table with which they are associated. For example, a listing of all employees in the Employee Roster table is simply referred to as the Employee List. If this listing happens to include data from other tables such as Projects & Assignments and/or Awards & Recognitions, that does not change the fact that this view is associated with the Employe Parent table.
As noted above, and as depicted in the image below, a row in a view represents a record while each column in a view represents a field within that record.
In the image above, the orange box surrounds all of the content that has been selected for this listing. In this case, that includes 10 invoices (each on its own row) and four fields (each in its own column). The green box contains one data field for all ten of the displayed invoices while the blue box contains all four data fields for a single invoice record. Given the row/column, x/y grid of this view, users sometimes refer to this as a “Spreadsheet View”.
When a new table is created in Ninox, the application will automatically create a new view for that table. That view is always named “(all)” and includes up to the first seven fields in the data model for that table.