Use tables in notebook entries or protocols with Excel-like functionality. To start, create a new entry or protocol by opening a project, going to the Notebook section, and then clicking the + on the top right corner of the panel, and then Entry or Protocol.
To insert a new table, click Insert and then choose Table from the drop down.
- Formulas: Click on a cell, and type “=” to begin a formula. Reference other cells by clicking on other cells. Tip: You can create formulas that reference other tables
- Functions: Click on the fx symbol, and choose from the dropdown of functions.
- Merge cells: Select adjacent cells and click the Merge symbol to merge cells. Click again to unmerge the cells.
- Scientific notation:For example, 1e3 will be interpreted as 1000 by the table. Change the precision by clicking the Settings gear and then Precision.
- Delete/insert rows and columns: Right-click on a row or column, and choose the appropriate action.
- Rename tables: Right-click the table name, and then Rename Table.
- Expanded View: on the top left corner of the table, click on the expand button.
- Selectors: Set up data validation for specific cells to standardize data capture.
With one or more cells selected, click the gear icon and choose Selector
Click Create a new selector first
Specify the Selector Name and the options for the selector, one per line. Click Save to create your new Selector
Click Back to return to the Set Selector screen. Your new selector will show up in the dropdown by default. If you create more than one selector, you can choose which one should apply to the cell(s) you picked earlier via the dropdown.
Click Set to apply the selector to the cell(s) you picked
Now, Benchling will provide a dropdown menu of choices for that cell, and will indicate if the data entered in the cell is invalid via a red corner