Streamlining Man-Hour Entry in Jobcan Attendance

Introduction

It is necessary to fill in Jobcan man-hour entries, but I will show you how to reduce the effort required.
Note that this assumes you are using Google Calendar for business.

Jobcan Attendance man-hour entry looks like this:
https://jobcan.zendesk.com/hc/ja/articles/206375022--PCマイページ-工数を入力する

spreadsheet, Processing

Usage

Preparation

1. Color-code your meetings in the calendar in advance.
2. Set up templates in Jobcan man-hour entry.
3. Enter the order of the man-hours set in the template in the "Man-hour Order" column of the sheet.
4. Set it up so that the function 'refreshManHourSheet' is executed when you click the image in the sheet.

Execution

1. Open the Jobcan man-hour entry screen, open developer mode, and have the Console ready.
2. Enter the target date and run the tool. Copy the resulting JS statement and paste it into the Console.
3. The JavaScript will be executed according to the statement, and the man-hour entry will be completed.