Header Row and Locking Key Columns in NetSuite CPQ

Enhance your QTable experience in NetSuite CPQ with new header and column locking features for better data comparison.

·2 min read·8 views·View Oracle Docs

You can now unlock the header and keep key columns in view while comparing and entering data in large QTables. Two new options have been added for these purposes in NetSuite CPQ Configurator:

Unfreeze Top Row

When enabled, the QTable's header will no longer remain fixed at the top of the table and will move out of view as users scroll down past the visible rows. You can find this checkbox under the QTable tab on the question record.

Note: A maximum number of visible rows must be set in the Maximum Visible Rows field on the same subtab.

Freeze Column

When enabled for specific columns, they will remain visible and pinned to the left side of the QTable as users scroll horizontally to the right. You can find this checkbox under the QTable Cells tab on the answer record.

These enhancements make it easier to navigate and analyze large datasets within QTables, thereby improving data entry and comparison efficiency.

Who This Affects

  • Administrators: Responsible for configuring QTables and making decisions on layout and functionality.
  • Users: Anyone who interacts with QTables for data entry or analysis will benefit from these enhanced navigation options.

Key Takeaways

  • The ability to unfreeze the top row in QTables allows for better data management.
  • Columns can be frozen to stay in view as users scroll horizontally, aiding comparison.
  • These features improve overall accessibility when dealing with large data sets in NetSuite CPQ.

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

Frequently Asked Questions (4)

How do you enable the unfreeze top row feature in NetSuite CPQ?
To enable the unfreeze top row feature, navigate to the QTable tab on the question record and check the option for 'Unfreeze Top Row.' Ensure the maximum number of visible rows is set in the Maximum Visible Rows field on the same subtab.
Where can you find the option to freeze specific columns in a QTable?
The option to freeze specific columns can be found under the QTable Cells tab on the answer record. You can select which columns should be pinned to remain visible as users scroll horizontally.
Do you need to set any configuration options for freezing columns to work in NetSuite CPQ?
Yes, you must enable the freeze column option for specific columns under the QTable Cells tab on the answer record to ensure those columns remain visible when scrolling.
Is it possible to set the number of visible rows in a QTable when using header row functionality?
Yes, you must set the maximum number of visible rows in the Maximum Visible Rows field on the QTable subtab to use the unfreeze top row functionality effectively.
Source: Unlock the QTable Header Row and Lock Key Columns While Scrolling Oracle NetSuite Help Center. This article was generated from official Oracle documentation and enriched with additional context and best practices.

Was this article helpful?

More in User Interface

View all User Interface articles →