Order By: department and then dragsort?
2 posts by 2 authors in: Forums > CMS Builder
Last Post: May 13, 2010 (RSS)
By zip222 - May 13, 2010
I have a list of staff members. the first criteria for ordering the list is by Department. But then within each Department the ordering needs to be manual. Is there a way to do this?
Re: [zip222] Order By: department and then dragsort?
By Chris - May 13, 2010
Hi zip222,
Dragsorting is an all-or-nothing feature. There are three ways I can think of to do this:
1. Use dragsorting only, and use the [url http://www.interactivetools.com/add-ons/detail.php?Create-Record-Here-1015]Create Record Here[/url] plugin to make it easy for users to create new staff members in the right department.
2. Don't use dragsorting at all; instead, create a new field called "manual_order" and enter numbers for each staff member, then you can have the database automatically sort on "department, manual_order".
3. Use separate sections for each department, each of which can have its own dragsorting.
I hope this helps. Please let me know if you have any questions, or what you end up deciding upon.
Dragsorting is an all-or-nothing feature. There are three ways I can think of to do this:
1. Use dragsorting only, and use the [url http://www.interactivetools.com/add-ons/detail.php?Create-Record-Here-1015]Create Record Here[/url] plugin to make it easy for users to create new staff members in the right department.
2. Don't use dragsorting at all; instead, create a new field called "manual_order" and enter numbers for each staff member, then you can have the database automatically sort on "department, manual_order".
3. Use separate sections for each department, each of which can have its own dragsorting.
I hope this helps. Please let me know if you have any questions, or what you end up deciding upon.
All the best,
Chris
Chris