Base Design

HelloMy company builds complex machines with many parts. A lot of these parts, I need to buy and keep track of delivery dates and whether or not the item has been deliverd.What is the best way to set up an airtable to show all the delivery dates for all items across all my projects?If possible in one interface?Lets say I have three projects running. I need to be able to quickly manually add products to any of these projects and see all delivery dates in one calender so I have an overview. But I also need to see each project seperatly Do I create seperate tables for all these projects? (this may lead to many tables)Best practises here?

As part of my workflow, I have a view in my base where I put in all my tasks for the day, which the populates my calendar. To make this work, I have "Date Start" and a "Date End" fields with the date and the start/end time of the record so that it'll be placed correctly on my calendar. This works great but has caused an issue with creating another view that I need, a daily summary.I want to have a view that groups my records by date so that I can see how much I earned that day, how much I worked, and other stats. I can filter my records to show me this information for a single date without any issue. But I'd like to have a view that shows all my days work grouped together to be able to build a few extensions around the resulting data. The problem is that AT will group based on the entire field information, so including the time, and not just the date (see attached screenshot).The only "workaround" I can think of is to have a third date field with just the date, but this feels redundant

I am aware there is no way to "overwrite" data but I'm trying to figure out how else I might accomplish what I need.I have a very basic 2-table base.  Table 1 is "Call Log" and Table 2 is "Users".  I want to set up a default set of fields (location, type, job) that apply to specific people.  For example, "Bob" might default to Ohio, Office, Data Entry, whereas "Linda" might default to Kentucky, Warehouse, Stocking.  But as I do the weekly logs, their job scopes and locations might change.  If everything is added to the Call Log table from lookups (pulling the defaults) I know I can't directly edit them.  What would be a best-approach (I'm not against some scripting or automations either!) on handling when I maybe want to track that Bob is in Indiana and Linda is in Ohio.Thanks!

My end goal is to associate the Slack ID of the user that submitted each record in my primary base.I currently have a 'User' column in my primary base that associates each record with an "owner". I'd like to be able for the record to automatically pull the Slack user ID for each User from a "Team Roster" table that holds the User and Slack information for each team member (or maybe there's a better way).The only way I have found to do it so far is to use a 'Lookup' column in the primary base that references the "Team Roster" instead of using a 'User' column which ties the record to their Airtable account. This is not my preferred method as the lookup column selection is not as clean as a User selection when team members are choosing the owner of a record.Primary Base: Team Roster Base:  

Hello,I'm just curious to know if Airtable plans to create a list view for calendars.  We have Lists and we have Calendars but I'm looking for a schedule or list type view within the calendar.  Or maybe there is a way to create such a view? Thanks!

Hi there,To use data for a list Softr you have to have the data in the same column. How would I be able to put two look up fields (one displaying a percentage and the other displaying a $ amount) into the same column while maintaining their exact values (not making them into just normal numbers and keeping 1 as a % and the other as a $).Any help would be greatly appreciated,Bart

I have a fairly complex set up that I may need to hire someone to help us complete, but I'm hoping to answer a few basic questions before putting in all of that time and money.We design and manage renovation projects for 5-15 clients at one time.  We collect records for various products and materials, present them to our clients (option 1, option 2, etc.), get approvals and create a final list of the approved products and materials to accompany our construction documents.  Sometimes we use the same products and materials on several projects, but each project requires different quantities, colors, pricing, tax rates, etc.  I've tried creating one "master catalog" base that has tables for products, vendors, suppliers, manufacturers, categories, etc. and a separate base for each project.  Each project can have a list of 100-400+ required items and we might collect 2-3 options for each item on the list. I've also created a web clipper extension for each project bas

Hi all,We have an AirTable base for our marketing team that has multiple "sub-bases" leading into one "master base". The thought of this is to have everyone keep their work flow in their base and have all the information on the team in one place with the master base. We do have an enterprise account which is why this question pop's up, why can't we edit fields in the master base. At first we were able to but it switched and now the master base has little to no use.  Thanks,Will

Is there a way to create a time slot, similar to when you add a calendar a pop up appears and you can choose a date. I've aded a screenshot of what I've created, which is a single select option, But would like it to be more flexible. So, if you choose 9am it will autofill a a two hour duration, 9-11 or if you chose 8am it will autofill 8-10 am.Thanks. le.

I am attempting to make a database for my social media.  I am having trouble with the best way to organize it.  I struggle with how I can put things in DATE order, We typically do Month and Week # so we don't have to change the date each year, but then it doesn't go in month order.I would like one grid with all our marketing ads, then some sort of way to separate for each type by date (either as a gallery or grid).  My questions are- What is the best way to sort by date?  If I have 1 row listing multiple dates, can I have another grid or form listing each week/date individually?For the image listed, I would like some sort of sorting to separate by date:Example:First week of the month SpecialJune Special

