Base Design

I have a table where we can record incidents occurring at school and select an incident category (e.g., stealing). Once a teacher selects an incident, they can choose the logical consequences from another table. Each incident category has a list of specific consequences. Can you explain how I can create a dropdown menu in Airtable and Airtable forms so that the values available for logical consequences are filtered to show only those related to the selected incident category?

I have a lot of personal views. I'd like to split them into sections like you can with collaborative views. I can't find an option for this. Is there a way to do this?

I have two existing bases in the same workspace on a Team plan. The new dynamic filter option appears in one of the bases as an option for new and existing linked record columns. It does not appear as an option in the other base, either on existing linked record columns or new ones. All of the linked records use text fields for the primary key. What makes dynamic filters appear as an option in one base but not another? Thank you

I am building a base to control the orders of my market. In there, I want to "Add a new order" and select the products of the order, while choosing their quantities. Is that possible? Also, I want to calculate the order value with the quantities of each product.

I am working with a new company that has five main areas I would like to manage using Airtable. These five areas operate independently but collaborate on the same projects, each contributing different inputs.Here is my question:Which is better: to have five different bases that sync (one-way) to a main base, or to have all five areas work in a shared base with individual tables and permissions?

Hi all, Can one base be the central CRM and the content editable in all other bases? For example, one central base could hold the organizations (companies, etc.) and their contacts, while the other bases could be used by different team members. The central information would be in each base and could be changed.I've created an image and each square represents a base.  

For the life of me can't figure this out...Imagine a non-human resource scheduling system (ie hotel rooms - not really, but close enough). We would like to be able to use timeline view to list all 'rooms' in the building, so that 'booking agents' can distribute incoming guests among available rooms.What we've done is create a table called 'rooms' and create a table called 'bookings', with bookings table having a timeline view, with records being grouped by 'room' on the Y axis and booking duration on X axis.The problem is that airtable timeline view only shows rooms that have bookings assigned to them. If a room has 0 bookings, it does not show us on the Y axis. How can we make it so that resources show up on the Y axis of the timeline, regardless of whether they have bookings on them? lack of this feature is the only thing holding us back from migrating from a 20 year old ERP system. the reason we can't use calendar or grid view for this i

I have a base where I have separated expenses into a few different tables. I did that to make it a little clearer for me as it became so cluttered. But now it’s hard to add up the prices and compare. How do I create a dashboard that truly just takes the sum of one column from each table that I have? For ex: I have a table for health insurance, car matinence & lease payments. How would I create a dashboard like summary where I can display the total sum of each of these? So it would look like: I tried linking, rollup and lookup but just can’t figure it out. I have used airspace for a long time, but only for simple data entry. I do not have pro.

HI GuysI was very specific in the question subject for a reason that anyone reading this will nod, say "oh, that" and cry into a coffee. Im at the final step of a looooong loop of data, and I need to now put multiple public attachments into a single attachment field in Airtable. I cant use Make for this, has to be Zapier. And i need to turn a simple array into a complex array so that the attachment field doesnt overwrite.Also, a huge thank you to @scottsworld for giving me a lot of the knowledge that got me this far without jumping off a cliffAnyone know how to do this? I have the public URL's (that was another adventure) and the data, now I just need to make it work. Picture tax - a cat, searching a map. This work we are doing is for a cat charity and you all like cats. I mean, who doesnt .

I have a CRM database with a table called Companies. These Companies have columns that are linked to different tables called Country and Sector. I would like to create a new table, a Market Matrix of sorts, that automatically rolls up the companies in Country A + Sector B, which would also include notes and different properties on the country/sector in question. What is the best way to accomplish this? Thank you in advance! I'm relatively new to this so any help most appreciated. 

Hi All,I'm trying to set up a resource tracker using the summarise function within the timeline view.In short, I want to be able take the days associated with a task and spread these across the length of the task. So if a task takes 20 hours and the task length is a week, then the summarise function would say 4 hours for each day and would group accordingly dependent on the scale we were looking at. I'll be grouping by individual, so want to be able to get this value summed across multiple tasks. This must be what the system is doing under the utilisation function, as it'll this to compare the available days to create the percentage, but I don't seem to be able to get it to work. When I go to summarise, and go to sum, it just shows me the total number of hours and doesn't spread the amount across the days. Crucially I don't want the percentage of available time used, I just want the number of hours themselves. Thanks in advance!

I have a table which has the entire organization list of Key results. It does identify each Business Unit. I have another table where I have a list of projects (in the same base). I want to have a field with the projects where the person entering the data can a select the key result this project is associated with but I do not want the entire list of key results to show up, only the key results from that business unit. Is that possible?   

Hello all. I'm new to Airtable and I have been charged with setting up project and task management for our team. We have a team of about 10 with multiple projects and tasks that are randomly assigned based on availability and skill level. Each project has a timeline with tasks, start and end date, status and assignee. The assignee can have multiple tasks on multiple projects at any given time. My question is, do I create one base with each project as the master table or do I create a separate base for each project and sync the tasks, assignee and status. I need to have a calendar view for each assignee with all of their upcoming task due dates and ideally an overall calendar view for the team director who can see all upcoming tasks, due dates, etc. We also want to share the status with groups outside our team for each project, so the outside team can see the status of tasks and overall project status.There is another wrinkle in that help desk tickets also create t

