Related list not sorting correctly - Answers - Salesforce Trailblazer Community
Trailblazer Community
Ask Search:
Tom LepkeTom Lepke 

Related list not sorting correctly

Hi All, 

I currently have a related list called Filing. 

When I click to view all and sort by the Application ID field the numbers aren't sequential. Does anyone know why? 

User-added image

Thanks!

 
Best Answer chosen by Tom Lepke
ASIF ALIASIF ALI
Hi Tom, 

If you're not referencing these ids anywhere, just go to Application ID field and Add one more 0 in MutualFund2020FL-{00000} 
Youll not face sorting issues,

Regards,
Asif

All Answers

ASIF ALIASIF ALI
Hi Tom, 

If you're not referencing these ids anywhere, just go to Application ID field and Add one more 0 in MutualFund2020FL-{00000} 
Youll not face sorting issues,

Regards,
Asif
This was selected as the best answer
Tom LepkeTom Lepke
Hi ASIF ALI, 

Thanks for the help! I would do that but the data type is a text field and not an auto-number. Any other ideas? 

Thanks!

User-added image
Ronald PoulsonRonald Poulson
Since it is text, what workflow, field update, process, or flow is updating the field?  That is where you need to change the functionality.

Regards,

Ron
Tom LepkeTom Lepke
Great thanks all!