Base Design

Hey everyone, I’m an archery coach, and I’ve been using Airtable for a few years to manage information about the people who participate in our archery club and their achievements. I’m trying to figure out the best way to track the relationships among the archery students and their parents or guardians. Note: it’s possible for someone who is a parent of one of the archery students to be a student in our program themselves. This is complicating the design. So let’s consider two tables from my base: People and Sessions. ┌─────────────────┐ ┌──────────────────┐ │People │ │Sessions │ ├─────────────────┤ ├──────────────────┤ ╱│Name │╲ ╱│Session Name │ ┌────│Sessions │───────│Start Date │ │ ╲│Related People │╱ ╲│End Date │ │ │is_current │ │Participants │ │ └──────────────

Looking for help in designing my tables. In my case I have unique records e.g. people but the metadata associated with each record/person is based on effective and termination date. In other words, for a single record/person Person A, smoked from 1/1/2000 to 12/31/2001. Chewed gum from 5/1/2000 to current. I was originally going to create 2 tables for each set of metadata (smoking and gum chewing) but there doesn’t appear to be a way to link the primary field of the gum chewing table to the smoking table. So I guess what I’m asking is; from a design standpoint should all the metadata be in a single table with effective and termination dates for each attribute (smoking and gum chewing) or should they be in 2 separate tables? TYIA

I know there are a million variations on this question already but I’ve read all the solutions and spent several days trying to resolve it and am still stuck. Perhaps my issue is unique, perhaps I’m just slow. I have 3 tables in my base. Trip Test, Members and Trip sign ups. Members is a list of members Trip Test is a list of trips Trip sign ups is a sign up form where a member selects which member they are in a form (from a look up of the Members list) Which ends up looking like this in grid view I am trying to create a view i

Hi. I’m a newbe with Airtable but I already love it. It is very powerfull and easy to use. I have a problem to solve if I want to adopte it: I need to populate fields in two related tables using the field value of one of those to select a right value for a field in the second one. I have to manage the attendances of a school where I have a Registration table with the Registration’s ID, a Student’s ID and a Course’s ID a Calendars table with the Calendar’s ID, a Date and a Course’s ID. A Calendar is a list of date of each Course. To trace the attendance I need only to put a multi record link field (called Attendances) defined in Registration. Automatically, Airtable create a multi record link field in Calendars. Perfect? No. When I want to select one or more value in th

I need to calculate automatically the number of chaperones I need for a field trip. If I have 1 to 30 students, I need 3, 30 to 60, 6, etc… The calculation is: {#of stduents}/30*3. The number is an integer. But if I have 31 students, it gives me 3 as a result while it should be 4. How can I round up the number to the next integer and not the closest one?

Hi there! I’m thinking of migrating our data from excel to Airtable. I collect data from a sign up form, which I then timetable a schedule for the classes. We have multiple teachers, all at the same time slots, so 4:00-4:30, 4:30-5:00, 5:00-5:30 and so on. I was thinking a table with all the sign up data, a table for the teachers and a table for the time slots, BUT, a student could have a lesson with one teacher at one time slot and with a different teacher at a different time slot, so that complicates things. Do I have a table that has Teacher Bob 4:00-4:30, Teacher Bob 4:30-5:00 etc? That doesn’t seem elegant. I love tinkering with airtable and would love to have a good excuse to use it for work! The other thing that excel can do, that I’m not sure if Airtable can, is make a pretty timetable for the teachers, but I could always do that manually, it’s not such a big deal. Any thoughts welcome, I see people using it for schools, but not

I am a total novice but cannot find the answer to my question in the guides or posted solutions. I have created a form with two fields, created the associated grid, and then changed the order of the feilds in the form and also changed the name of one field. The grid did not update to reflect those changes. I did refresh the pages. In the screenshots, you can see that the table does not match the form. Could someone tell me how to sync the form and the table so that they match? Thank you so very much!

Hi; I have multiple values in one column which I am trying to use for prefill form but its not working. If there is single value then its working but for multiple value it does not. The column can be linked records or multi select. If I select Company A then show contacts only those which are linked to Company A. Is that Possible? How to do that with some twisty method?

I added a “Last modified date” column, and it immediately the fields got updated with the creation date of the record. How can this field remain empty until the record gets updated (not created)!?

Hi everyone - I saw @Bill.French post about handling millions of records on airtable, but still am unsure given my use case. I’m building an inventory management app on airtable and building the front end on softr.io. I’m needing to store 1+ million records (serial numbers). The workflow is like this: someone on softr searches the serial number → softr returns fields associated with the record I.think something like this could work: User enters serial number → creates a row on airtable Once the row is created it triggers an automation to search for that serial number in some outside database that handles more records Airtable pulls back the other info related to the record on the large database into the airtable row that was just created Visualizes this data in Softr Once done record is deleted Does anyone have any thoughts? Thanks so much in

How unique is the record identifiers, ones produced via the RECORD_ID() formula? I know they are unique on the same table. Are they guaranteed unique across different tables on the same base? Are they guaranteed unique across all bases within a workspace? Are they guaranteed unique across all bases on all AirTable servers?

Airtable support seem to be struggling with what I assumed was quite a common use case. So trying here: Right now we have an employee database, each employee name is a record in the primary field. We also have other data in that table, like email address etc. We have a deliverables (think, tasks) table which we use to set deliverables for customers and each deliverable has an owner, we link to the employee table to deonte that owner and as such we can pull in other info (like email address) into the table via a lookup. We want to move away from adding the employee as a linked record and just add the ‘user’ (the airtable defined field of user) since they are one and the same thing (and employee is also a user). I’m struggling though with how to then have a table of info to do with that user I can pull in, seeing as a user can’t be a primary field so I can’t link to it in another table. any help or advice for a workaround much appreciated!

I’m on the free version of Airtable and considering upgrading but I don’t see how to customize a view in a detailed way. All I see is a vertically spaced bubbly fields with too much margins. Is there a way to customize the layout or view of airtable? Maybe an extension? Something like this.

Hi friends, Is there any inconvenience to not using unique fields names across all tables? Is ther any advantages to using unique fields names across all tables? I mean, which is the best practice A), B) or does not matter: A) users table: “user_name” “user_phone”… as name fields companies table: “company_name” “company_phone” as name fields B) users table: “name” “phone”… as name fields companies table: “name” “phone” as name fields Thanks for your help

Hello, I work on the office side of a housing renovation company. I am trying to streamline our projects to maximize our efficiency. I am hoping to create a table where the renovating employees can check off tasks within projects within workspaces in the house within the stage of the house that a workspace is in. Perhaps, I am just not familiar enough with Airtable or the feature is just not available. Can you please help? I look forward to hearing from you soon! Thank you!

Hi, I am trying to get my financials done with Airtable so I can have a nice play field to test Airtable in real world conditions. I created a first table for the acquisition from my bank. So I have many columns, but specially I created a formula to format the date into MM-YYYY (ex: 04-2022) Then, in a new table, I would like, for each row (04-2022 ; 05-2022…etc) to sum all the expenses and incomes for that specific month. I know I can create a link to cell everytime (by converting a formula MM-YYYY to a link to cell), but I want to create it automatically so I don’t have to manually link every item. I would like to replicate dynamically this : Here are my data table :

Airtable is such an amazing app. I walk around and very curious about how it can create a table or link between tables so quickly and fluently. I’m a developer and really want to discuss about how Airtable do all this stuffs behind the scene, is an airtable base reference to a database in server, the same question with table

Hi, I’ve built a base for a music conservatory. We are tracking student groupings for an ensemble. The students field are linked from a database tab. We are trying to avoid having one student in two groups, or at least flagging the groups that share a student. I hope this is clear! Is there a way to do this?

