QBench Mid August Release Notes

What’s New:

Canny Feature Requests

• Added the ability to assign Global Filters to all users with a click of a button
• LIMS Users will now be able to drag and drop attachments from their computer into QBench anywhere we allow attachments to be added.

Spreadsheet Worksheet

• Added the ability to Import/Export Spreadsheets Worksheets as JSON Files to move them from one environment to another (e.g. sandbox to production)
• Added the ability to use Jinja code snippets in Spreadsheet Worksheet named cells
• Added the ability to export Spreadsheet Worksheets to a CSV file on the Batch Details Page, Test Details Page, and Log Entry Details Page
• Added the ability to use Conditional Formatting (e.g. cell coloring based on value) for a cell in Spreadsheet Worksheets
• Added the ability to have drop down option value for a cell in Spreadsheet Worksheets
• Added more support for Batch worksheets in Spreadsheet Worksheets

Automation

• Added the ability to specify a VLOOKUP as part of an automation
• Added the ability to build an automation so that a Batch Spreadsheet Worksheet can copy values to each of its respective Tests

Reports & PrintDocs

• Added a new option for report creation to allow the ability to import a Word document containing Jinja code and merge fields as a Report and PrintDoc template.  This will allow our customers the capabilities of Word formatting for report building

Object Deletion

• Added the ability to require a reason for deleting items wherever there is a history tab available to post the reason to (e.g. test)
• Users can now view deleted items using a filter on their respective list pages
• Users will be able to restore deleted items using a new restore option on the details page

Internal Reports

• Added the ability to enable auto-refresh on Internal Reports.  This enables the ability to have a report continually run and refresh data each minute.  (e.g. dashboard report)