Base Design

Hi All,I'm trying to create a simple base that allows me to track items in boxes. An item can only be in one box so a one-to-many relationship seems like the right thing here. I added the link field to my Items table and made sure that "Allow linking to multiple records" is off in the settings. This works when I'm adding items and putting them into boxes. However, when I open the Boxes view and add an existing item to a box, it does not get removed from the previous box. Instead it ends up being in multiple boxes at the same time, exactly as if it was a many-to-many relationship.This looks like a bug to me. Is there any way to move an item without having to remove it manually from the old box?Thanks for your help, P

Dear friends, I need again your help.I am creating a database in which I will add information about patients with a specific disease. In a main table, I will summarise the most relevant information about each patient, and each row will correspond to a patient (record) with a specific ID number. In another table called "visits" I will add data about all the outpatients visits (each per row with a specific date). Each patient on the first table can have more than 1 visit but each visit can be associated only with 1 specific patient. I correctly linked the 2 tables, and now in the main table, I can see all the visits for each patient. What I need to do now is to visualise in a field of the main table specific information contained in a specific field of the "visits" table. In detail, I need to visualize the status of the disease in the most recent visit of that specific patient (disease-free, progression, regression). I tried creating a rollup field and using the for

I'm using a Calendar view, the "Customize labels" option, and the "Sync to an external calendar" option. The customized labels show up fine in Airtable's calendar, but when I sync the Calendar view to my Google Calendar, the name of the event is just the Date. I can't see the customized labels from Google Calendar. I've tried reconfiguring and re-sharing the calendar, but nothing seems to update it.See screenshots.Thank you for any help you can offer!–Ben

Dear friends, it's days I'm trying to create a database to store information about my patients and their follow-up, but I am having big troubles in understanding how to do it with airtable. Anyone willing to help?Thank you 🙂  

Hi Friends, I need help from somebody. I am trying to build a database to enter data of some patients with a specific disease. I created a 1st table di patients' unique IDs and some demographics. What I need is to add "events" related to each patient, which could be operations and follow-up visits. Each event includes info like date, type of surgery, patient status and so on. Each patient can have multiple events, but each event can be related just to one patient. Can someone help me and suggest how to proceed? Thanks a lot 🙂

Hi, Let's say I build a form on top of a table with fieldsClassroom | Student name | Favorite classmateI'd like the form to allow each student (indexed by Student name) to pick their favorite classmate from a dropdown list that contains only the students in their classroom (ie. the Student names pertaining to a group defined by the field Classroom). I'd like this to be able to scale to a few thousand classrooms, so creating new fields is not an option. I'm an Airtable noob but experienced engineer. Thanks in advance! 

I am creating a database to follow-up on some patients. Some patients have been operated on, others not and I created a field "single select" (yes/no). I need to make visible for the user some fields (columns) only if the answer to the "single select" is yes. Is this possible?Thanks you

Hello, I am still getting used to Airtable and am having trouble designing my tables and views. I am looking for some help from the community. Here's the scenario:I am trying to create a gallery view of approved real estate properties that I can share with my clients.Clients should be able to sort and filter the gallery view to help them find properties.The card view will show a couple fields but clients can click on the card to expand the record, to see all fields (with exceptions mentioned below).I have 2 people helping me search for real estate properties to add, so I want to create 2 forms for each of them to submit their properties for approval. The form for Person A and Person B will have the same fields except Person B's will have 3 extra fields.As the properties are submitted through the 2 forms, they end up in a grid view and their "Status" should be marked as "Pending" until I mark them as "Approved", at which poi

I have a "Task" Table with a Timeline View to track my employees’ resource utilization. So far I love the tool!  BUT... I am running into a major limitation when I try to enter multiple “Days Off”.  To my knowledge, the “Days Off” Date field can contain only one Date. Is that true?Multiple days off must be entered individually in my “People” table, then linked to a Lookup Field in my “Tasks Table” which populates a date field with all days off as comma separated dates.  The problem with this approach is that most employees take multiple, consecutive days off, not individual days.  I don't want to have them enter each day one-at-a-time for a 5 day vacation.  Ideally I would use a form with a date range (Vacation Start—Vacation End) and let the system do the calculation for the Utilization.Am I making sense? If so, does anyone know if there is a solution to this issue?

I am new to Airtable and I am trying to recreate something I have done in Excel (see attached image)I have a uniclass 2015 system list of Codes that cascade down and have a relationship with each other, as shown in the image you have a group that has a sub-group which then has a section and then objects.what I am trying to do is group each of the groups, subgroups, sections, and objects, so I can minimize the group level or expand down to the sub-group, section, or all the way down to the object levels as shown in the Excel image.Ive tried using the group function but it doesn't seem to give me the desired result, if anyone could help i would be very greatfulKind Regard

Does anyone know if its possible to hide a table from some users within a base?

Hello Community,I have a layered table where I have a Staff Table that is used to assigned Projects and Tasks.I am connecting three (3) tables: Projects, Tasks, StaffIn the Projects Table, Staff can be assigned as a Project Lead or as Part of the Project TeamIn the Tasks Table, there is one field, "assigned to" for any Staff to be assigned to the Project.In case a user assigns a task to Staff not already on the Project Team, I have an automation set up to add them.  However, when they do, it means that someone who is a Project Lead may be duplicated in the Project Team.This is an issue because I have a simple count field set up to count the total number of projects they are on SUM({Project Count: Responsible (Project Lead)}, {Project Count: Supporting}) With the

