Base Design

Hi Im following the many to many tutorial from Airtable Airtable - Support A beginner's guide to many-to-many relationships What sets Airtable apart from ordinary spreadsheet applications is its ability to link related concepts together. Knowing how to represent the relationships between different groups of objects can ... I’m stuck on the following step in the photo: I can create the first two tables (students and classes). In the bottom pic, they have created a 3rd table. It has got a list of the students and classes. In particular, I cannot find a field with the Icon show for both students and classes is different in the bottom pic I have tried to do this using the “Link to Another record” feature, but my version creates 2 columns each time (see pic below) I use link to another record. Additionally the icons are different to the one shown in the example. Thanks very much Amit

Hi! Is there a way to track completion of forms that are sent to a contact list in one of the tables? We want to send a form to everyone and then see who has or has not completed it yet. Furthermore, some people may need to complete the feedback form multiple times (about a different person/experience each time) so ideally we can see their completion status by the person/experience they are providing feedback on. Any recommendations? Thank you!

Is it possible to change what is able to be viewed on a card as the card moves through different phases of the pipeline in Kan ban view? For example, if my stage is ‘Intake’ only a few fields are displayed, but when the card moves to ‘Due Diligence’ more fields are automatically displayed.

These 2 options should be part of the basic design. And no, the Dedupe block is nice nut is not what is missing here. Simple basic option in every database. Please add this.

I’m setting up a dashboard for a travel agent with 5k+ carried out in 3 different currencies. The set-up I have right now works, but I’m wondering if anyone can suggest improvements or more enhanced approaches to this case. In the main table I’m extracting the ‘day’, ‘month’ and ‘year’ from the transaction date with formulas, then I get the user to link each ‘day’, ‘month’ and ‘year’ to the relevant Day, Month and Year tables where I can summarize the data accordingly. This is working fine but if you can think of a more elegant way to do it, I’d love to hear. The main issue I’m facing is that: I also need to convert transactions to a unique currency, so I prepared a different table with FX daily values - which I link to the main table (where all transactions are recorded) to pull the relevant exchange rate. Is there a way to do so without having the user to link the again to a different date, in this casem in the FX base? Any other schema/formula/functionality suggestion to stream

Project Summary: We need a system of managing, requesting, and distributing resources to students for the 20-21 school year. We are starting by creating a “Drive-Thru Library” A book catalog will be created using QR codes taped to the back of each book- I am hoping to use airtable to start with this inventory. I need for families to be able to scroll through the catalog of available books created with the QR codes and easily make a request - is that possible through airtable? We are looking to expand beyond books. In the future, we are hoping to allow students to be able to “check out” for example, a bag containing science lab materials or a trombone. Tech Goal: Create a system that can scan information pre-loaded into QR codes --> into a form --> that automatically populates into a spreadsheet. Also desirable… If a confirmation email can automatically send in this process. A way to use the spreadsheet information to populate a more user-friendly catalog

Hi, is there a way to create a list of the top 10 whatever, products sold, courses taken, etc? Many thanks for your help!!

Hi I’m really confused about lookup fields and assumed they worked in a similar way to vlookup in excel and google sheets. I have two tables:- Orders orderid order name price productid sku Products productid productname sku The Orders sku field needs updating with the sku field from the Products table. Is this possible and can someone show me an example please. Thanks Jonathan

I currently work in an office setting where we have supplies in multiple locations throughout the building. I have built an excel database to manage it all and I have been trying to figure out if it’s something that I could do in Airtable instead. I watched various tutorials, how to’s, and looked through what information I could find and unfortunately none of seems to help me. I have 12 different locations in which various supplies are stored. People within the office have access to those locations and can take supplies to use whenever they need to. What I have to do once a week is go through and count what is at each location, and also add or remove items to the locations to redistribute the supplies as needed. What I need to have an ability to add the weekly counts of each item at each location, so that it updates a master list on-hand total which can be flagged so that when it reaches a certain amount the office manager knows to reorder it. Sometimes what is at each location changes

Is it possible to display a different field than table’s primary field in the Calendar View?

Hello Everyone. I am new to Airtable and so far i’m loving it. I work at a law firm and we are creating a database that shows the settlement amount for cases for our attorneys as reference. I have 2 columns that I want to work in tandem. One column is designed Surgeries, for the amount of surgeries that person involved in the case had. The next column is Injuries. This shows which body parts were injured during the accident. I have color coded the Surgeries section. Let’s say if someone had 4 surgeries, that number would appear in orange. Can I then, in the following injuries column, have all 4 of the injuries appear in the same color to denote, each one of these body parts were surgically operated on? Also, if someone had 1 surgery but 3 body parts were injured, can I somehow color in just the body part that was operated on to match the color designed for 1 surgery? I apologize if this is confusing. Please ask any questions and I’ll try to explain it better. Thank you very much for yo

Hey all! I’m looking for some help in creating a database in AirTable that aids in estimating materials supply for new construction multi-family apartments. I have run into some trouble in creating the relationships and producing the data that I need at each level… I’m not so sure that AirTable will be the product for my needs. If anyone is willing to take a look at my situation, I am open to sharing my project information. Thanks!

