Problem Statement:
In a subgrid list of possible values are being displayed, One of the column in grid only contains integer value but the type of the field is set as single line of text. Due to this, sorting of the grid is not working as per the requirements because it is string and not integer.
Possible Solution:
- Create a new field.
- Migrate the data to new field from old .
- Delete the old field
- Create another field with whole number.
- Migrate data back to new field from previous created field
Wanted Solution:
Though, the solution above can work fine but it is very troublesome and could impact many things. Hence looking forward to a solution that could work dynamically or programmatically.
For example:
Using JavaScript if I can change the type dynamically and sort the values from greater to lesser value in the grid.
Looking for possible solutions and help