June 14, 201114 yr I have a value list of competitions, hiding the ID. RegionA 2010 RegionA 2011 RegionB 2010 RegionB 2011 and so on, for many years. I've created a value list for a popup menu that lists the competitions alphabetically. Is there a way to list the competitions by year descending (year is a separate field from name) without changing waht is displayed in the value listing? I'd like the value list to appear as: RegionA 2011 RegionB 2011 RegionA 2010 RegionB 2010 tia, Barbara
June 14, 201114 yr There is no easy way to change the sort order of a value list. Perhaps you can add a global field to select the year first then setup a conditional value list based on the year selected. Just a thought :)
June 14, 201114 yr Author I didn't think so, but gave it a shot that someone might point out a checkbox I missed or a technique I'm not familiar with. Breaking it down to select Year, select competition might just be the way to go, but right now I'm trying to stay with the one popup.
June 15, 201114 yr I didn't think so, but gave it a shot that someone might point out a checkbox I missed or a technique I'm not familiar with. Breaking it down to select Year, select competition might just be the way to go, but right now I'm trying to stay with the one popup. I'm probably missing something but the valuelist by field gives the option to sort by the second field.
June 15, 201114 yr A value list based on a field is always sorted alphabetically, ascending - using either one of the two fields. Since you are already using the second field, your options are limited. I think the best you can do here is: 2010 RegionA 2010 RegionB 2011 RegionA 2011 RegionB Of course, there are alternatives to using a value list - as you well know.
Create an account or sign in to comment