Creating Employee Resource Databases With Airtable and Unito
A logo for Airtable, with a right click menu that says copy selection.
How to Create an Employee Resource Database With Airtable and Unito
A logo for Airtable, with a right click menu that says copy selection.

How to Create an Employee Resource Database With Airtable and Unito

When an employee joins your company, where do they go to find the information they need? Is there a single source of truth? Or are things littered across your Google Drive, Slack, your HR platform, or maybe even an intranet? 

If your employees need to work hard to find answers to their questions, you’re setting them up to fail. Not only do they waste valuable time searching for documents and resources, but other employees also get pulled in to help them, meaning this negative impact on productivity extends across the organization.

Building an employee resource database in Airtable is a straightforward way to create a single source of truth and eliminate this issue. And, with Unito, you can automate data entry, so that database is always accurate and up to date — no manual, time-consuming maintenance required. Here’s how to do it!

What’s an employee resource database?

An employee resource database is a repository of information, data, documents, and other resources that employees can access to make their work lives easier. It can be consulted asynchronously at any time and should answer the FAQs that all new employees have when they join your company. 

Why use Unito and Airtable?

Airtable is a flexible database tool that supports the ability to have multiple sheets within each base. This allows you to gather and organized multiple types of information into one place — the perfect single source of truth for team members. And, thanks to its robust field types and customization, each of these sheets can be adapted to perfectly suit the needs of your team and business.

Then there’s Unito — the Thor to Airtable’s Captain America. Unito is a no-code integration platform that allows you to sync information bidirectionally across your business tools, including Airtable. In just a few clicks, you can build flows that automatically update records between multiple Airtable bases, or pull in information from a secondary tool. When multiple teams use Airtable to gather and organize resources, there’s no easier way to sync everything into your employee resource database and keep it updated automatically. 

Building your database in Airtable

Building a new base in Airtable is easy. You can start from scratch, or use Unito’s employee resource database template, to save yourself a ton of time in getting started. 

While there’s no standard for what should be included in this type of database, the Unito template uses the following sheets as a starting point: 

  • Employees: If your company has fewer than 100 employees, actually listing them out can be really useful for employees new and old. Make sure to include their role, department, areas of responsibilities, contact information, and a little bit about them.
  • Teams: While it might seem obvious to you, many people may not be aware of the various teams within each department across the organization and their makeup. List off the teams, the team members, their manager, their mandate, and link to any relevant playbooks or documentation.
  • Tool directory: What are the tools in use within your business? What purpose do they each serve? Who owns them? How does a team member get access? Is there training? Every new hire brings their own tool preferences and knowledge, so having a tool directory can really help familiarize them with your stack.
  • Training catalog: All new employees need to be trained. And ongoing training is important for employee retention. You may want to consider recording your training sessions so people can do them asynchronously. From there, log them in your catalog and include a summary of the training, a link to training materials, and the recording. 
  • Important documents and playbooks: The final piece of the puzzle. Save team members from hunting through strangely named Google documents gathered over the years. Instead, collect up-to-date documents and playbooks into your employee resource database. And make sure to include a document type, description, and hyperlink or file. 

Each of these sheets can include any number of fields depending on how much detail you want for your employee resource database. Just make sure that every sheet includes a last modified time field. This identifies how recently an entry has been updated, which can help you identify old content you may want to review. It’s also an essential field to make Airtable work with Unito.

The end result — populated with an example — should look something like this:

Now that it’s built, here’s how you make it work.

Populating your employee resource database with Unito

With your resource database set up in Airtable, it’s time to build the Unito flows that will keep it in sync with your other bases. Here’s how it’s done.

Start by connecting Airtable to Unito.

Next, pick the bases you want to connect. First, choose the employee resource database. Second, pick another internal database — maybe a team-specific base where some of your resources are already located. In this example, I’ve connected a base called “Content Funnel List,” which the marketing team uses to track content it produces.

Now, it’s time to choose your flow direction. If you want to be able to create records within your resource database, choose a bidirectional flow. If you only want to sync records into your database, you can make it a one-way flow, starting from the secondary data source.

After choosing flow direction you can build custom rules to decide how much information gets from one base to the other.

You could choose to filter records by a dropdown field, for example, and only sync in content that is marked “resource.”

After the rules screen, it’s time to customize your field mappings.

Now it’s time to add your field mappings. You can completely customize your mappings so the information lands exactly where you need it to be within your resource database. If, for example, fields are named differently in different bases, your mappings save you from having to move things around when records are synced over.

Make sure your fields are mapped for two-way updates. Even if you only want new records syncing into your database, you want the ability to make changes in either base. This allows you to change key information like who a trainer is, who manages a team, and more as your company scales.

After mapping your fields, you’re done! You can launch your flows and watch as Airtable records are automatically synced from one base to the other. Build flows for the rest of your bases, or for other tools where these resources are stored, and you’ll have a single source of truth for all employees to use.

Essential Unito features for this use case

One-way create, two-way update

That’s our term for one-way Unito flows with two-way field mappings. With this configuration, you can keep information up to date in both Airtable bases. You could even tailor your flow further so certain fields only get updated in one direction.

Custom fields

Airtable is a customizable platform stuffed full of custom fields. With Unito, you can sync these fields back and forth with flows that adapt to your projects. To make the most of this use case, you’ll need the unlimited custom field support that comes with Unito’s Company and Enterprise plans.

Advanced mappings

Customizing your field mappings is how you decide where information goes from base to base. In this use case, field mappings are how we can translate information from team-specific boards into something useful for the entire business.

How resourceful!

An employee resource database is an underrated asset for any business. It helps get new employees up to speed while saving existing staff from having to answer a ton of questions. Building your single source of truth in Airtable makes the entire process easy, especially when Unito is doing all the entry and update work for you!

Want to get more out of Airtable?

Find out how Unito's Airtable integration can help you do more, in less time, across multiple bases and tools.

Learn more