Ask your questions about Airtable Automations here.
Recently active
How can use “processing” check box as a temporary lock in airtable automations to prevent duplicate rink allocations? I have a bowling booking system where bookings trigger an automation to randomly allocate rinks 2 - 8. When several bookings are processed close together, the same rink can be allocated to more than one booking. I already have an Available check box in my rink pool table. I cannot use scripting and dont want to redesign the system. What exact automation steps would processing act as a lock so each rink can only be claimed once?
My automation OUTSIDE OF TESTING is only finding and returning 10 records, despite my limit being at 1000. Is this still an active bug?
SummaryAirtable Automations and Zapier's native Airtable integration both operate within a single base's boundary. There's no first-party way to build a trigger-and-action automation where the trigger lives in one base and the corresponding lookup/write lives in a different base — even when both bases belong to the same workspace and the same organization. Any cross-base workflow currently has to be built by dropping out of native tooling entirely and hand-writing REST API calls inside a Zapier/Make code step, using a manually-generated Personal Access Token.Concrete example of the workaround we had to buildWe needed: when a title record in our "Metadatabase" base gets a specific identifier populated, look up the matching title in a separate "Creative Base," find its linked Audio Cover Art project record, and write a direct link back into Metadatabase — so our Distribution team can jump straight to cover-status info without manually navigating a second base they aren't familiar with.B
Hi everyone,I’m using Airtable on-site to document materials, and I have two questions:Photo compression: Is there a way to automatically compress photos when taking them directly through the Airtable mobile app? The original photos are quite large, which makes uploading/syncing on-site slower. I’d like to reduce the file size while keeping enough quality for documentation purposes. Offline data collection: Is there a way to use Airtable fully offline for an on-site survey? Ideally, I’d like to be able to create records, take photos and fill in fields without an internet connection, then have everything sync automatically once I’m back online.Any recommended setup or workaround would be greatly appreciated. Thanks!
I previously posted about this issue here: I made updates to the Automation per @anthonyXRay ‘s advice but I’m still getting a steady stream of “Something went wrong with an automation” notifications. And similar to last time, the end data looks to be correct, so I’m not sure what’s triggering the errors. At this point, I’m wondering if it has more to do with @TheTimeSavingCo ‘s suggestion that all the steps are happening on top of each other and I need to introduce a delay somewhere. (If so, where and how?)Any suggestions as to what’s triggering the error and how to fix would be appreciated!
I have a base with a few tables, and an automation set so that when the status of a record on the Tasks table is updated, the linked record on the Time Tracking table is also updated. I’ve been getting intermittent ‘Your automation has failed’ notifications but all of the expected updates on the Time Tracking table are present. History log only ever says “Received invalid inputs”. I’m not sure how to even figure out what the problem is.
スマートフォンで、毎月の愛車の維持費、整備箇所、保険代、ガソリン代、税金、などを記録をするアプリの制作をしたい。 維持費、整備箇所、保険代、ガソリン代、税金、車検代、駐車場代、ローン返済額、などの項目を任意で追加したり削除できる。 ユーザーのメモも書き込めるようにしてください。 日付も入力できる。費用は、入力すると、1ヶ月分を自動で合計したり、月割りで自動計算したりする機能にしてください。 紙にプリントできる機能もほしいです。
Hi!I need to set up an automation for a solution I'm developing that allows volunteers to log their hours via a Google Form, which will then populate the tables. There will be around 100 volunteers. Is it possible to do this using Airtable's free plan?Thank youAlexandra
I have an automation set up to send weekly summaries across all workstreams in a project. I have the Workstream and Weekly Summary as fields. I’m currently inserting them as a List but then it doesn’t really allow me to format the content in the List - only the text I add before/after the List. Is there a way for me to insert the data I want and format it for slack?
Hi.I use sum up for my til & payment. Once sold, it alerts me on airtable. If I switch to a BOI payment terminal, will it affect the alerts on airtable? Thanks!
sono nuova, ho creato un’automazione, ma non mi aggiorna i dati.mi spiego meglio:nella tabella principale ci sono tutti i miei dati, poi ho creato una tabella ARCHIVIO ed una DA COMPLETARE, dove verranno smistati i dati in base ai dati inseriti nella tabella principalequando il cliente avrà saldo 0 e l’ordine sarà contrassegnato con SI, dovrebbe spostarsi in ARCHIVIO, ma ciò non accadegrazie a chi vorrà aiutarmi
I’m facing an issue with an Airtable automation that works correctly most of the time but occasionally fails to update the target record.My setup:Automation triggers when a record is updated. It finds a related record in another table. It then updates a few fields in that record. The automation is enabled and the field mappings look correct.The problem:Sometimes the automation runs but the target record is not updated. The run history does not always show an obvious error. Running the same update again manually often works. The issue seems more likely when several records are updated within a short period.I have already checked the trigger conditions, record matching, and field mappings. Has anyone experienced this kind of intermittent automation behavior, and is there a recommended way to make the automation more reliable?
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! I’m trying to run an automation, I have a repeating group but it only returns 10 records from a view, so is not a conditioning issue, somehow the length is set to 10 so that’s the only records retrieving, also the same problem is now presenting in other workspaces in the past it would retrieve more than 10 records and now it appears like this. Some help please
The run couldn't be completed[422] FAILED_STATE_CHECKCode: RuntimeErrorOrigin: Airtable
Hello Airtable Community,I'm excited to join the community! I have a basic understanding of Airtable and I'm now focusing on intermediate and advanced topics.My goal is to master:Advanced formulas Linked records, rollups, and lookups Interfaces Automations AI features Business database design CRM systems Workflow automation with n8nI'm building my skills to help businesses create efficient workflows and automation solutions.I'd love to hear from experienced members:Which intermediate or advanced Airtable Academy courses do you recommend? What projects helped you improve the most? Are there any best practices or resources I shouldn't miss?I look forward to learning from the community and contributing as my skills grow. If there are opportunities to collaborate on Airtable projects or volunteer on community initiatives, I'd be happy to help.Thank you
I’m new to Airtable, for the most part it’s not bad I’ve used Chat GPT and OMNI to set up my table however when generating a letter the identifier is not showing up in the right footer note like it should it’s using another Identifier. I’ve done everything I can to fix this but I’m getting nowhere
Despite log showing execution:I still get error :I believe the script to be OK, “let recordId = input.recordId;” Does anyone have any suggestions?
I’m fairly certain the answer is going to be no, but is it possible to get/collect the accepted/rejected responses to calendar invites when sent via Automations?We have a meeting planner, we will send out invites using an automation (fairly standard) - can we accept the responses in some way to then use that information (for example, a manager declines, so we can invite their deputy)?Anyone done anything like this?
We are on the Business plan and have almost reached our limit of 50 automations. Is there a way to request additional automations? We’re willing to pay for the additional automations, but just need to know who to talk to.
I am trying to set up a more complex automation than I’ve done before and something is wrong but I can’t figure out what exactly.The base has a workflow for tasks to onboard/offboard employees. There’s an overview table and then tables with sections of tasks. So each new hire shows up on all 5 tables. On the task tables, I’ve got a field that totals the completed tasks. I want that number to automatically (when updated) to be updated for the corresponding person on the overview table so that I can do an overarching completion percentage. I had the AI tool help me try to fix it, but now the wrong data (sometimes from the wrong record, sometimes from the wrong field) is getting copied over to the overview table.
Why do I have to regularly reconnect Slack to Airtable? It happens every few weeks or months, without warning (other than widespread automation-failed notifications). How can I avoid having to reconnect every automation that involves the ones I have set up to sent notifications via Slack?
If i Delete my account, will i no longer be billed. It is not clear and there is no response page. Very frustrating. I could not figure out how to cancel after my free trial and have been being billed for ½ year.
I am trying to create an automation that upon clicking a button, it takes all the records from the table, creates a PDF and sends it to the recipients. Is that possible?
Hi, I’m currently trying to set up an automation where a record will be updated, but I’m having a hard time with it. I’m attaching pictures of the current setup I have for it. In the data we have a ‘Start Date’ that will be entered manually. We have a 45 day deadline to turn paperwork in and we would enter it manually under the ‘Completed Date’ once its turned in. If no paperwork is turned in those initial 45 days, we want the automation to flag it and update the status under ‘45-Day Due’ as ‘Expired’. We have another automation (that is working perfectly fine) set up that changes the status of ‘45-Day Due’ to ‘Completed’ once a date is entered into ‘Completed Date’. Any help with the automation is greatly appreciated! :)
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.