TaskRay Tips & Tricks: How to add master project name to sub project tasks

"What's in a name? that which we call a rose
By any other name would smell as sweet."
- William Shakespeare (Romeo & Juliet)


Does a rose by any other name smell as sweet?
Does thy TaskRay tasks project name helpest thy complete?

TaskRay allows you to structure your projects in a number of different ways. For example, it is possible to create a parent project along with a number of sub-projects.

                                                                           A Project with three sub projects

                                                                           A Project with three sub projects

And with Task Labels, it is possible to display any task field  on the task card.

A Task Card with the Project Name displayed as a Label.

A Task Card with the Project Name displayed as a Label.

Labels are great for quickly visualizing data, however if you used Project Name as a label for your sub-projects, it would display the Sub-Project Name instead of the Parent project which is likely the value you would prefer to display.

A Task Card with the Project Name displayed as a Label. This is the name of the sub-project when we really want the Parent Project Name.

A Task Card with the Project Name displayed as a Label. This is the name of the sub-project when we really want the Parent Project Name.

As you could imagine, this could quickly become confusing to users as to which task belongs to which parent project when viewing multiple tasks and projects at one-time. And what if you had more than just one layer of project and sub-project. In TaskRay you can have up to 5 levels of hierarchy. You likely would want the top-level (or master) project to display on the task card of each sub-project layer.

So how can we easily identify which tasks are related to which top-level/master project?  

Below is a solution that should allow you to easily display the master project name as a Task Card Label on the front of any task that is part of a sub-project, even if your hierarchy is more than two layers deep.

To achieve this we'll create a formula field on the TaskRay Task object:

  1. In Setup, navigate to Create | Objects | TaskRay Task and click New next to the Custom Fields section.
  2. Choose Formula for data type and output will be Text. You can name this field "Master Project".
  3. Add in the formula. Feel free to copy and paste the below.

IF( ISNULL(TASKRAY__Project__r.TASKRAY__Project_Parent__r.TASKRAY__Project_Parent__r.TASKRAY__Project_Parent__r.Name), TASKRAY__Project__r.TASKRAY__Project_Parent__r.TASKRAY__Project_Parent__r.Name ,

IF( TASKRAY__Project__r.TASKRAY__Project_Parent__r.TASKRAY__Project_Parent__r.TASKRAY__Project_Parent__r.Name <> NULL, TASKRAY__Project__r.TASKRAY__Project_Parent__r.TASKRAY__Project_Parent__r.TASKRAY__Project_Parent__r.Name ,

IF( ISNULL(TASKRAY__Project__r.TASKRAY__Project_Parent__r.TASKRAY__Project_Parent__r.Name), TASKRAY__Project__r.TASKRAY__Project_Parent__r.Name,

IF( TASKRAY__Project__r.TASKRAY__Project_Parent__r.TASKRAY__Project_Parent__r.Name <> NULL, TASKRAY__Project__r.TASKRAY__Project_Parent__r.TASKRAY__Project_Parent__r.Name ,

IF( ISNULL(TASKRAY__Project__r.TASKRAY__Project_Parent__r.Name), TASKRAY__Project__r.Name,

IF( TASKRAY__Project__r.TASKRAY__Project_Parent__r.Name <> NULL, TASKRAY__Project__r.TASKRAY__Project_Parent__r.Name , TASKRAY__Project__r.Name ))))))

This formula is long since it goes a number of layers deep. This means that you can have many sub, sub, sub-projects and the tasks will still reference the name of its master project. In general this formula is saying if the great grandfather project name doesn't exist then populate the value to be the grandfather project, then if the grandfather project doesn't exist populate with the father's name and so on.

If you need to go even deeper you can create additional IF statement rows to this formula.

Once we've created and saved this field we'll need to add it to our Task Card Label field set.

To do this:

  1. In Setup, navigate to Create | Objects | TaskRay Task and scroll to the Field Set section.
  2. Click Edit next to the Task Card Label field set.
  3. Drag & drop the Master Project field from the top grid into the field set below.
  4. Be sure to hit Save at the top.

Now when we go back into TaskRay if we have any tasks that are in sub projects or sub, sub projects then the label on the front should be the name of it's master project.

                                                                            Multi-level project hierarchy

                                                                            Multi-level project hierarchy

          Tasks from different sub-projects all showing the same Master Project name in the Task Card Label

          Tasks from different sub-projects all showing the same Master Project name in the Task Card Label


This may also help in any reporting that you may have where you need to easily identify which tasks relate to which master project.

So, with thy master project name, TaskRay Tasks I doth see!


TaskRay Demo Webinar Recording

Looking to learn more about TaskRay? Here's a full demo recorded from our last webinar series. This demo walks through the entire TaskRay product and also includes some great Q&A with attendees.

TaskRay Best Practices: Chatter Collaboration and Email Notifications

Effective communication and collaboration is the key to success in any organization.

This becomes crucial when managing tasks and projects.

