How to link LINE WORKS and KING OF TIME to record a timestamp in KING OF TIME when a specific message is posted in LINE WORKS

Step 1: Register LINE WORKS and KING OF TIME as My Apps

Please register LINE WORKS and KING OF TIME as My Apps to connect them to Yoom.
By completing the My App registration in advance, you can easily automate the settings.

First, let's register LINE WORKS as a My App.
Click "My Apps" → "New Connection" on the left side of the Yoom screen.

When the following screen appears, search for LINE WORKS (API2.0) from the app list or use the search bar.

When the following screen appears, configure the settings within the red frame.
For instructions on how to register My Apps, please check here.

Next, register KING OF TIME as a My App.
When the following screen appears, configure the settings.
Detailed instructions can be found here.

Once the My App registration for LINE WORKS and KING OF TIME is complete, they will appear in My Apps.

Step 2: Copy the Template

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

Read the following screen display and click "OK".

The following screen will be displayed, so please check the "Title" and "Description".
If you want to make changes, do so on the screen below.
First, to set up LINE WORKS, click "When a message is sent to the talk room".

Step 3: Setting the LINE WORKS trigger that initiates the flow and the subsequent KING OF TIME operation settings

When the following screen is displayed, please check the settings.

• "Title" → Editable
• "Account information linked with LINE WORKS (API2.0)" → Confirm if correct
• "Trigger Action" → When a message is sent to the talk room

The following screen will be displayed, so copy the Webhook URL within the red frame.

Click here and paste the copied URL into the Bot's CallBack URL.
Send a Webhook event or execute a trigger event, then click "Test" → "Test Success" → "Save".

Next, to set up branching based on the messages "Entering" and "Leaving", click "Branch based on whether it corresponds to clock-in (Entering) or clock-out (Leaving)".
*Branch operations are available in some paid plans.
If your plan is not eligible, the flowbot operation you set will result in an error, so please be careful.
A 2-week free trial of the paid plan is available.
During the free trial, you can use restricted apps and features (operations).

When the following screen is displayed, check the settings.

• "Title" → Editable

Branch target output

• "Operation" → When a message is sent to the talk room
• "Output" → Text body

Branch conditions

• "Text body", "Equal to", "Entering"
• "Text body", "Equal to", "Leaving"

Once confirmed, click "Save".

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

• "Title" → Editable
• "Execution Action" → Retrieve Record
  

Create an employee list for testing in Yoom's database.
If creating a new one, click "+" next to "Project List" → "Database".
*By linking KING OF TIME and Yoom database with Data Connect, you can save the employee identification key in the database.

Scroll down to set up database integration.

The following screen will be displayed, so set the "Conditions for the record you want to retrieve".
Use the output from LINE WORKS to set it up.
Click the arrow within the red frame to display the output.
Set it up as follows.
Once the setup is complete, click "Test" → "Test Success" → "Save".

Next, to set up extracting the clock-in date and time from the LINE WORKS text, click "Extract data from text (Clock-in date and time)".
AI operations are available only in some paid plans.
If your plan is not eligible, the flowbot operation you set will result in an error, so please be careful.

When the following screen is displayed, check the settings.

• "Title" → Editable
• "Conversion Type" → Extract text from data within 3,500 characters (2 tasks)
  

Please check the following precautions.

Scroll down to set the "Target Text".
Click "Basic Information" → "Flowbot Activation Date and Time" → "%Y-%m-%d %H:%M" in order.

Next, set the "Items to Extract".
This time, since we are extracting "Date" and "Time", set it as follows.
Once the setup is complete, click "Test" → "Test Success" → "Save".

Next, to set up branching based on the words "Entering" and "Leaving", click "Clock-in (Entering) ｜ Clock-out (Leaving)".
When the following screen is displayed, check the settings.

• "Title" → Editable

Branch target output

• "Operation" → When a message is sent to the talk room
• "Output" → Text body

Branch conditions

• "Text body", "Equal to", "Leaving"

Once confirmed, click "Save".

Next, to set up clocking in at KING OF TIME when the message is "Entering", click "Register Clock-in Data (Clock-in)".
When the following screen is displayed, check the settings.

• "Title" → Editable
• "Account information linked with KING OF TIME" → Confirm if correct
• "Action" → Register Clock-in Data
  

The following screen will be displayed, so set the "Employee Identification Key".
Select from the output of "Retrieve Record (Employee Identification Key)".
*If not added to Yoom's database, it will not be displayed.

Next, set the "Work Date".
Select "Date" from the output of "Extract data from text".

Scroll down and set the following.

• "Clock-in Time" → Select time from the output of "Extract data from text"
• "Clock-in Type Code" → Clock-in

Once the setup is complete, click "Test" → "Test Success" → "Save".

Next, to set up clocking out at KING OF TIME when the message is "Leaving", click "Register Clock-out Data".
When the following screen is displayed, check the settings.

• "Title" → Editable
• "Account information linked with KING OF TIME" → Confirm if correct
• "Action" → Register Clock-out Data
  

Set "Employee Identification Key", "Work Date", and "Clock-out Time" in the same way as registering clock-in data.
Set "Clock-in Type Code" to clock-out.
Once the setup is complete, click "Test" → "Test Success" → "Save".

Step 4: Turn on the trigger button and verify the integration operation between LINE WORKS and KING OF TIME

Finally, click "Turn on Trigger" to complete the automation setup.
Check if the flowbot is operating normally.

Here is the template used this time.

Other Automation Examples Using LINE WORKS and KING OF TIME

1. This is a flow that detects missed clock-ins from the previous day in KING OF TIME and automatically notifies LINE WORKS.
By notifying LINE WORKS of missed clock-ins from the previous day, correction work can proceed smoothly.
Notifications can be sent at a fixed time every day, making it easier to keep track of missed clock-ins.

2. This is a flow that automatically adds the previous month's attendance information from KING OF TIME to Microsoft Excel every month.
It reduces the burden as there is no need to manually add the previous month's attendance information from KING OF TIME to Microsoft Excel.

3. This is a flow to register an employee in KING OF TIME when a row is added in Google Sheets.
Employee information added to Google Sheets can be synchronized with KING OF TIME, eliminating the need for manual data entry.
This prevents human error by removing the necessity to manually register the same data again.

Summary

This time, we explained the automation process where employees can complete clocking in on KING OF TIME just by sending a message to LINE WORKS.
With this, manual operations are no longer necessary, and attendance management can be streamlined.
This automation will be particularly helpful in addressing attendance management challenges in remote work environments.
Additionally, it offers the advantage of smoothly handling shift changes and irregular situations.

Yoom's automation is characterized by its ease of use and simple setup.
Utilize this template to simplify attendance management.