Empower Tip: Custom Fields

In this tip, we will learn how to create a column library.

Some time ago, I was asked if there is a way to create a list of columns, that when you select the column part number in either the Sample Set Method or Alter Sample, other fields such as particle size, length and so forth would be automatically populated. It can be done with Custom Fields. This example includes particle size, column length and column internal diameter. You could add additional fields such as particle type, carbon load and so forth.

The first Custom Field would be for the catalogue of columns. This is a Field Type ‘Sample’, Data Type ‘Enumerated’. Enter the Column Part Numbers in the ‘Translation Definition’ table

The next Custom Field is for the corresponding particle sizes. Once again, this is a Field Type ‘Sample’, Data Type ‘Enumerated’. Enter the ‘Particle Size Values’ in the Translation Definition table.

The next Custom Field is for the corresponding column lengths. Once again this is a Field Type ‘Sample, Data Type ‘Enumerated’. Enter the ‘Column Length Values’ in the Translation Definition table.

The last Custom Field is for the corresponding internal diameter. Once again this is a Field Type ‘Sample’, Data Type, ‘Enumerated’. Enter the ‘Internal Diameter Values’ in the Translation Definition table.

View the new Custom Fields in the Sample Set.

Click in the ‘Column_PN’ field and select a column part number.

The remaining Custom Fields automatically populate with the corresponding values.

It’s that easy!