Storing Filter Options in Tables
When you need to retrieve long lists of options dynamically, you can store data in tables to provide options for input box popup lists (called dropboxes). This approach simplifies adding, removing, and updating options. For example, if your business sells multiple desk types, you can dynamically update the desk options, without having to change the filter every time you add or remove a desk type. For more information about input box popup list filters, see Working with Popup Lists for Input Box Filters.
The following table types are available:
-
Dynamic tables – Let you create tables using data from any record type available in your account. Each record field becomes a column in the table. Dynamic tables automatically update when data change in your account. This table type is useful when working with account data that only needs to be accessed occasionally. For more information, see Creating Dynamic Tables.
-
Code exec generated tables – Let you create tables that you can fill in using NetSuite CPQ Guided Selling functions. You can use this table type when table data requires frequent access and updates. For more information, see Creating Tables Using Functions.
To create a table:
-
In NetSuite, go to Guided Selling > Product > Product Maintenance.
-
Click Edit next to the catalog you want to modify.
-
On the Tables subtab, click New CPQG Table.
-
Enter a descriptive name for the table.
This name is for internal reference only.
-
In the Code field, enter a unique identifier for the table.
The code can contain only uppercase letters, numbers, and underscores. You can enter a shortened version of the name as the code to identify the table.
-
Select a table type.
-
Click Save.
Creating Dynamic Tables
Dynamic tables pull data from the record type you specify. You can choose any record type available in your account, and the table updates automatically whenever those records change. When users click the button of the popup list associated with the table, options are dynamically loaded from the table into the popup list.
To add content to a dynamic table, specify the record fields you want to include. Each field becomes a column in the table. If you don't specify any fields, the dynamic table remains empty. After defining the table content, you can filter the dynamic table by field values to refine the results and display only the information that matches the criteria defined in popup lists. You can also preview the content of the dynamic table by clicking the Test Table button.
Record fields from sublists are unavailable.
Complete the basic steps to create a table before proceeding the specific steps for dynamic tables.
To create a dynamic table:
-
On the Tables subtab, click New CPQG Table.
-
In the Table Type field, select Dynamic.
-
Select the record type from which you want to retrieve data.
-
To add columns, click the plus icon next to the Record Fields field and select the record fields you want to include.
-
To refine the table results and retrieve a subset of records, click the open icon next to the Search Filter field.
In the popup wizard:
-
Select the record field you want to use for filtering.
-
Select an operator.
The available operators depend on the field selected.
-
Enter the filter text.
-
Click OK.
-
-
To add multiple filters and retrieve a more specific subset of records, repeat step 5.
When adding another filter, select a logical operator (AND or OR) to combine the filters. AND produces a more restrictive condition, whereas OR results in a less restrictive condition.
The filters are automatically copied to the Search Filter field in JSON format. The syntax is:
[["fieldID1","operator","value1"],"and",["fieldID2","operator","value2"]]
-
To preview the dynamic table content, click the Test Table button.
-
Click Save.
Creating Tables Using Functions
Code exec-generated tables are dynamically created when you open a catalog. After creating this table type, use functions to fill it in when the catalog loads.
To create a code exec-generated table:
-
Go to the Tables subtab.
-
Click New CPQG Table.
-
In the Table Type field, select CE generated.
-
Click Save.