Base Design

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 produ

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

Hi Airtable Community, I’ve got a sandbox running on one of my networked Airtable bases as I work on configuration to connect it to another platform, but I keep getting an error message when I try to apply changes made in the Sandbox to Production:  It’s the same error every time. I have creator permissions in both environments, as do the accounts of our external vendor working on the integration. I emailed Support, and was greatly disappointed to get an AI bot response. I’m hoping some real human beings can help me out.

Hi, I’m not so clever at IT and despite reading the Help and this site can’t find an answer.In Kanban view, all cards are listed under UncategorizedSo, how do I create Categories to get the cards out of that column?

I’m building an information architecture for digital asset workflows, especially emerging genAI workflows.Airtable is one early prototype surface for that work, but the larger project is not “just an Airtable base.” The real system sits above it: it defines the structure that commercial asset production actually needs — intent, inputs, constraints, orchestration, outputs, and governance.What I’m trying to solve is not simply how to store asset metadata, or how to bolt AI onto an existing workflow. The deeper question is whether brand rules, approved references, creative constraints, and output expectations can be made structured enough that a system can actually carry them without collapsing into prompt chaos.One early execution proof of that model takes the form of an Airtable base. But the interesting part is that I’m not just manually building a base and calling it done. The larger system expects that prototype, specifies it, auto-builds it, and now uses that

I’m an executive assistant who manages a “phone sheet” for an individual in the entertainment industry for someone who “rolls calls.” For those not familiar, essentially I call on the behalf of my boss and then keep a running log of all the outgoing calls placed but not answered, incoming calls not answered, reminders for calls to make at a later date, and then mark completed/connected calls. I use a program called “Phoneslate” that I’m attempting to make a dupe on Airtable. Here’s my question: I would like to be able to enter in someone, let’s say “John Smith,” and then have a column where I can select any of the phone numbers linked on the record. As you can see in the example pho

my organization does trainings and after each training, we send participants a post-survey to fill out. each training covers slightly different topics, so the questions we want feedback on change slightly with each training as well. right now, i have one table called post-surveys where each field corresponds to the questions we ask, and the field names are shortened versions of the questions. then we build the form for each post-survey based on which questions we’d like to include. the downside is that it means that table has a huge number of fields and it’s hard to see if the question you want to include already exists as a field or you need to create a new one. (e.g. “S3 FSOW: Challenges” means in session 3, we had a question about challenges that related to the reasons we did the session, you can see how that makes it hard to keep track of the actual question)

Hello,I am new to junction tables and have pretty much zero scripting experience, so bear with me.I am trying to create a breakdown of call sheets for group shoots and create individual “shifts” in a junction table. The goal is to be able to adjust start and end times for those linked in the shoots and to be able to create a more comprehensive reporting interface to track hours and OT by multiple criteria.I cannot show the actual base, but have created a basic example of the structure and result of Airtable’s junction table extension.Client tab:Franchise: Franchises have assigned POCs for internal notification

We’re an embroidery company and We’ve been working on relaunching our website on Shopify and we were planning on using a third party warehouse management system but we’ve had a dreadful time with the supplier and we’ve decided to scrap that project as its delaying launching our website (already three months late) For at least this year, we’re looking to use Airtable as our operations system and set up with a two-way sync with Shopify.  Has anyone used Airtable as a :  lightweight WMS / production workflow layer alongside Shopify? Has anyone managed production workflows (e.g. batching, manufacturing, customisation) in Airtable?  Basically  we’llUse Shopify for: storefronts (each school has its own store) orders + payments Use Airtable as our operational system, to manage: order lines (each item in an order) supplier ordering

I have a production base and a sandbox version of the same. I often accidentally mix the two if I don’t carefully look up to check that I’m in “ Sandbox”  mode when I’m working fast.  I’ve read you can change the color or base name e.g., “ Base (Sandbox)”  vs. “ Based (Prod)” from the home screen.  However when I try that I only see the main Prod base and it’s only allowing me to modify the name of the Prod base. I don’t see  a separate way to modify the name of sandbox itself.Has anyone been able to manage this? and how? Thank you. 

Hi, I am trying to create a pipeline that a few users can manage a “global view” and then when updates are made to automations or tables from there all the workspaces sync, but the workspaces can be broken into regions and maintained separately by diff teams. Are we able to do something like this? Thanks! 

Hello Airtable Community,I am working with a non-profit Educational Institute to centralize over 20 years of data currently scattered across various spreadsheets. Our data includes Programs (15+), Students, Enrollments, Mentors, Alumni, Marketing, Scholarships, Startups, and Events.Our Goal: We want to move away from siloed spreadsheets into a centralized Airtable ecosystem where we can track a participant’s journey from Student to Alumnus to Mentor or Founder.My Questions: Single Base vs. Multiple Bases: Given the volume and variety of data, should we aim for one "Mega Base" or multiple specialized bases? Unique Identifiers across Roles: For our Students, we use a University ID as a unique identifier. However, for Mentors, Alumni, and other external partners, we don't have a standardized ID. What do you recommend as a Unique Identifier f

