LaborChart

The LaborChart Developer Hub

Welcome to the LaborChart developer hub. You'll find comprehensive guides and documentation to help you start working with LaborChart as quickly as possible, as well as support if you get stuck. Let's jump right in!

Get Started    

AirTable Integration Overview

Classification

Data Types

  • People
  • Projects

Data Flow

  • Unidirectional; AirTable into LaborChart only

Sync Frequency

  • Twice daily

Connection Requirements

  • AirTable API Key
  • Company ID / Account ID

Example Integrated AirTable Fields

📘

Note

Your AirTable database will feature tables and fields with naming conventions that differ from what is listed below. This list is intended to be a baseline example and the integration will be tailored to match your system exactly.

People

LaborChart Field

AirTable Field

First Name

PEOPLE_FNAME

Last Name

PEOPLE_LNAME

Status (Active, Pending, or Inactive)

PEOPLE_ACTIVEYN

Employee ID

PEOPLE_ID

Address 1

PEOPLE_ADDRESS1

Address 2

PEOPLE_ADDRESS2

City

PEOPLE_CITY

State

PEOPLE_STATE

Zipcode

PEOPLE_ZIP

Phone Number

PEOPLE_PHONE

Email

PEOPLE_EMAIL

Hourly Wage

HR_PAYRATE

Date of Birth

PEOPLE_DOB

Hired Date

PEOPLE_DATE_HIRED

Gender

PEOPLE_GENDER

Job Title

PEOPLE_POSITION_ID

Union

PEOPLE_UNION

Projects

LaborChart Field

AirTable Field

Project Name

PROJECT_NAME

Status (Active, Pending, or Inactive)

PROJECT_DEAL_STATUS

Project ID

PROJECT_CODE

Address 1

PROJECT_ADDRESS

City

PROJECT_CITY

State

PROJECT_STATE

Zipcode

PROJECT_ZIP

Start Date

PROJECT_DEAL_CLOSE_DATE

Est. End Date

PROJECT_COMPLETION_DATE

Customer

CM_CUSTOMER_NAME

Project Manager

PROJECT_PM

Project Type

PROJECT_TYPE

Have questions? Reach out to us at [email protected]