Base Design

Newbie to Airtable! 3 days old 🙂 I have a table where I capture list of all the work I am doing.  There is a numeric unique ID that is in the first field and the record has a number of columns Unique ID.  Col 1.  Col 2.  Col 3. Col 4. Col 5 I created a table which has the following fields and a form submission will populate this table XYZ1   XYZ2     XYZ3      XYZ 4 ....etcXYZ1 is linked to Col2. So when I create a form and try to use a drop down to select a value for XYZ1, I was hoping all the values in XYZ1 will be displayed but what is happening is the entire record is getting displayed rather than that field alone and XYZ1 has Unique ID value rather than the Col2 value. How do I get to the below stage.When i submit the form, XYZ1 field should show me all the values in field Col2 and then display on that col in XYZ1 &nbsp

We've added Interface-only users to our AirTable Interface. How can I prevent users from adding them to the full Base?  The Base contains sensitive data that Interface-only users should not have access to.  I've noticed multiple times that Base users have invited Interface-only users to the Base.

Hey, all!I was wondering if there is a way to gain the sum of values based on column data. Here is what I'm looking for:I have four tables--materials, packets, procurement, & purchase orders. I link the materials to the procurement table to populate all the details of the material. I link the packet to that line item to signify what I'm charging to (it has job info and everything). Then I need shipping and receiving to check the items in so that we can determine that everything from a given packet has been received which is being validated by the purchase order. What we currently have to do is check every line item in as received. This is rather tedious, and all I really want is to determine that everything on the purchase order is being received. Additionally, if I can solve this, I would love a sum of how much of each material I have in stock for a given job, not a given packet as there are multiple packets per job. While some of this may seem redundant, it is du

I am trying to combine the lists in two different single select lists into one.  I'm not trying to concat the fields.  Combine the lists together somehow.

Hi Everyone, I need to build a performance review base to start a year review process with the employees in my company. Anyone who already built this in airtable and can share? Thanks!

I have a base where there is load list table that depicts every load on a power system (e.g. motor #1 of 10 hp). I have an instrument list table that depicts every instrument on the site (e.g. flow meter). I want another table that has all the inputs/outputs (IO) for the control system (an I/O list).An example is analog input from a sensor or digital output to a motor.How can I set up this IO list that it links to both the load list and the instrument list as needed? The IO list should have all the IO from the entire site, which means it will have IO for devices on the load list and have IO for devices on the instrument list.I can set it up so there are linked fields in the IO list, one for load list and one for the instrument list, but then I have one blank on each row (as the IO is either from the load list or instrument list). Is this the best way?

Hello, trying to set an advanced filter and it's not working.  Thinking I'm perhaps missing something obvious?  Looking to filter for projects that I'm working on and which are not "done" or "abandoned" or blank in their status.  See screenshots of my filter and what is currently displaying on the base (currently still showing done/abandoned items).  Thanks for tips/suggestions!Alex  

Hi all, Been experimenting if airtable can speed up my workflow for inspection reporting by using some forms and drop down fields. Right now I take photos on my phone and create a google doc report from a template then pdf and send to customer. Kind of stuck how to set-up the relationships across the tables and how to build the form or interface. Any resources or guidance y'all can offer?

Hello, I obeserved a significant slowdown of the Undo actions in the past weeks/months. I was hoping this would be resolved over time but it reached a state where it can take minutes for an Undo action to take effect. Suffice to say this leads to inefficiencies and confusion as of whether an undo action took place or not. Am I the only one observing this problem?

Hey!I have this "project management base" that I use for all my projects as a freelancer. in one of the fields I have Fee/budget. For some projects I invoice in parts, so maybe 1/3 on signing the contract, 1/3 on first delivery and 1/3 on completion.I my "main" grid view I have all my projects sorted on completion status. But I also have a Kanban view for tracking invoices which is built on the single select field "invoice status"; not ready, sent, paid etc.Does anyone have a suggestion for a convenient way of "splitting" the budget field so that it appears as 3 separate "invoices" in my invoice view, but is still attached to only one project in the main view if you understand what I mean? (i.e. I don't want to have to create a "separate project" in the grid for each of the invoice parts)

Hi All,I have been trying to create a base to manage our project purchasing and accounts payable process. We are a residential building company and run around 12 projects at once, with detailed and extensive project budgets.  These budgets are broken into categories relevant to the building stage, including materials, consultant services, accepted trade quotations, etc. Most of these line items are products from supply agreements, contract rates from contractor agreements, etc. These agreements are valid for approximately 12 months, and the items within the agreement form a catalogue (inventory), I guess. The line items for materials are the actual product per the supplier's catalogue, enabling us to order the products from our budgets accurately.I want to be able to select several rows within a budget to all be included on a purchase order generated in Airtable or, in some way, on a branded PO PDF template. The table would then register that these items have been

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?