Automations

Hi everyone,I'm looking for the best approach for the following use case.We have a read-only Shared View that we share with an external agency. They should be able to update only one field (Status Massnahme), which contains multiple predefined single-select status values.We do not want to give them collaborator access or edit permissions to the base.My initial idea was to include a button or link in the Shared View that would trigger an n8n workflow to update the record. However, since there are many possible status values, I'm wondering if there's a better approach.Has anyone implemented a similar workflow?Some questions: Is it possible to let external users update only one field from a Shared View? Would you recommend n8n, Airtable Portals, Fillout, Interfaces, or another solution? If using n8n, how would you pass the record ID and let the user choose from multiple status values? Are there any limitations with buttons or links in Shared Views that I should be aware of? The goal

I have setup an automation so when someone emails a purchase request, it makes a record and notifies me in Airtable, however it doesn’t look like there is away to email an attachment and have it populate the attachment field. Is this possible?

Hello,I am currently setting up an automation to send an email when a form is submitted. I had also created an extension page that is a confirmation sheet of sorts for clients that auto-fills information based on what information is submitted via the form in question. I was wondering if it is possible to attach this extension to an email automation. Or even automate this sheet to send on it’s own without an attached email message.Thanks!

Hi everyone,My workspace is on the Business plan and the latest invoice was successfully paid after a prior failed payment.The workspace billing page shows:Plan: Business Invoice status: Paid Invoice amount: $54 Subscription status: Active Automation run limit: 100,000 per invoice periodHowever, the Usage page still shows 100,000 / 100,000 automation runs, and automations remain blocked.It looks like the billing entitlement was refreshed, but the automation usage/block state may still be stuck after the failed payment.Has anyone experienced this before?Does Airtable automatically refresh this after some time, or does Support need to manually reset/remove the automation block?I already contacted Airtable Support, but I’m asking here to see if anyone has seen the same issue and how it was resolved.Thanks.

Hi,I’m pondering how to build an automation’s “Find records” step when the “contains” direction is seemingly wrong. Apologies for the perhaps convoluted question, this was difficult to write :).I trigger the automation from a Project with a button and want to find the Contact linked to that Project, using linked RecordIDs. One Contact can have many Projects, but one Project only one Contact.The Find step now has “Contacts” as its table, I think obviously. But then the order of my conditions is that the first variable refers to “Contacts”, and the second to “Projects” where the trigger button is.I wanted to look for the Contact that would contain the Project’s RecordID (I have linked that data), but instead I can only look for the Project which contains (or “is”) the Contact’s RecordID. But since there may be many Projects to one Contact, “contain” would not work I guess.I want to reverse this logic or somehow look for the Contact that contains the given Projects ID.How could I go about

Created this automation to send an email if a new task is created. Shows it’s running correctly. However no emails are being received. Nothing in spam either. Query into Omni as to why suggests all the usual things, which I’ve confirmed are not in error. Any suggestions? 

Hello,I have a form I am trying to create for clients to be able to fill out and provide their information. I currently have it set to populate a new field for “Agent” contact information when they select that the “Client” and “Agent” ARE NOT the same. When they ARE the same, I want it to autofill the “Agent” field with the same information into the “Client” fields, but I do not know if this is an option and have been unable to figure it out. Hopefully that makes sense.

Hi all. I have an automation that creates a doc in Google Docs as one of its steps. It’s triggered by a button press in an interface. We run it 20-30 times a day. 90% of the time, no problem. However, 5-10% of the time it randomly fails to create the doc with a very nonspecific error: When we re-run it with the same data and so on, it runs successfully.The workaround is simply pressing the button again, which is fine, but I’d still like to know what is going wrong. Is there any way to see more information on this error? Or, has anyone else encountered a similar issue?-Natalka

I have an automation that runs from a button on a blank interface. I’m trying to fill in the qualifying Billing Sheet [Link] field with the value from the current Billing Sheet on the blank interface. The automation runs correctly, finding the matching records in the Invoice Task-Hours table. But it won’t link them automatically. I tried linking to the RecordId and to the Billing Sheet Title field. No dice. Note: the Billing Sheet Title field is a formula, if that matters?  

