This idea has been merged into another idea. To comment or vote on this idea, please visit WEBFLOW-I-3329 Sort a collection list by Reference field. .
Is there a way to sort a collection by a Reference Link. I have created a collection called "Departments". In the departments, I have listed out each team (ex. Engineering, Marketing, Sales, etc...). Then I have created a Reference Link to that collection in the TEAM collection where the person's name, title, and department lives.
Each Department is numbered (01-Engineering, 02-Marketing, 03-Sales, etc...) so when I sort by that Reference Link it will sort them from A-Z or lowest to highest. The last thing I'm adding a number field in the TEAM collection so I can number the team members in a department from 1-10 so I can sort by department then sort by the number based on where they are in their department, (ex. team lead, team member, entry level, etc..). Any thoughts?
EXAMPLE OF MY END GOAL:
----------------------------------------------------
01-EXECUTIVE TEAM
1-Joe (CEO)
2-Kevin (CTO)
3-Mary (VP)
4-Corey (Director)
5-Andrea
02-ENGINEERING
1-Tim (Lead)
2-Dave
3-Rachael
4-Calvin (Jr Engineer)
03-MARKETING
1-Rory (Sr. Manager)
2-Andrew (Lead)
3-Heather
and so on... So I'm sorting twice, first by department, then by order in that department through the entire team. Appreciate any feedback.