Result schemas can be configured to accept text in float fields. In the example below, the result schema is configured to accept the values "ULOQ" and "LLOQ" (Upper and Lower Limit of Quantification) in the concentration column. This is frequently useful for analytical assays.

Text values that do not fall in the pre-configured set of valid text will continue to be flagged as illegal with a red flag, preserving data integrity.

In order to configure a set of text values on a result schema, use the JSON configuration to link to a dropdown with the “legalTextDropdownId” field.

This allows precisely the text values in the referenced dropdown to be used, in addition to float values as usual.

Integration to Warehouse

When a Results schema has a LegalTextDropdownID designated for a floating point field, Benchling will automatically generate a second "text" column for that field in the warehouse. 

If a float field has a LegalTextDropdownID, then it gets 2 columns in the warehouse instead of one: 1 regular column that holds the numeric value (if any float data exists) and 1 column that's named {field_name}$text that holds the text value (if any text dropdown data exists). 

Did this answer your question?