Airtable + Personio

Create records in Airtable for each new absence in Personio

When a new absence is noted in Personio, this tool promptly updates the corresponding Airtable. By doing so, it eliminates the need for manual entry, keeping your data up-to-date and accurate. This seamless process is crucial for effective leave and absence management, providing a simple yet ingenious solution for maintaining your HR records in an orderly manner.

When this happens...
New Absence
Triggers when a new absence is created.
TriggerPolling
automatically do this!
Create Record
Creates a new record with auto-populating fields.
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

Supported triggers and actions

New Absence
Triggers when a new absence is created.
Trigger
Polling
Try It
- Person ID
- Legal Entity ID
Trigger
Polling
Try It
New Employee
Triggers when a new employee is created.
Trigger
Polling
Try It
New Employment Created
Triggers when one or more Employment details of a Person are created
Trigger
Instant
Try It
Employment Updated
Triggers when one or more Employment details of a Person are updated
Trigger
Instant
Try It

Updated Attendance
Triggers when an attendace record is updated.
Trigger
Polling
Try It
- EmployeeRequired
- Absence typeRequired
- Start dateRequired
- End dateRequired
- Half-day Off Start DateRequired
- Half-day Off End DateRequired
- Comment
- Skip Approval
Action
Write

- File
- File Title
- Category ID
- File Comment
Action
Write
- File
- File Title
- Category ID
- File Comment
Action
Write
- Employee IDRequired
Action
Search
- Owner IDRequired
- Document Name
- Document Type
- Category ID
- Created On or After
- Created Before
Action
Search
- Employee IDRequired
- EmployeeRequired
- Absence typeRequired
- Start dateRequired
- End dateRequired
- Half-day Off Start DateRequired
- Half-day Off End DateRequired
- Comment
- Skip Approval
Action
Search or write
- EmailRequired
- File
- File Title
- Category ID
- File Comment
Action
Search or write
- Help Text
- BaseRequired
- TableRequired
- Last modified time columnRequired
- Limit to view
- Include file contents?
Trigger
Polling
Try It
- Cache Copy
- BaseRequired
- TableRequired
Action
Write
- BaseRequired
- TableRequired
- RecordRequired
Action
Write
- Api Docs Info
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- BaseRequired
- TableRequired
- Search by Field
- Search Value
- Search type
- Search Formula
- Limit to View
Action
Search
- BaseRequired
- TableRequired
- Search by Field
- Search Value
- Search type
- Search Formula
- Limit to View
Action
Search or write

New Attendance
Triggers when an employee or manager logs an attendance record for the day.
Trigger
Polling
Try It
- Owner IDRequired
- Category ID
- Created On or After
- Created Before
Trigger
Polling
Try It
Employee Updated
Triggers when an employee is updated.
Trigger
Polling
Try It
Employment Terminated
Triggers when an existing employment is terminated.
Trigger
Instant
Try It
New Open Position
Triggers when a new open position is created.
Trigger
Polling
Try It
- Job PositionRequired
- First NameRequired
- Last NameRequired
- EmailRequired
- Gender
- Phone
- Location
- Salary Expectations
- Available From
- Message
- Birthday
- Recruiting Channel ID
- File
- Desired File Name
- File Category
Action
Write
- Project ID
- EmployeeRequired
- DateRequired
- Start TimeRequired
- End TimeRequired
- BreakRequired
- CommentRequired
Action
Write
- Attendance IDRequired
- Date
- Start Time
- End Time
- Break Time
- Comment
Action
Write
- Employee IDRequired
- Category IDRequired
- FileRequired
- Desired File NameRequired
- File Comment
Action
Write
- Employee IDRequired
- Include Pending
Action
Search
- EmailRequired
Action
Search
- Employee IDRequired
- Include Pending
- Project ID
- EmployeeRequired
- DateRequired
- Start TimeRequired
- End TimeRequired
- BreakRequired
- CommentRequired
Action
Search or write
- BaseRequired
- TableRequired
- Limit to View
- Include attachment content
Trigger
Polling
Try It
- BaseRequired
- TableRequired
Action
Write
- BaseRequired
- TableRequired
- Help Text
- Primary lookup fieldRequired
- Secondary lookup field
Action
Write
- BaseRequired
- TableRequired
- RecordRequired
Action
Write
- BaseRequired
- TableRequired
- Field to search
- Search value
- Search type
- Search formula (advanced)
- Limit to view
- Include attachment content
- Max records
Action
Search
- BaseRequired
- TableRequired
- Field to search
- Search value
- Search type
- Search formula (advanced)
- Limit to view
- Include attachment content
- Max records
Action
Search or write

About Airtable

Organize anything with Airtable, a modern database created for everyone. Airtable is a fast and flexible way to create tables to keep track of anything, from sales leads to vacation planning to inventory management.

Learn more