That is one of the main reasons we integrated Chatter functionality to TaskRay, allowing users to to quickly communicate with each other as well as attach related files and links to TaskRay Tasks and Projects.

By having all of your conversations and files logged in TaskRay users can easily find and refer to them in the future. So, if a colleague is out sick and you need to pick up the pieces or you need to look at a similar project you did in the past you can quickly find all the related Chatter conversations, files and links. There’s no need to go digging through your email or have IT recover old messages or files from the system of previous employees. It’s all right here at your fingertips within Salesforce.

Here’s an overview of Chatter from the TaskRay User Guide: http://bracketlabs.com/taskray-guide#collaboration-chatter

So, now that we are all using Chatter within TaskRay to collaborate on Tasks and Projects what are our notification options? How does Eric know when I have made a comment regarding one of his tasks? How do I as a Project Manager get notified when someone moves a key task to “Finished”?

As with most things in TaskRay (and Salesforce) we have a number of options which means it can be tailored to your specific needs.


When writing a Chatter comment you can choose to also enter a user or Chatter group name by using the @Mention functionality (e.g. @DarrenGeary, @Bracket Labs, @Marketing). By doing so, this will result in an instant email notification going to that person/group members with a link to the conversation to which they can then respond.

So, if I’m working on a task and need Eric’s input to help complete it I could simply go to the Chatter tab of that task and say, “@Eric Wu where is the latest file for this?” Eric will then get an instant email notification from Salesforce with a link to the conversation. He can follow that link and respond accordingly, “Here it is!” and then either directly attach or add a link to the location of the document.

Here’s an overview of @mentions from the Salesforce help documentation: https://help.salesforce.com/apex/HTViewHelpDoc?id=collab_add_mentioning_people.htm&language=en_US

If someone is @mentioned in a Chatter conversation they will get an email notification. If someone is not @mentioned then they will not get an email notification.

However, if you make a comment and then someone else comments after you (without an @mention), you will still get an email notification and will continue to get notifications on further comments added to that conversation.

This relates to the "Comments After Me" Chatter setting in Salesforce which is typically turned on and can be found here: Click on your name at the top right of Salesforce then My Settings| Chatter| Email Notifications and you’ll see the below options:


These are personal settings and can be configured by individual users but in general its best to keep all of them checked to ensure you do not miss anything.

An overview of these settings can be found here: https://help.salesforce.com/HTViewHelpDoc?id=collab_email_notify.htm&language=en_US

Here’s an example that shows which Chatter comments will produce an automated email notification when all those settings above are checked:

For example:

User A: "@Darren Geary - what do you think of this task?" (I will get an email notification with an @mention)

Then in the same conversation: User B: "Let me know if you need help on this" (I will not get a notification, however it will show in my Chatter feed if I am following that Task)

If in Chatter I "like" or "Bookmark" User A's initial comment above then I would get an email notification of UserB's comment on the same conversation.

This occurs when the "Comments on an item I bookmarked" and “Comments on an item I like" options are set to on which they are in the above screenshot.

If in the same conversation: Darren Geary says: "I think we can complete this task today" (I will not get an email notification to my own comment)

Then: User A: "I have an offsite meeting today" (I will get an email notification because User A commented after me)

And: User B: "I can get this done by 2pm" (I will continue to get email notifications on comments after my comment).

So, be sure to use @mention’s effectively and configure your personal Chatter Settings accordingly.

Following tasks/projects

Within TaskRay it is possible to follow tasks and projects just as you follow users within Chatter: http://bracketlabs.com/taskray-guide#collaboration-follow

When you follow a task/project any updates made to it will show up in your Chatter feed.

Chatter feed tracking

However, even if you are following a task and a change is made to it, (e.g. Eric moves it to “Finished” status) that specific change may not necessarily show in your Chatter feed. Why not? Because your Chatter Feed tracking settings are only tracking changes to certain task fields.

Here’s how to modify the Chatter Feed Tracking for  TaskRay fields:


So, now you can easily follow and track the Deadline field or the List (status) field or any other field which is important to you and any changes made to those fields will be tracked for users to see in Chatter.

Salesforce Daily Chatter email

As you know, Salesforce sends a daily digest email that summarises recent Chatter Activity related to you and the items which you follow. This email includes the 50 latest posts from the previous day along with the last three comments on each post. It is recommended to have these emails set to active and the frequency as Daily. However individuals can change this to Weekly and Never by clicking on their name at the top right of Salesforce and going to My Settings | Chatter | Email Notifications

You can also set the digest frequency for Groups that you are a part of.

Chatter is great for communication and collaboration with your team to accomplish tasks and projects however, it does not tell you what tasks you have upcoming or send notifications when a task is overdue. This is where the TaskRay Daily Planner Email and Workflow Rules can help.

TaskRay Daily Planner Email

TaskRay offers a Daily Planner Email that includes a list of all your overdue tasks, tasks due today and tasks due this week. Individual users can turn this email on/off via the Tools and Settings section in TaskRay: http://bracketlabs.com/taskray-guide#basics-preferences

