Enumerated Custom field translation

Mark_Byrne

Hi All, is it possible to have an Enumerated custom field that populates a number of other associated fields?
Ex: Selecting an enumerated stent size value also translates an associated length value, dilution value, etc.

Empower2019

Yes. The way to do this is to first set up a sample, enum custom field, use as position, with a list of entries for Stent Size for example, 10mm, 20mm, 30mm....etc, whatever values you use. 

Then create another sample enum custom field- and select Calculated, Use as Position. Then for the formula:
ENUM(EQ(Stent_Size,0),EQ(Stent_Size,1),EQ(Stent_Size,2)). For the translation then put in your values for length value, such as 1 metre, 10 metres, 20 metres etc. and call this custom field Length_Value. Each entry of Stent_Size has a value in the drop down table, hence use as position. Position 0 corresponds to 10 mm, position 1 corresponds to 20mm etc. So for Length_Value position 0 in translation table, pick whatever length corresponds to position a Stent_Size entry of 10 mm and so on. Do the same with dilution, and select your appropriate values in the translation table that again correspond to the Stent_Size entries. Then when you populate Stent_Value in your sample set, the corresponding values in Length_Value and Dilution_Value will autopopulate. You can have up to 999 entries in Stent_Size. 

We do this all the time in our lab by first creating a sample enum list of columns and then linked sample, enum, calculated CFS with dimension, particle sizes etc associated with each column. 

Mark_Byrne

Ah  thank you very much, that is a great help!