How to integrate ovice and KING OF TIME to clock in on KING OF TIME when entering an ovice space

Step 1: Register ovice and KING OF TIME as My Apps

Let's register ovice and KING OF TIME as My Apps in Yoom. By registering My Apps in advance, the automation settings will be smoother.

First, register ovice as a My App. Click "My Apps" → "New Connection" on the left side of the Yoom screen. A list of apps will be displayed, so search for ovice or use the search bar.

The following screen will be displayed, so set the "Account Name," "Access Token," and "Client ID." Check here to obtain the Client Secret and Client ID.

Next, register KING OF TIME as a My App. Search for KING OF TIME in the search bar or find it from the list as before. When the following screen is displayed, set the "Account Name" and "Access Token." For detailed settings, check here.

Once both My Apps are registered, ovice and KING OF TIME will be displayed 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 check the "Title" and "Description".
If you want to make changes, please do so on the following screen.
First, to set up ovice, click "When Webhook is received (Online)".

Step 3: Set up the ovice trigger that initiates the flow and the subsequent KING OF TIME operation

When the following screen is displayed, check the settings.

• "Title" → Can be changed as desired
• "Account information linked with ovice" → Check if correct
• "Trigger Action" → When Webhook is received
  

The following screen will be displayed, so click within the red frame to copy the Webhook URL.
Set up the Webhook in the ovice management screen.
You can check the types of ovice triggers here.
Set the value in the red frame at the bottom in the post data section.
Send a Webhook event or execute the trigger event and click "Test" → "Test Successful" → "Save".

Next, to set up to retrieve 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 desired
• "Database App" → Yoom
• "Execution Action" → Retrieve Record
  

Pre-store employee list data in the Yoom 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 new, 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 Integration".
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 email address to retrieve the record.
Use the ovice output to set it up as follows.
The output can be displayed by clicking the arrow in the red frame.
Once the setup is complete, click "Test" → "Test Successful" → "Save".

Next, to set up extracting data from text, click "Extract Data from Text (Timestamp Date & Time)".
※AI operations are features available in some paid plans.
In other plans, the operation of the flow bot 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 AI features (operations).

When the following screen is displayed, check the settings.

• "Title" → Can be changed as desired
• "Conversion Type" → Extract text from data within 3,500 characters (2 tasks)
  

Check the following precautions.

Next, set the "Target Text".
Click in the order of "Basic Information" → "Flow Bot Activation Date and Time" → "%Y-%m-%d %H:%M".

Scroll and set the "Items to Extract".
Since we are extracting the date and time, set it as follows.
Once the setup is complete, click "Test" → "Test Successful" → "Save".

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

• "Title" → Can be changed as desired
• "Account information linked with KING OF TIME" → Check if correct
• "Action" → Register Timestamp Data
  

The following screen will be displayed, so set the "Employee Identification Key".
Use the output from "Retrieve Record (Employee Identification Key)" to set it.
Set it as follows.

Scroll and set "Work Date" and "Timestamp".
Use the output from "Extract Data from Text (Timestamp Date & Time)" to set it.
Set "Timestamp Type Code" as clock-in.
If there are other necessary items, set them and click "Test" → "Test Successful" → "Save".

Step 4: Turn on the trigger button and check the integration operation of ovice and KING OF TIME

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

Here is the template used this time.

Other Automation Examples Using ovice and KING OF TIME

1. This is a flow where you automatically clock out in KING OF TIME when you leave a space in ovice.
‍Contrary to this template, you can also automatically clock out when leaving. This eliminates the need for manual clocking and helps prevent human errors.

This is a flow that automatically notifies Microsoft Teams when entering or leaving 2.ovice.
Notifications of entering and leaving are sent to Microsoft Teams, making it easier to manage and confirm attendance.
Notifications to Microsoft Teams are no longer needed each time you enter or leave, saving effort.

3. This is a flow that automatically adds the previous month's attendance information from KING OF TIME to a Google Spreadsheet every month.
It is an automation recommended for those who manage attendance data with Google Spreadsheets.
It eliminates the need for manual input, reducing the burden on the person in charge.

Summary

The automation of KING OF TIME attendance stamping triggered by entering ovice significantly reduces the effort of stamping.
Especially in a remote environment, there is no need to launch KING OF TIME for stamping, allowing work to proceed quickly.
Additionally, it eliminates missed or incorrect stamps, enabling accurate attendance management, which is a significant advantage.
As a result, it reduces the burden on employees and shortens the time administrators spend checking attendance, contributing to improved transparency in operations.

Please consider utilizing Yoom's automation for attendance management to aim for improved efficiency.