I have a field (OrgId) which is currently a string, 10 char long under Accounts entity. The data is going to be an integer always. I did't have this as a number because it adds comma. I have other fields which are integer and needs comma. So in order to eliminate having commas, I made the OrgID field as string. Now when I am in the Accounts view and I am sorting by OrgID, it is not being sorted as integer and it is sorting as a string. Example. 102, 10001, 10057, 10069, 201, 2067, 21357, ...etc. I want the OrgID to be sorted like an integer, 102, 201, 10001, 10057, 10069, 21357....etc.
My issue is how can I convert this string field (OrgId) to act like an integer without having comma and also without affecting other integers formatting which needs comma. In the Accounts View, I should be able to sort the OrgID in ascending/descending order as integer type and not show any commas.
I know that I can do formatting (Set Personal Options/ Format) to not have commas but it affects all integer types. So that is not an option for me. Any help to show and describe in steps would be very helpful. If it needs some javascripting, please let help me with the steps which would be greatly appreciated. Or any other workarounds.
Thanks,
Vinay