Hello, I received a message that my workspace reached it’s automation run limit. However, there is nothing that I have found in the admin that shows anything about specific automations for a specific base. I have scores of bases and it will not be worth the time to go through each one manually to find the culprit. If there is something I’m missing I would really appreciate the help!

Hi everyone,We're currently managing Microsoft 365 mailbox migration projects and using Airtable as a project tracking platform.The migration itself is performed using SysTools Office 365 migration software, which generates detailed CSV reports containing mailbox status, migrated item counts, failures, timestamps, and other statistics.What I'd like to do is automatically push those CSV reports into Airtable so customers can view migration progress in near real time through a dashboard or interface, rather than sending them updated spreadsheets manually.Has anyone built something similar?I'm considering a workflow where Airtable automatically imports the latest CSV data and updates customer-facing views. I'm curious whether people are using Airtable Automations, Make, Zapier, custom scripts, or another approach for this type of reporting.Would appreciate any suggestions or examples from those who have implemented client-facing status dashboards.

Hi Team,I am currently using the Teams plan, and I noticed that the automation limit is capped at 50 total automations (including both enabled and disabled automations).Our use case requires additional automations beyond this limit, so I would like to know if there is any option to increase the automation quota. Is there an upgrade path, add-on, or alternative plan that supports a higher number of automations?I would appreciate any guidance on the available options.Looking forward to your response.Thank you.

After two years in the AI wilderness, finally the technology is allowing me to do business again with real opportunities to help other entrepreneurs and earn money doing it.  I have learned a lot these past two years, building an app concept in the mental health care space, and now AI audit tools for small businesses.  This past week, I struggled with two AI assistants trying to set up my lead generation database from one of the tools that were ready for launch. The experience, and an interview on YouTube with CEO Howie Liu, led me back to Airtable as a CRM for my new venture. Historically, I used Airtable for marketing content planning. I saw the value of integrations, but I didn’t want to pay for it. Now, I am hearing so many good things about what people have built and the huge benefits at the free level, I decided to come back. A lot has changed here too in two years. So, I’m hoping someone in the community can help me with their immediate experience with integrations through Make

Why when I get just only 1 item in a search node with airtable and 1 item in update record the API calls is not only 2?

Hi all - I’m fairly new to Airtable and hitting a roadblock… I have a form where people submit a list of activities they’ve participated in over a period of time. To avoid burdening the user with repeat submissions, I’ve set up my form/table with Activity 1, Activity 2, Activity 3, Activity 4, etc for all the different fields. However, I’d like to create a clean view where the data in all of those fields wraps up into one list of activities, as different records (i.e., if John Doe submits details for Activity 1, Activity 2, and Activity 3 all in one record, how can I get a list where John Doe has 3 records, one for each activity?).I’m struggling with how to make this happen. I tried nesting the records but it only works for 3 and I have 10 activity fields in my form. Does anyone have experience writing a script for an automation for something like this? I’ve never written a script and have no idea where to even start, so any guidance would be helpful!

Yatendra 

I have an automation that aggregates all the line items for an invoice - see attached image… That works fine but I would like to have each item be on its own line. So somehow I need to be able to insert a break <br> presumably. Not willing to go to Make or Zapier for this. How can I do this?  

Hi, how can I use script to prompt a user to confirm an action when a button is clicked on the interface? The Button is linked to a record picker on a Blank Layout.I tried adding this to my script:// Ask for confirmationlet confirmed = await input.buttonsAsync("Are you sure you want to perform this action?",[ {label: "Cancel", value: "cancel"}, {label: "Confirm", value: "confirm"} ]);if (confirmed !== "confirm") {output.text("Action canceled.");return;}But I am getting this error:Property 'buttonsAsync' does not exist on type '{ config(): { readonly recordID: string; }; }'.(2339)Here is my script:let table = base.getTable("Test Log");let view = table.getView("New");const recordID = input.config().recordID;let record = await view.selectRecordAsync(recordID);// Ask for confirmationlet confirmed = await input.buttonsAsync("Are you sure you want to perform this action?",[ {label: "Cancel", value: "cancel"}, {label: "Confirm", value: "confirm"} ]);if (confirmed !== "confirm") {output.text("

