Base Design

I have linked field which connects two tables. On clicking “+” symbol, I can select records from connected table. There is also option to search “Find an existing record” records to add records. I can only search with primary field value of that table while unable to find anything using any other field vale. It gives empty value. I want to search records using another field value of that table not only primary field value. here is the pic of search option

How can I “Remove” or “Hide” uncategorized column in Kanban View. Can it be merged to another column in Kanban View to solve this problem. Here is the Pic for reference

I am creating an ordering system to help distribute items between multiple stores. I would like to have the option to attach quantities to individual items in the same order. Here is my order form as it stands. You can add multiple items to the record no problem but the way to attach the quantities to the items is not sustainable. Ideally, I want to be able to attach those quantities to the items themselves. Is this possible? Thanks for any and all help.

This is my first post in the community forum, so I hope I chose the right category. I am wondering if I can create a column that shows records that occur in both of two other lookup columns. I’ll describe my use case, and in addition to my specific question, I welcome any feedback on the overall design. I’m very new to all of this. I have a directory of therapists that our business refers clients to, among other attributes we list their specialties and the locations where they practice. Each of these are many to many relationships, where a therapist may have 1-3 specialties and may practice in 1 to many locations. I have two link to records on the therapist table, one for locations and one for specialties. We are creating unique landing pages for each combination of specialties and locations (e.g. Addiction therapists in Phoenix, Addiction therapists in Tucson, Trauma therapists in Phoenix, etc.) Each landing page corresponds to a single location + specia

Hi! I’ve run into a problem and I can’t find the solution on my own so I really hope someone can help me. I need the ingredients to be in the descending order based on the % they are used in an ingredient list. As you can see I have the ingredients sorted correctly but in the Label of ingredients the information is mixed. is there a way to fix this?

