What are sheets?
Sheets describe the structure of the data.
Sheet Name
The sheet name must match its original name in the spreadsheet.
Sheet Range
The range defines a subset of datas, expressed using the Google Sheets syntax. Example : A2:E1000
Columns
Describes the structure of your datas (cf. Columns).
Virtual columns
Virtual column allows to display custom data in a view. These data can be the combination ot other columns (for example, the sum of two amount) or the evaluation of relationships of your current item (for exemple, the total amount of purchases of a product).
Embedded views
Embedded views are displayed directly from your current item form. they are the evaluation of relationships of your current item)
Reference label
Reference label references the columns that are displayed when your sheet is referenced as a target item of a relationship.