Hi there I just start my first airtable base and currently I have multiple survey forms in one table. Some of the questions share the same column but some of them are not. However, when I look in a grid view, for those columns that are not shared in multiple forms will remain blank, making the whole table looks not organize, because some of the questions in one survey are not relevant to the questions in another. In this case, would you recommend me to add another table ? I’m not familiar with the “database” concept so, I’m wondering what would be the best practice if I would like to analyze my customer profile later. Don’t want to mess it up :stuck_out_tongue: Thank you Lee

HI I am trying to create a list of resources (Small Carton, Large Carton etc) with purchase price and purchase date against each product. I use this data to then allocate resources against each order. Eg : Order No. 1 Order Date: 1 Jan 2022 Small Carton $5 x Quantity 5 = $ 25 Large Carton $10 x Quantity 1 = $ 10 Total $ 35 Eg : Order No. 2 Order Date: 2 Jan 2022 Small Carton $5 x Quantity 1 = $ 5 Large Carton $10 x Quantity 1 = $ 10 Total $ 15 However on 3rd Jan 2022 the cost of these resources go up From Small Carton $5 to From Small Carton $6 How can I update these rate change on the table such that all new orders will use the updated rates and older orders rates are not impacted. Thanks Ajit

I’m working on migrating data between tables. For context, let’s say I have designed these 2 tables for a tutoring company that offers bulk tutoring with different packages: Students Name Hours purchased - rollup from a purchases table Hours tutored - rollup from the classes table Hours remaining - formula, subtracting the above two from each other Classes Student - relation to Students table Class Paid - checkbox of whether this class has been paid The Classes table has a record of booked classes, but not all are paid. We use an automation script that monitors the Students table for any changes to the hours purchased for a student (say through Stripe, or a manual change by sales), and updates the field in the Class Paid column for any of that student’s classes accordingly. This worked for a one-to-one relationship between a student and a class. H

How to Transfer All of Data from Monday.com to Airtable as each record in monday.com has subrecords.

Hi all, I have a rather complex and specific set up, and I’m looking to pick everyone’s brains to see if I can find a solution. Here’s my situation: I am running a business to do with coaching and I want to be able to handle attendances and shift assignments in AT. So I have a table with all the Coaches A table with all the students I want to have a table where I can keep track of all the available hours of my coaches, and which students are assigned to specific time slots for the coaches. And the coaches must be able to mark the students attendances to keep track of their progress as well. I am currently on the pro plan, if that helps. Would this be too much for AT to handle?

I’m working on a project that may be able to use Airtable, it is a database designed to help organize the requirements for an event, but the events are extremely flexible. For example, I would have an event (event A), that event could have any number of quantities of types of items, and any number of quantities of those items. For this example, lets say the event has desks and chairs, each at a bespoke quantity. However event B has lamps and stools, and I don’t want to display desks, chairs, lamps and stools as columns with their respective quantities to the end user entering or viewing the record. My only workaround at the moment is to link a table of items and every time they create a new event, they will need to make a new record specifically for those items, at that quantity, and with any notes about it. Is there a way to go about this that would be more effective? I am hesitant to

Hello, I would like to store the location of electronic components in my workshop. As I have mixed furniture, boxes in boxes, drawer cabinets, etc, I thought a simple “Location” table with parent row would suffice: ID Parent ID Name ---------------------------------------- 1 Red Cabinet 2 1 Drawer A1 3 2 Front Compartment Now I can record that a component is stored in location ID 3. However showing only “Front Compartment” is meaningless without parent names. How can I concatenate an unlimited number of parent’s names into a string for each row? I would like a field storing the string “Red Cabinet, Drawer A1, Front Compartment” for ID 3, for example. I have tried using a formula to create a Display Name field concatenating parent Display Name fields however it throws a circular reference error. This sounds like a common problem but I can’t think of the keywords t