Base Design

Hi everyone, I’m looking for some advice regarding Map View in Airtable.We have one table with all the businesses we work with, and another table with all our points of interest. What we’d really like is a single Map View where both datasets appear together, each in a different color (for example: businesses in one color, POIs in another).Right now, Map View only accepts data from one table. To work around this, we had to create a combined table that contains both businesses and points of interest, with a “Category” field that marks each record so they appear in different colors. This works, but it’s messy and difficult to maintain.My main questions are: Is there any way to use another mapping solution inside Airtable Interfaces, something faster or more flexible than the current Map View? Is it possible for Map View to show records from two different tables, or is merging everything into a single table the only option? Any recommendations or best practices would be greatly appreciat

I’ve run into a problem that I can’t solve.I’m using a Rollup field, and I need to get the total for the previous month.I’m using the filter “Date – is within – the past month”, but it gives me the total for both the current and previous months.When I set fixed dates for the previous month (from the 1st to the last day), the calculation works correctly.Below, I attached a screenshot with my filter settings and the result.I expected the numbers to be the same with this configuration, but they are different.The issue is that I can’t use fixed dates, because I need the period to be calculated dynamically.  

Hi team!I have to create an app to analyze interviews, extract discussed topics and suggest social media posts, based on the topics. Similar to the one Alex McDonnel showed here.It should have three datasets: Interviews, Topics and Posts. Omni created the app and filled it with some examples. Everything looks great, but when I add the new interview no topics or posts are created.Could you tell me how to fix it? 

Hello, I am syncing my calendar to Airtable, but once I did so out of the items on the calendar it is broken up into two separate kinds of events, so a sure-fire way to be able to separate and organize them is item one right now I have an automation whenever and events/ record is created it tags (single select) either one or the other with Nobody edit permission as very rare will items float between the different types. Secondly, so many of the calendar meetings are canceled or deleted. I want Airtable to follow when that happens, but also snap back live on the calendar if it is brought back into the calendar. Anything to help me head in the right direction would be appreciated.

Hello all,I am a small video game refurbisher/reseller and as my business grows Im looking to move from Google Sheets to Air Table to help me manage the complexity of my inventory. Im hoping that the community can provide some insight into how to structure my system so that it is manageable and I keep track of things without making mistakes and/or losing my mind :)The core of my business is based on selling 3 things:Consoles Games ControllersGames are a standalone item. Controllers and consoles are not. Consoles have cables and replacement parts and controllers are similar. I often have to supply additional parts in order to create a single sellable product. For example, I wouldn’t sell a console without a power supply and AV cable.Each product also has different characteristics. For example controllers have colours and could be aftermarket whereas game have unique titles and consoles/controllers do not.Between these 3 core items would you recommend different tables to track each? Woul

buongiorno a tutti, ho bisogno di aiuto perchè non riesco a concludere quest’operazione:mi occupo di vendita di merce, ho creato una griglia con varie informazioni, tra le quali esiste la colonna nella quale viene visualizzata la data della merce in uscita.mi piacerebbe che quando questo cliente risulta “uscito” venga spostato in un’altra grigliacosì da avere un elenco di clienti da consegnare, e nell’altra griglia merce uscitagrazie 

Hello everyone, I started a new job at a company where I’m trying to structure how Airtable is used.We have a view that’s publicly accessible, but we don’t know which account it’s tied to. We want to delete it, but without knowing the account, it’s impossible.Do you have a way to help? Thank you for your help.Maxime

Hello!I’m looking at building a forecasting tool for a seasonal sales business and I’m not sure the best way to set up the base table My dream is a Forecast App/Page (currently happy with out Softr interface) that; #1. has a list of all products, with 2024 sales, 2025 sales, and then an editable field for 2026 Forecasted Sales#2 can be expanded upon to see a listing of customers and their purchases of said product (ideally with quantities and gross margin)#3. The forecasting and customer sales data is only visible to the relevant salesperson (sales code) My question is; what is the best way to set up the database. Currently I have different tables for Salesperson, Customer, Items, 2024 Sales, 2025 Sales (this is over 6000 entries), and then a forecast table that summarizes total item sales per sales code for 2024 and 2025 and has that 2026 Forecasted Sales column. Am I on the right track, it seems like I’m running into issues when linking things together to get that layered visibility

