Hi Guys,
We recently imported a auto number generator solution in our environment to generate Autonumber in a Text field. Records created after implementing auto nmber solution (numbers from 30000) are not sorting properly in OOTB crm View. Please find the below screenshot. Records in 5000 series are numbered manually. Any faced this issue before?
Thanks in advance !!
*This post is locked for comments
Adding 0's in front of the 5000 series, fixed the issue. Thanks for the information
String length is the key here. You can check a bit more and you will see that numbers that are same length are those subgroups.
Yeah, that is one solution, but we are using that fields in so many places and creating a new field will take time. It was sorting fine before we implemeted the Autonumber generation solution. Now it is sorting fine in the sub groups(numbers manually entered, numbers generated through Auto number genration). I dont know why that difference is. Any idea?
That is happening because you are using text field as the record number. You need to use whole number field if you want to sort records like that (numbers from 0 to 9999) or you can use fixed length string as number (numbers as strings from 0000 to 9999)
Sorry for the wrong screenshot, check the below one, I sorted as Ascending, It is applying the sort wierdly.
I can see that "Bid Number" column is sorted in descending order and I don't see any wrong sorting order here. Can you explain what is not ok on this screenshot?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (