Table Views

Note:

The content in this help topic applies to SuiteScript 2.x.

Table views let you explore your dataset query results in a simple tabular format. Using table views does not require complex customization and lets you view your data without setting up a layout or defining custom formula fields. You can only create table views using fields that have been added to the underlying dataset.

For more information about table views in SuiteAnalytics Workbook, see Workbook Table Views.

To create a table view, use workbook.createTable(options). This method creates a workbook.Table object. As parameters, you must provide a set of columns to include in the table view, the underlying dataset that contains the data for the table view, and an ID and name for the table view. Use workbook.createTableColumn(options) to create table columns. For more information, see Table Columns.

          var myTable = workbook.createTable({
    columns: [myFirstTableColumn, mySecondTableColumn, myThirdTableColumn],
    dataset: myDataset,
    id: 'customscript_myTable',
    name: 'My Table View'
});

Related Topics