The public link cannot open the mobile page on my phone.The page opened on the phone shows the desktop version. I’ve tried all browsers and also tested on my friend’s phones.  

Hi all,I'm excited about the new Deep Matching functionality in AI Labs, but I haven’t been able to get any results yet. Here’s what I’ve tried so far: Tested with both large live tables (10k–50k records) and small test tables (10 records) Used conditional filtering to narrow results down to a single expected record Tried multiple models (GPT-4.1 Mini, GPT-5 Mini, GPT-5) Has anyone been able to get results successfully? If so, I’d love to hear what worked for you.Thanks!

Is there a way to wrap the text in a filed name?

Hello, I need to create a database for a fire station with:- A table for staffing levels- A table for scheduling training sessions- A table to indicate which personnel were present or absentWhat I'm doing isn't very efficient. Could someone help me? I'm new to Airtable and its many features.Thanks

Hi everyone,I’m building an Airtable base for product data management in pet nutrition. The goal: automatically generate “Article Passes” – structured text outputs with all packaging-relevant details (composition, analytical values, additives, storage info, etc.) in multiple languages.My structure: Products → general info Product Versions → recipe & design versioning Packaging Units → GTIN, article number, recycling info Analytical Constituents / Additives → linked via junction tables Multilingual Content → texts for a number of languages At the moment, I use Rollup fields filtered by language (e.g. Language = DE/EN/IT) and combine them into a big formula for multilingual output like:🇩🇪 GermanShort descriptionComposition:Additives…etc.🇬🇧 EnglishShort descriptionComposition: …etc.It works, but it’s quite static.Any advice on:smarter or more dynamic multilingual output – the formula solution is not very handy only displaying languages with existing content    best export

Our small creative team uses Airtable in a KanBan view to manage client workflow. Each client has a base. Within each base, we typically include the active teammate assigned to the task as a field on each record. This allows us to manage team bandwidth for that particular client, but we still have to manually manage our teams task assignments across various client bases.Is there a way to pull records from different bases within a shared team workspace? We’d like to have an internal view stacked by team member.

My sync stopped working even when I manually sync. When I have investigated what the issue is I did find out that sync stops working when the source base is inactive which could be the case here. But how do I fix this issue without losing any data? I have tried resyncing to the original view and also syncing to a duplicate view. I’m lost. 

I am seeking to set up a new base for my Podcast with all the lessons learned from using airtable the last several month, however I am unsure the best way to go about planning a whole new base.  Is there any suggestions for best practices?

I am evaluating various platforms to build a custom production scheduling application for a client.  Here are some details:Customers place orders for products they need produced Each order can have multiple line items for different products they would like produced Each order line item needs to be scheduled on one or more machines to be produced. The scheduled jobs for each line item need to be run sequentially, but not necessarily back-to-back.  In fact, some products need to sit for a set period of time after one job before it can be consumed by the next job to make the final product If the date of the first job scheduled for a line item needs to be adjusted ahead or back, the other subsequent jobs need to be adjusted by the same amount of time as well.  For example, if a customer orders “Product A”, which needs to run on “Machine 1” on 3/20, then “Machine 2” on 3/21, then “Machine 3” on 3/25, if the job scheduled on “Machine 1” is changed to start on 3/21, then the job on “Machine 2

I have an Airtable base for events I host. We get repeat attendees at the different events. I would like to send text messages to the participants at a particular event if they opt in for text messages. I have this all working.The issue I need help with is that I’d like to keep a master list of participants and their phone numbers who have already opted in at a previous event so they don’t have to opt-in every time. I’m looking for suggestions on how to handle this. When I add a participant for a new event, it needs to check the master opt-in table to see if there is a match. There will be records that don’t have a match as they have not completed the opt-in previously and opt-in records that won’t have a participant as they are not attending this event. As I write this, I’m wondering if an automation is where I need to go for this???

my question is regarding FormsI have a table countries with country name as main field.in my main table clients I have a field client_country filed which is a field linked to table countriesI want to create a Form view of the clients table.For the field "Client_Country I want to display a select dropdown to select a country among the list from the table countries  Instead of that, in the form besides the field Client_Country, I have a button "Add a file", which is not what I want  Can you please guide me to get the possibility to select one country from the list of countries ?  Many thanks in advance

