Automations

I have 20 project managers. Every Monday i need to email each of them independently their list of jobs that meet specific criteria they need to take action on. I am starting to run out of automations for this base and am trying to consolidate this into a single automation rather than an automation per PM. Here is what I am trying to accomplishat scheduled time (good on this part) find records - find the PM by email address (this is a record within the table) I've taken this line out because it does not seem to be able to dynamically pull each PM, but m not sure how tog et the automation to accomplish this step. find records - when status1 <100%, and status1 due date is empty (good on this part) find record - when status2 <100% and status2 due date is empty (good on this part) send email - the PM defined in pm email address in the table gets an email listing the records in parts 3 and 4. These records are specific to projects he is running (cant get this to work correctly in a sin

I have a table called “Tickets” that my team enters project requests. Each ticket has a due date. A second table called “tasks” are specific things that need to be done to complete the project. Some of these tasks must be done a specific number of days (lead time) before the ticket due date to meet the deadline.I have a third table with standard tasks with a field called “lead time” that I use as a template to populate the tasks for each project.I want to be able to automatically enter the task due date based on the pre-defined lead time and the ticket due date. These dates need to editable to account for holidays and other conflicts, so I can simply use a formula.I want to create an automation that will look at the ticket due date and calculate the task due date (subtract number of days from said task due date) and enter it into the task due date. I can handle most of the automation, but I’m a bit out of my league trying to grab data from one table and use it in a calculation in anoth

I’ve spent hours on this and can’t figure it out. My goal is to simply click a button to trigger a N8N webhook trigger. Can anyone help me?

DescriptionI have a Tasks table with a multi-select field (e.g. values: A, B, C).I also have a Subtasks table linked to Tasks.Goal:When the multi-select field on a Task contains A and B, the automation should create two Subtask records: one Subtask called  A one Subtask called B (both linked to the same Task) Current setup: Trigger: When record is updated Field watched: multi-select field on Tasks Run Conditional Logic If condition are met: Type = A → create record A in subtask table Otherwise If condition are met: Type = B → create record B in subtask table Problems:Type in Task table = A & B, but the automation only run AHow do i fix this? Thanks in advance 

I’m working with a company that manages products, materials, and services across multiple Airtable tables.I want to use the Airtable API with Python to perform data integration / migration between two tables: A source table containing general product records A destination table where records must be created based on specific selected fields One of the main challenges is that I cannot rely on fixed column names, and I need a way to define which fields should be considered by the script when creating new records.I’ve read that working with JSON is the recommended approach by Airtable, but I’m unsure about the best practice to: Select only specific fields from a table Map them to the destination schema Maintain a relationship with a linked table (“categories”) My question is:What is the recommended way to automate field selection and mapping when creating new records via the Airtable API, especially when schemas are not fully standardized?Any guidance, examples, or design patterns w

I’m trying to build an automation so that if I put ‘Regular’ in the ‘type’ column in the bookings table it will automatically populate the ‘populate issues’ column in the same table with all the entries in a list (‘issue date’) from the ‘Issues’ table. I can’t work out how to build this automation and get a ‘Received invalid inputs’ error. Can anyone help? 

I have a button and I would like to attach an automation task to it. Is there a way to do that, I see that you can attach a script for a URL but not an automation.

How would I create an automation that whenever a record is created it should generate a PDF from my page designer extension, and place it in an attachment field - in that record.

I would like to populate a linked filed with the lookup field coming from different table. How do I automate this

I’m trying to work out if I can create an automation to do multiple tasks or if they all have to be separate (which might max out my allowance)…I have a table which tracks my book contracts. Each contract may have up to 5 titles on it and each title could be produced in up to 6 editions.  I’d like an automation that creates a record in my edition table for each planned edition…So,Test title 1 HardbackTest tile 1 PaperbacketcI can get this to work if each automation is separate but feel like there should be a way to group it somehow. However, at the moment when I try to create a chain it comes up as ‘otherwise’ so it doesn’t run the paperback if there is a hardback. What am I missing? 

Hey Airtable fam,I'm trying to build a deal flow CRM in Airtable, and I'm looking for a way to automatically pull investor data from Pitchbook into my base. I'm currently doing it manually but it drains my time.I'm wondering if anyone has found a good way to automate this process. I've been looking at a tool called the Pitchbook Investors Scraper on Apify, which seems like it could work, but I'm curious if there are any other solutions out there.I'd love to hear how you're using Airtable to manage your deal flow and any tips you have for automating the data entry process. Thanks!

Hi everyone,What are the recommended best practices for sharing complex Airtable bases with multiple stakeholders while maintaining data integrity, permission control, and performance—especially when using linked records and automations?Thanks in advance.

I am going around and around a lot on this problem and still trying to fin. d the right way to go.I have a table of invoices. The invoices are numbered sequentially. Right now I have to enter each invoice number by hand after checking a summary table I made that lists the latest invoice number used +1 from a formula.I would like to have the “latest number used +1” inserted into the invoice number field of the new invoice being created. I imagine that it I not as hard was I am making it. I will tell you that I am TERRIBLE at automations. I find them unintuitive and frustrating. It’s probably me.But I am guessing that an automation is what I need..So invoice table is “Invoices: House” and summary table is “Invoice: Next invoice Number”. The summary invoice numbers in the “Invoice: Next invoice Number” table are in a rollup field and the Invoice Numbers in the “Invoices: House” field is a numbers field if that matters.Any help is appreciated.Best, Scott