I have an attachments column in Table A with a bunch of photos for each record. Table B has records that link back to Table A – and actually there are probably 2 or 3 records on Table B linking back to each record on Table A. Is it possible to have a column in Table B that shows just selected attachments from the linked record’s attachments column in Table A? So, like, if on record in Table A has 10 photos in the Attachments column, then each record in Table B that links to that record could show one or two of those photos? Thanks for the help!

I would love your help! I basically have a form where people need to input their email address. I have all these users in a user table already, and would love to set up an automatic lookup that would match people’s answers to the right user. Any ideas?

Hey guys, Im very new to airtable Im trying to build a basic sheet wherein the user can select a bunch of records and only those filtererd ones show Can someone show me how to do this? Thanks!

Hello !, I am trying to make a database for my store, I have 3 tabs created as “customers”, “products” and “orders”. The problem is that if someone buys 6 of the same product from me, I must create 6 records of the same product. I would like to be able to select the product and its quantity. then be able to get the total order. I would greatly appreciate your help!

The Set-Up: I have a Table called “Building Master List” This Table has 2 views in which a Stone and Tile Takeoff was completed: I have another Table called “Stone and Tile General Info” which contains a summary of the information contained in the Building Master List Views: The Task As an example, I would like to SUM the data in the “CT001” Column from the “Building Master List” Table and have it show up under the “Quantity” Column for the “CT001” Row in the “Stone and Tile General Info” Table: * Please advise if this is possible to accomplish without manual typing as mentioned above. I’m assuming this may be accomplished using Rollup. Please advise.

Hey, I have a strange problem, I’ll point out that I already have several bases and everything works as it should. I created a new one and the problem is that I have almost 300 rows, there are about 10, I cannot read the data in the application where the remaining 290 have no problem, in addition, I have 4 rows where I cannot update them, has someone had this problem?

First time poster. Airtable sound and seems like a great tool, however I find it a bit complicate to navigate and create jobs/task/relations… in it. After spending some time to play around with already made templates (and trying to understand the complexity of all the links and relations), going and reading help/support pages I’ve ended up here. So, before I comit my time with Airtable, I would like someone to point me the right direction and just simply to tell me “No, it cannot be done with Airtable”. I need to create a “Planning a task/job”. Its text-based list, where you might have 10 or 100 individual steps (sentences) where you select only the ones you need for said task. Then you select/pick required tools, safety equipment… Once you select them all (in a correct order) you can create a printable list. Another option I can think of is to use a Kanban View, where you drag and drop all “Steps”, “Tools”, “PPE”… from a General list to individual “categories”. Once completed, the use

We are mentoring a program of teams and wanted to take notes after the meetings with each teams just to track progress and such. Right now, I have a CRM setup using a separate notes table and linking the notes records. This is helpful for tracking when notes are taken, but the biggest problem is that when someone wants to open up the record for the meeting, they can’t easily visualize all the previous notes (since they just appear as linked records vs actual text). So even though you can take notes in a clean way, you can’t visualize them quickly and easily. Any recommendations on ways to set this up?

How can I keep my numbers field from rounding? This seems somewhat simple, but I’ve searched and found nothing. I’m in publishing and trying to add page counts. My numbers field keeps updating 1.75 to 1.8 and I don’t know why. Even if I fix the decimal view, it will do 1.8 or 1.80 or 1.800 - not 1.75. I have done it with simple text but then I lose my sum feature. Any help is appreciated!

I’m looking for some help in how to set this up properly. My main table has the 1st column that is an App. Table 1: App1 App2 App3 I’d like to to have another table where the main 1st column is directly linked and the same as on Table 1. App1 App2 App3 without just copying and pasting them over. I have another Table that is “Company” that has all the data on the company that created the App1 which is simple to link via relational because the column 1.

I’ve got a situation where a group of three tables all link to each other. [Workers} links to {Companies} and {Workers/Site Visit} {Companies} links to [Workers} and {Workers/Site Visit} {Workers/Site Visit} links to [Workers} and {Companies} When our agent goes to a job site, she fills out a Workers/Site Visit which lists each worker she encountered on the jobsite and which company each worker was working for. Let’s say Diane went to the jobsite and met John, who was working for Pink Lightning Construction. She also met Barbara and Francine who were working for Bedrock Concrete. All of this would be reflected in Workers/Site Visit. The thing that I would like to happen is for the indirectly linking of Juan to John Lightning and Barbara and Francine to Bedrock would trigger a direct link to these companies in their respective records. I could do a rollup field in {Workers}, as you can see in the photos, but that doesn’t resolve my problem satisfactorally. Does there exist some mechan

Hello Everyone, I could use some help. Ideally I would like to create a form that can easily be emailed. I have Client orders in one table, each order is linked to a customer and the products they will be shipped. On the Product table there is a Retail price and product description. I am trying to get the specific products for a customers order, price and descriptions in a long text form that can be easily copied. Thanks in advance, BH

I need to keep two tables separate because of an integration with another app, but want to create a master list of all the items across both. Any idea how I can get this to happen automatically? Thanks for your help!