Base Design

I’m trying to organize a summer arts camp. I have 4 tables: Guardians(parents), Campers(their kids), Weeks(the weeks we are operating), and Invoices. I’d like to set it up so that: The Weeks table contains the week and the cost of that week (different weeks can cost different amounts). I have done this already. In the Campers table, I can assign the Weeks that each Camper has signed up to the camper (we are able to assign more than 1 week to a camper if they sign up for more than one week). I have done this already. In the Guardians table, we can assign Campers (more than one if they have several kids attending) to each Guardian. I have done this already. Here is where I am having trouble: In the Invoices table, I’d like to assign a Guardian to each Invoice. I’d like to be able to look up the Campers assigned to each Guardian and the Weeks assigned to each Camper assigned to each Guardian so that I can get the total cost that each Guardian needs to pay for all of their kids.

Hi, A client of mine is using Airtable form on Squarespace. How can I add custom CSS to the form? I found this Better Whitespace Use with Custom CSS but I don’t understand where to add the CSS. Thank you

I have a table of employee records with one field being a link to the manager record. Id like to count the number of employees that a manager manages. How do I do that?

The overall goal is to show what trainings a person has not taken yet. I have a table that lists all training modules, a table listing roles that is linked to the trainings table to indicate which trainings are required for each role, a table for people that is linked to roles, and table for completed trainings linked to person and training. I need to show, for each person, trainings that are required for their role(s), but that have NOT been completed. How can this be accomplished?

Not sure if this is possible, but I have a number of things I’d like to track a daily basis (workouts, journal entries, meeting notes, etc.). Each of these tracked items use numerous unique fields that don’t overlap, so combining everything in one table would result in a huge list of fields—too cluttered. I would prefer to keep each tracked category in its own table. However, it would be nice to have a separate “overview” table that shows all of the records from these various categories. For example, the “workouts” table contains daily records with fields for reps, weight, etc. The “meeting notes” table contains daily records with fields for client, topic, etc. The “overview” table aggregates and links to all of the records from “workouts” and “meeting notes”. That way, I could reference all of the records combined in a central location but they are stored in their respective tables. I could have a table that contains records for each date and link to those, but then the overview would

Hi, We currently use google sheets to keep track of project budgets (this is fed data from a complex set of estimating/budgeting sheets plus quickbooks. The quickbooks part is manual). I want to be able to bring all our project budgets into one sheet. We already use airtable to track subcontractor costs, as well as other items by project, so we have the database of projects well developed. Does anyone have any ideas for how we might now associate this estimated vs actual cost data? We could even add an actual revenue line. I’m imaging tracking this data across projects by cost code or drilling into each cost code. It’s important that: -We can view it in a compact interface -Data entry is no more difficult -Ideally we get “snapshots” over time. (I have created a pay schedule before when tracking employee hours so the idea of advancing ‘schedules’ is something I’m familiar with) If it’s too difficult, I’ll probably just use IMPORTRANGE in google sheets to create a summary view… womp womp

Hello and Good Day to All, As the header suggests I’m looking for some advice as to how to proceed with my project. A bit of background. My wife started making custom jewelry for herself a few years ago. One thing led to another and now she’s taken her hobby and expanded it into a small-ish side business. She currently uses Excel to keep track of everything related to her hobby/business. I’ve even jumped on board with a Laser Engraver/Cutter and am making items for her to sell as well. (Plus it’s a frickin laser and really fun). We both have a lot of experience with Excel and next to no experience with Airtable. I started out looking for an inventory management program that we could tweak to our needs. I couldn’t really find anything and then I stumbled upon Airtable. I already have a decent-ish handle on my inventory including setting up a form that we can easily enter in new items to sell. I have our items categorized by item type (earrings, ornaments, etc) and then sub-cate

