Results 1 to 7 of 7

Thread: Is it possible to sort by Time Zone?

  1. #1
    netprospector is offline Junior Member
    Join Date
    Oct 2009
    Posts
    2

    Default Is it possible to sort by Time Zone?

    Or will I have to sort by states?
    If I sort by multiple states (for each time zone) can that be saved as a customized search criteria and then used again in the future? Thanks in advance -

  2. #2
    sugarcane is offline Sugar Community Member
    Join Date
    Apr 2005
    Location
    Chicago, IL
    Posts
    1,207

    Default Re: Is it possible to sort by Time Zone?

    what module are you trying to create the search for? you can certainly create a saved search on any of the fields available in the search panel.
    Intelestream has a great deal of experience hosting and customizing the SugarCRM application. Our company is made up by former employees of SugarCRM, and together we have over 50 years of experience working with the application. To learn more about us, please visit our website at www.intelestream.net or contact us directly at 800-391-4055 or by email at info@intelestream.net

  3. #3
    netprospector is offline Junior Member
    Join Date
    Oct 2009
    Posts
    2

    Default Re: Is it possible to sort by Time Zone?

    I tried listing the states by postal abbreviation (which is how they are stored in my leads) to no avail. I tried searching with the PST states separated by spaces and alternatively separated by comma's. Neither way returned a result. Am I missing something?

  4. #4
    sugarcane is offline Sugar Community Member
    Join Date
    Apr 2005
    Location
    Chicago, IL
    Posts
    1,207

    Default Re: Is it possible to sort by Time Zone?

    I tried listing the states by postal abbreviation (which is how they are stored in my leads)
    Yes, you can currently sort results in the leads list view by billing state or alternate billing state. However, this will sort all the leads alphabetically by state, not anything to do with timezone.
    I tried searching with the PST states separated by spaces and alternatively separated by comma's.
    If you are trying to perform a search in the search panel and are trying to pull more than one state, then this will not work. Out of the box, you can only search for one item. You would need a reporting module to be able to search on more than one state in the same query, or customization to be able to search multiple within the search panel.

    It sounds like a good solution to your problem would be to create a custom dropdown field called 'Timezone'. Then you could place this in the leads module (and any other module you need it to be) and you would easily be able to perform a search on just this one field, as well as sort on this field.
    Intelestream has a great deal of experience hosting and customizing the SugarCRM application. Our company is made up by former employees of SugarCRM, and together we have over 50 years of experience working with the application. To learn more about us, please visit our website at www.intelestream.net or contact us directly at 800-391-4055 or by email at info@intelestream.net

  5. #5
    sugarcane is offline Sugar Community Member
    Join Date
    Apr 2005
    Location
    Chicago, IL
    Posts
    1,207

    Default Re: Is it possible to sort by Time Zone?

    You might also want to look at some of the plugins on the forge or exchange. [URL="http://www.sugarforge.org/projects/enhancedsearch/"]This [/URL ]might help you with what you are trying to do. I always recommend testing on a test instance first, and making a backup of your production environment before you implement.
    Intelestream has a great deal of experience hosting and customizing the SugarCRM application. Our company is made up by former employees of SugarCRM, and together we have over 50 years of experience working with the application. To learn more about us, please visit our website at www.intelestream.net or contact us directly at 800-391-4055 or by email at info@intelestream.net

  6. #6
    jesy is offline Junior Member
    Join Date
    Oct 2009
    Posts
    1

    Default Re: Is it possible to sort by Time Zone?

    It seems a great idea, I support it.

  7. #7
    tekdeus is offline Member
    Join Date
    May 2011
    Posts
    17

    Default Re: Is it possible to sort by Time Zone?

    Any solution for this? I would gladly pay for this ability.

    I've created a custom field for timezone, but it really should be possible to have a plug-in do this automatically.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Server Time Zone vs. User Time Zone
    By danies3 in forum Help
    Replies: 38
    Last Post: 2010-04-27, 08:55 PM
  2. Time Zone
    By jasonstarin in forum Help
    Replies: 2
    Last Post: 2009-11-13, 03:46 PM
  3. Time zone
    By malay in forum Help
    Replies: 2
    Last Post: 2008-08-12, 06:39 AM
  4. Time zone
    By mjcr777 in forum Help
    Replies: 4
    Last Post: 2008-07-10, 09:06 PM
  5. Time Zone
    By cgarcia in forum General Discussion
    Replies: 2
    Last Post: 2007-11-29, 08:47 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •