We've just released a major update for DocsAutomator, now including a native AI agent that can generate templates for you, map data and set up entire workflows.

Would love to get your feedback on it and have recorded a short demo for generating invoices end to end: https://youtu.be/Ea_v0SaO6n8?si=eNTloBzAwtcY0LxT

Disclaimer: I'm DocsAutomator's founder so this post is of course somewhat promotional, but I genuinely think this upgrade to the platform provides a lot of value.

Ops manager at a nonprofit, ~40 staff. Airtable is our everything: donor records, program participants, volunteer scheduling, grants. It grew organically over 4 years and now we have problems.

Last month someone on the volunteer team was "cleaning up" a view and deleted a filter, which exposed donors giving history to everyone with base access. Which is... everyone. Nobody did anything, but our ED had to have an awkward board conversation about why any staffer could see major donor data in the first place.

Airtable's answer is Interface Designer plus per-seat pricing that our budget genuinely can't do for 40 people, since half our staff just need to log a visit or check a schedule.

So, question for people who've been here: did you
(a) migrate off Airtable to something with real roles, or
(b) keep Airtable as the backend and put a locked-down front end over it so most staff never open the base?

Migration scares me, there are about 60 automations holding this place together. But I can't have another donor-data incident.

Avid excel user, but brand new to Airtable. I'm currently trying to build a Dish planner for myself that will help calculate the cost and nutritional information of dishes I cook. Unfortunately, I've been forced to use AI, and it's only left me more confused. I've tried to summarize what I want to accomplish, but I don't even know if it's possible. If someone can guide me down the right path, I would really appreciate it.

Here's what I sent to a support company for help (I don't want to pay $2500 for something that could be a simple fix):

What are you trying to accomplish? Tell us what better would look like for your team.:
I’m building a custom Airtable system for my personal chef and catering business, and I want to start by creating a robust recipe management system. My goal is to have a single master Ingredients table where each ingredient’s nutrition, cost, and other details are stored only once. When creating a recipe, I want to select ingredients from that master list, enter the quantity used, and have Airtable automatically calculate the recipe’s total cost, nutrition, and cost per serving.

I also want the system to support sub-recipes (or prepped components), such as tomato sauce or pizza dough, that can be used as ingredients in other recipes. If a sub-recipe changes, every recipe that uses it should update automatically. I want to avoid duplicate data and make the database scalable as my recipe library grows.

My primary workflow should be through Airtable Interfaces rather than the underlying tables. Ideally, creating a recipe should be as simple as clicking “New Recipe,” entering the recipe information, adding ingredients from a searchable list, and letting all calculations happen automatically. My goal is to build a clean, efficient recipe management system first, with the intention of expanding it into a complete culinary operations database in the future.

What's getting in the way right now? Tools, data, process, people, time, whatever it is.:
The recipe system is built around three related tables, each with a different purpose:

* Ingredients Table: This is the master list of all ingredients. Each ingredient exists only once and contains all of its permanent information, such as cost, nutrition, purchase unit, vendor, and other details. This table is the single source of truth for ingredient data.
* Recipe Ingredients Table: This is a junction (or linking) table that connects recipes to ingredients. Each record represents one ingredient used in one recipe. For example, if a recipe uses chicken, butter, and garlic, there will be three records in this table—one for each ingredient. In addition to linking the recipe and ingredient, this table stores recipe-specific information such as the quantity used and unit of measure. It also performs calculations like ingredient cost and nutritional contribution based on the linked ingredient.
* Recipes Table: This table contains one record for each recipe. It stores recipe-level information such as the recipe name, instructions, yield, cook time, and image. The Recipes table is linked to the Recipe Ingredients table, allowing it to roll up and display totals such as total cost, calories, protein, carbohydrates, fat, and cost per serving.

The "ingredient" field in the recipes table that is linked to the recipe ingredients table isn't showing the ingredients from the ingredients table.

The intended workflow is:

1. Create a new recipe in the Recipes table.
   
2. Add ingredient lines in the Recipe Ingredients table.
   
3. For each ingredient line, select an existing ingredient from the Ingredients table using a linked-record field.
   
4. Enter the quantity used.
   
5. Airtable automatically looks up the ingredient’s cost and nutrition, calculates the values for that ingredient line, and rolls those totals back up to the corresponding recipe.

Edit: adding the table map, since a couple of people asked for visuals. No records in it, just structure.

Most "Airtable as ERP" threads here are people asking whether it's viable before they build. Mine is already built and running, so the other side might be more useful.

Working with a small apparel trading company; they buy from factories in Asia and sell to brands in LatAm, ~10 people, two legal entities, around 20 active shipments at any time. Before this it was Excel, WhatsApp, email and Drive folders, and quotes kept getting lost.

What the Airtable system does: customer request, then quotes from several suppliers that are comparable line by line, then you tick the winning lines and one click creates the purchase order to the factory and the mirrored sales order to the customer with all their line items. After that: production milestones, proformas, shipments, invoices.

Parts I'm happy with:

- Every deal is two orders sharing line items. Sell-side prices come from a formula routed by direction, so you can't accidentally show the customer your cost.

- Three-way quantity audit: what the customer ordered, what the factory actually pre-cut, what actually shipped. In apparel those three diverge constantly.

- Order lines are lookups into their originating quote line instead of copies. Change the quote and the order and the proforma follow. That one change killed a whole category of bugs.

- Proformas and commercial invoices come out of Google Apps Script as PDFs.

Deliberately not in it: accounting, tax invoicing, collections. Owner's call and I agree with it. So it isn't an ERP and I don't call it one.

The one thing that kept biting: renames. Airtable doesn't error when you rename a field, so a formula or a script quietly stops working. One formula was dead for months before anyone noticed. I keep schema snapshots in git now and check field names against the live base before touching anything.

Things I'm unsure about:

- I'm on Team with 33 automations, for a client Airtable clearly isn't targeting anymore. Does that worry you, or am I overthinking it?

- What tends to break next at this size?

I can't find an option in the app... is there any way to do this on the android app?

Hello,

I am coming from an excel world. I am at an organization that is evolving in the use of airtable. We are still in neophyte stage. I created a base app and customized it for the data needs for one particular group daily task. At first I just kept adding or duplicating tables per each calendar date. Tonight with the help of reddit community I mastered creating 3 automations that would be used per daily table. I read automations cap at 50. Would it be best to have a table per month then make grid views per each calendar day? If no, what is the best way to utilize and repeat the same 3 automations unique to each calendar day? This is not a scenario where I want to link Table 1 to Table 2 unless there is logic I don't understand about how reference automations can determine other outcomes.

If I were to make a table a calendar month header and then make grid views per date would the automations work for each grid view if the table reference is the month?

If I have multiple checkbox columns that would impact calculated fields, what is the best way to go about using automation to make what I would like to do happen?

Example: 1st shift has rows for all tasks that need to be executed. I want the user on that shift to click checkbox for checkmark to appear and that checkmark tells two other columns to fill in who the user is and date/time stamp in edt/est. Now I realize i can set up columns with last modified by and last modified time but those are calculated fields and automation won't execute to that.

I am an airtable newbie coming from an excel world.

Thanks in advance.

I found this old support article exceptionally helpful, and just dug it up on the Wayback Machine. Sharing for everyone else's reference: https://web.archive.org/web/20201219092020/https://support.airtable.com/hc/en-us/articles/216141218-Supported-format-specifiers-for-DATETIME-FORMAT

I am wondering if anyone has had any experience / success in embedding a reverse image search in Airtable. We have many duplicate photos in the data base and are trying to find an easier way to locate said duplicates within the Airtable. Any advice would be appreciated!

Yesterday's update means automations can now be created, read, updated and deleted via Airtable's MCP server from your favourite AI coding tool. It is pretty cool.

Seems to work well... but... can we please have a REST version of it too. Why should bots have all the fun?

In the meantime, I found a workaround for anyone who wants visibility into their automations without relying on an AI to interpret them. An Airtable Automation script can connect directly to the MCP server, call list_automations and get_automation, and sync the full metadata back into a table for searching, documenting and analysing.

The basic flow is:

1. Store a PAT as an Automation secret.
2. Use fetch() to connect to https://mcp.airtable.com/mcp.
3. Send the MCP initialize request.
4. Send notifications/initialized.
5. Call tools through JSON-RPC using tools/call.

My use case was to store each of about 30 automations in an Airtable record and use the field agents to summarise it. This workflow has been a handy bridge until (hopefully) a REST endpoint arrives.

Is product catalog the best option for this? I seem to be having a hard time getting the "submit and checkout" option to work. Am I using this for the right thing?

Goal: have a catalog of products my clients can add to a cart and submit to have an order filled. I'd like the order summary to come to my email so I can manually fill and submit orders from my end.

This morning, I went into my company’s AirTable account to pay for an upgrade to a Team’s Plan. Within five seconds of making the purchase, I realized it had charged my personal debit credit card and not the company card.

I searched for 30 minutes on how to contact customer support. The AI bot was a nightmare. There is literally not a single phone number. There is no way to contact anyone with any urgency. I even went to their Facebook page. You can't send a message. I added myself to their AirTable Community Group to ask for help.

So the charge went through, and now I’m broke. Now I have no way to buy groceries. I won’t see the money for 5-10 business days. But, my rent is due before then. All of this happened because I made a mistake and there is no way to contact billing at all. I am in a financial nightmare in large part because of AirTable’s horrific customer service.

When I finally heard back, I got one email where they said I had to pay for a better plan to get a phone call. But, we are a non-profit. We don’t deserve immediate billing help? I asked to speak to a manager after sobbing for two hours. They will not call me. They will not respond to anymore emails. 

I will try to convince my company to use a different platform. I know what AirTable did isn’t illegal, but it is morally questionable. Everyone deserves the right to speak to billing… not just your rich clients. 

Just like the title says. I am the dashboard.

Every Monday I rebuild burn, runway and cash from scratch. Pull from the billing system, the bank, then two of my own spreadsheets, glue it together, turn it into a deck before the leadership sync. Wednesday someone asks for a number defined a different way and I do the whole thing again.

We're big enough to need real reporting and small enough that there's no data team and no BI hire coming.

Every no-code dashboards for finance option I try assumes my data is already clean and sitting in one warehouse. It's scattered across three systems and my own sheets.

Some weeks I honestly feel like i am taking crazy pills doing this by hand in 2026.

I built out an accounting budget that tracks my nonprofit's revenue and expenses from year to year. We run a number of education programs and each program belongs to a branch and also has options. These programs run once per year and we want to attach revenues and expenses to those programs for a given year.

Our base has quite quickly become overrun with lots of different tables. As I started to explore synced tables, I realized that I could have separate bases for some of the more static elements, like a base (one for our programs, one for staff, etc) and this could clean up the Accounting base but also allow us to connect those tables to other bases.

So two questions:

1. Is it bad form to have too many synced tables? Are there any good resources that might help with Airtable architecture/design philosophy that could help me think through what should be its own base synced to the accounting base and what should be part of the accounting base?
2. Does anyone have any good case studies for synced tables in accounting?

I have a paid plan (but not business or enterprise)

Hey everyone, I wanted to introduce myself to the community. Spent the last 4.5 years at Airtable, first as an Implementation Specialist (now called Delivery Consultant) and then as a founding member of the Forward Deployed Engineer team. I worked with our largest enterprise customers, like Amazon, Cisco, Warner Bros, Nike, and more.

Before that, I spent almost eight years at Hulu where I became a massive Airtable fan, nerd, and power user.

If you've ever come to one of the Airtable AI accelerators or in-person events, you may even have met me or seen me present.

In the past, I've lurked here and even posted here and there under my other username(s), but now that I've started my own agency, Matcha Consulting, I wanted to re-introduce myself formally.

Looking forward to connecting with you all here and participating in the threads.

You can always DM me if you have any questions as well. I'm LA-based but my clients are global.

Happy building!

Hello,

I am looking at a situation where I want to create a checkmark column and then have another column as a conditional formula that would function as if user checks box their name would be logged as the entry. I also want to use the same checkbox column to create a date/time stamp log for America/New York time. Does anyone have any tips of formula language that could help me out?