Is it possible to make a rollup field where the output is a list of user records (linked records, not just flattened names)? Alternatively, is there a way to filter duplicates out of a Lookup field?My example:-Contracts table, Budgets table, Users (collaborators) table. -Budgets table is linked to Users table (each budget has a specific User who's in charge of expenses on that budget)-Contracts table is linked to Budgets table (each contract is going to be paid for with one or multiple budgets)-I need a way to have a column of UNIQUE values, looking up who the User(s) are who control the Budget(s) that I have linked to this specific contract. These Users will each have an approval task for this Contract.I can do a simple Lookup column to get the list, but if the same User controls 3 of the Budgets we're using to pay this contract, her name shows up 3 times.I can do a rollup using ARRAYUNIQUE to get a list of names that does

Hi!  We are trying to use record templates to build out our Airtable environment.  We've looked through the help pages but cannot figure out how to build out the record template to accomplish what we want.  Are there any experts or consultants that could help us work through the challenges we're experiencing?  

I have a table of collaborators where one of the columns is Line of Business (LOB), which is also a column in a couple of other tables. I want to create (shared) views of those other tables that is automatically filtered on the LOB of the logged in user. Is that possible?

I manage an organization which hosts various events and we'd like to use Airtable to track RSVPs and attendance at these vents.  Some of our events are open to the local community while others are for members only.  I have created an Events table which includes a checkbox to indicate which events are open to the community.Now I'd like to create a form for RSVPs that conditionally shows a field for respondents to indicate the number of guests a person is bringing (think +1s) ONLY when the event chosen in the form is open to the public?Does anyone know a way to make this work???  Thanks so much!

Hello, I'm looking to make a table in Airtable that can sum a column based on the unique combination of other columns. Below is a sample of how I would do this in Excel using a pivot table.  The use-case is we are trying to create a labor tracking system for our manufacturing floor. Team members come in and work on different assemblies, parts and operations. Generally, there can be two records for the same combination of columns (a real example would be someone spends 4 hours on Thursday working an assy/part/operation, they submit their time tracking form for the day and then return on Friday and spends another 2 hours on that assy/part/operation to complete the job). How can I achieve this? I thought I could do it with the Uniquearray function but unforunately cannot seem to get the solution working properly. Thanks in advance!&n

What is the single most effective change you've made to your base to improve speed and performance? 

Hi All, I've been building out a base on Airtable and am running into some issues with the linking. I've linked two tables together. I'll try to explain here what I'm experiencing. Table 1: Action Items and Column 1: Item Name; Column 2: Pillar OwnerTable 2: ProjectsI've linked my Action Items table to my Projects table. I brought in both the action item name and the pillar owner name into the projects table via the Action Items table. I then decided I didn't want these tables linked in this way. I removed the Item Name and Pillar Owner columns from the Projects table. I think found a more appropriate way to link the tables, so I re-linked the Action Items table to the Projects table, but brought in different columns. Now, via my dropdowns (specifically when I'm attempting to create a Lookup column - this doesn't happen when I'm attempting to Link to another record), I have two Action Ite

Hello All, Essentially, is there a way to set the column widths in a view other than clicking and dragging each separate one? I have to change the width of something like 10 fields across 50 views, and I’d rather not have to click and drag 500 fields individually. Especially since they all should be a standard width. I’ve looked around online and haven’t found anything - but if you know of a solution, you’d save me a lot of time. Thanks!

Hi, When I try to upload any images or files on desktop, I receive an 'error uploading file' message. Uploading off my phone works fine. Is something on my end not working, or is this feature down? Thanks.

I have a budget tracker where an item needs to be allocated with multiple budget IDs in one column and the other column should specify the amounts that each of the budget IDs are been allocated which will give me the sum of total allocated amount in a column separately.  Lets say the below Opex Amount should be for the Budget IDs OP23_310_ProdEng_SW_001 and OP23_310_ProdEng_SW_002 for 300,000 USD and 250,000 USD each. I should be able to identify these separately as well as a total. Why I need them separately is I am doing a roll up function in another tracker which has the total approved amount, spent amount(which is rolled up from the above details) and remaining amount.  

I have a base with 2 tables - Teams and Projects (as shown below). Every 3 months the leader changes. Now if I update the leader name in Teams table, it updates the leader names in the previous records too in the Project table (because of Lookup). How can I prevent updating the lookup values in the previous records?Please try to provide a detail solution.

I know that, according to this support article that "Multiple records can [only] be selected one at a time from the list of linked records (there isn't a way to link multiple records at one time).I have a base with records for items to photograph. Each of those records has a Checkbox field for marking whether the item has been photographed or not. So each record has that field checked off or not.My end goal is to see what percent of items have been photographed.Because I can only create formulas by "row" and not by "column," I understand that I need to create a second table to start tabulating photographed and not photographed. So, I have a single record called "Whole Project" in that second table that links to all of the records in the first table. Then individual count fields in the "Whole Project" r

Hello, I'm just learning so I apologize for the ignorance.I'm trying to collect game statistics for my son's hs lacrosse team.I have a data table with fields of Statistics (like shots made, shots missed, etc.) and Player.I have a form that lets me enter statistic (e.g. forced a turnover), Player (6 Jimmy) and submit.From that, I have a pivot table that collects the stats for each player.I want to make a field for Quarter that doesn't have to be entered each time I create a new record.  I tried creating a table with game information and doing a lookup but I don't think that works.Is there a way to have a record keep the Quarter the same until I have it changed at the end of each quarter?  The goal is to be able to have a summary of stats for each quarter and the overall game.Thank you!Mike