Your cart is currently empty!
Category: Knowledge Base
-
Attach File in a Task via linking Google Drive in Teamwork.com
Definition
While working on a Task in a project, it is very common that either input raw files or output delivering files are needed to work with the Task. It is a must for us to prepare a central storage where we can store the project files while satisfying the access rights concern. Meanwhile, after uploading the project files to that central storage, to reduce the time cost of searching, we need to attach (i.e. link up) the project files to a particular Task# in Teamwork.com.
Example of attaching File in Task via linking Google Drive
Problem Pattern its Solves
Although we can always choose to attach a file by simply clicking on
+ Add Files
inside the Teamwork.com Task interface, it is strongly not recommended to do so due to the following reasons:Limited storage capacity
Teamwork.com’s paid plan only allows 5GB storage capacity, which is far less than the 2,000GB storage in our company’s Google Drive.
Limited access for application outside Teamwork.com
Anyone who doesn’t have access to a particular project in Teamwork.com cannot access the files stored in Teamwork.com.
Lack of going conern
One day, if we no longer use Teamwork.com, all the files will no longer be accessible.
Step By Step on attaching a File to a Task via Google Drive
Attach a File (via Google Drive) in Task Level
Teamwork.com
- <<
TARGET_TASK
>> Files
>Manage Task Attachments
Google Drive
>+ Create
Create a new folder...
Name of the new folder
= <<TASK#
>>Search for...
- <<
TASK#
>>
- Drag and Drop the <<
TARGET_FILE
>> into the window.1 - Tick <<
TARGET_FILE
>> Link-in Selected Files
- Done
You can see the file is now attached in the Task while keep storing in the Google Drive.
While collaborators who have the access rights of the target Task can access the attached file, anyone who cannot access the Task via Teamwork.com interface can still access the attached file via traditional way in the Google Drive.
Attach a File (via Google Drive) in Comment Level
Instead of attaching a file in Task Level, you can also choose to attach file in Comment Level. In fact , the steps will be almost the same as attaching file in Task Level, except:
- <<
TARGET_TASK
>> - <<
TARGET_COMMENT
>> Attach a File
>Google Drive
Conclusion
By attaching the file with associated Task and storing them in Google Drive, we can significantly help future yourself, client and collaborators to cut the time cost on searching related Task Attachments.
- Please refer to the article File Naming Convention to see how you name the attaching file. ↩︎
-
Label in Gmail
Definition
Label in Gmail is a tagging system in which you can classify an email into different categories as much as you want by giving the email the tag(s).
Unlike a Folder in Gmail which “physically” is located in one folder path, the folder path of the tagged email will not be changed.
How Label in Gmail looks like
How does a Gmail Label Look Like Gmail Label Applied In an Gmail
What Problem Pattern the Gmail Label in Gmail solves
As a Kanban Board for Task Status
By creating the Tag with different Task Status (e.g. 01 – Processed ; 02 – Wait Response ; 03 – Pending) , users can tag gmail with associated Task Status Tag in order to classify the current Task Status of the emails.
Save Time for Searching
By simply choosing the
Label
in theleft side bar
of the Gmail Interface, users can easily filter out all the gmail with associated Label (i.e. Tag)
Step by Step on Creating Label in Gmail
Manually Create Label
- www.gmail.com
Labels
>+
>New label
- <<
LABEL_NAME
>> Create
Auto Creating Labels via Filters
By setting the Filters, you can apply the auto rules into your inbox , so that whether any criteria of the receiving email is hit, the pre-defined action (i.e. creating a Label in this case) will be automatically be triggered.
www.gmail.com
See all settings
Filters and blocked addresses
Create a new filter
- Insert any criteria
Create filter
Apply the label:
<<TARGET_LABEL
>>
Auto Create Label By Creating Gmail Filter
Step by Step on Using Label in Gmail
Suggested Label to be created
For sure you can create any Labels you like which can enhance your working efficiency. If you have no idea on how to start, you are suggested to create the following Tags as default:
Kanban Job Status Tag
- 01 – Processing
- 02 – Wait Reply
- 03 – Pending
- 05 – Failed
- 06 – Success Completed
Caution
Even though you have tagged the emails with the Labels in your gmail account, the recipient will NOT see the Labels due to the fact that the Labels information is limited in your gmail account only.
If you want to send the email to the recipient with Labels, you should communicate with the recipient and add the Gmail Filter into the recipient side so that the Gmail Filter will automatically tag the Label into the email after a specific Filter Rule is hit.
Taggingg the Label to an Email
www.gmail.com
Inbox
- <<
TARGET_EMAIL
>> ⋮
>Label as
- <<
TARGET_LABEL
>>
Gmail Label As in Email -
Google Authenticator
Definition
Google Authenticator is a two-factor authentication (2FA) app developed by Google. It adds an extra layer (i.e. 1 Factor + 1 Factor = 2 Factors) of security to your online accounts by generating one-time verification codes that you use in addition to your password when logging in an application (e.g. Your Gmail account)
What Problem Patterns that Google Authenticator Solved
Vulnerability on one-factor authentication
While the term Authentication always mean :
- What you have (e.g. You possess a Mobile Device)
- What you know (e.g. You know the password)
- What you are (e.g. You are the fingerprint owner of the unique fingerprint)
Software or APP always use the above 3 factors to secure the ownership of the software or APP of the owner.
However, it is not secure enough to use only 1 factor to authenticate an user. For example, while you lost your mobile device when you didn’t set a login pin, the person who picked up the mobile device can probably manipulate any APP that you have logged in before via the mobile device.
Another example is that if you only use the What you are factor to authenticate who you are via a fingerprint scanner, when you meet a robber , you may face the risk that you will be forced to use your finger to log in your mobile device and Bank account APP.
To tackle the security vulnerability found in 1-factor Authentication, the world is being introduced to 2-factor Authentication.
Other than simply providing the APP Password (i.e. what you know), some APP may also require you to receive an 6-digit One Time Password (OTP) which is generated from the Authentication APP installed in your mobile device , so as to prove that you own the mobile device which is used to log in the app (i.e. what you have)
One of the example of this Authentication APP is Google Authenticator.
Lack of capacity to develop a Authentication function by each Software and APP
Step By Step – How to Install Google Authenticator
iOS
Step 1 – Download from Apple Store via your Mobile Phone
Android
Step 1 – Download from Google Play
Enable 2FA of Google Account
Step 1: Install Google Authenticator App
Google Play Store
orApple App Store
>Search
"Google Authenticator"
>Download
>Open App
Step 2: Enable 2FA on Your Google Account
Account
>Security
>2-Step Verification
>Sign In
2.
Add authenticator app
>Set up Authenticator
>Scan a QR code >Nex
t >Enter Code
>Verify
3.
Turn on 2-Step Verification
>Turn on
>Done
-
Bookmarks in Google Chrome
Step by step on importing Bookmarks into your Google Chrome
Step 1 – Get ready for the Target Importing Bookmarks File
Step 2 – Export Bookmarks from Your Current Browser
Safari (Mac)
Safari
>File
>Export Bookmarks
Export Bookmarks File Window
> <<SAVE_LOCATION
>> >Save
Step 3 -Import Bookmarks into Google Chrome
Google Chrome
> ⋮ >Bookmarks
>Bookmark Manager
.Bookmark Manager
> ⋮ >Import Bookmark
.File Explorer
> <<EXPORTED_BOOKMARKS_FILE
>> >Open
.Bookmarks Bar or Other bookmarks
>Imported Folder
.
By following these steps, you will successfully export bookmarks from your current browser and import them into Google Chrome as shown in the cap screen below.
-
Google Drive Usage in Project Management
Definition
Google Drive is a cloud-based file storage provided by Google which is totally free for use if the storage usage is under 15GB. You can regard it as a storage of your hard drive in your laptop, except that the storage is stationed in the Cloud instead of your laptop..
Problem Patterns that Google Drive solves
Files needed to be stored in mutli-location and multi-device
By storing the file into Google Drive (i.e. the Cloud Drive) , you can access the file in any device including laptop , desktop or even mobile phone. As long as you have access to the internet, you can use any browser to login to Google Drive and access the storage.
This is a common scenario where you have saved a important Powerpoint file in the laptop in your home but in the morning you forgot to copy that Powerpoint file from your laptop to the USB drive, which eventually you failed to use the file to do the presentation.
Different roles need different access rights level for different files in the storage
Imagine a scenario that when you are working for a project with your client, you want to share only one of the files in the storage, while keeping the vendor quotation files away from your client.
Another scenario is that you want to only share the company profile .pdf file to your client for reading and don’t want them to have the rights to delete the file.
This capability is what we called Role Based Access Control🛈, which is one of the features of Google Drive.
Company’s Files scattered around different local storage
Imagine if you have 30 staff in your company and everyday they work very hard to do their jobs via their laptop. One day , you have a very important sales pitch which drives you to gather all the past job references from your colleague. While you may need to get the Social Media Ads Image Ads from a designer, you also need to go for the programmer to ask for the wideframe of the website. Without luck, the programmer who created the wideframe just quit last week without leaving any clue where he stored the wideframe which he created 2 years before.
If this scenario sounds familiar to you, it is time for you to think of using Google Drive to centralise all the important files and documents to save the time of searching.
Scenario of using Google Drive
Sharing files to your client by Role Based Access Control
Step By Step
- Determine the hierarchy level that you want to share in the Google Drive
As said before, Google Drive is no different than any of the File Manager in your laptop computer, except that the files inside the Google Drive are stored in a cloud harddisk, while the Files accessed by your File Manager of your laptop are saved in your local laptop harddisk.
Therefore , both of them are using the same tree hierarchy to locate the files. Allow me to illustrate the File Manager Hierarchy with the example below:
Your Company Google Drive File System Hierarchy
- Google_Drive_Root
- Human_Resource (Folder)
- Accounting (Folder)
- Client (Folder)
- 00_Alice_Ltd (Folder)
- 01_Facebook_Post_Image.png (File)
- 02_Facebook_Post_Text.docx (File)
- 03_Alice_Quotation.pdf (File)
- 04_Vendor_Invoice.pdf (File)
- 05_Billy_Company_Ltd (Folder)
- 00_Alice_Ltd (Folder)
In this example, as the Project Manager of Alice Ltd, you may probably want to share the whole Folder of Alice Ltd (i.e. 00_Alice_Ltd) to your Assistant Digital Marketing Manager , Sam, but not Billy Company Ltd (05_Billy_Company_Ltd), which Sam has no time to manage.
Meanwhile, you may want your Digital Marketer to access only the Image (01_Facebook_Post_Image.jpg) and Text file (02_Facebook_Post_Text.docx) , and you don’t want him to access the Quotation to Alice Ltd which contains the selling price of the Project.
In this case, to share the Whole Folder of 00_Alice_Ltd to Sam (Assistant Digital Marketing Manager), you can :
-
Whack a Mole (R028)
Definition
Whack-A-Mole, literally, is a classic arcade game where players use a mallet to hit plastic moles that pop up randomly from holes on the game board. The objective is to hit as many moles as possible within a set time limit, earning points for each successful hit.
In the context of Project Management, the term “Whack-A-Mole” is also used metaphorically to describe the risk where solving one problem leads to another problem (either being found or is hidden) popping up, much like the moles in the game
Meanwhile , R028 is the code assigned to one of the Risk Types which will usually be found within a Project. The code R028 is a DDM Terminology which is only used within our company (Diamond Digital Marketing)
Example of the Risk – Whack a Mole
Imagine if you are a web developer that when your client told you that their website is under risk of being hacked, you then deliberately install a firewall to enhance the security of the website. While you have successfully solved one problem (i.e. enhance the security level of the website), at the same time the Marketing Executive who is responsible for updating the content of the website reported to you that he cannot login the backend of the website again due to the fact that the IP address of his computer is not in the security whitelist.
How to tackle Whack-a-Mole Risk
Infact, it is very hard for us to avoid a Whack-a-Mole Risk. While the problem you are going to fix is obvious, the “Another Pop-up” problem that comes after the fixed problem is always hard to predict and observe.
Most of the time , we don’t even know that the “Another” problem is caused by the 1st problem. Compared with solving a problem ,addressing the causal relationships of 2 events among thousands of events is always the hardest part of solving a problem.
To tackle a Whack-a-Mole problem, we can:
- Keep Activity Log – Have a habit of always recording every single step before you fix a bug / solve a problem. Whenever the “Whale-a-Mole” problem occured, we can trace back every single step so as to address the which step is actually the cause of that Whale-a-Mole problem. Due to the fact that to “recording every single steps” (i.e. Activity Log) is a time consuming procedure and your client will not recognize your detailed mind, you probably will spend all of your time focusing on solving the problem instead of recording. However, “recording” is just an insurance – It only does matter whenever there is a matter. You can regard the time you spent on “recording every single step” as an insurance cost. If you don’t pay for the insurance cost (which is affordable), you will pay for the total loss if the “problem” happened. The rule of thumb is that you can spend around 5% of the time of the whole production lead time to keep the activity log. Not go fast, but go far as 1st priority.
- Keep Error Library – As we said before, as there is no way we can predict all the Whack-a-mole problem , another way we can handle this Whack-a-Mole problem is that we establish an Error Library to record all the Whack-a-Mole problem which address the causal relationship between 2 events. While we cannot avoid the 1st Whack-a-Mole problem, we can avoid the 2nd by referring to the Error Library.
-
What is SKUd
Definition of SKUd
SKUd is a DDM Terminology and it’s a portmanteau which is consisted of “SKU” and “d”.
SKU – A Stock Keeping Unit (SKU) is a unique alphanumeric code used by businesses to identify and track their inventory. SKUs are often represented as barcodes or QR codes and are essential for managing stock levels, sales, and product details.
Although we (DDM) is selling service instead of physical goods, the term SKU is still suitable to use in our company because we need to keep track of how many time of the service we had sold out.
d – To differentiate the service between DDM and client’s of DDM, a suffix “d” is added at the end of the Term SKU only in DDM’s SKU.
Example of SKUd
#8202100
What Problems Do SKUd Solve
Ambiguous Scope of Service
The big difference between a business which is selling Physical Product and Service is that while the deliverable of a Physical Product is well defined, the deliverable of Service is always ambiguous and Goalpost shifting.
For example, in a website development service, creating 100 Pages involved the cost much higher than creating 10 pages. But most of the time the quotation does not clearly quantity the deliverable in terms of Pages.
Even worse, the definition of a “Page” is hard to define because while some pages are generated dynamically by fetching the data from the database, some pages are created statically .
The wording “Creating a Page” has an ambiguous meaning which does not define whether the content of the Page is fetched from the database or is manually installed.
While different ways of production will involve different amounts of cost and labour hours, dispute will be derived during the project.
To define an quantifiable SKUd is to avoid these disputes.
What you Sold is not What you Produce
While the ultimate goal of a Salesperson is to earn the commission by selling out the service, the objective of a production team is to produce and deliver the service.
While the more details a Salesperson describes the service to the client, the harder the service can be sold out. On the contrary, the more details a Project Manager defines for the service, the easier he/she can deliver the service.
You can see that in most cases the Salesperson and the Project Manager are in conflicts of interest.
For example, due to the incompetent of the knowledge of website development, the Salesperson may not realise that a SMTP Service is a prerequisite for creating a Contact Us Form and therefore exclude the SMTP function from the sales contract.
When the Project Manager takes over the project and realises that while one of the deliverables is a Contact Us Form but the sales contract does not charge the SMTP function, the extra workload which is not absorbed by the sales contract revenue will be involved, and hence the company will lose the money.
A SKUd is here to clearly define and quantify the scope of service which is saleable and executable.
Knowledge it not monetized
Do you still remember the linear algebra equation learnt in your secondary school life ? Or do you still remember how Napoleon took power in France?
While we had spent thousands of hours in our school life learning, we all experienced that most of the knowledge we learnt are forgotten as we seldom have any chance to get use of the knowledge.
If the money spent on study is an “Investment” , then the “Return” on “Investment” is very little for our school life.
The same problem happened in the journey of studying digital marketing. If we do not turn the knowledge to become the service item shown in the quotation, what we have learnt cannot be monetized. (We called it Knowledge Monetization).
To monetize the knowledge, we have to do the mapping among Problem Patterns and Solutions aroused during our study, as well as the Deliverables that we are going to deliver to our client.
For example, during the self-study online you realise the Problem Pattern that WordPress does not have any built-in function to send out the administrative email automatically. And after another 4 hours of studying online you realise that to make WordPress ready to send administrative email, the Solution is that you have to install an SMTP plugin , as well as subscribe for a SMTP Service from the Web Hosting company.
And therefore you go for the SKUd Library and found out that SKUd #83102 is the service which clearly defines the deliverable of installing SMTP Plugin in WordPress, as well as the SMTP yearly subscription plan. The SKUd is here to act as a quantifiable and measurement Deliverables which links up the Problem Patterns and Solutions.
Components of SKUd
#
The “#” is simply denoted as “Number”
1ST DIGIT
8 – Represent the SKUd which is open for sale
5 – Represent the SKUd which is for internal use only. (i.e. not for sale)
2ND – 5TH DIGITs
The 2nd to 5th digit of in the SKUd# is simply an unique number to represent each SKUd.
6TH – 7TH DIGITs
The 6th – 7th (i.e. Last two) Digit represent the Sub Task of an Task Instruction. Due to the fact that 1 SKUd# will have many Tasks in order to delivery the service, the 6th – 8th Digits are assigned to index each Sub Task of the SKUd.
Due to the fact that our service is charged on Sub Task basis, you can expect that sub SKUd for Sub Task can be sold separately, or sold as an “Top Up Item” of a SKUd.
Example of SKUd for Sub Task
- #8202101
- #8202102
- #8202103
Relationship between SKUd and other Business Objects in DDM
- One
Quotation
HAS_MANYQuotation Item
- ONE
Quotation Item
HAS_ONESKUd (1-7 digit)
- One
SKUd (1-5 digit)
HAS_ONEDDM Eshop Product Page
- ONE
SKUd (1-5 digit)
HAS_ONETeamwork Task List
- ONE
Teamwork Task List
HAS_MANYSKUd (1-7 digit)
- ONE
SKUd (1-7 digit)
HAS_ONETeamwork Task
/Sub Task
SKUd is acting as the centrality among Sales Team (in terms of Quotation and DDM Eshop Product Listing) , Production Team (in terms of Teamwork Task) and Business Development Team (In Terms of bGraph) , so that all 3 departments can be co-operate cohesively
<<W.I.P>>Relationship among SKUd , Selling and Production
- Problem Pattern – Producer will do more task then it is suggested, which will duplicated to the task scope of another SKUd.