How to integrate Chatwork with KING OF TIME to record timestamps in KING OF TIME when a specific message is posted in Chatwork

Step 1: Link Chatwork and KING OF TIME with My Apps

Register Chatwork and KING OF TIME with My Apps for this process.
Registering with My Apps beforehand will make future operations smoother.

First, link Chatwork with My Apps.

When the following screen appears, click "Allow" in the red frame.

Once the linking is complete, you will return to the My Apps screen and see Chatwork displayed.
Next, register KING OF TIME with My Apps.

Click "My Apps" → "New Connection" on the left side of the Yoom screen.

Search for KING OF TIME using "Search by App Name" or find it from the list of apps.

‍

A screen like the image below will be displayed, so proceed with the input according to the content.
For more details on registering KING OF TIME with My Apps, please check here.

Once KING OF TIME is displayed on the My Apps screen, the registration is complete.

Step 2: Copy the Template

To set up automation, click "Try it" on the banner below.

Read the following screen display and click "OK".

‍

Step 3: Setting up the Chatwork trigger and subsequent KING OF TIME action

1. Setting to detect Chatwork messages
Click "When a new message is posted in the room (Webhook trigger)".

A screen to select the linked account and action will be displayed, so click "Next".

‍

Copy the Webhook URL and set it in the management screen of the target application.
※ For Webhook settings, please check here.

Once the setup is complete, run the test, and after confirming the test success, click "Save".

2. Retrieve records with Yoom
Click the red-framed area on the screen below.

‍

A screen to confirm the linkage with Yoom's database will appear.
Proceed with the input according to the content.
Once the input is complete, click "Next".

Detailed settings for database operations will be displayed.
Enter so that it operates when Yoom's record ID and Chatwork's account ID are the same.

‍

Next, to set up retrieving one record that matches the conditions from the specified table in Yoom, click "Retrieve Record (Employee Identification Key)".
When the following screen is displayed, check the settings.

• "Title" → Can be changed as you like
• "Database App" → Yoom
• "Execute Action" → Retrieve Record

Pre-store the employee list data in Yoom's database.
If already saved, select the project where it is stored from the project list on the left side of the Yoom screen and check if the data is saved.
If creating a new one, create a project from the "+" next to the project list and click "Database" to create an employee list.

This time, we will use the following database as an example.

Return to the "Retrieve Record (Employee Identification Key)" screen and set up "Database Linkage".
Select the "Project", "Database", and "Table" of the data saved earlier.

The following screen will be displayed, so set the "Conditions for the record you want to retrieve".
This time, we will use the sender's account ID to retrieve the record.
Use the Chatwork output and set it as follows.
The output will be displayed by clicking the arrow in the red frame.
Once the setup is complete, run the test, and after confirming the test success, click "Save".

‍

‍

3. Setting up the clock-out action

Click "Register Clock Data (Clock-out)" in the red frame on the screen below.
On the screen to select the linked account and action, click "Next".

The setting screen for clock-out in KING OF TIME will be displayed.
Enter according to the content below.
Once entered, run the test, and after confirming the test success, click "Save".

‍

4. Setting up the clock-in action‍

Click "Register Clock Data (Clock-in)" on the screen below.
On the next screen to select the linked account and action, click "Next".

‍

The clock-in setting screen will be displayed as shown below.
Enter according to the content, and once entered, run the test.
After confirming the test success, click "Save".

Proceed with the input according to the content.

Step 4: Turn on the trigger and check the linkage operation between Chatwork and KING OF TIME

When you click "Save" above, a screen like the image below will be displayed.
Finally, click "Turn on Trigger" to complete the automation setup.

Check if the flow bot is activated correctly.

‍

Here is the template used this time.

Other Automation Examples Using Chatwork and KING OF TIME

① Notify Chatwork of Zoom Meeting Information Daily

This is a flow to notify Chatwork of Zoom meeting information daily. It is recommended for companies using Zoom as their cloud meeting tool. By using this template, Zoom meeting information is automatically retrieved at a set time every day and can be checked on Chatwork. By easily grasping the meeting schedule, preparation becomes easier, and you can confidently attend meetings. As a result, you can expect an increase in the success rate of business negotiations and customer satisfaction.

② Detect Missed Punches from the Previous Day in KING OF TIME and Notify via Chatwork

This is a flow to detect missed punches from the previous day in KING OF TIME and notify via Chatwork. It is recommended for those seeking efficient management by reducing the effort of checking daily punch status. By using this template, you can quickly detect missed punches from the previous day and take necessary actions immediately. This is expected to improve the accuracy of attendance management and prevent issues with payroll calculations and shift management due to missed punches.

‍

③ Update KING OF TIME information when employee information is updated in kintone

This is a flow to update KING OF TIME information when employee information is updated in kintone. It is recommended for those who manage information centrally with kintone or utilize KING OF TIME in their business operations. By using this template, you can detect updates in kintone and automatically reflect the updated content in KING OF TIME, eliminating manual work. Automation helps avoid input errors and omissions due to manual work, reducing the burden on the person in charge and allowing the entire team to focus on core tasks.

Summary

By integrating Chatwork and KING OF TIME, as introduced this time, automation of attendance management is achieved, significantly improving work efficiency. Especially in a remote work environment, accurate attendance management becomes easier, reducing the burden on both administrators and employees. No special skills or knowledge are required to implement automation with Yoom.
Simply follow the instructions to input, making the operation easy.
If you would like to experience it, please register for free here.