If you right click on a Result Table, you may notice that you can insert columns in the result table and, when you do, your newly inserted column will have a "*" in the column name. These are custom columns.
Custom Columns allow you to insert formulas, text, lookups, and lookupfields to enhance usability of your result table for your experiment.
You can type formulas in a cell in custom columns just like you would a cell in a regular table or in Excel. Below, we show an example of using 2 columns in our result table to show Cell Density
When would I use a custom column?
Some common use cases for custom columns are:
- Using a formula to convert units from a standard in your result table to another
- Calculating a concentration or density (given other parameters in your result table - such as volume or mass)
- Calculating Molarity (using a lookupfield to retrieve the Molecular Weight of your sample)
Are there any limitations?
Note: Custom Columns are designed for your reference only and data that is stored in them is not stored in the Data Warehouse, the Results Tab of your registered entities, or anywhere outside of your entry.