Marketing Stack

Now it’s time to create our Task report. When creating a new report, it is always best practice to create a name and write a description for the report. The name should be descriptive enough to alert the user what the report is and the description should explain what the report shows.

Report Name: My Tasks Due this Week

Report Description: The My Tasks Due this Week report displays tasks that I am assigned to and have a planned completion date in the current week.

 

Instructions:

  1. Navigate to the Reporting area, select “New Report”, and choose the Task report.
  2. Navigate to the “Report Settings” dropdown and add the Report Title and Description. Select Done, when complete.
  3. Add the following columns: Project Name, Task Name, Status, Assignments, Planned Start Date, Planned Completion Date, Planned Hours, Actual Hours.
  4. Select “Add Column” and drag the new column between Planned Completion Date and Planned Hours,
  5. Confirm the new Column is highlighted blue then select Switch to Text Mode (upper right corner).
  6. Set the displayname to “Days Remaining”.
  7. Create a new line and type: textmode=true
    • This action alerts Workfront that we are using custom text mode rather than using standard fields.
  8. Create a new line for the valueexpression, which will leverage three functions: ROUND, DATEDIFF, and DATE
    • Remember to reference the API Explorer for the camel case values for object fields.
    • Set the valueexpression to: valueexpression=ROUND(DATEDIFF({plannedCompletionDate},DATE($$TODAY)),2)
    • DATE($$TODAY): calculates the date within the parenthesis and we used the $$TODAY wildcard to calculate today’s date.
    • DATEDIFF: calculates the number of days between two dates and we used the Planned Completion Date (camel case form) and DATE($$TODAY) dates.
    • IMPORTANT: Don’t forget to enclose your Workfront field between curly brackets: {plannedCompletionDate}
    • ROUND: rounds the value to the number of decimal places identified, which is 2 in our example.
  9. Create a new line for the valueformat.
    • Set the valueformat to: valueformat=doubleAsDouble
    • The valueformat formats the value of the valueexpression in the report when displayed.
  10. Select “Save”.
  11. Select “Add Column” and confirm that the column displays after the Actual Hours column.
  12. Confirm the new Column is highlighted blue then select Switch to Text Mode (upper right corner).
  13. Set the displayname to “Hours Remaining”.
  14. Create a new line and type: textmode=true
  15. Create a new line for the valueexpression, which will leverage three functions: ROUND, DIV, and SUB.
    • Set the valueexpression to: valueexpression= valueexpression=ROUND(DIV(SUB({workRequired},{actualWorkRequired}),60))
    • SUB({workRequired},{actualWorkRequired): calculates the difference between two fields and we used workRequired (planned hours) and actualWorkRequired (actual hours).
    • DIV: divides two numbers and we used SUB({workRequired},{actualWorkRequired}) and 60; We need to divide by 60 because Workfront uses seconds rather than minutes within the SUB function.
    • ROUND: rounds the value to the number of decimal places identified, which is 2 in our example.
  16. Create a new line for the valueformat.
    • Set the valueformat to: valueformat=doubleAsDouble
  17. Select “Save”.

 

After you have added both custom columns, select “Save + Close”. The report should look similar to the following:

 

In Part III, I will share the text mode code for a Task report and an Assignment report and introduce the series of blogs in the Create Reports Like a Pro series.

Now that you have a Workfront Requests queue to track errors, it is time to show our admins how to troubleshoot Workfront using a real-life example (with historical Revolutionary War heroes as our users). 

Remember, in the first article titled, “Think Like a Workfront Admin: What is Troubleshooting?” we discussed four fundamental questions to ask after reviewing the technical support ticket: 

In addition, we identified the process for troubleshooting errors in Workfront: 

Let’s attempt to solve George Washington’s error in Workfront. 

George Washington submitted a request to the Workfront Requests queue as a Technical Support request. After reviewing the form, we have identified the error involves a report on a layout template: 

Based on the custom form, we can identify three out of four fundamental questions when reviewing Workfront errors: 

        1. George Washington is attempting to view a list of active projects he owns on the “My Active Projects” report in Workfront.
        2. George Washington has the Planner Access Level.
        3. George Washington’s Layout Template is Creative Director (based on the ID in the Custom Form).

 

The last question we need to answer is, “Does the user have the correct sharing permissions on the corresponding object?” In this case, we need to review the sharing rights on the “My Active Projects” report. 

Upon further investigation, we have identified that George Washington does have the correct sharing permissions for the “My Active Projects” report. The report is visible system-wide, without restrictions: 

 

Now it’s time to follow the troubleshooting process! 

      1. Answer the four fundamental questions for troubleshooting errors in Workfront.
      2. Log in as George Washington in Workfront. 
      3. Replicate the error by navigating to the Projects area and viewing the “My Active Projects” report. Picture 1 shows the results that George sees when reviewing the report and picture 2 shows the results George should see but does not:

 

 4. In order to properly resolve the error, we need to further investigate the key features of the report. 

          • First, review the report’s filters and determine that the filters are set up correctly (we use wildcards to make the report dynamic).

          • Next, review the report’s settings and notice that we accidentally set the “Run this report with the Access Rights of Andy Koprowski.” When selecting a user in the “Run this report with the Access Rights of” field, it will overwrite the existing filters of the report. So, instead of viewing active projects with an owner ID equal to $$USER.ID, the report will instead show all active reports owned by Andy Koprowski. 

          • To resolve the error, remove Andy Koprowski from the field, “Run this report with the Access Rights of” and save changes to the report.
          • Next, log back in as George Washington and confirm that the update to the report resolves the error: George can now view all of his active projects.

          • Remember to respond to the error ticket, informing the user that the error has been resolved and move the status of the ticket to Closed. 

 

In our next blog in the “Think Like a Workfront Admin” series, we will discuss how to create advanced reports using advanced views.

In the previous article, we discussed what is troubleshooting and what to expect as a Workfront System Administrator. Now, it is time to shift our focus to Workfront queues.

What is a Workfront Queue?

A Workfront queue refers to a special type of project that stores requests, issues, change orders, and bug reports submitted by Workfront users. Organizations traditionally use queues to capture requests and develop a working backlog of active issues that Workfront System Administrators will resolve. Every organization that leverages Workfront should have a version of a Workfront Request queue.

A successful Workfront Requests queue has the following features:

  • Project name: is informative and clearly articulates the queue’s purpose
  • Project status: equates with a status of Current (this activates the queue)
  • Queue topics: are easy to understand
  • Custom forms: have the appropriate fields to adequately capture the error
  • Other features:
      • The project is published as a Help Request Queue
      • The project enables “Anyone” to add requests to the queue

 

We have successfully outlined the characteristics of a functioning Workfront Requests queue and you are probably thinking, what does an example queue look like? Fortunately, you are in luck. Below is an example queue structure that many successful Workfront organizations use to capture Workfront issues submitted by their workforce.

  • Project name: Workfront Requests
  • Project status: Queue (equates with Current)
  • Queue topic structure:
      • Technical Support
      • Enhancement Idea
  • Custom forms: contain fields to identify the object/area of Workfront experiencing the error, space to describe the error in detail, and a final message to nudge the user to submit any photo/video proof of the error

There are many benefits to having a Workfront Requests queue, but the benefits are not just for Workfront System Administrators. Providing a Workfront Requests queue empowers your users to take control of errors and improves error resolution communication. In addition, logging errors helps Workfront System Administrators conduct intelligent and meaningful conversations with their Workfront Account Executives, Customer Success Managers, and Support Engineers. The more detail captured per error, the better equipped you and Workfront Support will be to quickly resolve the error.

Lastly, creating a Workfront Requests queue that captures technical support requests (errors) and enhancement ideas (product enhancements), supports your organization’s Workfront governance model. Users will build a product backlog of enhancement ideas, which can be routed to your Workfront Governance team. Rather than assuming the enhancement idea is valid and should be resolved, the Workfront Governance team can discuss the idea, determine the ROI of the idea, the overall impact to your user group, and ultimately decide if the enhancement is worth pursuing.

We will be returning to the idea of a Workfront Governance team and structure in a later series.

Understanding the type of DAM that is right for your team can be a challenge. Over the past few years, I have taken on a new role as a consultant. With my creative, marketing/communications, and project management experience, I have a fresh perspective when aiding clients in finding the right tools for their marketing and creative stacks.

Each client I have worked with endures similar challenges when evaluating their tools in their stack. Enterprises face difficulties with having too many tools and creating tools that are too proprietary – limiting growth and integration. They also struggle with user adoption. Picking a new tool for your marketing solution stack is not an easy feat. It is easy to get caught up in the details such as features of the tool while trying to balance buy-in from stakeholders (IT, security, VPs, and end-users), and balancing a budget. So how do you know where to start when you are evaluating Digital Asset Management tools?

 

THE 4 P’S

I have found that the 4 P’s are crucial to not only selecting a tool, but configuring it properly, and ensuring user adoption for long term success.

Understand the PROBLEM you are trying to solve, the PRODUCT you are selecting to solve that problem, the PROCESS for which the organization works, and the PEOPLE that are using the new tool.

Problem

Tools should never be sold – they should always solve. From my experiences in both marketing and creative industries, I have understood the struggles first-hand that users encounter when trying to complete work. The first step to tool selection is establishing the problem you are trying to solve. Are you bogged down by spending time constantly trying to distribute files? Are you struggling to keep the most current files at your fingertips? Do you have too many places where files are stored? By clearly establishing the problem, it will remain a strong focus on selecting a tool that will be adopted long-term.

Product

Selecting a product is not easy. There is a lot to take into consideration when choosing the right product for your team. Keep in mind the identified problems to resolve, without setting technical limitations. While the DAM you select should have all the right features and functions, also consider what other tools you already have in your stack. What integrations are available for the DAM you are selecting? What other groups or teams may want to leverage the DAM in the future?

Considerations of cost are equally as important. Time is money, and the DAM you select should help reduce the overhead hours your team is spending searching, delivering, and modifying assets. Will other teams benefit from the addition of a DAM? Teams should be selecting a tool that can grow with the organization, and that can meet their needs. The bottom line is that the DAM you choose should work for you and your team, not the other way around.

Process

Often the problem comes, not only with a need for a tool but the need for understanding of where in the process each tool should sit. After recently attending a DAM conference with a room full of tools, I could see how attendees were overwhelmed. The challenge with “pitching a solution” is that you need to understand the organization and process first. Organizational assessments are vital in selecting the right DAM. It is essential to first understanding workflows and internal organizational structure to provide an educated recommendation that will meet your organization’s needs. Consider scalability. Selecting a solution that works not only for today but also for growth tomorrow. Naturally, organizations shift and change over time, so the tool implementation must be completed with a full understanding of the potential growth of organization and integration.

People

Understanding the organization from high-level executives, IT, and end-users is key to a successful roll-out. Top-down leadership and messaging is key when rolling out a new tool and will help drive user adoption. The most successful clients I have worked with understand that getting key stakeholders involved from the start will help drive success. However, the other side of the coin is involving end-users at all levels. Involving these users will help create champions among the team to ensure the new tool is well adopted. Get your teams involved upfront in part of the tool selection process, develop clear communication, and have a roll-out plan in place.

 

We would love to learn about where you are in your DAM journey and discover ways we can ensure your continued success. Contact our team of DAM experts today – email us at info@leappoint.com

DAM New York 2019 is now in our rear view mirror and it’s taken some time to fully process the experience. Attending as a sponsor requires a lot of preparation. It’s as if you’re throwing a party, cooking dinner, singing and greeting guests all at the same time. Still, we were excited to learn and collaborate with other DAM enthusiasts. Librarians, archivists, designers and more- we had a great time, met interesting people, learned lots and were absolutely ready to hit the ground running (after a weekend to rest). There’s a lot to unpack but here are a few observations after this event.

Useful AI in DAM is right around the corner

Artificial Intelligence is at the forefront of just about every technology gathering today. Gatherings such as the Henry Stewart DAM event are integral for the development of this cutting edge capability. We heard ups and downs of allowing AI to identify objects and tag content. In my experience, the most successful application is with a touch of machine learning (ML) and a hint of human intervention. The balance between AI/ML and human intervention is going to be a delicate one. A slight error can take the AI into a tailspin of poorly tagged content. Too much human intervention becomes counterproductive. We’re seeing machine learning take large strides to close the gap between what has to be trained and what’s ready ‘out of the box’. I’m excited to see how this technology develops. For now, I see digital workers playing a big role in augmenting the ‘human’ intervention as this application of AI is fine-tuned.

It’s not about the feature, it’s about the result

Yes, I realize my last observation was about a technology feature. At the end of the day, the technology we use is a tool to enable results. It’s a tough idea to completely embrace. Most people who attend a conference on Digital Asset Management are genuinely excited about where the industry is going. We get fixated on every new feature and all of the shiny new objects. This is the kind of passion that makes these events so much fun to attend. It can also be a barrier to adoption. Our users haven’t spent their professional lives understanding the impact of governance on scaling across the enterprise or why metadata matters in your archiving strategy and measuring campaign performance. Instead, our users have their own work to do and their own goals to accomplish. Unless we can show how it impacts the results, each feature is just a button that may end up skipped or worked around.

Governance without adoption is just a bunch of rules

During a panel session, someone asked me about how to actually get your users to buy into your governance model. In fact, this question was asked many different ways throughout the conference. The usual formula for implementing DAM is Scale = Structure + Governance. You figure out how it works on one team, document it and use those steps to bring on the next team. Rinse and repeat until you’ve taken reached every team and it’s instant scale, right? Well, that’s how governance grows. That’s how you grow the rule book. We need people to use the DAM to say we’ve really achieved scale. My response to gaining buy-in was simple: try to avoid saying “you have to”. To some extent, it’s really that simple. In practice, however, it’s much easier said than done. The reasons we face resistance vary greatly between groups and individuals. Sometimes it’s about understanding the bigger picture, other times it’s about enablement or awareness. There’s no hard and fast rule for making sure adoption happen smoothly. It’s a matter of understanding people and managing change. We’ll be exploring this topic in greater depth during a roundtable discussion at DAM Europe next month. I encourage you to stop by and listen to others’ experiences with this very topic.

 

If you won’t be in London or have comments/questions, reach out via LinkedIn or email me at nrashid@leappoint.com

Marketing has dramatically evolved in the last 20 years. The rise of digital marketing and the exponential growth in marketing technology solutions are just a couple of things that have brought a new level of complexity—and power—into the hands of marketers. But, as the saying goes, “With more power comes more responsibility.”

Chief marketing officers and their teams are facing greater expectations to demonstrate results across their organization. Marketing investments are under continued scrutiny and organizations are being tasked to perform at higher levels with the same or fewer resources. The bottom line:  today, marketing organizations must demonstrate steadily increasing ROI while achieving higher levels of innovation, and team and client engagement.

So what?

 

Marketing organizations need to bring their A-Game. They must take steps to evolve their stack, processes, and strategy to keep ahead of the curve – and the competition. Wherever you are in your digital transformation, you should ask yourself:

  • Can you demonstrate how your marketing organization is aligned to the company’s strategy and driving real, measurable value for the enterprise?
  • Do you have the means to communicate full cost and ROI transparency to the CMO and business lines, and drive informed marketing decisions?

 

If you’re not confidently answering “yes” to these questions, here are the six steps you can take to build and bring your marketing A-Game:

 

1. Thoughtfully create your marketing stack

The number of marketing platforms has grown at an exponential rate, and it can be hard to know what the right strategy and tools are for your organization. Assess your current stack with these questions:

  • Can you qualify the value you get from each of your platforms and tools?
  • Are there gaps you can identify within your existing stack?
  • Could you possibly consolidate the number of tools you are using?

 

2. Build integrations

Like most companies, you likely have multiple systems of record. But it’s not effective to plan in one system, execute work in another, and host assets and deploy in others. Your holistic marketing story and accurate ROI reporting are critically important. Power your organization’s collaboration with integrations that seamlessly connect your stack to unlock and unify the data that enables these stories.

 

3. Organize your data & insights

Your stack is creating ever more data to manage. But the problem isn’t the data itself; it’s how to organize it in a way that leads to actionable insights. Define a best-fit data strategy for your stack. And with the right visualizations, your organization will be empowered with the ideas to make smarter marketing, business, and operational decisions.

 

4. Examine your existing processes – and do it often

Organizations and your marketing needs will continually evolve. Being comfortable may lead to a miss on an important technological advance that your competitors are employing.

  • Review your processes regularly to re-engineer and optimize them and to ensure they’re as efficient as possible.
  • Refine your organizational roles to maximize new capabilities.
  • Look into custom development options to create new automation opportunities within your organization.

 

5. Make change personal

Tools are only effective if you know how to use them and know why you’re using them. Equip your team with proven approaches and tools that affect lasting change. Discover methods that will influence behavior and allow your staff to understand the value of new capabilities. By encouraging your team to embrace change, you’ll drive operational excellence and create a model for the rest of the enterprise to follow.

 

6. Recruit an expert or find a reputable partner

Ultimately, bringing your marketing A-Game is complicated. It takes time, strategy, investment, and the right guidance to ensure you will have an ecosystem that positions your organization to win. In this process, don’t be afraid to recruit an expert for that industry or employ a technology partner to make strategic recommendations. Create a roadmap that aligns with your objectives, prioritize your specific initiatives and create the ideal marketing ecosystem for your organization. Your team will be able to focus on creativity and innovation, and you’ll watch your ROI (and credibility as a leader) soar.

 

Are you ready to bring your A-Game?

Through multi-city workshops, LeapPoint will provide senior marketing professionals a solution set that enables their organizations to align with corporate strategy and effectively and efficiently deliver value to the enterprise. We’ll showcase how to achieve these outcomes via a robust, intelligently integrated, set of best-of-breed cloud applications that holistically provide for this capability with effective governance.  All with the added benefit of actually making the end-user experience more efficient and effective.

Learn more about the marketing A-Game and register for an A-Game Workshop in a city near you at leappoint.com.

 

 

Digital asset management (DAM) software gives businesses a platform for storing, retrieving, and sharing digital content such as videos, photos, audio files, presentations, and images. Instead of keeping files on different computers, businesses can use DAM software to create a centralized library that gives everyone access to the content they may need.

 

How DAM Software Can Benefit Your Business

Before you purchase DAM software, you should learn about some of the ways it can help your business. You should also learn about some of the most popular software options and the features they offer.

 

Organize Your Digital Media

Without DAM, your business doesn’t have an easy way to organize digital media. At best, you can try to keep certain files in one folder. Given enough time, though, people will forget where they saved files. When they need to retrieve them, they end up wasting a lot of time searching for the files they want.

DAM organizes your files in a central location, so you can quickly find the items you need. You can even add metadata to help you find content. Instead of losing your assets, you organize them in a convenient place that the whole team can access.

Improve Workflow

Since everyone involved in a project has access to the files stored in your DAM software, you can reduce redundancies that slow your workflow. The best DAM software has built-in workflow management features that let you track a project from beginning to end. The smoother your workflow gets, the faster you can bring your projects to market.

Manage Rights and License Agreements

You may not own all of the digital media that your company uses, so you need to keep track of each asset’s rights or license agreements. It’s very difficult to manage rights and license agreements when you store media in folders.

When you use DAM, though, the software remembers all of the rights and license agreements for you. That way, you never mistakenly use content that could get you sued for copyright infringement.

DAM Software Scales to Your Needs

Digital media files can take up a lot of space on your computer, especially when you work with audio and video. Cloud-based DAM software can scale to meet your current needs. If you need more memory today because you’re working on three videos, then the software can accommodate that. Tomorrow, when you work on one video, the software automatically scales down.

Once you find the right DAM, you have all of the memory and processing power that you need to finish your projects.

 

The Top 3 Digital Asset Management Platforms

Make sure you review some of the most popular DAM software options so you can choose one with the features that matter most to you.

Bynder

Bynder excels at giving users access to templates that make it easier for designers to complete projects. Since Bynder uses the AWS cloud, the software can scale to your immediate needs. As your business grows, the software will grow with you. Finally, Bynder has a built-in, customizable workflow feature that lets you improve efficiency and track each step in a project’s progress.

Aprimo

In addition to storing digital media, Aprimo can automatically approve each step of a project. Assuming that the software approves terrific content, you should see your efficiency improve significantly. Aprimo also benefits from its ability to connect to other systems, including Adobe Creative Cloud, eCommerce, and Enterprise Resource Planning (ERP)

Adobe Experience Manager Assets

Adobe Experience Manager Assets makes it easier for colleagues to collaborate. The collaboration feature should help improve your office’s efficiency. Adobe Experience Manager Assets also stands out for its AI insights. The software will review your content and tell you where you get the best ROI.

Many DAMs will let you try a demo before you purchase. Explore your options, find one that works well for you, and get your DAM life in order.

Recently, Adobe announced its 4.75 billion dollar purchase of Marketo – an investment that should move Adobe into a B2B marketing leadership position. Already a powerhouse in the marketing industry, Adobe Experience Cloud is setting the stage for domination with this purchase, but the real question remains – will you benefit?

Adobe Experience Cloud

Adobe’s Experience Cloud was launched in 2017, with the company rebranding its Marketing Cloud as one of three sub-clouds – the other two being Adobe’s Analytics Cloud and Advertising Cloud. Some of the most impressive features of Adobe Experience include the Visitor ID service, which is vital to core operations and integration ability, Dynamic Tag Manager, which supports tools for Adobe functions as well as Nielsen and Google, and Device Co-op, which is a device graph that promotes understanding of customer behavior. Adobe Experience Cloud is relatively new but has already established itself as a competitive player in cloud computing.

Marketo

Marketo is a SaaS marketing automation platform that B2B marketers find essential in building campaigns and making sales strategies operational. Sales reps use the system to understand business prospects’ behavior, while marketing executives use it to link marketing investments to the sales process and revenue generation. Marketo offers software features that allow lead management, lead scoring, mobile marketing, and website personalization, among other features. Marketo has positioned itself as a leader in B2B marketing automation, a position that Adobe Experience Cloud can only enhance.

What’s in it for you?

Since Adobe acquired Marketo rather than a company with their own CRM to push, you will continue to be able to connect any significant CRM to the platform. This means that users will benefit from having all the Adobe tools at hand without being forced to make a major, and possibly disruptive, CRM switch. Joining the Adobe Experience Cloud adds powerful, advanced capabilities to Marketo. Leveraging the market-leading platform allows Marketo to enhance its strengths in mobile marketing and personalization while taking advantage of industry-leading analytics- an area in which Marketo customers have felt frustration in the past. Marketo’s B2B users will also benefit in several ways, including through its personalization engine. These Adobe tools will particularly help B2B shops that have some B2C features in their business. Marketo was already working to strengthen this aspect of their business, the Adobe purchase immediately sends them to the head of the class, leapfrogging over their competitors.

The purchase of Marketo by Adobe Experience Cloud promises better service for users of both services. Adobe Experience has the B2C market handled with numerous easy-to-use tools that can only enhance Marketo’s B2B prowess. The combination of these marketing powerhouses means that you can have the best of both worlds, keeping your favorite functions while gaining even more effective marketing features for your clients’ use.

Only time will tell the exact impact of this purchase, but you and other people in the industry have every reason to expect better service all around. The combination of these two industry leaders promises to give you groundbreaking platform power.

1. Add a billing record to safeguard project

Although Workfront has recently added a recycling bin feature, deleting a project can cause panic, confusion, and loss of productivity, especially if the project you just deleted was a request queue. Prevent any worry around losing key projects by adding a zero dollar billing record to them.

Even if your company or group isn’t using the billing record feature for its native purpose, it can be used here as an extra layer of protection against project deletion. Simply go to the project, create a new billing record, and set the status to Billed”. Then, if someone attempts to delete the project this error message will display and the project will stay out of the recycling bin:

 

2. Make a placeholder job role to prevent assigning users to parent tasks

By default parent tasks can’t be updated or completed independently from their child tasks. The one task detail that can be independently edited on a parent task is the assignment; however, when users are assigned to parent tasks we find that it often leads to frustration when they receive the inevitable error message for trying update the status or completion percentage. To help prevent project managers and other users from accidentally assigning workers to parent tasks, create a job role titled “Do not assign – Parent Task”. Assign this to all of the parent tasks on your project templates and it will serve as a reminder/safeguard that these tasks are a summary of their child tasks and shouldn’t have a user assigned to them.

 

3. As a plan license user, view the resource planner by user

(Note: this assumes your Workfront instance has completed the prerequisites needed for Resource Planning) The Resource Planner is a helpful widget in Workfront to manage the allocation of resources to projects and forecast their availability for future work. Formerly, this was limited to only users who were listed as Resource Managers on projects. With recent updates, however, any user with a plan license can get valuable information from the Resource Planner by setting the view to “View by User”. If the view is set to View by Project or View by Role, results will only be returned for projects where the user is listed as a Resource Manager, putting you right back at square one. View by User doesn’t have that prerequisite and allows other plan license users to see the allocation of all users, regardless if they’re listed as a resource manager.

 

4. Change ID to name in text mode

(Note: this only works for details tab) When creating views and reports in Workfront, there will be instances where the information you want to display is too many levels away from the object you’re working on. This will limit the display options from the field explorer. For example, when adding a column to a task report or task view for the name of the project sponsor, you will find the only option is “SponsorID”. While this makes sense to the Workfront database, this doesn’t provide much value to users viewing the report. Luckily this can be changed with a quick text mode edit.

While in the report or view editor, click on the column for the ID field and switch to Text Mode.

  • On every line where you see “fieldnameID” change the “ID” to “:name”
  • For example change project:sponsorID to project:sponsor:name
  • Click “Save” in the text mode window, then save the view or report.
displayname=Documents
valuefield=project:sponsor:name
querysort=project:sponsor:name
valueformat=HTML
displayname=
linkedname=project
namekey=view.relatedcolumn
namekeyargkey.0=project
namekeyargkey.1=sponsor
namekeyargkey.2=name

 

5. Flag task commit dates greater than planned completion dates

Commit dates are set by task assignees and can’t be changed by the project owner. While the project manager is notified when commit dates affect the project timeline, it can be hard to quickly review a project and see which task commit dates are later than their planned completion dates. With some text mode code, the commit date field can be added to a task view with conditional formatting to display in red when later than the planned completion date.

This can be done by adding a blank column to a task view and switching to text mode, and pasting in the code below:

displayname= Commit Date
linkedname=direct
namekey=commitDate
querysort=commitDate
styledef.case.0.comparison.icon=false
styledef.case.0.comparison.leftmethod=commitDate
styledef.case.0.comparison.lefttext=commitDate
styledef.case.0.comparison.operator=gt
styledef.case.0.comparison.operatortype=date
styledef.case.0.comparison.rightmethod=plannedCompletionDate
styledef.case.0.comparison.righttext=plannedCompletionDate
styledef.case.0.comparison.trueproperty.0.name=fontstyle
styledef.case.0.comparison.trueproperty.0.value=bold
styledef.case.0.comparison.trueproperty.1.name=textcolor
styledef.case.0.comparison.trueproperty.1.value=d30519
styledef.case.0.comparison.truetext=

Click “Save” in the text mode window then save the view you’re editing. Now when viewing a task list, any user commit dates that are later than the planned completion dates will be displayed in red.

 

6. Link directly to queue topics

Have you ever instructed someone to submit a Workfront request and found yourself listing off the steps of selecting the proper request queue, topic group, then queue topic? Theses directions can be eliminated and the end user experience enhanced by sending them a link directly to the queue topic. Instead of sending the URL “domain.workfront.com/requests” with instructions on which drop downs to select, if you select the request queue & specific queue topic, the URL in your browser grows with each selection. This enables the URL to take the user to the specific queue topic without having to manually make any selections. This is incredibly handy when posting Workfront URLs on intranet sites for users to submit work requests.

 

7. Link directly to a sub-tab on an object

In similar vein to tip #6, URLs can also be built to take users to specific tabs on a project, task, issue, etc. To land a user on a specific sub-tab of an object, Workfront allows for a parameter to be added to the URL with the structure below:

https://<domain>.my.workfront.com/project/view?ID=5b6c7eb5003d2022cea3a135cca33ac1&activeTab=tab-project-updates

Normally when viewing a project (or task, or issue), the URL stops after the object ID regardless of which tab is being viewed. By adding the parameter “&activeTab” the URLs will navigate directly to the project tab of your choosing. Some more examples:

 

URL modifier Landing tab
&activeTab=tab-project-details-forms Project Details
&activeTab=tab-project-approvals Project Approvals
&activeTab=list-project-documents Project Documents
&activeTab=tab-project-updates Project Updates
&activeTab=tab-project-optasks Project Issues

 

The same concept and URL structure works on other Workfront objects such as tasks, issues, programs, portfolios, etc. For other objects, simply change the object reference in the URL examples above from ‘project’ to the object you’re referencing.

 

8. Make sure your browser zoom setting is at 100%

Occasionally, when selecting a request queue or an option from a drop down field in older browsers, the drop down option menu appears on a random part of the screen or, in some cases, doesn’t appear at all. Although this seems like a major issue, 99% it’s not a bug and can be fixed very quickly. Double check the zoom on your browser and make sure it is set to 100%. In certain browsers, if the zoom is set to a value other than 100%, it can cause issues with drop downs appearing.

 

9. Link to documents in a project or task view

Use this text mode trick to create hyperlinks to documents from a project view. When creating a project/task view or report, add a blank column and switch into text mode. Copy and paste in the text mode code below, and be sure to update the <domain> section of the URL with the domain of your Workfront instance.

displayname=Documents
listdelimiter=
listmethod=nested(documents).lists
textmode=true
type=iterate
valueexpression=CONCAT({name}, - "https://&lt;domain&gt;.my.workfront.com/document/view?ID=",{ID},"; ")
valueformat=HTML

Click “Save” the text mode window, then save the view or report. Now, when viewing the results, the names of any attached documents will be listed along with a URL to navigate directly to the document.

 

10. Find projects with no tasks, issues, or documents

After Workfront has been implemented, there will inevitably be projects in your system that were either created by mistake or abandoned shortly after creation. While many of these can be cleaned up by searching your instance for “Untitled Project” and deleting any results, this doesn’t work for projects that have had a name change. To assist in system maintenance, use this text mode to find projects with no tasks, issues, or documents. Creating a project report, go to the filter page, switch into text mode, and paste in the code below:

EXISTS:a:$$EXISTSMOD=NOTEXISTS
EXISTS:a:$$OBJCODE=OPTASK
EXISTS:a:projectID=FIELD:ID
EXISTS:b:$$EXISTSMOD=NOTEXISTS
EXISTS:b:$$OBJCODE=TASK
EXISTS:b:projectID=FIELD:ID
EXISTS:c:$$EXISTSMOD=NOTEXISTS
EXISTS:c:$$OBJCODE=DOCU
EXISTS:c:projectID=FIELD:ID[/CSS]