Using google spreadsheet to be your update log sheet.
With this app script, u may easy to find which task have not done yet
With this app script, u may easy to assign color to each status
With this app script, we are saving your mouse click to prepare new lines
Lets me show the result to you first
With this app script, u may easy to find which task have not done yet
With this app script, u may easy to assign color to each status
With this app script, we are saving your mouse click to prepare new lines
Lets me show the result to you first
Google Spreadsheet - update log
Installation
- Step: Make a copy from: Update Log Template, rename the softcopy
- Step: Copy the spreadsheet Key ID, this is a unique identify code in the URL
https://docs.google.com/spreadsheet/ccc?key=This is your spreadsheet key#gid=0 - to Go to the app script, Press Tools > Script editor ...
- replace the spreadsheetID value by sheet key your just copy, please kindly note that another properties I will explain later
Demonstration
- Step: Make a copy from: Update Log Template, rename the softcopy
- Step: Copy the spreadsheet Key ID, this is a unique identify code in the URL
https://docs.google.com/spreadsheet/ccc?key=This is your spreadsheet key#gid=0 - to Go to the app script, Press Tools > Script editor ...
- replace the spreadsheetID value by sheet key your just copy, please kindly note that another properties I will explain later
====================================================================
GitHubs
Reference
No comments:
Post a Comment