Integrating Airtable with HRMOS Attendance: How to Update Employee Information in HRMOS Attendance When Updated in Airtable

By utilizing HRMOS attendance management, you can smoothly manage employee attendance and potentially improve the efficiency of related tasks. Furthermore, by accumulating employee information in the Airtable database, you can also expect to enhance the efficiency of managing employee information beyond attendance data. However, manually updating HRMOS attendance information every time there is an update in Airtable's employee information can be cumbersome and may lead to human errors such as input mistakes. In this article, we will introduce a method to update HRMOS attendance information whenever employee information is updated in Airtable by linking Airtable with HRMOS attendance. We will clearly explain how to integrate applications without code using Yoom, so please read until the end. Recommended for: - HR personnel considering the efficiency of information update tasks while using Airtable and HRMOS attendance - Management department members aiming to reduce human errors in data management during hiring, resignation, or transfer - Corporate executives and HR managers who feel challenged by legal compliance and the improvement of attendance data consistency - Members of the corporate planning department seeking swift management decisions through the utilization of employee data Benefits and Examples of Integrating Airtable and HRMOS Attendance Benefit 1: Work Efficiency Improvement through Immediate Synchronization of HR Data By integrating Airtable and HRMOS attendance, when employee information is updated in Airtable, the data in HRMOS attendance can also be automatically reflected, eliminating the need for manual data entry. Especially in situations where frequent information registration is required, such as during new graduate recruitment, human errors are likely to occur, and a significant amount of time may be spent on data entry. However, by automating the data entry process, you can accurately reflect Airtable's employee information in HRMOS attendance, reducing manual effort and preventing human errors. This allows personnel to focus on high-value tasks, potentially improving overall productivity. Benefit 2: Legal Compliance and Consistency Improvement Accuracy is crucial for employee data to comply with laws and regulations. For example, if changes related to labor contracts are not quickly reflected in the attendance management system, discrepancies may arise in the contract content with employees, increasing the risk of labor disputes. However, by integrating Airtable and HRMOS attendance, consistent data management becomes possible, allowing for quick and accurate responses to audits or inquiries, potentially enhancing the company's reliability. Benefit 3: Accelerated Management Decisions and Data Utilization By integrating Airtable and HRMOS attendance, accurate employee data is quickly updated, allowing HR personnel and executives to access necessary information swiftly and make quick decisions. For instance, if a review of personnel allocation in a specific department is needed, it may be possible to immediately create a concrete action plan based on the latest attendance data. Being able to constantly check the latest employee data allows for optimized resource allocation, potentially strengthening the company's overall competitiveness. [About Yoom] How to Create an Integration Flow between Airtable and HRMOS Attendance From here, we will introduce how to create a flow where "when employee information is updated in Airtable, HRMOS attendance information is also updated" using Yoom to integrate Airtable and HRMOS attendance. You can create it with the following process: - Integrate Airtable and HRMOS attendance with My Apps - Copy the template - Set triggers in Airtable and operations in HRMOS attendance - Turn on the trigger button and verify the integration operation between Airtable and HRMOS attendance

If you are new to Yoom, please register for free from here.
※ If you are already registered, please log in.

Step 1: Connect Airtable and HRMOS Attendance to My Apps

1. How to register Airtable

After clicking "My Apps", search for Airtable from "New Connection".
The Airtable sign-in screen will be displayed, so select the account you want to connect and sign in.

Once signed in, the screen will change.
Click "+ Add Base" and select the base you want to connect with HRMOS Attendance.

Once the base is added, click "Allow Access".
This completes the Airtable My Apps connection.

2. How to register HRMOS Attendance
Next, search for HRMOS Attendance from "New Connection".

The above screen will be displayed, so enter the account name and access token and click "Add".
※ Reference）How to register HRMOS My Apps
‍This completes the HRMOS Attendance My Apps connection.

Next, copy the template to My Project and create a Flowbot.
Copy the template from "Try it" in the banner below.

Step 2: Set Up a Trigger to Activate When an Airtable Record is Updated

First, click on "When a record is updated" to set it up.

Title: You can change it as you like.

Trigger Action: Select "When a record is updated."
Once you've set this up, proceed to the next page.

Trigger Activation Interval: You can set it to 5 minutes, 10 minutes, 15 minutes, 30 minutes, or 60 minutes.
Note: The activation interval varies depending on the plan.
Base ID, Table ID, Last Modified Time Field Name: Set these according to the annotations.
Supplementary: For information on how to retrieve record field information, please refer to this article.

Once you've set this up, register a sample record in Airtable.
When you run the test, the output will be obtained, so check it and save the settings.

Step 3: Update User Information in HRMOS Attendance

Next, click on "Update User Information" to set it up.

Title: You can change it as you like.
Action: Select "Update User Information."
Once you've set this up, proceed to the next page.

Next, set up the items you want to update in HRMOS Attendance user information.

It is set up as shown above.
When an Airtable record is updated, you can automatically retrieve "Employee Number," "Last Name," "Last Name (Kana)," and "Email Address" to update HRMOS Attendance user information.

If there are no changes, proceed to run the test as is.

If successful, HRMOS Attendance user information will be updated, so confirm and save it.

Step 4: Turn On the Trigger

Once all the template settings are complete, the above screen will be displayed.
Turn on the "Trigger" to activate the flowbot.

This completes the flowbot for "Updating HRMOS Attendance information when employee information is updated in Airtable."

Introduction to Other Automation Examples Using HRMOS Attendance

Here are three examples of flows using HRMOS Attendance.

1. A flow that automatically registers a new user in HRMOS Attendance by searching for an employee in HRMOS when an email is received.
By utilizing this flow, you can automate the registration from email reception to HRMOS Attendance, potentially allowing for a swift start to attendance management for new employees.

This flow automatically registers clock-in and clock-out information in HRMOS attendance when entering or leaving 2.ovice.
By utilizing this flow, attendance information is recorded automatically, eliminating the need for manual input.

3. This is a flow that automatically updates HRMOS attendance when employee information is updated in Google Sheets.
By utilizing this flow, you can reduce manual errors and effort, allowing you to focus on other tasks.

Summary

In this article, we introduced a method to update HRMOS attendance information whenever employee information is updated in Airtable by integrating Airtable with HRMOS attendance.
By automating data entry tasks, you can streamline operations and improve information consistency.
Yoom offers a variety of flowbots and templates.
Please make use of Yoom's flowbot template list.