New Task Owner Email Notification

When a task owner is changed from one person to another a notification email is sent to that new owner with a link to access the task.

Individual users can toggle this notification on/off via the "Don’t send email notifications when I change task owner" box in the TaskRay Tools and  Preferences section: http://bracketlabs.com/taskray-guide#basics-preferences

Email Alert Workflow Rules

There may be situations where you would like to get a notification email when a task meets a certain criteria. For example, you may want project stakeholders to be notified whenever a certain task is finished or when a task has been overdue for a day.

To do that go to Setup | Create | Workflow & Approvals | Workflow Rules and click the “New Rule” button.

Then select the TaskRay Task object which the rule will apply to, enter the rule name and set your criteria for when the rule will fire. (E.g. When the list/status field does not equal finished and when the deadline date field is greater than today).

Next, set the workflow action to be a new email alert.

Now, before you create the workflow action you’ll need ensure that you have an email template built that will be used for this alert.  

To do that go to Setup | Administer | Communication Templates | Email Templates and click “New Template”.

With your email template you can enter merge fields that will auto-populate for example the subject line could read as:

Task {!TASKRAY__Project_Task__c.Name} for {!TASKRAY__Project_Task__c.TASKRAY__Project__c} Finished

Then the body of the email could look something like this:

Task {!TASKRAY__Project_Task__c.Name} relating to {!TASKRAY__Project_Task__c.TASKRAY__Project__c} has been finished on {!TASKRAY__Project_Task__c.LastModifiedDate} by {!TASKRAY__Project_Task__c.LastModifiedBy}

The above example, is an email alert that tells us that a specific task has been finished along with the date it was finished and by whom.

Here’s further information on how to create workflow rules: https://help.salesforce.com/apex/HTViewHelpDoc?id=creating_workflow_rules.htm&language=en_US

And here’s further info on how to create email templates within Salesforce: https://help.salesforce.com/HTViewHelpDoc?id=admin_emailtemplates.htm&language=en_US

An alternative to Workflow Rules could be to take advantage of the new Salesforce Process Builder functionality: https://help.salesforce.com/HTViewHelpDoc?id=process_overview.htm&language=en_US You could use this to build a process that sends an email to specific users when a task is marked as “Finished”or to create a new Project when an Opportunity status changes to “Closed Won”.

So, think about the situations and types of notifications that you or your users would like to receive related your tasks and projects and feel free to create and experiment with your own workflow rule email alerts.

All of these collaboration tools and notifications within TaskRay can be utilized to help ensure your team is successful in driving tasks and projects forward to completion on time, every time.

Have a question about any of these notification options and configurations? We're always ready to help, feel free to post your question in the comments or contact us at support (at) bracketlabs.com

A New Year & a New Look for Campaign Calendar!

Happy New Year!

For our first blog post in the New Year we are excited to announced a new release of Campaign Calendar just in time for 2015 Marketing Plans. Here is a quick look at some of our new features:

New Toolbar

Campaign Calendar got a subtle makeover, including a redesigned toolbar. This streamlined look lets us increase the screen real estate dedicated to what matters most - the calendar. We also added a new count indicator which counts the campaigns displayed in the selected view.

Inline Editing

One of our most exciting productivity enhancements is inline editing inside of the Campaign Detail window. You can now quickly edit your Campaign fields and avoid the extra click of the Edit button.

Personal Color Settings

Users can now choose between the default Company Color Settings (managed by administrators) or a Personal Color Setting.



There is now a configurable hover on each Campaign to display campaign details without opening the Campaign Detail window. Another productivity win! 

Here are some highlights of additional enhancements we are delivering in this release. For a full list of features and bug fixes, check out our release notes page.

Upcoming Webinars

New to Campaign Calendar?

Join us for an introduction to Salesforce Campaigns + a demo overview of Campaign Calendar including the new features from our recent release!

Learn how Campaign Calendar's interactive features can help your users quickly plan, schedule, and share a visual marketing calendar.

Date: Thursday, January 29th  Time: 9 am PT / 12 pm ET / 5 pm GMT   REGISTER HERE

Ready to Get Started?

If you're already a Campaign Calendar customer you will be receiving an upgrade link via email.

If you're not a Campaign Calendar customer yet, we offer a free trial so you can see for yourself how Campaign Calendar will help make marketing easier. Install the free trial directly from the AppExchange, just click the green Get It Now button.

Still have questions? You can always mention us on twitter, post on our facebook wall, or send us an email at team@bracketlabs.com.

Happy Holidays!

The holidays are often a time of reflection and thankfulness. As I look back on 2014 at Bracket Labs, I continue to be tremendously thankful for our amazing customers, our growth, and most of all our team - our very awesome team. 

And especially for the hire of this guy:

Happy Holidays from all of us here at Bracket Labs, but especially from Darren Geary, full of cheer and the guy that makes us all laugh every day!