- Getting started with Airtable
- Introduction to Airtable basics
- Contacting Airtable Support Updated
- Airtable home screen
- Glossary of Airtable terminology
- Airtable technical requirements
- Feature differences between Airtable on desktop and mobile
- Airtable keyboard shortcuts
- Using Markdown in Airtable
- Adding descriptions in Airtable
- Finding Airtable IDs
- Airtable Automations
- Automations Overview
- Automation feature walkthroughs
- Integrated automation walkthroughs
- Airtable automation walkthroughs
- Linking existing records using automations
- Conditional groups of automation actions
- Repeating groups of Airtable automation actions
- Creating recurring records using automations
- How to delay Airtable automation runs
- Prevent automations from triggering by mistake
- Use automations to timestamp status updates
- Automation Triggers
- Airtable Triggers
- Airtable automation trigger: When record matches conditions
- Airtable automation trigger: When a form is submitted
- Airtable automation trigger: When record created
- Airtable automation trigger: When record updated
- Airtable automation trigger: When record enters view
- Airtable automation trigger: At scheduled time
- Airtable automation trigger: When webhook received
- Airtable automation trigger: When a button is clicked
- Airtable automation trigger: When email received Updated
- Integrated Triggers
- Airtable Triggers
- Automation Actions
- Airtable Actions
- Airtable automation action: Send email Updated
- Airtable automation action: Create record
- Airtable automation action: Update record
- Airtable automation action: Find records
- Airtable automation action: Sort list
- Airtable automation action: Run a script Updated
- Airtable automation action: Generate with AI
- Integrated Actions
- Airtable automation actions: Slack
- Airtable automation actions: Google Workspace
- Airtable automation action: Send MS Teams message
- Airtable automation actions: Outlook
- Airtable automation actions: Jira Cloud
- Airtable automation actions: Jira Server / Data Center
- Airtable automation actions: Salesforce
- Airtable automation action: Create post in Facebook Pages
- Airtable automation actions: GitHub Issues
- Airtable automation action: Hootsuite post
- Airtable automation action: Send Twilio SMS
- Airtable Actions
- Airtable Bases
- Using Airtable Cobuilder
- Airtable bases overview
- Creating and managing Airtable bases
- Structuring bases in Airtable
- Moving bases between workspaces in Airtable
- Creating and managing tables in Airtable
- Creating Airtable base share links
- Importing third-party data into Airtable
- Using insights in Airtable
- Troubleshooting Airtable base performance
- Airtable Betas
- Collaborating in Airtable
- Airtable Enterprise Support
- General Enterprise information
- External badging in Airtable
- Using app library and components in Airtable Updated
- Ask an Expert beta overview
- European data residency at Airtable
- Airtable user groups overview
- Airtable Enterprise API
- Creating and managing data retention policies in Airtable
- eDiscovery APIs in Airtable
- Airtable and data loss prevention
- Accessing Enterprise audit logs in Airtable
- Set up Jira Server / Data Center to connect with Airtable
- Admin panel pages
- Airtable admin panel overview
- Users - Airtable enterprise admin panel
- Airtable admin panel user details
- Groups - Airtable admin panel
- Workspaces - Airtable Enterprise Admin Panel
- Bases - Airtable admin panel
- Interfaces - Airtable admin panel
- Data sets - Airtable admin panel
- Managed apps - Airtable admin panel
- Components - Airtable admin panel
- Reports - Airtable admin panel
- Settings - Airtable admin panel Updated
- Managing Enterprise organizations
- Managing Enterprise admins in admin panel
- Using Organizations
- Organization branding for apps in Airtable
- Enterprise Hub in Airtable
- Enterprise Hub: Org unit assignment with user groups Updated
- Deactivating, removing access, and reactivating users in the admin panel
- Managing user access to workspaces and bases
- Airtable Enterprise Key Management Updated
- Custom terms of use New
- Enterprise SSO
- General Enterprise information
- Airtable Extensions
- Airtable Fields
- Fields Overview
- Attachment
- Date-based fields
- Formula
- Getting Started with Formulas
- Formula Foundations
- The essentials of Airtable formulas
- Formula writing tips for beginners
- Troubleshooting formulas
- Basic calculations
- Conditional statements
- Logical arguments
- Working with dates
- Displaying DATETIME_FORMAT using the date field in Airtable
- Working with date functions in Airtable
- Calculating the difference between dates in Airtable
- Supported DATETIME_DIFF unit specifiers in Airtable
- Supported DATETIME_FORMAT format specifiers in Airtable
- Using the DATETIME_PARSE() formula in Airtable
- Working with timezones
- Record functions
- Text functions
- Numeric functions
- Common Solutions: Beginner
- Common Solutions: Intermediate
- Common Solutions: Advanced
- Long Text Field
- Linked Record Field
- Linking records in Airtable
- Limiting linked record selection to a view in Airtable
- Dynamic filtering in linked record fields
- Linking to one, many, or a subset of Airtable records
- Converting existing fields to Airtable linked records
- Reordering record links in Airtable
- Understanding linked record relationships in Airtable
- Number-Based Fields
- Other Fields
- Rollup, lookup, and count fields
- Select and user fields
- Integrating with Airtable
- API
- Getting started with Airtable's Web API
- Creating personal access tokens
- Airtable Webhooks API Overview
- Service accounts overview
- Airtable Web API - Using filterByFormula or sort parameters
- Airtable API Deprecation Guidelines
- Airtable API: Common troubleshooting
- Managing API call limits in Airtable
- URL length limitations for web API requests
- Integration services
- Third-party integrations via OAuth overview
- Troubleshooting disconnected OAuth integrations in Airtable
- Options for integrating with Airtable
- Third-party integrations - Common troubleshooting
- Low-code integrations - Common troubleshooting
- Integrating Airtable with external calendar applications
- Visualizing records from Airtable in Tableau
- Visualizing Airtable records in Microsoft Power BI & Power Query
- Integrating HubSpot with Airtable
- Using Zapier to integrate Airtable with other services
- Using Zapier's Multi-Step Zaps to find and update records
- Using IFTTT to integrate Airtable with other services
- Integrating with AWS Lambda & DynamoDB
- Developer tools
- API
- Airtable Interface Designer
- Interface Designer overview articles
- Interface layouts
- Interface elements
- Adding and removing elements in interfaces
- Adding layouts to interfaces
- Formatting elements in interfaces
- Interface element: Button
- Interface element: Calendar
- Interface element: Chart
- Interface element: Filter
- Interface element: Gallery
- Interface element: Grid
- Interface element: Kanban
- Interface element: Number
- Interface element: Record picker
- Interface element: Text
- Interface element: Timeline
- Learning and Resources
- Managing Airtable
- Airtable Policy
- Airtable Records
- Airtable Sync
- Airtable Views
- Airtable Workspaces
- Print
- Share
- DarkLight
- PDF
Creating recurring records using automations
- Updated on 29 Feb 2024
- 4 Minutes to read
- Print
- Share
- DarkLight
- PDF
All plan types with different automations usage limits | |
Owners/Creators - Can create or edit automations in Airtable | |
Platform(s) | Web/Browser, Mac app, and Windows app |
Understanding automated recurring record creation
Note
The article below is still useful in many cases, but you might also find value in creating record templates that have similar functionality at times.
The value of using automations in your workflow becomes immediately obvious when reducing manual errors by automating repetitive tasks. One common use case for automations is creating new records on a recurring basis. This article walks through a simple example workflow for creating recurring records, and showcases the" When a record enters a view" trigger, and the " Create record" action.
We'll start our example by first making sure our base is set up properly. Here's a quick list of everything we created for this workflow:
We created a new view to serve as the trigger for our automation
In the view we created, we added a filter to only show records that match a condition we set.
For our example, we created a filter to only show tasks where the Status is "Done" and named this view, "Completed Tasks.”
Feel free to copy the base below to your own workspace to follow along with this article. If you have copied this base note that the Task Name field is a formula field combining a task's name and the status of that task ( Task &" _ "& Status
).
Configuring a recurring record automation
Step 1: Configure a trigger
Check out this support article if you'd like a refresher on how to create a new automation.
We'll start by creating a new automation, and then clicking to add a trigger. For this example, we will select the " When record enters view" trigger.
When using the "When record enters view" trigger the first thing we must do is select the table and view that will serve as the triggering point. For this example, we will use the "Completed Task" view we created above.
Here you can see what the trigger looks like with our "Completed Task" view in place.
Note
We strongly recommend pairing the "When record enters view" trigger with a locked view. By using a locked view, or ensuring a locked field is involved, you can decrease the likeliness of accidentally changing a view's filtering (therefore avoiding accidental automation runs for unintended records that enter that view).
Now, whenever a record enters this "Completed Task" view, which will only happen when a record's status is set as "Done" because of our filter, this trigger will fire.
Step 2: Configure an action
The next step is where things get fun—we can now setup an action to create recurring records. To create a new record we will make use of the " Create Record" action.
When our automation runs successfully, a record will be created in the specified table. The "Create record" action can be configured with multiple fields using dynamic values from previous steps, or static values. For this example, we will be using the "Create record" action to create records in our "Recurring Tasks" table.
Note that in the above step, we pulled in the dynamic "Task" field value from our previous step (the trigger step) and set the "Status" field value to a static value of "Todo". After adding the fields, you will want to test the automation to make sure no errors occur.
Step 3: Test and turn on the automation
Once the test runs successfully, all that is left will be to turn your automation on.
After our automation is turned on we can see that every time we change a task's status from "Todo" to "Done" a new task will be added to our table!
Bonus step: Creating recurring tasks with dates
First, we'll move to the "Recurring Tasks w/ Dates" table of the embedded base above, and see that we added the due date to the primary field's formula, like so:
DATETIME_FORMAT({Due Date}, "MM.DD.YY") & " _ " & Task &" _ " & Status
Note that we use the DATETIME_FORMAT() formula to format our due date nicely.With our due date clearly visible for each task, we can move on. To create recurring tasks based on dates, you will want to add a formula field to your table and use
DATEADD([date], [#], 'units')
to add additional days to the task date.For our example, we added 7 days to our task due date. Now, our primary field has all the information represented, and we are able to see that our "Monday Task" has the DATEADD formula calculating for the next Monday.
Once you have a formula in place, you will need to create an automation. You can follow the same configuration steps above, however, you will be adding an additional field to the automation action. In our example, we named the date field "Due Date" and inserted the formula dates. By doing this, our automation will create a new record with the date set 7 days after the date of origin from the previous record.
Once the "Due Date" field has the formula date value inserted, run a test to make sure the automation is working as expected. If the automation run is successful, you'll see a new record appear in the main grid view with the new date.
Now you can turn on your automation knowing that every time you mark a task as "Done" a new task will be created using the "Next Task Date" set on the previous task.