I need to work with 2,500 - 3,000 records for a 6-Mo/1-Yr project. Once the records are loaded there will be no need to ADD primary records; maybe a few variables in associated tables. Only one ‘Seat’ is needed; no team collaboration. When the project concludes if I change the Base to the Free plan what will happen to the records over the 1’000 limit?

I have created a base that I want to use as a central dataset (People, Office, BU, CoDEs, Disciplines).I am syncing the People table into another base (feedback base) and linking to it. I can successfully pull through the Name field, but I cannot get Office or CoDE-related data to come through correctly.When I link a record, I only see the Name, and lookups for Office / CoDE fields return blank.SetupSource base (dataset)People table:Name (primary, single line text) Office (linked record → Office table) BU (lookup → Office → BU for Office) Office List (lookup → Office → Office) CoDE Lead (linked record → CoDEs) CoDEs List (lookup → CoDE Lead → Codes) Other fields (emails, etc.)Office table:Office (single line text) BU for Office (single line text) People (linked to People)

I am looking for a front-end developer to build the public website for Single Use Connect, a B2B platform serving the biopharmaceutical industry.The site has already been fully designed — we have production-ready HTML, CSS and JavaScript, along with SVG logo files and a defined brand system (Libre Baskerville / IBM Plex Sans, a navy and teal colour palette). Your role is to take this existing code and turn it into a live, hosted website.What we need:— Ability to implement clean AirTable data base— Experience deploying softr App— Custom domain configuration (singleuseconnect.com)- A user access management— Basic SEO setup (meta tags, Open Graph, sitemap)— Mobile responsiveness review and polishThis is a focused, well-scoped project — the design is done and the code is largely written. We are looking for someone who can take it across the finish line cleanly and professionally, not reinvent it.Expected timeline: 2–3 wee

I have a base with a single table that I’ve published as a library. I went to add that to another base and noticed that there’s a description that I had previously given to the library base, but now I can’t figure out where that description lives. I need to be able to update that text. Is someone able to tell me where that info lives? Slightly longer description of the text I need to edit:In the new base, I click on the plus sign to add another table, and under the ‘Add from data library’ I click on ‘View more...’  Then I see a few cards with the bases I’ve added to the library, and they each have a brief description that was obviously written by me. 

HelloI am a relatively new user of AirtableI am interested in using it to manage my life and work using the 12 week year approachI downloaded a base from the community for thisI am trying to understand how I can use this base week in and week out without having to copy and paste tasks repeatedly? Thanks

Hello, I want to build something and need your thoughts on it.We have seventy technicians who need to conduct an inventory of their vehicle contents once a year. I would like to map this using Airtable. I have the data of the technicians in another database, which I sync into the new base. Now the contents from an Excel file (each technician naturally has a different one) must be copied and pasted into Airtable. The inventory should then be able to be conducted. Each technician should only see their own data (this can be done easily via the Airtable ID). The technician should confirm at the end that the inventory is complete and then no longer be able to make changes. I am only missing the basic concept of how to best structure the base. I have an idea, but I am not sure if it is wise. Therefore, I would appreciate brief bullet point input from you. Many thanks! // Update ;) I can answer the first question myself right away. I would filter the view

I am learning Airtable and am with a new company as of November. I’ve taken many of the online classes to learn the system but am still encountering issues with a few things. I believe part of it is the way the current data and forms are designed. I don’t think they were too far off during the creation process. However, I’d love some assistance reviewing a few small items. I’m unable to change some forms and a few other oddities. The only person who knew the system has left the company. Perhaps a 15–30-minute call. I’m sure I’m overcomplicating things. Anyone with 30 minutes willing to help me out?

En los botones de búsqueda dentro de la interfaz, actualmente solo se puede buscar por el campo principal de esa tabla. Por ejemplo, si tengo en la tabla cliente: como primer campo ; “ Teléfono ” . Como segundo campo; “ Nombre ”. Actualmente solo puedo  buscar por Teléfono, porque está establecido u  ordenado  como campo principal. No puedo buscar por nombre o otra categoría , aunque la vista previa si lo contiene. Sería posible de alguna otra manera, que no se unifique estos campos. ¿?Podrías hacer algo para que sea posible. 

I reviewed the following related topic but would like to do a quick check to make sure I’m on the right track…I work in natural resources but essentially have an inventory type question. I have locations (preserves) with sub-locations that I am tracking inventory from (both receiving and outgoing). I am still building my base and recently realized that I should probably move the locations into its own because multiple tables/records are related to the location AND it’s a bit more complex than a short list of 5 items. As I started building the location (preserve) table, the problem of sub locations came up. I’ve included a couple screenshots of how I have it setup at the moment. Does this look okay from a design/structure standpoint? Ultimately I will have seeds coming from these locations and plants going back to the same or different locations.