Base Design

I’m managing service requests (tickets) for apartments using Airtable and need help creating a more advanced lookup field. Here’s how my base is set up:Tickets TableEach record represents a service request (ticket).Each ticket is linked to the apartment it is for, using a linked field to the Apartments table.Tickets have a Tags field (multi-select) where multiple tags can be assigned (e.g., Appliances, Plumbing, Internet, HVAC).Apartments TableEach apartment is a record in this table.It is linked to all tickets associated with that apartment.Current SetupIn the Tickets Table, I have a Lookup Field that retrieves all other tickets associated with the same apartment as the current ticket. For example:Apartment A has three tickets:Ticket 1 (Tags: Plumbing, HVAC)Ticket 2 (Tags: HVAC, Internet)Ticket 3 (Tags: Appliances)When viewing Ticket 1, I can see a list of all three tickets because they are all linked to Apartment A.What I Want to DoI want to create a field in the Tickets Table that o

Hi All!I am trying to change a single select field in my base to a linked field, with all the single select options populated as rows in a new table. I have a long list of single select options that I do not want to have to re-type manually if possible.I could have sworn this was possible in the past with a right-click action, but I can't find it anymore (or I don't remember right).Thanks,Jaco

Hi,So far we've been building a small CRM for internal use. Out of curiosity I started wondering if it would be possible to re-design it to support other companies. I've seen multi-company databases having an owner identifying prefix to fields, e.g.company1_projectcompany2_projectcompany1_e-mailcompany2_e-mail etc etcFor users there's the abstraction "current user" but haven't seen anything like "current organisation" as an access role qualifier. How would one build any access right system hard limiting any access to the user's own organisation.Would this be at all possible to design? Or would one need something like Bubble on top? Which then would take away the whole point of Airtable, and suggest doing everything from scratch within that environment, non?Rgds,Björn

Hi Airtable community,I’m seeking advice on the best way to structure a base that involves Tasks and Issues, which have overlapping fields but serve distinct purposes. Here’s the situation:Issues: These require detailed tracking and notes, including fields like changes made, follow-up steps, progress status field, open/closed field, inspection notes, and specific next actions. They are client-facing, often shared externally via reports or synced with external platforms.Tasks: These are broader, internal actions (e.g., conducting reviews, generating reports, collecting data) that help our team manage workflows. Tasks frequently lead to the creation of multiple Issues. Tasks need fields like progress tracking, notes, and assigneesShared Requirements:Quality Control (QC): Both Tasks and Issues require QC, and we need a single view or dashboard to easily track what requires QC across both types when they are ready.Active Assignment Restriction: Only one Task or Issue should be active for a

Right now we have a few different bases where contacts live and we're thinking of restructuring our workspace so there is one master contact list. Within the master contacts table we will have filtered views that can be synced to the relevant bases. The bases where our current contacts live have automations through Airtable and Zapier with 2 way syncs with our Salesforce and other apps. In theory it makes sense to have one master list so we can easily track all of the information for each contact in one place.My fear is that creating one master list for the whole org to use (~24 people) will cause issues if there are upload errors/mistakes or automation errors/mistakes that will impact the whole org all at once. Our organization has contacts for our members (10,000+), donors, prospective donors(5k+), press contacts, political contacts, and basically anyone else we interact with. I'm also wondering if the time commitment of this would be worth it right now. I imagine this is going to be

I have multiple lookup fields with similar data but from different sources that i would like to have merged into one lookup field. Is that possible and if so how?

I am tracking two kinds of activity related to a list of locations that I keep in a table called LOCATIONS. One kind of activity (programming) has very specific dates. The other kind of activity (development) is hard to pinpoint in time so I do not want to assign specific dates, but I do want to know what calendar and fiscal year activity is happening. My question is, should I create one table for all location activity, so I can see it all in one place for each location (when grouped by location), or should I create two tables and then look at my LOCATIONS table to see all linked activity? Or maybe just track development activity in the LOCATIONS table? Thanks!

I have a project management base. I use the in-built Time Tracker extension to track the time spent on each project. I have several ongoing projects, and I work on more than one project each day. It annoys me that I have to select the project from a relatively long list before starting the time tracker, so I am trying to figure out if there is a way to skip that step.I have a table with clients and another with projects (Project name, Authorized number of hours, Time spent, and Time left). Is it possible to use the button field in the projects table to start the time tracker for a specific project with one click on the button in that project's row? Or is there perhaps a better way of doing this?Please feel free to ask if my question is unclear.Thanks,Lene D. Kottal