Hi there! I have a bit of a math problem I'm looking to solve:I manage a Department with about 85 Software Designers, which are assembled into 15 Squads, which support 3 different categories of software products. And about 1/3 of the work they do is product-agnostic (like onboarding, up-skilling, tooling maintenance, etc). I'm building of Airtable Interfaces so that Designers, Leads, Managers, and our VP have access to the project information that matters to them. I'm just a little stuck on how best to architect these Tables.Should house alllllll the Projects/Tasks (Epics/Stories) from all 85 Designer practitioners in ONE Table, and then group and parce with other Tables and/or Tags?OR should I create 3 Tables for each of the slightly different product categories (since that kind of makes sense ) and just accept that Practitioners will need to toggle around a bit in the Team's Interface?Also, would separating my Department's project work into 3 Tables mess me up when I'm putting t

An existing base tracks students self-enrolling in classes by submitting Airtable forms.Tables:Students (linked to Classes)Classes (linked to Signups)SignupsThe Signups table contains forms to sign up for various classes. There are multiple forms because some require different information than others. What's really messy is that Students has one linked record to Classes for each type of class!When a form submission is received in Signups, an automation is triggered based on the kind of record received. If the class type is "Class A," automation A runs. If the class type is "Class B," automation B runs. The automations update the "Class x" linked record fields in Students.This gets more and more unwieldy since Students has multiple linked records to Classes. The person who created it is no longer with the company, but I was told the Signups table is a helper table. I'm beginning to think it should be redesigned. Would this work better with a junction table between Students and

I am wondering if anyone is able to assist with a couple of questions. 1.  When adding an attachment into the 'attachment' field I am simply adding from files and attaching a word document.  I am then having issues once I send the email with the attachment not coming through in the correct format.  It seems to only be coming through in email as a small photo that is quite blurry.  I am wondering if there is any work around to this and how I can have an email sent with the correct attachments - preferrably the word document.Above is my current airtable.  Each date has 3 specific shifts 0100/0800/1630.  I am wondering what I need to do in order to have 3 emails go out each day with the attachment (from question 1) as well as the checkmarks associated to who is involved.  I am able to accomplish this by simply highlighting all the areas on the data sheet and right clicking send email.  However I am looking to have this function automated and se

On Table A I have a linked record field that allows multiples. It pulls records from Table B. These records on Table B include a Date field. Records on Table B are not necessarily entered in chronological order. For example:Table B Record 1 - 1/1/2023Table B Record 2 - 3/1/2023Table B Record 3 - 2/1/2023On Table A, I'm trying to pull the most recent record linked using a Lookup field with the "limit the number of items shown" option turned on and set to "last 1" but I believe this is giving me the date of the linked record that was most recently created rather than using the date field of the record to give me the most recent. I believe I could play around with an automation that could accomplish this for me but before diving into that, is there a more simple way to achieve this?

Hello,I have records of 4 thousand rows in Airtable, with around 100 views and about 50 columns. Two of them have attachments fields where we store pictures.Every month, we need to create a new table organized by month, and we want to retain the previous month's views and settings, but the data itself is not required. Currently, I use the duplicate table feature without including records, but it has become quite problematic and slow. I am wondering if the Airtable team is working on improving their servers to address these issues.I need some assistance. Is there any other method or workaround to synchronize all the views and create a new table for this month without including previous records?Thank you.

Hallo community,I have two tables: "Bestellungen", "Bestellung Positionen".Table "Bestellungen" has 3 Lookup fields "Artikelnummern", "Anzahl", "Einzelpreis". So the values will be not correct sorted like in a table "Bestellung Position".I think, it is a big bug in Airtable.P. S. If it is not possible to sort automatically in "Bestellungen" table, how should I sort it in relative table "Bestellung Positionen", which filter should I use. I know how to sort Table "Bestellung Positionen" by a field with a type "Created time", then the result with be ok, but I still need an option to order it how I want... And table "Bestellungen" should automatically bring me the same order.Thanks in advance. 

Hello,We are currently at 38,500 records. I'm curious how others are handling their data once they hit 50,000.Do you duplicate the base, delete all records and continue on (thus leaving all your fields, automations intact)?Looking for suggestions.Thanks!