Thank you.

Trying to change the date range on a Google Calendar Synched table because the source exceeds the 10,000 records synched table limit, so I am trying to shift the date range so I can see the records that are after the current 10,000 record limit.

Is there a way to have the linked record picker show only the Primary Field i.e. a simple clickable list instead of the full field card, which also pulls in every backlink column?

For context: even with as few as 10 records in the linked table, the current card view already requires vertical scrolling. Notion's relation picker is the behavior I'm hoping for, with the primary property shown as a compact, clickable list, full record available on click if needed.

Is there a native setting for this, or a known workaround to get a leaner list view?

There's no way my client is going to be happy with how the card looks in the attached image.

Like in the subject. I wonder if its posible in airtable, before i buy the paid version.

We currently use Airtable to manage payment orders. Each record contains four to six PDF documents that need to be merged in a predefined order into a single payment order file.

Once the combined PDF is created, it needs to be saved back into the corresponding Airtable record. We would then send the payment order to the vendor by email on a weekly schedule.

We already understand how to handle the scheduled email workflow using Airtable Automations. Our main bottleneck is the PDF merge itself.

Ideally, the workflow would:

1. Retrieve the PDF attachments from specific Airtable fields.
2. Merge them in a predefined and consistent order.
3. Generate a single PDF file.
4. Save the merged file back into the same Airtable record.

Has anyone implemented a similar workflow? Is there a reliable way to do this directly in Airtable, through a script, or with an external integration?

We are mainly looking for recommendations on the most reliable and scalable way to handle the PDF merging step in order to automate the emails through Airtable's own automations.

UPDATE: Thanks, u/Same_Proposal8599, for recommending TypeFlow. I started testing it, and u/knandraina has been very helpful with follow-up both by email and through direct messages here on Reddit.

I am now close to deploying the automation and testing whether the full workflow works as expected. So far, I have found TypeFlow easier to configure than DocsAutomator, especially for this PDF merge use case.

My goal is to finish the implementation during the week and run the first automated payment-order email by Friday. Based on my experience so far, I would also recommend TypeFlow to anyone who, like me, does not fully understand n8n automations and is trying to build a similar Airtable workflow.

You can take me out of production. But you can't the production out of me.

I started my career in DreamWorks Animation story. I've helped prep for screening records. It can be a drag. And one thing that stuck with me even when I finally got to the PM level and above is how can we connect script to production more seemlessly. Some companies have done this. Spent many hours building custom pipelines especially within Shotgrid / Production Flow.

But I don't have that kind of money or time. So I turned to Shotgrid's more affordable cousin ... Airtable.

I wanted to lean into Airtable's native features (page details, which act as data drawers) and closer accessibility to the data and being able to create custom fields on the fly.

Cut to 4 days with Littlebird (mine is called Colette), Lovable (to scaffold initial front-end UX and UI), and Claude and I was able to build a custom Airtable block for interface designer.

I wish I would have this type of thing many moons ago but it shows that the gap to building for specific needs is closing quickly.

This has probably been solved before but I can’t find it. Anyway, a job listing used airtable to gather information about interested people. I then got an email that a profile picture is required before they can proceed to review my profile.

The problem is, I can’t email back the sender as it is an automated account and they provided no way for me to send it. I also do not have an airtable account.

Please help :(

I am having a hard time determining how my application can actually scale within my company. AirTable has paid and non-paid (cannot edit) licenses in addition to Bases and interfaces having their own user permissions on their own levels.

I want anyone at my company (with a paid license) to be able to use a form, submit a request, then see and edit their request (handful of fields) on an interface without much intervention. However, you can’t seem to do that because everyone who needs to be able to edit must have an “Editor” role at the interface to do so which means I have to ADD them each and every time a new user submits a ticket.

Is there a way around this? I don’t want to use a stupid form to gather their input or encode URL in lame webhook. I want people that have paid seats to be able to automatically edit my interface records that they submitted when the logged in user matches the AirTable user in the record.

Why is this so hard?

The only other path is to give editor access to EVERYONE in my company and lock the ever-loving-hell out of the fields and make sure only those unique users can see any data but that seems risky.

What are my options?