Hey all —My team and I build white-labeled mobile apps for treatment and recovery programs, and we’re finally moving a lot of our client intake and pre-development process into Airtable.We’ve got most of it built out — linked tables, a client-facing form, a few automations — but before rolling it out, I’d love to get a quick sanity check from someone who really knows their way around Airtable.Ideally just a 30-minute screen share to walk through what we’ve set up and get your thoughts on structure, permissions, and anything we might be overlooking.If you’re up for it, drop a comment or DM me. Would be super appreciated!

 I’ve been building an Airtable app for my team (about 10 people) at a foundation. We make a lot of grants across different programs, and I’ve been trying to create a central hub for all of our work. So much of what we do overlaps that it just made sense to keep everything in one app rather than splitting it up.Right now I’ve got about 15 tables:  organizations, projects, tasks, budgets, inquiries (from email), notes, annual budgets, program budgets, etc. It’s a big base, but I’ve built separate interfaces for each program, so even though the back end is large, the front end feels really clean.Some folks on my team have suggested that each program should have its own app, with a master one where everything rolls up. I’m not sure that’s the best approach. it feels like it would add more work and complexity.Curious what others think.  has anyone else gone through this decision? Does keeping everything in one well-structured app make sense, or is it better to split things out? Would love

Hello I thought this would be simple to figure out but somehow its not working for me.I have 4 tables.  They are all linked together.  Each field in everyone of these 4 tables has a common Dept Code (this is their link to each other).  Also in each of these fields is a field Associated Program.  At times we may need to edit the data in the Associated Program field.  If we do this I would like that update to appear in all the other tables as well.  I thought if I linked them this would be the case.  But they are linked on the dept code?  How can I create something that would update this other field in each of these tables.   Thank you, hope this makes sense.

Just posting this to check if there is some kind of systemic issue happening, or if this s***storm is unique to my Org. Airtable status says fully operational but something is definitely wrong.My Organization has several bases that are currently experiencing a complete collapse in their functionality. At the moment, we have 4 bases that cannot be accessed reliably, and 2 of these can’t be accessed at all. The bases can’t be loaded by any user, on any device, on any network. We have tested access from many locations and this issue persists.These bases do have some syncs set up between them, but nothing outside of what I have built many times for other clients with no issues.This appears to be an extension of an issue I have been working with Airtable support on for months now, but have made no progress:When updating the configuration of a base, updates take 30 plus seconds to occur, and always throw an error saying that the operation failed, even though they did not fail. This issue is

CONTEXT: I am a Film and TV Producer (on a Pro (Legacy Team) account) with PEOPLE, COMPANIES and INTELLECTUAL PROPERTY bases that I sync (i.e. “push out”) as relevant to seed specific FREE client/project bases so a handful of (<5) different team members (respectively) can update content specific to their projects.EXAMPLE: I maintain box office data on movies, track streaming, broadcast and cable series ratings, statuses and talent (ShowRunners, Actors, Writers, Directors, etc.), actors’ bankability stats, everyone’s credits linked to their IP, who’s moved company-to-company in the relentless musical chairs and vertically integrated morphing and consolidating - it’s A LOT to track! LOL! :-)If I’ve done the deep dive of complicated music licensing research on a specific song - or have an actor’s whole suite of (also constantly evolving) reps’ contact info, I don’t want to have to keep manually updating that across a ton of different project bases. I USED to have this all syncing perfe

I’m an event promotor. I’ve been using AT for a while to keep track of community member applications, event details, and general ticket sales. I want to get a better sense of real time income via sale so I’d like to update the base.Right now, I have 3 tables in the base:Member List - Record for each member with personal info Events - Record for each event (Party A, Party B, Party C, etc) Ticket Types - Record for each type of ticket (Full price, 25% off, 50% off, comped, etc)None of these include price of the ticket and I would like to start tracking that.Thinking the tables should be this, but I’m not sure:Member List - Same as above Events - Same as above, but add in pricing columns for different ticket types — Tier 1 = $90, Tier 2 = $100, Tier 3 = $110, etc. The pricing can change from event to event so the amounts cannot be a universal across all events. Discount Codes — This would be a conversion of the above Ticket Types table and apply an actual percentage off of the event — Ful