How to integrate Airtable with KING OF TIME to add employee information to KING OF TIME when it is registered in Airtable

The integration of Airtable and KING OF TIME using Yoom is an automation solution that can be easily implemented without programming knowledge. By using this flow, it may lead to improved efficiency for HR and labor personnel and reduce human errors and costs. In this article, we will explain in detail the specific benefits and implementation methods obtained through the integration of these two apps.

Recommended for

・Those who are utilizing Airtable and KING OF TIME respectively
・Managers looking for ways to smoothly proceed with onboarding new employees
・HR personnel at companies who want to reduce human errors in attendance management and employee information management
・Those who want to improve time reduction in data entry and cost efficiency while handling a large amount of employee information

Benefits and Examples of Integrating Airtable and KING OF TIME

Benefit 1: Achieving Smooth Onboarding

By simply entering information into Airtable, the content is also reflected in KING OF TIME, allowing for quick use of the attendance management system. This is expected to enable new employees to start their work smoothly and reduce stress for both labor personnel and employees. As a specific example, when a new employee joins, the labor personnel only need to enter basic information into Airtable, and attendance management in KING OF TIME will begin, allowing the new employee and onboarding personnel to start work with peace of mind.

Benefit 2: Reduction of Human Errors

By automatically reflecting the data in KING OF TIME when employee information is registered in Airtable, the risk of errors and data inconsistencies associated with manual transcription work can be reduced. For example, if a name or ID is incorrectly entered when registering a new employee, it can affect payroll and attendance management, but automation ensures data accuracy. Additionally, the time spent on data entry is reduced, allowing administrators to focus on more important tasks.

Benefit 3: Cost Reduction in Time Management Tasks

By automating data registration tasks in HR and labor management, it is expected to achieve a reduction in workload due to the reduced burden on personnel. Especially for companies handling a large amount of employee information, a reduction in manual data entry time can be expected. For example, by automating the monthly attendance data entry tasks, it may be possible to reduce response time and labor costs and allocate time to other resources.

[What is Yoom]

Now, let's create a flow bot using the template "Add to KING OF TIME when employee information is registered in Airtable."

How to Create an Integration Flow between Airtable and KING OF TIME

The general process until the flow is completed is as follows.

・Integrate Airtable and KING OF TIME with My Apps
・Copy the template
・Set triggers in Airtable and configure various operations in KING OF TIME and Airtable that follow
・Turn on the trigger and confirm the actual activation

Now, let's establish a new connection between the two apps to be integrated.

Step 1: Integrate Airtable and KING OF TIME with My Apps

(1) First, connect Airtable to My Apps.
After logging into your Yoom account, click "My Apps" on the left column and search for Airtable from "New Connection".

‍

‍

(2) The Airtable app icon will appear, so click it, select the relevant workspace from "Add Space", and click "Allow Access".

‍

‍

This completes the connection to Airtable.

(3) Next, let's connect KING OF TIME.
Search for and click the KING OF TIME app icon in the same way as before.
For instructions on how to register KING OF TIME with My Apps, please check this page.

‍

‍

Follow the displayed instructions to enter "Account Name" and "Access Token", then click [Add].
If the settings are successful, you will be redirected to the My Apps screen of your Yoom account.

Now the two apps are connected to your Yoom account.

After confirming that the new connection of the target app to the Yoom account is complete, click the icon for "Try this Template" in the template below.

‍

Click the "OK" button to copy the template.
You'll be taken to the "My Projects" screen in your Yoom account, so please check the template content.

‍

‍

There are three setup flows.

Step 2: Set up Airtable Trigger

(1) First, set up the Airtable app trigger.

‍

‍

From the My Projects on the left side of the Yoom account screen, click "【Copy】Add to KING OF TIME when employee information is registered in Airtable".

‍

‍

You'll be taken to a screen like the one above, so let's start setting up the flow bot.

(2) First, click on the trigger "When a record is registered".

‍

‍

(3) On this screen, enter the information for the Airtable account you want to link and click [Next].
Keep the trigger action as "When a record is registered".

(4) On the next screen, set the "Trigger Activation Interval" to 5 minutes, 10 minutes, 15 minutes, 30 minutes, or 60 minutes.
*Note that the trigger activation interval varies depending on the plan.

‍

‍

‍

(5) Check the annotations for "Base ID", "Table ID", and "Field Name for Created Time" and set them up.
Click [Test], and if there are no issues, click [Save].

Step 3: Set up KING OF TIME

(1) Next, set up to add information to KING OF TIME.
Click the second action, "Register Employee".

‍

‍

Enter the account information for the KING OF TIME you want to link and click [Next].

‍

‍

(2) On the next screen, set up to obtain employee information such as "Affiliation Code" and "Gender".
Click the input bar to reference the output obtained in the previous step, as shown in the image below.

‍

‍

(3) Once the input is complete, click [Test] and [Save].
In this step, you will obtain the 【Registered Employee Identification Key】 from the KING OF TIME side as output.
The obtained output can be referenced in subsequent actions.

‍

‍

Step 4: Set up Airtable

(1) Finally, set up to update the record information on the Airtable side.
Click the third action, "Update Record".

‍

‍

Ensure that the account information is entered and click [Next].

‍

‍

(2) On the next screen, enter "Base ID", "Table ID or Name", and "Record ID" with reference to the annotations.

‍

‍

(3) Additionally, enter any information in "Field Information" and "Value".
As an example, we are referencing the output 【Registered Employee Identification Key】 obtained in the KING OF TIME step.

‍

‍

(4) Once the input is complete, click [Test] and then [Save].

Step 5: Turn on the Trigger

A message will appear indicating that all settings are complete, so click "Turn on Trigger".

‍

‍

This completes the setup of the flow bot.

Here is the template used this time

Other Automation Examples Using Airtable and KING OF TIME

There are other examples of automation using Airtable and KING OF TIME on Yoom, so here are a few introductions.

① Update KING OF TIME Information When Employee Information is Updated in Airtable

By utilizing this template, you can update KING OF TIME information when employee information is updated in Airtable.
When employee information is updated in Airtable, it is automatically reflected in KING OF TIME, allowing you to update KING OF TIME information to the latest without waiting for manual input completion.

② Issue KING OF TIME Account from Yoom Database

This flow is recommended for companies that use KING OF TIME on a daily basis.
When new employees join, a new KING OF TIME account is issued based on the employee information in the Yoom database.
Automating account issuance is expected to reduce the time spent on this task.

③ Add information registered in kintone to KING OF TIME

By implementing this template, the content in KING OF TIME is automatically updated just by registering in kintone, allowing you to start managing working hours immediately after registration.
This flow is recommended for those handling tasks related to onboarding, managing working hours, and payroll calculations that automatically reflect the content registered in kintone to KING OF TIME, as well as for those looking to reduce manual input and automate processes.

Summary

The integration of Airtable and KING OF TIME is expected to greatly contribute to the efficiency of HR and labor management.
With benefits such as smooth onboarding, reduction of human errors, and cost savings in time management tasks, it is particularly useful for companies with a large number of employees.

By implementing Yoom's automation, you can achieve operational efficiency and cost savings, creating an environment where you can focus on more value-added tasks.