Base Design

I have created a base for cataloguing books/manga. The problem I’m having is with audiobook narrators. When a book is logged, they sometimes have two different narrators. They log the narrators names and the strengths and weaknesses of each narrator. For a specific example, lets say there are two narrators. Narrator 1 is Julia Whelan and Narrator 2 is Will Damron. Narrator 1 strengths (a multi select field)  “Distinct Character Voices” and “Emotional Resonance”. Narrator 2 strengths are “Good Articulation/Pronunciation” and “Good Rhythm and Pacing”. Then the information is supposed to go to a narrator table where it logs this information. Because they narrate multiple books, these strengths can be added to with other books. The issue is that as far as I can figure, a lookup field won’t work because they need to apply to only the correct narrator. A rollup has the same issue. I can do it via automation but that gets really messy and complicated because it will create extra little bubble

Hi, we need to set up an attendance tracker (I know how to do the student and class dataset) for teachers to track students attendance in three activities each afternoon (same teacher tracks all three, and there are 6 teachers / classrooms). I know how I could do this in the form but are limited to each student with the three activities. I want to give the teachers a form to fill it that looks like a excel table, with all the students names on the left, and the three activities on the right for them to mark as present, absent, or partial. We do not want to use a portal as those are expensive. Will I need to use another application on top of this to do it? If so, which one if we want one place that the teachers go to for a drop down list of their classrooms, and then to fill out the matrix. In addition, how would you set up the attendance data table in airtable. Thanks!

I am needing to build a dashboard to represent TAT on Account Implementations for various teams. I am being asked to use a field history report that will give me a date and time stamp when Stage or the Platform Setup field is changed. We want to be able to show an overall TAT but granular time spent in the various options. Historically I have had a report that would be a single line item per Opportunity with the date stamps out the right in columns.Is there a way in airtable, or before airtable, to help me consolidate or accurately report the metrics? Here is a snapshot of the data from the field history report I am being asked to use: 

Hello! I am importing messy data entered over many years in many different formats. I am hoping there is an easy way to merge similar single select fields in one.For instance, in the screenshot below there are 50+ ways that people have entered this info over the years, but I would like to consolidate those into under 10 categories. So I would want to take the “Large” single select option and then pull in the various fields such as: “lg” “Lg” “large shade” “large?” etc.Hoping there is a simpler way to do this because there’s a large volume of records.Thank you for any thoughts! 

Hey all! I am building a base to track degree progress over about two years for a small group of students. These students need to do four internships in these two years, and I am trying to use a gannt view to set four semesters as dependent on each other. I am having trouble with how to move students backward. For example, I have linked fields to the specific semesters that students are doing internships in: First internship: Fall 2026 Second internship: Spring 2027 Third internship: Fall 2027 Fourth internship: Spring 2028 I am trying to build the system such that if I change the second internship to Fall 2027, it will change the value of third and fourth internship to Spring 2028 and Fall 2028 respectively (but NOT change the semester tied to first internship).  Has anyone done anything like this? 

Dear Airtable Community, for a Project Gantt Plan I have differnt swimlanes that are grouped by Workstream Tags. The gantt view used to show the Tags in a column on the very left side of the table (directly next to the column of the different views). Now this column with the Grouped Workstreams disappeared and there is no option to show it again only when I change the Layout from Gantt to stacked. Please help

This seems to be a grossly missing option for sorts.  I should be able to check a box to decide if I want blank fields to show at the top or bottom of a sorted column.  I know there is a workaround, but I shouldn’t have to create a workaround for a painfully missing feature.  How do I submit this as a feature request and get everyone to upvote it?

I’m looking for experts to build an all in one inventory management system with CRM capabilities. Each item in our stock is unique. The system needs to work in multiple currencies and track purchases, sales, partnerships in items, stock value, consignment etc. UK based but open to international developers/experts too. 

Hopefully a quick yes/no.I have several published datasets right now serving multiple bases all within one workspace.I’m about to split out our workspace into several for permissions control reasons. Will the dataset still be available to other workspaces (all under the same account), or is a dataset limited to just the one workspace it is created in?

Seeking an Airtable consultant with experience building product development, merchandising, or retail operations systems in apparel, home décor, gift, or consumer products. I am currently implementing Airtable for a nonprofit client and looking for hourly screen-share coaching while I build the base myself. Need guidance on product development calendars, cross-functional workflows, linked records, and database architecture. Seeking flexible, pay-as-you-go support rather than a large consulting package or minimum-hour commitment.Thank you! Rebekah 

Hi all,Anyone else having this issue today?  I’m not doing anything I haven’t several times before.  Not sure if the issue is with me or Airtable is having a challenge.  

Why is it not possible to view all of the “Pages” in a base? On an interface view we can create and view all the main pages, but in order to create specific record detail layouts we need to drill down through any and all pages to get to the record detail layout we want to edit. Then we can save a copy and rename and edit, but it would be so much easier to be able to open a “Library” of pages and layouts related to our database so we can easily and quickly view, edit, and copy these.I have to write down and keep track of which page layout I have for different views so I don’t forget where it is and how to get to it.

 I need to perform some calculations on the evolution of the skills of all participants individually, using the Airtable interface. For this, I need your help to create the data model.This is the information flow:1- At the beginning of the program, participants must fill out a Google form with 36 questions (never, rarely, sometimes, frequently, always) to assess their skills. The key is their email address.2- At the end of the course, they answer another Google form with the same 36 questions to assess the development of their skills. I already have a table with the participants' data, where the key is the email address.What is the simplest solution to implement this?I've already asked for help, but I haven't been able to implement the solution. :-)

