Turn Airtable structure changes into DeskTime projects
When an Airtable base changes to support a new initiative, tell Notis what should become a DeskTime project and whether it needs an initial task.
Trigger
Base Schema Changed
Triggers when tables, fields, or views change in an Airtable base.
Action
Create Project with Optional Task
Tool to create a new project with an optional initial task. use when you need to set up a new desktime project programmatically.
Why this helps
A new project can be ready to track in Airtable long before anyone remembers to set it up in DeskTime.
- Start time tracking setup when a base's tables, fields, or views change.
- Use a prompt to explain which schema changes represent a project.
- Include an optional initial task when the work needs one.
Setup
Build it in a few focused steps.
- 1Connect Airtable and DeskTime once in the Notis portal.
- 2Create an automation in Notis by naming it and describing the desired project outcome in plain language.
- 3Pick Airtable Base Schema Changed as the trigger.
- 4Choose where run reports should go.
- 5Test with one real schema change and review the result.
Questions about this workflow
Does every schema change have to create a DeskTime project?
No. Describe in your instruction which changes should represent a project and what Notis should create. The trigger fires on a schema change, and Notis can interpret returned data.
Can the automation create a first task too?
Yes. DeskTime's Create Project with Optional Task action supports an optional initial task. Describe it in your instruction when it is useful.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Airtable to Desktime. A trigger fires from one place; an action lands in another.
Airtable triggers
Desktime actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Create Project with Optional Task
Tool to create a new project with an optional initial task. use when you need to set up a new desktime project programmatically.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Get Account Details
Tool to retrieve detailed information about the authenticated user's company account. use after confirming the api key is valid to fetch company name, work settings, account timezone, and timestamp.
Base Metadata Changed
Triggers when an existing Airtable base changes its name or permission level.
Get All Company Employees
Tool to list all employees in the company, including their roles and statuses. use after confirming valid credentials to fetch the organization’s roster.
Base Schema Changed
Triggers when tables, fields, or views change in an Airtable base.
Get Employee Data
Tool to fetch data for all employees within the company. use after verifying the api key is valid.
User Profile Changed
Triggers when the connected Airtable user's profile information changes.
Get Employee Projects
Tool to retrieve information about projects assigned to employees, including project names, durations, and statuses. use when you need to fetch per-employee project tracking data for a specific date.
View Created
Triggers when a new view is created in an Airtable base.
Get Employee Projects and Apps
Tool to retrieve an employee's tracked projects and application usage. use when you need combined project/app time data for a given employee and date (defaults to current user and today). example: "get projects and apps for employee 711867 on 2025-07-28."
View Deleted
Triggers when a previously known Airtable view is deleted.
Get Projects List
Tool to retrieve all active projects for the company, including related tasks. use when you need projects overview after authentication.
View Metadata Changed
Triggers when an Airtable view changes its name or type.
Ping DeskTime API
Tool to check the api's availability and confirm the service is operational. use when you need to verify that the desktime api is reachable and responsive.
Connect any two apps with Notis in the middle.
Airtable and Desktime, or any other combination from 1,000+ integrations.
When this happens · Trigger
Do this · Action
Save your first hour today.
7-day trial of any paid plan, with 20$ of usage included.
No card. Works with personal or business Desktime.