Version 29.4.0

|

What’s Changed?

  • Settings: Added options to allow for toggling on and off some features (Learn More)
    • Collapsible Field Groups
    • Sticky First Column of Sublists
  • Global Script Execution Log: Now formatted like all other execution logs (Learn More)
  • Custom Lists: Added a “Used By Fields” table to show which fields are using the list (Learn More)
  • Added a character counter to text fields that have maximum lengths (Learn More)
  • Scripted Record page: Added All Deployments buttons (Learn More)
  • Global Search: Allow searching for File Cabinet file and folder paths using a “path:” prefix (Learn More)
  • SuiteQL Results:
    • Added a Paged button toggle to control whether to run the SuiteQL as paged or not (Learn More)
    • Variable Manager: Added a Save & Execute button (Learn More)
    • Variables are now saved as comments at the top of SuiteQL (Learn More)
    • Added special variables called “constants” to access data from the current NetSuite account for use within a query (Learn More)
    • Naming a column “_bg” and returning a CSS color value sets the row’s background color (Learn More)
    • The Library button has been merged into the Load button (Learn More)
  • Collapsible Field Groups: It’s now more obvious that a field group is collapsed (Learn More)
  • CSV Import Status page: Live View can now be disabled
  • Global Search: Added support for searching for more record type scriptids:
    • Workflow fields
    • Plugin scripts

New Settings Options

  • Collapsible Field Groups
  • Sticky First Column of Sublists

Global Execution Log Formatting

It now has the same features as all other Execution Logs

  • Clickable scriptid and record:id formats
  • Syntax formatting for JSON and XML

Used By Fields Table on Custom Lists

See which fields are using the custom list at a glance

Text Field Character Count

Easily see how close you are to the maximum character count in a field.

Scripted Record Page Buttons

The “View All” button has been renamed to “All Scripts”, and a new “All Deployments” button has been added for both of the scripts subtabs.

Global Search Path Prefix

Examples:

  • path: SuiteScripts/Folder/script.js
  • path: "SuiteScripts/Sales Order/my_sales_order_ue.js"
  • path: "Images/Assets/3D Printer.jpg"

SuiteQL Results Paged Toggle

Control whether your SuiteQL executes paged or unpaged.

SuiteQL Results Variable Manager Save & Execute

Saving you a click! Every second counts!

SuiteQL Results Variable Comment Syntax

Variables now get added as comments at the top of your SuiteQL query. This allows you to view, create, and edit the variables straight from the SuiteQL query.

SuiteQL Results Constants

Easily use details about the current NetSuite account, environment, and user within your SuiteQL query.

  • ${USER_ID}
  • ${USER_NAME}
  • ${ACCOUNT_ID}
  • ${ACCOUNT_SUBDOMAIN}
  • ${ACCOUNT_DOMAIN}
  • ${COMPANY_NAME}
  • ${ROLE_ID}
  • ${ROLE_NAME}
  • ${LOCALE}
  • ${ENV} – Possible values: pd = production, sb = sandbox, rp = release preview, db = debugger
  • ${DATE_FORMAT} – User preferences format converted into SuiteQL format
  • ${TIME_FORMAT} – User preferences format converted into SuiteQL format
  • ${TIME_ZONE} – From user preferences

SuiteQL Results Row Background Color

Use “_bg” as a column name and return a valid CSS color to set the background color for the row.

SuiteQL Results Load Button

The Load button now includes the Library as well.

Collapsible Field Groups UI Improvements

Collapsed field groups now display as slightly transparent. There’s also an animation when collapsing a field group.