1. NetSuite CPQ
  2. NetSuite CPQ Configurator
  3. Working with Product Building Blocks
  4. Working with the Product User Interface
  5. Gathering Information with Questions and Answers
  6. Storing Answer Options in Tables
  7. Creating Static Tables

Creating Static Tables

Static tables let you manually create and maintain a table in the table record. You can also enter JSON data in the JSON Data subtab and the table will be automatically displayed in the editor. The table editor and the subtab with JSON Data are synchronized. When you apply changes to one subtab, the other one is updated as well.

Note:

Static tables have a one million character limit. To create large tables, use the CSV table type.

You can also create a static table by importing data from a CSV file. For more information, see Importing Data Into Static Tables from CSV files.

Before completing the steps for this table type, follow the basic steps to create a table.

To create a static table:

  1. On the Tables subtab, click New CPQC Table.

  2. In the Table Type field, select Static Table.

  3. To enter data for the table, two options are available:

    • In the Table Editor subtab, click a row and enter text.

      Use the table editor buttons to add or remove rows and columns as needed.

    • In the JSON Data subtab, paste data in JSON format.

      For example, a table with two columns and three rows would have these structure:

                          [{"ColumnName1":"Value","ColumnName2":"Value"},{"ColumnName1":"Value","ColumnName2":"Value"},{"ColumnName1":"Value","ColumnName2":"Value"}]

  4. Click Save.

Importing Data Into Static Tables from CSV files

Instead of entering data manually, you can import data for a static table from a CSV file stored in the File Cabinet. Data will be saved in the table record.

Before completing the steps for this table type, follow the basic steps to create a table.

To create a static table from a CSV file:

  1. On the Tables subtab, click New CPQC Table.

  2. In the Table Type field, select Static Table.

  3. In the CSV File field, select the CSV file you want to use as the data source for the static table, for example, a comma or a semicolon.

  4. In the Column Separator field, select the symbol that separates the columns in the CSV file, for example, a comma or a semicolon.

  5. In the Escape Characters field, select the character used to indicate that the following character should be interpreted literally, or to enclose text with special characters.

  6. Click Save.

  7. On the Tables subtab, edit the table you've created to continue the setup.

  8. To unlink the CSV file after loading its data, check the Unlink static table from CSV file box.

    The static table will no longer be associated with the CSV file, and you can save the changes applied to the static table in the table record.

    If you clear this box, any changes you make to the static table on the table record will be disregarded.

    Note:

    Alternatively, you can unlink the static table from the CSV file by clearing the CSV File field after loading the data. Use this option if you don't need to keep track of the CSV file name.

  9. Click Save.

Related Topics

General Notices