Benchling Results is comprised of structured tables that allow you to capture experimental or assay data in a lab notebook entry.
Results manages your data in three primary ways:
It captures critical experimental data in a centralized and queryable manner of an entity or batch (such as the ELISA result from a cell culture experiment).
It standardizes result capture between scientists, eliminating variation or ambiguity, and maps those results back to your samples in the registry.
It syncs to your Benchling data warehouse for advanced analytics and data visualization.
Result tables need to be configured to meet your specific needs based on the type of experiments and assays you perform.
Results in the Lab Notebook
The example above shows a Result table inserted into a lab notebook entry. The Purified Protein column of the table includes a reference to the registered plasmid entity called Demo Protein and the two other columns record the metrics for this assay.
View of Results in the Registry
The Results tab in the Registry will aggregate and display all data that is recorded in Result tables across the organization by any scientist. This data can be exported, and includes a link to the lab notebook entry where it was recorded.
Tip: The Results tab combined with the Registry field values provide you with a full picture of this entity.
Inserting a Result table
Before utilising the Result table feature, first a Result table must be configured by an admin. This guide explains how this can be done.
To insert a Result table into a Notebook entry, navigate to Insert on the Notebook toolbar > Result table > Select the Result table from the dropdown and press Insert.
Adding entities to the Result table
Adding entities to a Result table can be done in multiple different ways, all methods require you to first press the blue + icon. The following options will be available:
Add from structured table - Pull multiple entities from other structured tables within the same Notebook entry.
Add from worklist - Add entities listed in a worklist. To find out more about worklists have a look at this help article.
Import from spreadsheet - Use a spreadsheet to add entities and their corresponding results to the Result table in bulk.
Results must be submitted to be saved by selecting the blue Submit button in the top right corner. Unsubmitted rows are marked with a blue line on the far left side of the row and will not appear in the Results tab of the entity until they are submitted. Rows with incorrect values (e.g. text in an integer field) or missing values in required fields cannot be submitted until the errors are corrected.
View Results recorded against entities in the Registry
Within the Registry, search for the entity you want to view. On an entities page navigate to the Results tab, here all results recorded against this entity will be displayed. The Result table fields will be included as well as a link to the entry the Result table can be found within.
Submitted Results from Result tables will appear on the Results tab in the Registry.
Bulk import samples into a Result table using spreadsheets
When importing into a Result table using a spreadsheet, ensure the column headers match those in the Result table. You can either use an external spreadsheet editor (e.g Microsoft Excel) or a regular Benchling table.
To import your data select the blue + and click Add from spreadsheet, here you have the option to import from:
Spreadsheet - Drag and drop your spreadsheet into the upload box.
Raw Text - Copy and Paste the raw text from your spreadsheet, including column headers.
Click Next and confirm the columns match, correct any errors, then press Next again. After the data is validated click Import. Rows containing your data will now be added to the Result table. You will need to select Submit to submit your results after import.
Incorrect, invalid, or out-of-date results can be archived after submission by selecting the down karat on the number cell, then selecting Archive Row. The reason for Archiving can be selected as Made in error, Archived, or Other. Archived rows will be marked by a gray line on the far left side of the row.
Note about deleting Result tables with data: In a previous version of our Result tables, results could be archived by deleting the table in the Notebook entry. This is no longer the case. Deleting the table from the entry will not archive the results, and they will still appear in the data warehouse. If you accidentally delete a Result table, simply revert the Notebook entry to a previous version to regain the Result table and archive the incorrect rows.