Hi, I am trying to design two bases on Airtable for my team:Base 1: Instruction ManualInformation: This base should consists of all tasks our team need to do throughout the year, which instruction and attachment.Base 2: To-do tasksInformation: The tasks of this base should be synced from Base 1. In this base, each task will be assigned a collaborator, start and end date, task status, and team's comment. My current questions/roadblocks:1. In my Base 1, ideally, there should be two tables of tasks - "standard" and "intensive". But I still want both tables to be synced directly into one table in my Base 2. 2. In my Base 2, ideally, when I run a script of auto-updating the start and end date of each task, it can create dates of the following year, i.e., my team is currently monitoring the "to-do" and "in-progress" tasks (synced from Base 1) of 2023, but since all our tasks (both standard and intensive) are repetitive throughout the year, we would like to plan ahead say towar

Hello I'm new to airtable, and I recently had a website built using Airtable as a database for a car listing widget. We have a column in our airtable where we input a short and long description for each vehicle we list. Below is a screen shot of what the data looks like once we past it into the cell of the airtable. It looks like one big run-on sentence. Is there any way to format this data to display nicer? Or at least have a line break so that each sentence can be displayed on its own line so its broken up some and easier to read? Thanks!I would prefer it read like the following if possible.... SOLD!USED HEAVY RESCUE PUMPER FOR SALE!8 Man Cab (7 SCBA Seats)Air Conditioned CabDiesel EngineAutomatic TransmissionMileage: 19,074750 GPM Side Mount Pump500 Gallon Poly Water TankFoam TankFoam Pro Foam SystemFront SuctionFront Trash LineGenerator Light TowerElectric ReelCascade SystemFront WinchFederal Q SirenRear Arrow StickRear Tripod Scene LightsCoffin Storage Up TopSlide Out Tool Tr

So it's obviously quite a shock getting the email yesterday, the 23rd of August with the massive downgrades to the Pro Plan (Team Plan). However, this post is not to nag on the obvious downgrades which are going to affect how some current systems work. How I see it is some clients will have no choice but to upgrade, at a high expense, or stay on the Team Plan and try and work with the downgrades. My first question that I want to have more clarification on what's offered on the new Business Plan that was not available on the Pro Plan. The two main points that really stand out to me are as follows:Two Way Sync 🆕Unlimited Workspaces 🆕Are there any other exciting features I can show my clients that was not available until the new Business Plan features come into affect?  Question 2: Unlimited WorkspacesPrior to this, my understanding on the Pro Plan was that each workspace was billed as an individual plan. So if I had two workspaces that needed the Pro P

I am working on a base with one table that has a record of all my fabric purchases, their respective lengths and widths. I want to create a my second table as a list of patterns and the length and width requirements for the fabric necessary to complete the pattern and have it automatically pull what fabrics I have that are eligible for the project based on the length and width criteria of the pattern. Is this possible?

I think it's clear that the vast majority of the Airtable Community has rejected the new dashboard/home screen design. For every 1 person complaining here (and there are many across the threads), there are many more unhappy people that are not posting (like my 7 staff members). It's clear the Product Team & decision-makers have no interest in accommodating or reversing this update after removing the option to roll back to the previous version, regardless of the negative feedback already received then. Yet Airtable Management needs to address us. So if it isn't regarding a solution to our concerns then I would like to ask;why did you 'fix' something that to so many of us wasn't broken?what methodology or use cases determined dashboard navigation & layout? what artistic school/philosophy/strategy determined the new colors/designs? why was the initial roll-out done without warning & why now are you forcing everyone to use the new dashboard instead of a

Hello Airtable Community,I hope this message finds you well. I'm reaching out to inquire about a potential workflow that I'm interested in implementing within the Airtable database.My objective is to create a user-friendly process that involves the following steps:Pop-up Dropdown Menu: Upon clicking a designated button, I'd like to trigger a pop-up dropdown menu.Link to "Startups" Tab: This dropdown menu should be intricately linked to a specific tab within our database, specifically labeled "startups."Automated Email Template: Upon selecting an option from the dropdown menu, I aim to have an email template automatically populated with the relevant information.Functionality Similar to Dropdown Lists in Forms: I'm essentially looking to replicate the convenient functionality of the dropdown list selection process in Airtable's forms.Note:I've been exploring alternative approaches beyond using a field to establish a link to another record. My goal is to identify if there's a formula or a

hello everyone, I have a question that i can’t change the order of my wokspace. It’s just can arrange depend on my “Created date”? btw i use the app not the web airtable. if someone can help , I’ll Appreciate.

Hi!  I am building a project management tool, and I have difficulty understanding how I can use my Project and Tasks table combined in a way I can get a gantt view of each project, with the tasks and subtasks nested.  When I create a gantt view in the projects table, it shows the projects, not the tasks and subtasks.In my mind, it would be something like opening a task table from each project line, but the system don't work like this.Thanks for anyone that can help.