Keep Airtable KPI records current
Have Notis review available KPI information and update the corresponding Airtable record when a status change is clear.
Trigger
Recurring schedule
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Action
Update record
Modifies specified fields of an existing record in an airtable base and table; the base, table, and record must exist.
Why this helps
Teams can waste attention reconciling status across scorecard views and a separate follow-up base.
- Reduce manual status reconciliation.
- Keep existing Airtable follow-up records useful.
- Avoid updating records when the change is not supported by available information.
Setup
Build it in a few focused steps.
- 1Connect BSC Designer and Airtable once in the Notis portal.
- 2Create an automation and describe how to identify matching records and supported status changes.
- 3Ask Notis to update existing Airtable KPI records only when available BSC Designer information supports the change.
- 4Choose a recurring schedule as the trigger and select where run reports go.
- 5Test with one real example and confirm the matching record.
Questions about this workflow
Will this create new records?
No. This workflow updates existing records. Use a separate create-record workflow when new follow-up should be added.
What if Notis cannot confirm a change?
Instruct Notis to leave the record unchanged and report that the available information was insufficient.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link BSC Designer to Airtable. A trigger fires from one place; an action lands in another.
BSC Designer 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.
Create Field
Creates a new field within a specified table in an airtable base.
Create multiple records
Creates multiple new records in a specified airtable table.
Create a record
Creates a new record in a specified airtable table; field values must conform to the table's column types.
Create table
Creates a new table within a specified existing airtable base, allowing definition of its name, description, and field structure.
Delete Comment
Deletes an existing comment from a specified record in an airtable table.
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.
BSC Designer 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.