I used AI for one of my columns type long text. Is there a fast way to generate all rows other than clicking generate button manually?I tried to drag the bottom right of one cell down to the last row but nothing happened 

In actual databases, I can explicitly define which table holds the linked column, e.g., Table A has a foreign key field to Table B. So, if I look directly at Table B by itself, I wouldn't know that it has a relationship with Table A. But that's okay, because Table B isn't supposed to hold that information itself.But in Airtable, I noticed that when I put a linked field in Table A to Table B, instantly that field also appears in Table B. While that's very useful and helpful to understand the bigger picture of how things are interconnected, now I no longer know which table was the original one that established that relationship.The purpose that I need to know this is to transform an Airtable base into an SQL database schema, so I need to know the "native" fields of each table. Any tips, or anything I missed?

My client is a midsize construction subcontractor. I built a CRM that tracks invitations to bid on projects that my client receives from general contractors (GCs). They typically receive multiple requests to bid on a single project because multiple GCs are all bidding to win the same project. All of these GCs would use my client to perform the work, however, only 1 GC can win a particular project.The current CRM requires the sales team to create a new record each time a GC invites my client to bid on a project. The database is set up with a company table and a contact table that are both linked to each invitation to bid. This allows me to create summary statistics like win rate / GC. There are numerous other fields for each bid opportunity like that are the same across multiple invitations to bid such as what is the physical location of the project and what type of location is the project (ex Retail building).The team is complaining about performing duplicate data entr

Seems like I did this in a past life, but I can't find it  now.Just want to import or past selections from excel or CSV as options for single select field.Thanks for all help!

I found a great Airtable template but I can't for the life of me figure out how to get that template into my existing base. I get it that I can sync and then remove the sync, but the reason the template is so cool is because of the multiple tables, views and interfaces.Am I right that I would have to sync each table in the template to my base and then edit to get all of the configurations, like views and interfaces?I also understand that I can make a copy of the template and sync my existing tables to this new base and then delete the old one, but this means that all of the links I've shared out will no longer work, which leads to frustration and less uptake of the toolIf I understand this right, templates are designed only for when you're starting a brand new base and not good for adding to existing bases. Is this correct? I

I'm having difficulties understanding how to link these two tables and would appreciate a little help.Table 1 called "Products" looks a bit like this:MakeLineModelTypeDellLatitude123LaptopDellOptiplex3231DesktopHPProbookA34LaptopAll the fields are Single Text except Type which is Single SelectThen I have another table called 'Processes' with only two fieldsTypeProcessLaptopBox AssemblyLaptopScreen ManufactureLaptopPSU TestingDesktopBox AssemblyDesktopCase Paint

I have just started working in airtable and want to make a base for my highschools National honor society to start up a virtual online tutoring service but I am having problems with designing the forms for submission. Currently I have a tutoring sessions table, students table and tutor tables. I want to make a form that allows a student to input their name and email that will go as a record in the student table then link itself to a record in the tutoring sessions table that will have the date and time they want the session that the student will also input in the same form. Is this possible? Also I need some help on designing a way to make it so that existing students don't have to input their name for every form submission and just find it since we already have their names so I can do better tracking on the data. How could I do that as well? 

Is there a way to disable download button that appears below images in gallery view? I have attached screenshot.

Hello,I would like to know if there is a way to automatically use the same colors for single select and multi select options for cohesion and ease of viewing.For example:1. If I have a survey, all Yes/No questions will automatically make 'Yes' chips green and 'No' chips red.2. If I have several multi-select questions with answer options 'Strongly agree, Agree, Disagree, Strongly disagree' I can Strongly agree - color green, Agree - pale green,  Disagree - orange,  Strongly disagree - Red Thanks! 

I have to create a report over a period of time where i have an initial set and every month a new file will be shared where soem rows would be dleetd and some new will be added. How can i create a report of how many rows got added, which got deleted and also update the base file to mark the rows deleted

Hi allI am setting up my product SKUs and need some help to ensure that external users will find matches when searching on front end.I have the following fields; Product SKU IDWidthThicknessGradeConditionTreatmentProfileLength Product Description (all these together)Product Category (for filtering purposes when buyer searching for products) I want all these to be filters so that buyers can search to find results representative of the fields.I want results to appear if I'm searching under Product Description for products in different formats (e.g. searching by Grade before Width) or including/excluding spaces (e.g. 50x25 vs 50 x 25). -Please advise how I can make this happen and if needs to be seperate tables for each filter (e.g. one table for width, one for thickness etc) or if I should have all these filters in one table with multiple fi

I am currently in the process of using Airtable to build a new shipping schedule. I have grid view set up so it is grouped by delivery date because it is very important for management to be able to quickly see how many pools are scheduled to ship out on any given day. The problem is that when an order is canceled, it still appears in the count. Is there any way to exclude certain records from being included in that count? Thank you.