Hey there, I’ve decided to venture into trying to achieve my mail-merge in Airtable. Premise: I have pre-written documents written by a lawyer to issue to new clients. (the copy is multi-language but the details of the project and the client remain constant) I would like to synch the client name, and project details into the copy. I’ve read and have tried to make the CONCATENATE approach but I feel it is very messy, and ineffective should the copy change at a later date, it also I will need to weed through the formulas to fix it. I tried another approach of creating a separate table of “parts” that at pulled in as needed, but since they come in as an array it made it tricky for me to figure out how to reference each key of the array. I’d love to hear from anyone who has tried this endeavour before.

Evening All, I'm building a data structure in airtable to represent a rather large tree style database. We're talking about 50k to 100k objects in the tree. I've got the heirachy view working quite nicely by uploading the components using the api, and then (again using the api) linking the objects with parent/child relationships. The next issue I have is some of the data the objects have. Most objects in the tree have a unique set of data. For example, one might have {colour, size and weight} while another might have {power, consumption}Is there a good way of representing this? The cleanest way I found was by creating another table of this data and then linking it to the original objects, but with 650k data points, this doesn't seem feasible on a large scale.I can add them as generic fields i.e. data01, make it a text type and then put the value in like "colour:Blue", but it's not ideal.Let me know if you have any suggestionsRabbit

Hello everyone, I’m running a speed dating business and would like to automate the matching system. What I want is the following. After the speed dating, each participant will receive an airtable form in which they can each select any number of participants of the opposite sex that they want to match. If Woman1 selects Man1 AND Man1 selects Woman1, then a formula must be triggered and I’ll then use zapier or the email block to send emails automatically with each other’s private info. Any idea on how to organize that ?

Apologize for this possibly simplistic question, but here goes:I want to create a field that is a Category, that based on the category value selected, will ONLY display a list of relevant Sub Category values for the selected category. EXAMPLE (Simplified)1.  I have a field that is Product Category - it has two values: Mobile, Home.2. If you pick Home for Product Category, for the Product Sub Category, I would want to display the Home Sub Category values. (Wireless, Wireline, Other services)3. To take it one step further, I would also like the Product Sub Category could have  Product Sub Category 2, that would show ONLY relevant values based on the Product Sub Category. (eg. Home > Wireline > 5G Router, 4G Router, Extender, etc.)Is there a way to set up a table to have this hierarchical relationship. Do I need to refer one table to another, etc.? How do I do this in Airtable? I would prefer to have the values exist in a table and not buried in a formula for vis

I have a group of freelancer reporting weekly on how many hours they worked on various projects. Im looking for a way (either through a view or interface) to see a report of how many hours are worked, by each employee, on each project, per week. 

I am attempting to create a SignUp Page in Airtable. My current iteration is live at this link. The form does meet the basic requirements I have, BUT the design/UI is lacking, especially the "Select Your Session" drop down.Is there a way I can change the "Select Your Session" into a Grid View, List View Interface, or even a Radio Button List within this form? Context: I'm trying to accomplish the SignUp process on an Airtable form because in addition to giving people a list of time slots to choose from, it enables me to prefill the guest's application number on the form (and hide it from the guest). This means the guest's application will be automatically linked to their session when they submit the SignUp form.I don't know of any other way to accomplish this because, for example, an interface doesn't allow me to prefill the guest's application #. Ideas or input welcome! TIA,ML

Hi All! For the Gantt Chart view, does anyone know if there's a way to have airtable automatically adjust all dependent task start dates when the predecessor task is moved up (backward in time)?  I see that airtable automatically pushes out all dependent tasks automatically if a predecessor task is delayed (this is great!) but if a task duration is shortened or end date is moved back, all of the dependent tasks stay exactly where they are. Is there a setting or bit of automation I can add to enable automatic date adjustments in both directions?  This seems like a very basic feature for Gantt charts and doesn't quite make sense to have it only for updates in one direction but not the other! Jack

Hola a todos! Estoy buscando contactarme con gente que tenga buenos conocimientos de airtable. Estoy trabajando en una base y mis skills no son suficientes. seria genial poder juntarme interactuar con gente de Córdoba para sacar el proyecto adelante. gracias 