Hello,I’m trying to automate the population of resumes as attachments to a candidate table once a form is submitted.  I’m having trouble getting the resume file to attach to the resume field.  When I do it like this (within a loop through the uploaded resumes), I get an error saying “Invalid String”.  That’s likely because the “ContentReference” is a JSON formatted string.  I don’t see an option to insert the resume file itself, only metadata.  How can I actually auto-insert the resume file itself? Thank you,Robert

Hi Guys,Our staff submit invoices to airtable page and Airtable generate the form with Xero id however currently Xero submission Id is empty hence please guide us how to sync the data connects with Xero.If there is no direct connection/integration we can find with Xero and Airtable please guide steps to fix it.ThanksRegards,Being

Hi All. I have a problem that I hope is just a result of me missing something simple. I have an automation creating Outlook events from a list of Airtable holidays and birthdays. The “create” automations work fine. I was also able to capture the Event IDs from the Outlook events in the corresponding record in Airtable. Now I’m trying to generate a second automation for record updates using the event IDs and am running into an issue. When I input the data, the “Event ID” field shows up in the “Calendar” field, and the Event ID field is blank, so the automation won’t run. Photo included. Any ideas?  

Hi all, is there a way to integrate QuickBooks Online Plus with my Airtable workspace and bases? If there isnt already an existing integration, how do you get around it to sync with each other?

Hi everyone,I'm helping out with the technical logistics of an in-person event. I've set up a contact database as a Base and configured an automation that triggers an email to send when the record's status updates from "pending" to "invited." The automation includes a prefilled link to Typeform which is generated from a formula (and that in turn syncs back to the base). Happily, all these aspects work fine 🙂The only unexpected hitch I've encountered is that the automation seems to have trouble passing well-formed HTML over to the sender (in this case Google Workspace. I would use the built-in automation but want the emails to come from an owned URL).If I use very basic HTML like this the automation will render properly:But image tags simply refuse to pass (I tried scrubbing the HTML elements that might have caused compatibility issues with Google to no avail). If I pop in a designed HTML template with inline CSS ... nothing renders.I see that this has been discussed before

Hi there, I want to send HTML emails from AirTable using the Send Outlook Email action in Automations. I need them to contain embedded images with external links and a call to action button at the bottom. Please can someone tell me if this is possible and if so how?

Hi, I am trying to construct a daily email to summarise data. I have all the data I need, but I cannot get the email to structure correctly. I have used HTML to make a table for the data, but when the email sends the formatting is awful. I’m looking for a way to get the table to display correctly, does anyone have any ideas? Ideally I want the table to sit in the white space with the other text I have attached a copy images to show the issue and what the raw form looks like

Is it true that Airtable is fairly limited in its ability to allow you to use HTML formatting for send email? Is the solution then to have to use SendGrid or another service that could help out with email automation?

Hey everyoneRan into something interesting and not sure what is going on.I have a table called assignment with a Start Date and End Date field that are used for Date dependencies and to calculate duration.I have an Interface button called runs an automation. In that automation is a script that will use the End Date of the record, calculate a new start date (which is one day after the end date) and a new End Date (which is 3 months after the new start date).I have another script later in the automation that will duplicate the record and insert the new start and end date into the Start Date and End Date field for the duplicated assignment.Interestingly, the Duration is not updating when the new dates are added.In the attached image the, the top record is the source and the bottom record was the duplicate created by the script.I created a test formula to calculate the works days to validate what I am seeing. The top record has a duration of 132 days and the bottom record is also 132. But

Hello team, hope you’re doing well.Is there any way to share or extract the schema of an automation in the aim to share with functional people, non technical just to make sure that we are respecting the functional specifications.

Hello!I am currently working on a form and want the ability for individuals to make multiple selections and get specific emails depending on their responses. For instance, we have 3 trainings with their own Zoom calendar invite that individuals can select on the form. Lets say Jane picks Training 1 and Training 3. We have an automation to send Jane an email that contains a Zoom calendar invite for Training 1 but want an automation that will also send her Training 2 in the same email. Is that a possible automation? Or is there a different way to do this? My organization currently cannot connect Zoom to our Airtable so that isn’t a potential solution unfortunately.  Please let me know your thoughts or if you need clarification on anything!

Hi everyone — hoping for some guidance on best practices in Airtable.I have a table with a column that represents a numbered list (1–100). The order matters. When I insert a new record after, say, item #51, I’d like all rows below it to automatically renumber, so the list becomes 1–101 without manually updating each value.In other words: Current state: rows are numbered sequentially Action: insert a new row in the middle Desired result: all following rows shift +1 automatically I’m trying to understand: Whether this can be done natively (formulas, views, sorting, etc.) Or if it requires automations or scripting And what the recommended pattern is for maintaining ordered lists like this in Airtable I’m open to restructuring the field (e.g., using a sort/order field instead of manually entered numbers) if that’s the right approach.Any examples, tutorials, or best-practice patterns would be greatly appreciated. Thanks in advance!