ProfilerX lets you automate profile switching with different methods. The most basic one is Time Schedule. Here are the available methods.
Time Schedule
Location Base using Cell Tower Info
BlueTooth Connection
WiFi Hotspot
Features
Automatically switch sound profiles
Turn off Bluetooth and/or WiFi with each scheduled profile
Can mix any profile methods eg: time schedule, location base
Turn off WiFi when the BB is connected to the handsfree when you are driving
Switch profile when you arrive work or home
and more
Limitations
Profile switch is delayed when the BB is in the Holster. Once you unholster the profile will switch automatically
Profile switch is delayed when the keyboard is locked or password locked on OS5.0 only
Profile switch is delayed when the password locked on OS6.0 only. Keyboard lock will not work due to different BBOS versions
All of above cases you will receive a vibrate. Once you unholster or unlock the BB the profile will be switched
Work Around
The workaround for the keyboard and password lock is to use a 3rd party screen or password lock. If you have a touch screen eg: Storm or Torch you can get PatternLock Lite free version which works very well with ProfilerX.
It's unfortunate that developers aren't able to make the phone switch profiles while it's in standby/holstered. This is the only reason that I choose not to use these kinds of apps. I don't want to take my device out of the holster just so it can switch the profile. It only takes 2 seconds more for me to hit space for quicklaunch then the 3 letters associated with the sound profile I want.