Hi everyone, I’m wondering if anyone has solutions for formatting text in long text fields. We use these fields to build out decision trees for text messages, and the more options or levels to a decision tree, the hairier things look in the long text field. We love the option to add headers and numbered/bulleted/checkmarked lists, but we need more to differentiate the levels of decision trees. When we draft these, we use different colors for each level of a decision tree, so that would be an ideal solution (feature request alert!), but we’re open to other suggestions. Thank you! Here’s an example of a text message with multiple layers of responses: We are just about at the halfway point of the semester and I’m dying to know how you’re doing! How are you feeling about your progress in school so far? (e.g. reply 1) 1. Amazing - I’ve got this on lock 2. Pretty good - I’m confident 3. Okay - not terrible, but not great, either 4. Lots of room for improvement 5. Send help! Responses: (Ama

Hi, I’m having an issue with linking two tables together. I have a ‘Companies’ table and an ‘Employees’ table. In the employees table I have a column named ‘Job Title’ in addition to the column linked to the companies table. My issue is that sometimes a person is connected to two companies. One can be an executive in a one company and a board member in another. So, how do you state or clarify the two job titles in the database schema. You can easily have two companies in the “companies” column but the Job title will be wrong as it might not specify the company where he/she hold that job title (Imaging the companies column having two companies and the job title saying ‘Executive’ or ‘executive, board member’ to make it more ambiguous!) I thought of having a column in the companies table named “board members” and link it to employees table and then another column named executive and link it to employees table too. But I think it’s a bit limiting in that you can have a column for every ti

Is it possible to sort the Kanban view by the sorting columns? I want the red boxes in the picture to be sorted numerically. I also want to filter them so it only shows columns with less than 30 records

Hello, this is my first post, and to be honest, my first time with airtables. I do have extensive experience in excel, so that’s a start, right? hahah I am taking over for a colleague who organized the information, but after spending 3-4 hours of looking at all of the “tables” and then reviewing some of the webinars, I’m pretty sure I need to start from scratch. This is what we have … it’s a rescue for animals … (one table) and then we have people (the second table) There are many different tables for each of the roles that people play. And then there are many many tables for the animals. I want to have two tables - one for people, one for animals, and then I want to put all the people info in the people table, and all the animal info in the animal table. The tables will be quite wide and have lots of data (about 1400 records of people and close to 500 of animals.) Here’s my problem - all of these many many tables are linked records all over the map to other many many tables … I am t

Hi dear community, I am a developer, quite experienced at using Airtable, and love best practices. I never really had a need to post a message as the documentation and this forum are already full of precious infos. Thanks you all for that, especially members like @Bill.French - are you french by the way? :winking_face: My problem concerns big structures for bases. It is not really a matter of slow performances, but rather a matter of human understanding and keeping a clean database. I just got on a new project as a Product Manager, the main base contains 32 tables and some tables have almost 200 fields. Obviously everything has been built through small fixes here and there, and there is no naming convention. I have a lot to learn about that and I am now looking into topics like this : database - Relational table naming convention - Stack Overflow Problem I have : Do these naming conventions fit an airtable usage ? Most of the people who are going to use my base are not developers. I

Good Afternoon! I am a Learning Design Coach for a public K-12 virtual school. I am attempting to move our registration process over to Airtable. Is there a way using filters (or any other way) to create views based on alpha order. So I need a view that shows all of the records in which a student last name starts with an A as well as all other letters up to L. Thanks ahead of time! Dan

I have a field that has a drop down in each cell. I want to create a formula that will count the total number of names selected in the field. Here’s a screenshot of the field. This formula for the screenshot above would show a total count of 7. I also want to be able to create a formula that counts the number of each possible selection. The results of this formula would show: Carlo - 2 Zach - 2 Mark - 2 Ryan - 1 Thank you in advance for your help!

Hi there. We use an excel spreadsheet to manage monthly sales targets for our partners/employees. In Excel we are able to put in targets by month/quarter and then also put in the actual data so we can understand target vs actual. I’ve been trying to figure out how to structure my base to do this for the last week and I can’t seem to work it out. We have periods of time that we need to track these figures (e.g. January, February, Q1 etc) but also within that we have different types of targets. So we have a software and a hardware target. But it also needs to be tracked per partner/employee. Any ideas very welcome! Appreciate Airtable isn’t Excel but we use Airtable for everything in our business so we are trying to get this moved over as well. Thanks Dan

I would like to, in a single Base, create a list of Projects with associated Tasks and their assignments, status, and status dates - then copy that Project and its related Tasks for use on a new Project. We would like to track multiple Projects, which have similar sets of Tasks, without having to create and link all of the Tasks every new Project. They cannot share the same Tasks, as each Task (for each Project) requires its own assignment, status, and dates. Shared Tasks do not provide this. I have reviewed the documentation and have not found a way to do this in Airtable. Is it possible? Thank you in-advance.

Hi there, I am working on an alien database project in Airtable that needs to track how each alien’s Lead Researcher has changed over time. I have a table of “Aliens” listing all their relevant traits (home planet, native gravity, atmosphere, diet, etc.) and I have a table of “Lead Researchers” listing all their relevant traits (name, major phobias, favorite color, etc.) I have a field that tells me who the current “Lead Researcher” is for each alien. Each Lead Researcher is the lead for several (between 20-40) different aliens. When the Lead Researchers change, we simply update this field. Easy peasy. However, I also need a way to see “Researcher History” for each alien, including the dates that the lead researcher started and ended with that subject. I know that Airtable tracks changes, but I am looking to have this in my actual data as part of the base. I can imagine building out fields to make the table wider with something like this: Previous Researcher 1 Start Date 1 End Date 1

Hi there :slightly_smiling_face: I have a table that lists “People” in different categories (by role) and includes contact information for all of those people. For Department heads, I would like the email address of their Executive Assistant to populate in a field in their record. So I would like Bam Bam Rubble’s email address to show up in the box circled in green: I have a second field of “Organizations” that these link to that looks like this: Is it possible to do what I want and have Exec Assist emails appear in the records of their department heads? Thanks so much!

Hi all, I use the phone field a lot in my tabs but I don’t live in the US and so what I get is a very odd and inconvenient formatting of my clients phone numbers. For instance I want to call a french number which should be formatted as follow : 06 01 23 45 67 it shows in Airtable as (060) 123 45-67. When I’m using the app on my phone I can just click but I’m also making a lot of calls from my office. So I manually type numbers and the formatting is very distracting and I always have to double check before making a call. My collaborators have the same problem and while it doesn’t look like much it adds up to a lot of lost time. Is there a way to change the number formatting ? My iphone does it automatically as I type numbers in so i’m a bit surprised that I can’t do it on Airtable. Thanks for your input.

Hi, I have assigned different tasks to employees. Each task has a start and end data and workload. The real workload will of course then vary by time. I can always calculate the total workload for all tasks. But that is theorectical since not all tasks are ongoing simultaneously., Is there some way of showing me the real floating workload profile? Like for example the timeline with the actual varying workload. “This is the workload profile based on the allocated tasks”. The basic need is to get the workload profile for planning purpose.

Hi, Airtable community! Our company teaches glass classes, and we have been utilizing Airtable for our schedule for going on two years now. We love the platform. That said, we would love to take Airtable to the next level for us, but I’m a little perplexed on the right way to go about it or even all the options that might be open to us. I am not opposed to hiring a developer, but I need a scope of work. :slightly_smiling_face: We teach several different classes per day, and we have multiple members within a party. For example, our most common is for two people to signup together or to have three people signup separately but all within the same party. Therefore, each class can have up to 16 individuals, typically in groups of 2 or 3. We utilize WordPress, WooCommerce, and Events Calendar Pro for our students to schedule online. Currently, we manually enter the information to Airtable from the WooCommerce store email. We also take email and phone reservations. We use a printed version

I’ve encountered the following situation a few times when trying to cross-reference information from multiple sources. In short, I’m creating a row for each source, with the source name in one of the columns. Then I can compare the data from multiple sources. I now want to set one row as definitive or authoritative. For example, a bibliography. My base contains lists of books taken from multiple sources. Some books are mentioned several times. This is useful, as I can compare e.g. source notes. However, I want to mark one of the rows as the definitive entry. At the moment, my approach is to have a column with a checkbox called ‘Duplicate’. I am hiding these ‘duplicates’ in an Airtable view. I’m not sure this is the best approach. I could perhaps tick the ‘best’ version and send that to another table within the base? Where I can amend the data? The desired outcome from the bibliography example is a table with a consolidated, clean list of books. I should mention also that the aim is to

Hi There, I am responsible for reporting the number of open projects per month that my team works on and breaks it down into four project categories. I am trying to build a Base that does the following: Master Table that lists all projects and assigns each project a category A form that feeds into a table that each employee records daily projects worked on as multiselect linked record An automated way to count the number of projects that were touched in any given month by both total project and breaks out into the four project categories above. I have built point 1 + 2 without issue, but I am having trouble with point 3. Any help would be appreciated. Best, Colin

Hey everyone! I am trying to learn best practices for how to link tables. My goal is to create a Data structure that will allow me to filter the records in a table based on features that are linked to that record in the same table. I created separate tables for each feature that are linked to the table that I’m trying to filter. Questions This creates an array of values as a result in each table that is linked even thought the table for the feature itself is a list, not an array. Is this going to cause problems down the road? when I create linked features in the tables, it automatically creates another column that references this link. Why does Airtable do this? Should I delete this extra column? Thank you!

I need a deep dive course in Airtable. My immediate task is to Take a client list (that is imported from google forms) Then add jobs to that client Then have a another table in the client base that is materials Then be able to make a shopping list for each job By going to the material list and multi selecting the job (which is been rolled up from the jobs field in the client table) And while we’re at it, I need to record each site visit per job per person so it would be great to have the multi select list available for the after action report Currently using an outliner or a moleskin notebook harhar Seriously I would pay somebody to tutor me Thanks