Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 4791 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

(I hope this is the correct forum for this question since there isn't a Sorting section.)

I have three fields, each with its own sorting script: City, State and Country. Is there a standardized or "best practice" way of sorting these guys?

For example, if a user selects City, should the sort order be City / State / Country?

...if State, should the sort order be State / City / Country?

...if Country, should the sort order be Country / State / City?

...or, just don't have any subordinate sorts at all? If the user selects City that's the only field that gets sorted--State and Country go unsorted? To me, it'd be beneficial to have the other two fields sorted as well but it just may be me and not standard practice.

Decisions, decisions ... TIA for your input!

Rich

Posted

1. Each record has basic demographic information about a tourist site, address, phone, e-mail, etc.

2. If the user wants to plan a trip, he or she may want to group sites by city or state. So, if you're planning a trip to lush, exotic, tropical Idaho, you may want to sort by city to visit places in, say, Boise and Coeur d'Alene. (Country comes into play since it'll be a solution that'll include Canadian and American sites.)

Posted

If I am planning to visit Idaho, wouldn't I want to find records in Idaho, USA first? If I can't do that, I suppose I would want the 'by city' sort order to be City/Country/State - so that all Canadian cities named Boise are grouped above my line of sight. But I don't think there are any established rules here.

Posted

A good pearl of wisdom--think Find instead of Sort, first. Thanks!

This topic is 4791 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.