Edit after ~1h of investigation: it turns out these are rate limits that are the culprit. Which raises a new question: if I change the email address in the automation, will it impact the runs that are currently in progress? My guess is no. And so, if no, is there any way to trigger a re-run of the currently stuck runs?  I several automations running that involve sending emails. They have both run over 6k times until yesterday around 8pm many runs are stuck in “pending”. There are several things puzzling about it:There isn’t a clear cut off when the automations started getting stuck. See screenshot below: several still pending from before 9pm on Oct 16, followed by successful runs, then everything after 10.15pm is pending.2.Runs stuck at different steps. The automation has two steps: find records, then send email. The earlier runs are stuck at the step of sending an email. This makes it hard to verify which part of the automation is malfunctioning.Earlier runs pending at the step “send

Unbenownst to us and without warning, we ran into our Business tier automation limits. We run a mission-critical medical company. Is there any way to escalate this internally at Airtable? I have already submitted support tickets and contact forms. Ticket # 01168252. My business is literally stopped right now due to this and the repair process will be significant, and we didn’t have any warning whatsoever. 

Hi everyone! I’ve been trying to use Webhooks for a while to create a simple link that will allow my University’s Data Team to click a link to let us know that a query has been created. The Data Team will not use Slack either, so I’m basically trying to do an Actionable Message, but automating sending an ‘actionable’ link through our Microsoft Teams Channel.I have the Webhook examples below.The formula automatically generates the RecordID into the Webhook so that when it is sent, the RecordID appears in the Params. However, I can’t get that information to go into the Body, so I am not able to use the RecordID in my “Update Record” automation. (AirTable recommends using ReqBin for webhooks/testing, so that’s what I’m in) With University Guidelines and permission issues, I am only able to do this through AirTable and not any 3rd party tools. Do you have any suggestions on how I can do this? Thank you!

I have a multi-select form field.If they click Paid Social, I only want to show the questions related to paid social.If they click on Organic Social, Employee Advocacy, or Executive Advocacy, they get other set of questions.Additionally, can I hide all the questions until the preferred channel is chosen?

I am trying to create a task management database for a small farming operation. Each year, many tasks will follow the same pattern of dependencies, duration, and time between. I currently have 4 tables: Plants: As I add plants to the list, I can generate tasks for the Task table with an automation that pulls tasks from the Templates - Task List table. Templates:  Lists the different available task templates.  Templates - Task List: Lists the different tasks associated with each Template. Also links dependent Predecessor and Successor tasks. Tasks: The final output table, where tasks from the Templates - Task List table are added when the automation from the Plants table is triggered. This automation works. Certain details are included in the Templates - Task List table and called to the Task List via lookup or rollup fields, including Days Before Next Task and Duration. I also have a marker (checkbox) to indicate which task is the starting task in a sequence. Another automation (also w

Hey everyone,Just wanted to introduce myself to the community. I’m Lawal Aliyat, an Airtable and workflow automation specialist.I spend most of my time helping businesses scale past basic spreadsheets by designing relational architectures, setting up external API integrations, and building custom Airtable Interfaces. I love solving the puzzle of turning messy data workflows into clean, automated systems.Excited to hang out here, learn from you all, and jump into the threads to help solve some technical bottlenecks!Feel free to connect!"

Using an automation to assign a part number to any part who does not have a part number. Since this database is needing to retroactively run this script one at a time due it is nature of how it assigns part numbers. The best way to do this is to have the script run once, then identify the next record this script needs to run on (next record without a part number) and run again.However as it stands, the second automation run will not happen even when the conditions of the second record are changes to meet the conditions of the automation.Is this a known bug/limitation of airtable automations?