Inserting a data table

While selecting a location in your ELN or Workflows Stage Entry, choose Insert -> Data Table -> New. 

If you are creating an entry from an Notebook Entry Template or Workflow Template, appropriate data tables may already be present.

Search or choose an Assay Result 

Adding samples to data tables (one by one)

Choose “Add New Row” and search for and select an entity or batch in the window. Data Tables are designated to capture data against either entities or batches.

Importing samples and results into the data table

Create a spreadsheet whose columns match the data table headers (including a sample column). You can do this either in an external spreadsheet editor (e.g. Excel) or utilize a regular Benchling table.

Choose “Import into data table”

Copy/paste in raw text including the headers or upload a spreadsheet

Click 'Next' and confirm column matching. Please correct any errors. After data is validates (after clicking 'Next'), you can select 'Import' in order to add new rows to your data tables, along with any relevant assay data.

Note: this lets Benchling know which data should be recorded against which sample. The most common values used for matching are sample name/ID or plate well

Updating results in the data table

Create a spreadsheet whose columns match the data table headers (including a sample column)

Choose “Update from spreadsheet”

In the import into data table window, copy/paste in your raw text or upload your spreadsheet. Then, click Next and choose the appropriate fields to match with your columns. Afterwards, click Import to update values in the data table

Note: this lets Benchling know which data should be recorded against which sample. The most common values used for matching are sample name/ID or plate well

Adding custom columns

To add a one-off field, right-click on any column header. Choose “Add Column” to the left or right.

After, Right-click on the new column and choose “Rename"

Note: The custom column is marked by a STAR (*) to indicate that it is not included in the formal data table schema. To add the column to your table, please contact your Registry administrator .

Viewing results

Results from data tables will appear on the results tab in the Registry (except for custom columns)

 

Did this answer your question?