Hello community again :slightly_smiling_face: i just want to ask for suggestion whats the best way to do this: table 1 = products some products are made from other products == spare parts, which can be sold separately. So they are in same table. what i want: if i get product made from spareparts into inventory= show me, that this is made from those spare parts… (because when i send it to customer, i need to know it is made from those parts == dont forget to send other package with this one too. I dont know whats the best solution to do this ? ideas on my mind: create field “from parts” =yes/no and then other one which is linked to those parts numbers… so i can sort them into view when they are in order (so i will see those x are made from y, beware) but… i want to use it in the other way - when i get some parts into stock, i want to know “you should look for those other packages too” i know, this lookslike stupid, but the manufacture

I have multiple users running different test cases and entering test results (pass, fail, incomplete) in a spreadsheet. There are several test categories and numerous test cases under each one. I need to capture pass/fail/incomplete at the test case level. I would also like to capture the user/company conducting the test as well as which device they are testing. Multiple user/companies can test the same device. I would like to capture all of this information into airtable database to aggregate the results and enable consolidated reporting. I would also like to setup notification triggers (email or chat) when a test is completed and data is entered. Is this Possible in Airtable and if yes Please help me.

Hi, I am designing a form that needs to have multiple items listed by the person completing that form. Currently it is set as a long text box but was wondering if this could be set up as a text box with 10 rows 3 columns for example?

Hi there, I am brand-spanking new to Airtable, so break it down for me. I make and sell first aid kits and am looking for help setting up my inventory so that when I sell a kit, the multiple individual items sold in that kit also decrease. Is that possible? I already have my SKUs linked to the individual items it includes, but not the quantity per item. Thanks so much for the help! Megan

I’ve seen some posts similar to this, but I’m not quite sure I follow them with the data I have here. I just need Number of clients trained that week, in this case four. Names of said client’s that trained, as you can see some companies train more than once a week Any pointers? Thanks Sean

Hi, I encountered a problem while filling a table. In my main field I’m trying to reference a date field of my table who is a lookup to a date field in another table. When I try to do this, I have an error stipulating a circular reference. When I try the formula in another column of the table (not the main field) it works fine. Are there limitations on the main fields of a table? Thanks in advance,

Hi I have a table which has a list of all my team. On another table I have a form they need to submit their covid tests each day. I need to know who from the list of crew hasn’t completed a form each day. is there a way to do that? I saw something similar asked before but the explanation didn’t make sense when I tried it out. Thanks in advance Zoë

Does anyone have a sample base, along the lines described in the recent blog post: Allocate your resources in Airtable’s Timeline view? I’ve got a few years of AirTable experience, but I’m trying to fast track my learning about this. Thank you in advance! :pray: James

Greetings Airtable community! I’d like to ask for your help —> I need to be able to share a single Airtable record (e.g. form response) with people who are not Airtable users or collaborators, and to have it password protected. Up to now, I’ve done the following to share this information: Receive an online form response, Turn it into a PDF manually, Encrypt the PDF manually, Email it to my team member manually, and Send a separate email manually with the password to open the encrypted PDF. This is cumbersome and it is not scalable. Instead of doing all that, I would like your help so that I can: Share an individual Airtable record via email using a link to that specific record, Do not give access to the entire base through the link, only to the specific record, Password protect the individual reco

I’ll I am trying to develop an automation action that does the following: if a record is updated in table A, check if the name of the field (or better yet, some field ID) is included in a text line field of a record in table B. In practice, the idea is to have a table A with various fields that are either check boxes or drop down. In table B, there are three fields: a text field, the name of the field of table that the automation should ckeck, and a value. Any ideas or workaround ?

Thursday, May 12, 2022 10:00 AM Hello! I am creating a database to manage multiple households. The problem I am running into is measuring Average life of an item. I am currently trying to use 3 tables to fix this. I have table {Supplies} where I have my item records, {Log} which keeps track of weekly inventory checks, and {Orders} which records orders placed for this item. In the {Log} table I have a different record for checking each of the items in my household, I group them by Check Date. In {Orders} I group the items that are ordered together. And am manually entering Date Ordered and Date Received. My problem is that I can’t seem to find a way to calculate days elapsed since the previous order for each entry in the {Log} without manually entering the date of the previously received order for this item. I think I need to find a way for the Previous Order Received Date the records in the {Log} table to stop updating so that I

Before I make too many trial and error mistakes, can you help me with a base design for the following: Over the coming year we will have over 400 residents do rotations in our emergency department. There are 13 different rotation blocks (each 4 weeks). There are multiple levels of learners (Medical Students, Juniors, Senior, Fellows) and four different schedules (Medical students, Juniors, Seniors) (Some Fellows get scheduled as juniors, others as seniors). Some learners are CORE and others are here as electives. Some will work only one block - others will work multiple blocks - not always consecutively. We will fill in the following information on the initial Table: Name, email, level, schedule, and Blocks that they are assigned to. Block Design Question: Would it make sense to have one learner request table where they choose the block and enter their requests? Or have 13 additional tables for each block? Can we set up an individual

I am trying to create a timeline table to assist with tracking heavy volume days. The first option once I choose to create a timeline- it gives me a drop down with several options. "Using date range from (Due Date) to (Date Entered) **both ( ) fields are drop downs. When I select those 2 options- i get the follow error message " The above fields cannot be displayed because DUEDATE and Entered have configurations that are not compatible. " What I am trying to do is create a “Puck” like timeframe where I can view all of our open work orders- each one identified by a puck (bar) that runs from date entered to due date. Any ideas as to how I can get the dates to communicate correctly? I included a screenshot of the error message I am receiving. Thank you

Hi there, first time posting. I have created a table to help me price jobs more effectively and I have effectively created a list of materials, costs with and without VAT, it all totals up and is working well. What I would like to be able to do now is having added the quantities for a particular commission then move this materials and quantities to a new table with that customers name and have it remain and not change when I alter the master. That way I can keep an accurate costing for individual customer and amend just their record when I need to. Does anyone have the time to help me. Thanks so much in advance.

Hello! I’m looking to get some help on how to structure my base. We are tracking shipping containers and would like to make our base automatically update the ETA based off where the container was last seen and which path it’s taking to reach us. For example, if the container has reached the 1st port in a particular path, I would plug in numbers to show it usually takes 60 days to reach the second port, and then 30 days after that to reach the warehouse. I would like an “ETA” field that automatically updates to show the estimated end date. We have multiple warehouses, and 5 different sets of timelines based off how they’re reaching us (which I am calling paths). We initially had all of our tracked containers in one base. The ETAs did not update automatically, so I’d have to calculate where each shipment is and how long, based off its path, it would take to reach us and then manually update the ETA field. I was playing with the idea of having each different path h

Hi All, New to this forum. I’d like if possible to set up a conditional date field. We have two fields Date field (which should not be empty) Checkbox field “Date not needed” If the date field is empty and the checkbox field is true then I’d like the message “Date not needed” to display in the date field. Possible?? Thanks!!

I am building a new project where users will enter details about book titles and submit them for approval. The official list of titles lives in another database with a decent API and also contains some reference numbers and dates about the title that is required for the approval. Purely in the sense of end user engagement what would be the best way to manage this? Pull all titles and reference details into a holding table and let the user link to the record with look ups pulling in the details. This will consume about half of the available records in the Base. Let the users free type the Title then have a script check the API for a match on the title, if only one match update the record, if multiple have the user pick the correct one. Have an app that lets the user search the API and add the selected record. The latter two probably involve the user navigating away from the record (expanded view) to find a

I am attempting to create grouping for a category of show seasons. Right now, colleagues can view shows by title, but a few shows have multiple seasons, so I would like the parent group to be the show title, with child tiles titled season 1, season 2, etc. Is this possible?

I need to create and save my own custom base template for strictly personal use (i.e., not for sharing.) I need to create dozens of bases with the same exact schema (field structure). I can only find information on sharing bases, not on saving a custom base as a template for your own personal, repeat use.

Hi everyone! I’m new to using Airtable and curious if anyone can help me out. We’re creating a database to register data from an archaeological excavation. During this excavation, we’ll come across different contexts, so in Airtable we have added these contexts as different options, you can for instance select ‘floor’, ‘wall’, ‘burial’ and then we’ve added several fields that contain descriptions on these contexts/options. Now all of these fields show up for every single context/option. But, for a burial for instance we don’t need the field ‘masonry finish’ or ‘color’. So we’re wondering: is there a way to create unique fields for each option or to disable that certain fields pop up (or can be filled out) when selecting a certain option from the drop-down menu? Thanks!