I am trying to build a more comprehensive product-tree type base where I can accurately keep track of Projects, Assemblies, Parts, attachments, and revisions. I want to have a parent-child relationship in that same order as well, but I don't strictly need to assign this attribute. The goal is to have some sequence number for an assembly or part, where the first few strings are based on their parent fields. I've found a sufficient workaround for the hierarchy by just linking tables and limiting to one field per record. Now I'm stuck because I can't limit my count or sum formulas to only be above the current record like I would in excel. For example, I have AssemblyA, AssemblyB, and AssemblyC.If assemblies A and B already have 5 parts each, when I create the first part for AssemblyC it should be in the format [Proj#]-[AssyC]-001. With autonumber the sequence would have jumped directly to 11 by now, even though this is the first part for AssyC. Has anyone found a way to implement this?

Hi all,I have an automation that needs to send an email to several people in one organization (the record is the organization). Is it possible to add more than one email address into the same field (Email? text?) rather than me creating 5 different fields that are all columns? 

I have a form that i am sending out to my team members to understand how much time they anticipate they will spend on a project. I'd like to create a dashboard that shows in a bar chart how much time each member of the team anticipates to spend this week by project. So for example a bar should look like [----Blue----][--Green--][-Red-] with blue representing one project, green representing another, and red another. giving us the idea that the team member's time is 80% spoken for this week, with 30% going to blue project, 20% going to green, etc. The issue that I am running into is that the way that we have structured the form, the output table looks wide. so it looks like :Survey EntryName (link to project record)Survey DateProjects (link to another record)Blue ProjectGreen Project Red Project1Sarah Johnson11/20Blue Project, Green Project40%60% 2Javier Smith11/20Green Project, Red Project 30%50%3Charles Estevez11/20Blue Project, Red Project20% 70%In order

Hello! As I'm quite new on Airtable, I need some help on the general approach for the following task:I already have a table of products for my Webdesign Agency with prices per year and use this also to track by renewals.Structure like in this photo:Now, I want to have a table, where I can distribute the costs to my customer. I would need to assign products to customers and based on the numbers of customer assigned to a product, the cost per customer is calculated (Price of the product divided by the numbers of customers using this product = price per customer) and it should be displayed like in this Excel table I use currently:Honestly saying, I have no idea, if such a scenario could be done with Airtable or if I should use Excel instead...So my question: Is this possible and if yes, is there any tutorial available, where such a scenario is explained?Thanks in advance for your help!Cheers Peter

I want to find the sum based on my first metric Companies and within that a metric KPI such that i find the sum of all values of a single KPI within a company. For example, I want the sum of travel hours for a single company and also the sum of fuel used for a single company. What formula do I use.

I am trying to create a base/table to track promotional inventory on a website.There is a set amount of inventory at any given time3 Hero Images3 Banners5 TilesMy goalstrack which promotions we have running at a given time Track the usage of each promotional elementLimit usage of a given element if we are oversoldCurrently I have a table with the following fieldsNameStart DateEnd DatePlacement (Multi Select with each element)Details (Long Text)

Hi, new to airtable. I have several databases related to various types of inventories. I just want a simple interface to be able to select, for instance, a product. Then have the database properites for that product presented so I can edit them. For instance, adjust quanties. From the little bit of googling I have done it doesn't seem possible with airtable's built in tools. 3rd party tool implentations seems like a house of cards. I have tried this in Notion and it quickly becomes too complicated to be reliable. Are there any other ideas out there? Thanks 

Hi all, I’ve been reading through a ton of different conversations about Airtable and recipe managers. and have found some amazing info on here. I’m currently a little blocked so maybe someone has more info on the following topic. Overall, I’m trying to create a database that has recipes where I can understand both the cost per recipe and the macronutrient breakdown for each recipe. Where I’m getting stuck is breaking down the nutritional values because some ingredients are in cups and others in tbsp. I’m trying to convert measures to grams but am having trouble connecting the conversion info to the recipe info. Generally my table is structured as follows: I have the following tabs within my doc Meals - it’s the meal planning tab Recipes - this is an overview of the recipes that feed into the meals tab Recipe Ingredients - this is where the recipes (in the recipe tab) get composed of all their ingredients Ingredients - this is a master list of different ingredients that cascade up

Hi,I am new to using Airtable, and I want to utilize multiple forms. The idea is to have a first form where, upon clicking a picture, it will transition to a second form, allowing the customer to input all the necessary information. Upon pressing a button on the second form, it should move to the third form, displaying quotations for the woods, including the pricing and quantity. These forms are intended for quotations of the product that the user can request.My question is: Is this functionality possible with Airtable? I am uncertain if a clickable image is feasible, so I need clarification on whether Airtable can support multiple forms, as described above.