Dashboards in minutes

Connect Sólides DP to Airtable: Dashboards in Minutes

Get started for free

No credit card required | 14 days | 10 million records | 30 pipelines

sso google logo
Sign up with Google
sso facebook logo
Sign up with Facebook
sso microsoft logo
Sign up with Microsoft
sso linkedin logo
Sign up with Linkedin

or sign up with your email

By signing up, you agree to Kondado’s Terms of service and Privacy policy

Connect Sólides DP to Airtable

Connecting your Sólides DP time tracking information to Airtable gives your HR and operations teams a flexible workspace to analyze attendance patterns and workforce productivity. With Kondado, you can replicate employee hours, daily summaries, and staff details directly into Airtable without writing code or managing complex databases. Simply select your data source, choose which pipelines to activate, and watch your attendance data flow into organized bases where you can build custom views and share insights with stakeholders.

13
available pipelines
276
extractable fields
  • ✓No code, no spreadsheets
  • ✓Auto-refreshed data
  • ✓14-day free trial

Try out all the features for free for 14 days

Kondado connects Sólides DP to Airtable through a direct integration that replicates your Daily Summary and Employees pipelines on a configurable schedule, enabling you to track worked hours, overtime trends, and team availability in flexible Airtable bases without technical setup.

This setup eliminates the need for manual CSV downloads and gives you a centralized view of your workforce data. You can configure updates to run every few minutes or daily, ensuring your attendance tracking stays aligned with actual operations while your team makes informed decisions based on current information. The automated flow means your managers always see up-to-date staffing levels and can respond quickly to scheduling gaps or overtime situations.

Our prices start from $19 USD/month, and you can try Kondado for free for 14 days with no credit card required

Try out all the features for free for 14 days

Available data

Sólides DP data available in Airtable

Each item below is automatically replicated by Kondado from Sólides DP into Airtable — no schema setup, no manual mapping.

13
available pipelines
276
extractable fields
∞
Auto-refresh

Available integrations

Daily Summary
Includes information such as worked hours, paid hours, and compensatory hours. Fields like id, employeeid, and isholiday help analyze employee attendance.
Employees
Contains data about employees, including name, email, and admission date. Fields like id, jobroledto__id, and birthdate provide essential details about each employee.
Time Clock Records
Employee clock-in and clock-out punches, one per row, with date and time, entry and exit geolocation, workplace, and adjustment and validation flags (fingerprint, facial recognition).
Time Adjustments (incl. vacations and leaves)
Time adjustments such as vacations, medical certificates, days off, and excused absences. Each row has the period, reason, employee, and approval status, useful for tracking justified absences.
Adjustment Reasons (incl. vacations and leaves)
Registered adjustment reasons, such as vacation, medical certificate, day off, and excused absence. This is the table that classifies time adjustments.
Job Roles
Company job roles, with description, CBO (Brazilian occupation code), and base salary.
Work Schedules
Registered work schedules (shifts), one per row, to compare the planned workday with the recorded hours.
Workplaces
Workplaces (departments and units), active and inactive, to analyze attendance and hours by unit.
Managers
Registered managers and their matching employee record, to build attendance analysis by team and leadership.
Companies (branches)
Registered companies (headquarters and branches, by CNPJ). Employees point to their company through the company__id field, so attendance and hours can be analyzed by branch.
Time Clock Rules
Registered time clock rules: tolerances, night hours, hour bank vs. overtime control, and hour bank percentages and limits.
Hour Bank (current balance)
Current hour bank balance for each employee at read time. The table is rewritten on every run, as a snapshot of the balance, without history.
Time Edit Justifications
Justifications available for manually editing clock punches, with the attachment and note requirements of each one.

Try out all the features for free for 14 days

With the Daily Summary pipeline flowing into your Airtable base, you can create views that highlight overtime patterns, identify employees approaching compensatory hour limits, and spot attendance trends across departments. The Employees pipeline brings essential staff information including admission dates and job roles, allowing you to correlate tenure with productivity metrics or filter reports by team. Together, these pipelines transform raw time clock data into actionable workforce intelligence that helps managers optimize scheduling, reduce absenteeism, and ensure compliance with labor regulations while maintaining a single source of truth for HR decisions.

Try out all the features for free for 14 days

How to create Sólides DP dashboards in Airtable

Visualize your data automatically — no spreadsheet exports or custom scripts.

1
Add Sólides DP as Your Data Source

Log into Kondado and add Sólides DP as a new data source using your existing account credentials to establish the connection.

2
Select Airtable as Destination

Choose Airtable as your destination and map the Daily Summary and Employees pipelines to specific bases where your HR team can access the information.

3
Configure Updates and Build Reports

Set your preferred update frequency from 5 minutes to daily intervals to keep information current, then create custom views and reports in Airtable that track attendance trends and overtime patterns for your management team.

Access Sólides DP data in Airtable and combine it with dozens of other data sources

If the source you want is not listed, drop us a chat message. We love to add new sources!

Visualize Sólides DP data in other BI tools

If the software you need is not listed, drop us a messagem. You can use almost every tool

Hundreds of data-driven companies trust Kondado
arezzo
brf
Contabilizei
dpz
Experian
grupo_soma
multilaser
olist
unimed
v4_company
webmotors
yooper

Frequently Asked Questions (FAQ)

Answers about visualizing Sólides DP data in Airtable automatically

How do I connect Sólides DP to Airtable using Kondado? ▼
Start by adding Sólides DP as a data source in your Kondado account and authenticate with your existing credentials. Then select Airtable as your destination, choose which bases will receive the data, and activate the Daily Summary and Employees pipelines to begin replication.
What attendance KPIs can I track in Airtable with Sólides DP data? ▼
You can monitor average daily worked hours, track overtime accumulation by employee, analyze compensatory hour balances, and identify holiday work patterns. These metrics help you spot burnout risks early and ensure fair distribution of shifts across your team.
How often does the Sólides DP data update in my Airtable base? ▼
Kondado lets you configure automated updates on a schedule that fits your business needs, ranging from every 5 minutes to daily intervals. This keeps your attendance reports current without requiring manual data exports or spreadsheet updates.
Can I build a vacation and time-off dashboard in Airtable with this data? ▼
Yes, by combining the Daily Summary pipeline with Airtable's calendar and grid views, you can create visual trackers for paid time-off balances, sick day patterns, and leave requests. This gives managers a clear overview of team availability for better workforce planning.
Is there a pre-built template for Sólides DP dashboards in Airtable? ▼
Kondado provides the data infrastructure for you to build custom dashboards tailored to your specific HR workflows and reporting needs. You can design your own views in Airtable using the replicated Daily Summary and Employees data to match your company's unique organizational structure.
How can I share Sólides DP attendance reports with my team in Airtable? ▼
Once your data flows into Airtable, you can share specific views with department heads or create read-only interfaces for executives using Airtable's built-in collaboration features. This ensures stakeholders see relevant attendance metrics without accessing sensitive time clock administration.
Can I combine Sólides DP data with other business data in Airtable? ▼
Absolutely, you can import additional datasets from Google Sheets or other sources into the same Airtable base to correlate attendance with sales performance or project deadlines. This unified view helps you understand how workforce availability impacts overall business outcomes.
What specific fields from Sólides DP are available in Airtable? ▼
The Daily Summary pipeline includes worked hours, paid hours, compensatory hours, and holiday indicators, while the Employees pipeline contains names, emails, admission dates, birthdates, and job role identifiers. These 153 fields give you comprehensive workforce data for detailed analysis.

Try out all the features for free for 14 days