I'm a total novice when it comes to any kind of coding, but I've found the ability to create custom interfaces on Airtable using Hyperagent absolutely extraordinary.

At first I used Hyperagent for simple things like inbox trawling and to-do lists (barely more than its basic chief of staff demo mode) but after providing context about my bases, it was able to help me translate a vision of an interface into a fully functioning interactive dashboard that my team use to track sales and bonuses daily in less than a day.

I've previously used Cursor for some basic tasks and in this case I asked Hyperagent to provide context and instructions, which I then uploaded to Cursor for it to do the build work. Not sure how necessary that truly was, but I essentially ended up passing messages between the two and it became a powerful way to execute the build - Hyperagent specialising in what I needed and was asking for, with Cursor specialising in the technical implementation.

We're definitely living in the age of sci-fi.

Overview

I manage an Airtable database that tracks events, and I’m trying to improve how we standardize location data. The goal is to standardize event locations so that we can reliably create maps and group events by location.

In an ideal world, I’d like the system to behave somewhat like Google Maps: a user could search for anything from a city to a specific street address, select the correct result, and then have the relevant location fields populated or linked automatically. I’m not sure what the best Airtable-native or automation-supported way to approximate that would be.

I’d appreciate advice on:

1. Whether this linked Locations table structure makes sense (see below)
2. How others handle standardized city/state/country data for events
3. Whether there is a practical way to integrate or mimic Google Maps-style location lookup in Airtable
4. Any recommended automations, scripts, extensions, or schema changes for this type of setup

Context

Right now, each event record includes the following location-related fields. All except Location are single-line text fields:

• Venue
• Street Address
• Postal Code
• City
• State/Region
• Country
• Location* (linked field)

The Location field is linked to a separate Locations table. When a Location is linked to an event, it overwrites the event’s City, Region, State, and Country fields with standardized data from the Locations table. However, the Venue, Street Address, and Postal Code fields remain untouched because they may be specific to the event venue rather than the broader location.

The Locations table is designed to help us group and map events consistently. Its primary field is a formula field that displays locations like this:

1. For U.S. locations : Displays as "City, State" (e.g., "Boston, Massachusetts")
2. For international locations : Displays as "City, Country" (e.g., "London, United Kingdom")
3. Fallbacks : If city is missing, it falls back to country, then region, then other, and finally defaults to "Unknown"

Field	Description
City	The city or town name
Region	A broader regional designation
State (US)	Links to a standardized list of U.S. states
Country	Links to a standardized list of countries
Continent	Lookup field; populated based on the country (Africa, Asia, Europe, North America, Oceania, South America)
Metro Area	Identifies major metropolitan areas (Greater D.C., Bay Area, Greater Boston, Greater NYC, Greater LA)
Other	Captures any additional location information that doesn't fit elsewhere
Domestic vs International	Automatically calculated based on the country - if the country is "United States of America," it's marked as  Domestic ; otherwise, it's  International .
Time Zone	AI-generated fields automatically determine the UTC Time Zone  and  Abbreviated Time Zone based on the location data.

I have a few hundred records in an excel file and 2/3 of these are duplicates except for 1 fields which has unique data. How do I combine multiple rows together but add that unique data as comma separate for that 1 field?

For example I have 5 records that are 30 columns across. 1. of those columns have unique data for each of those 5 records (year 2020, 2021, 2022, 2023, 2024). I want to turn this into 1 record and combine that unique columns data by comma separate.

Can AirTable do this or do I have to do this in excel first?

I am currently using the free tier as my needs are extremely minimal.

I have made a database for orders, and I am tracking different dates (eg. arrival, finished, sent) and I have a status variable for each order which is just a selection variable.

Now, I want the status to be automatically set based on which fields are not empty. This would be incredibly easy on something like excel to just create a function to do this, but it looked like it was a paid feature to be able to write these kinds of functions.

I have instead set up an automation that does it. It works like it should, but I run out of 'automation runs' each month as I am on free tier.

Again, I'm not going to go on paid tier, but I have not been able to find any solutions for this incredibly simple problem on my own.

The reason I am using airtables and not something like excel is because of how well I can link orders and images, and just general layout. I would really like to get airtables to auto set this variable without automations so that it just works, but if this isn't possible feel free to suggest alternative software

I really like Airtable for organizing projects and data. But I’ve noticed something over time… Once tables start growing, things get complicated fast. Fields, views, filters, relations… everything becomes harder to manage than expected. And I often end up thinking: “This should be easier to clean or restructure than it is.” So I wanted to ask: What’s the most frustrating part of using Airtable when your base starts getting bigger?

I will be helping a documentary director and producer do archival research for a film. The documentary is in its beginning stages with no story arc yet, but I need to start evaluating materials (posters, tapes, letters, videos, even a Nobel Peace Prize Medal)! Its been suggested I use Airtable as I evaluate and log my research. Can anyone point me to someone using Airtable for the purpose of supporting documentary film research? I would not want to reinvent the wheel. I could spend valuable time teaching myself Airtable, but I think its worth it to possibly hire someone who is an expert in the field who is using it for this purpose. I'm from the era of index cards and writing reports in longhand on yellow legal pads. (Don't worry I am with the program now 😄and use my Lenovo with Microsoft Office Suite)

Am I missing something or is it not possible to build a custom interface extension from scratch (not using Omni) on the team plan?

Edit: resolved. See this comment.

I need 3 main sections to this AirTable: Accounts, Notes/to-do, Vendor (PDF library).

I want to have my accounts listed in alphabetical order with account names only (I'm driving a lot and need a simple view).

Accounts:

• Account Names ONLY plainly listed in Alphabetical order as my 'homepage'
• Tap/select an account name to open a detailed account view
• Display all account contacts clearly within the account
  • Contact names
  • Phone numbers
  • Email addresses
• Include an easily accessible notes section within each account
• Allow notes to be updated and sync'd into a separate “Notes / To-Do” table automatically, while still keeping a history within the account details
• Use the Notes / To-Do table for follow-ups, reminders, and tracking activity

Notes/Daily To-do:

• Ability to mark notes/tasks as “Done” or “Cleared”
• List notes organized by associated account name
• Display either:
  • The full note directly in the table
  • OR a link to the full note when additional detail is needed
• Use notes for:
  • Follow-ups
  • Reminders
  • To-do tracking
  • Account activity history

Vendors:

• List vendor names ONLY in alphabetical order
• Tap/select a vendor name to open a detailed vendor view
• Display vendor contact information clearly within the vendor account
  • Contact names
  • Phone numbers
  • Email addresses
• Include either:
  • PDFs directly attached to the vendor
  • OR links to a centralized PDF library
• Use vendor records for quick access to supplier information and documents

I posted in another thread and instead of suggestions, I had people messaging me requesting $300-$600 for a "full crm setup" . Just want to be clear, this is only bridging the gap while I'm in the field. The company uses SUPER out of date systems that aren't very realistic to use while in the field.

I wanted to give a full overview so there was no confusion and context was clear!

Any help, guidance or suggestions would be VERY much appreciated!

I have a Projects table that links to another Risks table to associate risks to existing projects. The issue is, people can fill out the risk table and enter the Project Linked Record and If it doesn’t exist (or they just hit enter) it forces a new Project record to be created. I do not want this. Projects shouldn’t be created here. Only referenced to be included.

Google says if the Projects table uses a formula as primary field and not text then it won’t allow a new creation but that’s a lie (tested it) and it still allows it. Google also said to use a View for the linked record which also doesn’t work. Sure it reduces the visible records but people can still create projects here.

The only think I can think of is using a text field instead and an automation that checks against existing project names and if so, adds the appropriate linked record and if not throws a status flag but that’s ridiculously overkill.

Why is this not a simple toggle switch in linked records in 2026?! Just disable NEW record created if toggled.

I had a similar setup before. The easiest way is to treat “Email Open” as just another field update in Airtable.

When someone opens an email:

• get the lead’s email address
• find the same record in Airtable
• update fields like:
  • Last Opened
  • Open Count
  • Status = Opened

The important part is having a unique email field so records match correctly.

Also, I wouldn’t overcomplicate it early on. Just updating the latest engagement status in the Leads table is usually enough.

I'm testing the waters with airtable to track both inventory/materials, orders, & customers for the small business I work at. It's a laser business and we make a lot of different products, ranging from pre-made, pre-made with customization, and fully custom orders. I'm running into a few problems so far.

1. A lot of our products have variations to choose from. Ex: a 20oz tumbler can come in red/blue yellow, but a 40oz tumbler can come in red/green/white. This is hard to set up in the data tables and I'm not sure how to handle it.

2. Setting up an order form. I've tried both airtable's forms as well as jotform. Airtable forms are limited it looks like, maybe I'm just doing it wrong, but I can't get them to handle input like "20oz tumbler, red, premade" vs "20oz tumbler, green, customized".

The issue I was having with Jotform was that when I linked it to my test airtable's Order table, it refused to acknowledge the Customer field even existed on the airtable side (along with a couple other fields).

I'm 100% open to using other forms/apps for taking orders, but it needs to a)have a free tier, as I'm just testing this for my boss atm, b) have a mobile app that lets you fill out the form and submit it, because my bosses often take orders while on vacation/etc and they're glued to their phones, and c) have airtable integration, or the form integrates to another good database app to keep track of orders.

I’ve been building a cash flow forecast base for my small business and I’ve gotten stuck with not being able to pull data from another record into my formula. Unfortunately this isn’t a feature airtable offers, does anyone know if a similar tool does?

Basically each day of the year is a record. I have two tables for incomes and expenses that roll up to the main daily bank total table. In that table I have my daily starting balance, my net gain/loss (rollups), and the ending total. I want future dates to keep updating the starting balance from the previous days ending balance. In theory I could do this with automations, but I have so many transactions that it would take up too many runs.

Thoughts?

been using Airtable for stuff like lightweight CRM, project tracking, internal workflows, and client management. overall I like the flexibility but once you start scaling it a bit the pricing and setup can get harder to justify.

before we commit deeper into it, I wanted to see what other tools people have switched to that still give a similar feel without becoming overly complicated or expensive.

mostly curious what alternatives people here actually ended up happy with long term and what made you move away from Airtable in the first place.

I tried left/right arrows and the mouse scroll wheel, but they both don't work. Are there any other shortkeys aside of arrows to scroll horizontally if one has many field columns?

Got tired of paying $20 - 45/seat for collaborators who only update one status field a month. So I built RowRouter as the cheapest possible way to do it.

You paste a Personal Access Token (or OAuth), pick a base / table / fields, generate a per-row magic link, send it. The recipient gets a clean mobile form prefilled with the current values, edits, submits - change writes back to Airtable. They never create an account, they never see the rest of your base.

Single-use tokens by default. Field-level access controls (only what you allow is visible). Full audit log of every open and submit. Optional review-before-publish queue. AES-256-GCM at rest, hashed link tokens. Works for vendors, freelancers, customers, anyone external you don't want to pay a full Airtable seat for.

Free during the founding beta - 500 links/month while I figure out pricing. Founding users lock a discount off the launch price for two years.

Curious whether this maps to anyone else's pain or whether I just hated my own bill.

Not affiliated with Airtable. Built by one person, happy to take feedback.

https://i.redd.it/e8o8o92u8rzg1.gif

I’m testing something I built as a free Airtable alternative.

The idea is simple:

Upload a spreadsheet → turn it into an app.

Instead of keeping everything in rows and columns, you get a cleaner app with records, pages, forms, and workflows.

I’m looking for honest feedback from people who use Airtable, spreadsheets, or no-code tools.

What would make this actually useful?

What do you hate about Airtable or spreadsheet-based workflows?

Try it free: Aurelia .so