QBench Early April 2023 Release Notes

What’s New:

Canny Features (You asked, we delivered!)

• We have added an integration to use Dropbox Sign (https://www.dropbox.com/hellosign) for our Print Docs templates from the Order Detail Page.  A Dropbox Sign account is also required for this functionality.  Please speak with your Customer Success Manager for any questions!

Spreadsheet Worksheets

• You can now use an XLOOKUP function in spreadsheet worksheets (Knowledge Base Help Article).
• You can now use a TEXTJOIN function in spreadsheet worksheets (Knowledge Base Help Article).
• You now have a configuration menu on the worksheet to turn off / on row numbers for a CSV export.

Charts

• More Chart customization options: Sizing and Location of Legend/Key, Axis Title Location, Font, Font Size, Font Color, and Background color.
• More data type options for Charts: Test - All Fields (Includes Worksheets), Batch - Worksheet Only, Batch - All Fields, Sample - All Fields (Includes Worksheets) (by test), Order - All Fields (Includes Worksheets) (by test).

Inventory Management

• Quantity Available can now be seen on the Inventory list page view config.

Automations Engine

• Users can now set up an Automation that sets a Worksheet field using Jinja  (e.g. {{test.state}}).  This allows for a default value to be inserted into a non-read-only field on Spreadsheet worksheets. 

File Parsers

• You can now specify an Assay in the No-Code File Parser config. This ensures that only the matching Assay triggers a file upload.
• You can now specify an Inclusion Criteria to conditionally retrieve row data within a spreadsheet file.

Customers/Contacts

• You can now import their Customer and Contact lists via spreadsheet uploads.