I build 3 tables:First table for suppliers: supplierId, supplierNmae.Second table for products: productId, productNameThird table for the link between suppliers and products: supplierId (link to suppliers table), productId (link to products table), price (the price of the product that supply this product).In relational data base that what I need to buid.Is that what I need to do in Airtable data base?  

My job is changing and I’m going to be managing 3 employees.  Each has their own set of tasks, but when one person finishes a task, then the next person can then begin doing their task that is associated.  In my head, I have Task field, due date, and who it is assigned to in Table 1.  I have an airtable I use for my tasks and when I have a date assigned, it will email me on that day and tell me all the things I have on my task list for that day.  I’m wondering if I can do the same thing where when a task is assigned to Taylor, it will email her on the date, as a reminder.  And when a task assigned to Betty comes up, it emails her.  And the same for Augustine.  Is it possible to have it automatically email 3 different people based on the tasks assigned to them?  I’m watching training videos, but haven’t found one yet that advises me on the most efficient way to do that. Thank you in advance for any guidance you can provide.Mary

DescrizioneCiao,sto cercando un freelance per aiutarmi a costruire un sistema di controllo di gestione per una società immobiliare (affitti brevi e medio termine).L’obiettivo è creare un sistema semplice ma strutturato che permetta di avere visibilità quotidiana delle performance economiche per appartamento.Obiettivo del progettoCostruire un sistema che consenta di visualizzare:Ricavi per appartamento (OTA, diretti, ecc.) Costi (pulizie, utenze, condominio, commissioni, ecc.) Margine operativo Vista per: cassa competenza fiscale Il tutto tramite:database strutturato dashboard chiara e aggiornataScope del lavoro (fase iniziale)Creazione struttura dati (Airtable o simile) Implementazione logica di calcolo (ricavi, costi, margini) Creazione dashboard (Looker Studio o equivalente) Eventuale setup automazioni base (Make / Zapier)Stack preferitoAirtable (o Google Sheets avanzato) Make (Integromat) Looker Studio / MetabaseSe proponi alternative, spiegami il perché.ImportanteNon sto cercando

For my project, I need to compare responses between two Google forms with the same questions. At the beginning of the program, the student fills out a form with 15 questions (competencies) of the type (Never, rarely, sometimes, always), and at the end of the program, they fill out another form with the same questions. The goal is to validate, by student, whether there has been progress in competencies or the evolution of competencies among the various students.I already have the table with the students' data; how should I create the tables for this project? Thank you very much! 

I have a product table. The first field is ProductId and I want it as a unique field.

Every time I expand a record, the activity feed panel resets to its system default view of “Comments only” instead of remembering my last selection or having an option to change the default per user. For teams that rely heavily on tracking changes, this means manually switching to "All Activity" or "Revision History" on every single record open - which adds up fast.A simple "remember my last selection" or a setting under personal preferences would go a long way.Would love to see this added. It seems like a small lift with a solid quality-of-life payoff. Anyone else finding this frustrating?Has anyone found a workaround in the meantime? And would others find this useful? If so, please upvote. Happy to submit this as formal feedback to Airtable if there's interest.

I have been trying to brainstorm a way to report on all the orders in my Airtable system. I would like to be able to pull reports based on some time measurement (weeks, months, just today, etc.). The best way that I can think of is to have a script that creates a “week record” in another table and assign orders to a week. I would then use those week records to report on.This mostly works, but it feels very chunky. Are there any better ways of doing this?

I got this idea from the AirTable webinar for their Field Marketing team, where they can click a button and generate standard tasks for different events.I worked with an AirTable team member onsite at the NYC event and created my “Tasks” table and I know how to make the button automation. But I seem to still be missing a step.(my tasks table):How do I link my tasks to the event so I can have different due dates? I’m trying to avoid the date dependency set up since our events have different requirements and my coordinators need to be able to adjust those as needed. The real issue I’m trying to solve is that my current task automation is set up with record templates but doesn’t assign those templates to a specific event so I have to go through manually and assign the a show.

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! I’m a first-time poster here. I hope the below makes sense. Here goes.I’m a Marketing Coordinator and we have a team of 6. I am redesigning our Airtable base, so that it aligns with best practices and utilises the functions within Airtable more efficiently. Currently everyone works directly from tables, with no interfaces or automations. I have a fairly good understanding of Airtable and it’s capabilities. Our team has deliverables associated with multiple departments and with many external partners. I am starting from scratch, building workflows and the likes, having inherited the Airtable space.Departments include:Product Sales Partnerships (including events) Customer Service RetailRequests include tasks for:Social Content eCommerce Web and SEO Photography and videography Print and digital design (for catalogues, sales conferences, specialty customer product promos, website, etc.) Photo and video processing, editing and creationMy question is; would it be suitable to have all tab

Somewhat recently, Airtable updated self-linked record fields so they automatically create a second field on the same table showing the inverse relationship — same as how linking between two different tables has always created a field on both sides.I have a few tables with self-links that I set up before that change, and they're still one-way. Is there a way to add the inverse field to an existing self-link without deleting and recreating it? 

There is a BASE / Table / bunch of fields.There is web app using API, which neatly makes a form for users to change their details, not just create as Airtable native forms.Everything works perfectly, until team member changes the field name.I know you can use serial name “fld123ABC456”, but it involves creating another object to hold pairs of serial names and human readable name. Code is also much cleaner with field names. rawContacts[xyz].fields[“Some Field Name”] reads much better than rawContacts[xyz].fields.fld123ABC456Question: is there a native way to find who and when made a field name change.Also how the change was made old name → new name and old type → new type I have been asking Airtable, as enterprise user for years now, to implement admin layer on field definitions, so that very few people can make these devastating changes. In the meantime, is there a log of these changes natively?Or does it have to be a hack of either manually defininThere is a BASE / Table / bunch of fi