To insert a new table into a Notebook entry, click Insert and then choose Table from the drop down.
Use common table features
- 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.
See a table in expanded view
On the top left corner of the table, click on the expand button.
With Selectors, set up data validation for specific cells to standardize data capture.
Select one or more cells. 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