Daily Resource Availability Check
You assign a new task but don't know if your team has capacity, whether the design tool license is free, or if the contractor is booked. Notis checks your Airtable resources table every morning and surfaces what's available.
Trigger
Recurring schedule
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Action
List records
Retrieves records from an airtable table, with options for filtering, sorting, pagination, and specifying returned fields.
Why this helps
You assign work without knowing if the resources exist, leading to promises you can't keep or projects on hold waiting for tools you forgot to check.
- Know what's available before assigning
- No overbooking surprises
- Quick allocation decisions
- Full visibility on resources
Setup
Build it in a few focused steps.
- 1Connect Airtable to Notis (one-time setup).
- 2Tell Notis: 'Every morning at 8 AM, pull my Airtable resources table and show me what tools, team members, and contractors are available today.'
- 3Set your timezone and notification channel.
- 4Create a simple Airtable resources table with status (Available/Booked/Maintenance) if you don't have one.
- 5Test by running the automation and checking that availability is surfaced correctly.
Questions about this workflow
What counts as a 'resource' for this?
Anything you want to track: team members, design tools, contractors, equipment, software licenses. You define what's in your resources table.
Can this create new resource records?
This automation reads availability. To add new resources, you create records in Airtable manually or via another automation.
Does this update based on Asana assignments automatically?
You can set it up that way. When someone is assigned in Asana, update their availability status in Airtable as 'Booked'.
Can I get an alert if something becomes unavailable unexpectedly?
Yes. Set up a watch for status changes and Notis will alert you.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Asana to Airtable. A trigger fires from one place; an action lands in another.
Asana triggers
Airtable actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Create base
Creates a new airtable base with specified tables and fields within a workspace; ensure field options are valid for their type.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Create Comment
Creates a new comment on a specific record within an airtable base and table.
Attachment Added to Task
Triggers when an attachment is added to a task.
Create Field
Creates a new field within a specified table in an airtable base.
New Comment on Task
Triggers when a comment is added to a task in a project.
Create multiple records
Creates multiple new records in a specified airtable table.
New Task Created
Triggers when a new task is created in a project.
Create a record
Creates a new record in a specified airtable table; field values must conform to the table's column types.
Task Moved to Section
Triggers when a task is moved to a section in a project.
Create table
Creates a new table within a specified existing airtable base, allowing definition of its name, description, and field structure.
Tag Added to Task
Triggers when a tag is added to a task. Note: Asana's event structure is inverted for tag events — the resource is the task and the parent is the tag. So parent.gid gives the tag GID.
Delete Comment
Deletes an existing comment from a specified record in an airtable table.
Task Updated
Triggers when a task is updated in a project.
Delete multiple records
Deletes up to 10 specified records from a table within an airtable base.
Connect any two apps with Notis in the middle.
Asana and Airtable, 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 Airtable.