Workbook Table Object Members Reference for SuiteScript

The workbook.Table object is essential for developers working with table views in SuiteScript. It provides key members that help to define and manipulate the structure of tables within your applications. Understanding how to utilize these members effectively can enhance the way data is represented in your NetSuite environment.

What Are the Members of the Table Object?

The workbook.Table object includes several members that allow you to access and modify properties of the table view. Here's a detailed breakdown:

How to Create a Table Object

To create a workbook.Table object, use the workbook.createTable(options) method. Here is a basic example of how to instantiate a table object:

Code Sample

1// Code to create a workbook.Table object
2var myTable = nWorkbook.createTable({
3    columns: [column1, column2], // Previously defined workbook.TableColumn objects
4    dataset: myDataset,           // Previously defined dataset
5    id: 'myTableId',             // Unique identifier for the table
6    name: 'myTableName'          // Label for the table
7});

This snippet demonstrates how to declare and initialize a workbook.Table object, which can then be used in various operations throughout your script.

Logging Table Columns

If you need to log or inspect the columns of a table, you can do so with the following syntax:

Code Sample

1// Load the workbook and log the first column of the first table
2var myWorkbook = workbook.load({
3    id: myWorkbookId 
4});
5 
6log.audit({
7    title: 'Table.columns = ',
8    details: myWorkbook.tables[0].columns[0] // Accessing the first column
9});

This approach is useful for debugging and understanding the structure of your table data.

Conclusion

The workbook.Table object and its members are powerful tools in SuiteScript, enabling developers to craft dynamic and effective data views in NetSuite. Mastering these attributes will improve your ability to control how data is presented to users.

Source: This article is based on Oracle's official NetSuite documentation.

Key Takeaways

• The workbook.Table object provides key features for managing table views.
• Members like columns, dataset, id, and name are essential for defining tables.
• Understanding syntax and usage can enhance data representation in your scripts.