We are displaying numerical values for temperature as a string so that it carries the correct units of measure (e.g. 75 °F). We need to have a View that allows for these values to be sorted in a meaningful way to the user. We're using a Trigger to populate the field so that the column is sortable, but since the value is a string the data does not sort correctly (e.g. 100 °F will be displayed before 75 °F when in descending order). Is there a way to change the logic of the column sort its displays correctly? Thanks!!
Perhaps the best way to solve that: add Input template to integer field similar to Input template available for Text fields.
I can't change sorting algorithm, but can change HTML presentation.