To integrate Airtable with KING OF TIME and update information in KING OF TIME whenever employee information is updated in Airtable

When managing employee information collectively in Airtable and handling attendance management with KING OF TIME, do you find it cumbersome to enter the same data twice?
Especially during transfer periods when the frequency of updating employee information is high, HR and labor department personnel might consider streamlining their operations.
By integrating Airtable with KING OF TIME, managing employee information becomes more efficient.
Not only does it save the hassle of manually entering the same information repeatedly, but it also helps maintain the accuracy of the information.
Here, we introduce a method to achieve integration between Airtable and KING OF TIME without coding.

Recommended for

Those who use Airtable and KING OF TIME and find data integration cumbersome
Personnel in companies looking to streamline HR and labor management
Those who frequently update employee information and want to reduce manual input between systems

Benefits and Examples of Integrating Airtable and KING OF TIME

Benefit 1: Improved Work Efficiency through Centralized Employee Information Management

By automatically reflecting updates made in Airtable to KING OF TIME, there is no need to repeatedly enter the same information.
Additionally, it can prevent data entry errors, omissions, and duplications, thereby improving management efficiency.
For example, during periods when employee information is frequently updated, such as departmental transfers or position changes, the burden on HR and labor departments can be reduced.
As a result, if the entire workflow is streamlined, more time can be allocated to other important tasks.

Benefit 2: Enhanced Information Accuracy through Automatic Updates

Automatically updating employee information from Airtable to KING OF TIME allows administrators to have the same information.
For instance, when managing shifts or work statuses in KING OF TIME, registering a new employee in Airtable automatically reflects that information in the attendance management system.
This can prevent operational issues due to missing employee information in KING OF TIME or discrepancies in information.

Benefit 3: Strengthened Interdepartmental Collaboration and Smooth Information Sharing

Automating data updates from Airtable to KING OF TIME significantly smoothens information sharing between HR and labor departments.
For example, when there is a change in employee information due to a departmental transfer, entering the information in Airtable by the HR department automatically reflects it in the attendance system, preventing oversight on the labor department's side. Integrating Airtable with KING OF TIME reduces unnecessary confirmation tasks between departments and facilitates smooth information sharing.

[About Yoom]

Next, we will introduce how to create a flowbot using Yoom, which allows app integration without programming, to update KING OF TIME information when employee information is updated in Airtable.

How to Create a Workflow for Integrating Airtable and KING OF TIME

The workflow to integrate Airtable and KING OF TIME using Yoom proceeds through the following four processes.

・Connect Airtable and KING OF TIME to My Apps
・Copy the template
・Set up Airtable in the app trigger
・Configure KING OF TIME

Step 1: Connect Airtable and KING OF TIME to My Apps

First, register My Apps to connect Airtable and KING OF TIME with Yoom.

1. Click "My Apps" on the left side of the Yoom management screen and then click "+ New Connection".

2. Enter Airtable in the search box and click on the displayed Airtable (OAuth).

3. Click "+add a base", select the base or workspace you want to connect with Yoom in Airtable, and then click "Grant access".
This completes the My Apps connection.

4. Similarly, click "+ New Connection" in My Apps, search, and select the displayed KING OF TIME.

5. Enter the account name and access token, then click "Add" to complete the My Apps registration.
※ Please refer to this help page for the account name and access token.

Step 2: Copy the Template

Next, copy the template to integrate Airtable and KING OF TIME with Yoom.

1. Open the above template and click "Try this template." 2. Click "My Projects" in the Yoom management screen, then click "[Copy] Update KING OF TIME information when employee information is updated in Airtable." * You can change the template title on the next screen. Step 3: Airtable App Trigger Settings Next, set up the trigger, which is the first step in the integration flow. The trigger for this flow activates when Airtable information is updated. 1. Click "App Trigger When Record is Updated." 2. Verify the account information linked with Airtable and ensure the trigger action is set to "When Record is Updated," then click "Next." 3. Set the trigger activation interval. * The selectable time for the trigger activation interval varies depending on the plan. 4. Enter the Base ID, Table ID, and Last Modified Time field name according to the description below the frame, then conduct a test. 5. If the test is successful, the Airtable information will be output as follows. Check the content, and if there are no issues, click "Save." Step 4: KING OF TIME Settings Finally, set up the automatic reflection of the updated information in Airtable to KING OF TIME. 1. Click "Integrate with App Update Employee Information." 2. Select the account information linked with KING OF TIME, ensure the action is set to "Update Employee Information," then click "Next." 3. Set the information to be reflected in KING OF TIME. The template includes the following items. Click each field to display the output from Airtable as shown below. By setting the necessary data from "When Record is Updated," the updated employee information in Airtable will be dynamically reflected in KING OF TIME. * This is created on the premise that the KING OF TIME employee identification key is already saved in the Airtable record. 4. Conduct a test, and if successful, click "Save" and finally turn the trigger ON to complete. This concludes the method for creating a flowbot that "updates KING OF TIME information when employee information is updated in Airtable."

Other Automation Examples Using Airtable and KING OF TIME

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

1. This is a flow where employee information registered in Airtable is also added to KING OF TIME.

When new employee information is registered in Airtable, the information is automatically added to KING OF TIME.
Companies that hire a large number of new employees can expect improved operational efficiency.

2. This is a flow that sends a notification to Slack when information is registered in Airtable.

When new employee information is registered, a message is automatically sent.
With this integration, once the HR department completes the registration of new employee data, a completion notification can be automatically sent to the labor department.

3. This is the flow for registering information from Google Forms to Airtable.

When an employee updates information, the content entered in the form can be automatically reflected in Airtable.
This integration reduces the data entry work for HR and labor department personnel.

Summary

The integration of Airtable and KING OF TIME greatly contributes to the efficiency of HR and labor departments.
This integration not only allows centralized data management but also enhances the accuracy of information.
Additionally, it facilitates smooth information sharing between departments.
When updating employee information in Airtable and integrating it with KING OF TIME without code, it can be easily achieved by using the introduced template.

Let's utilize Yoom to achieve efficient HR management.