Base Design

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

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 m

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: *

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

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 Bar

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!

View the latest field Hi, I’m totally new to Airtable and so far I’ve been fascinated by it. :smiling_face_with_sunglasses: I started doing is something that allows me to keep the daily balance of different accounts, see image, So I capture daily transactions and therefore the actual balance is the last recorded . How can you make a query or a summary, which brings me only the data of the most recent registration of the different accounts? Thank you very much for your help

I am trying to use XML to get and update information from my Airtable. I am doing the following for POST to update a value but I keep getting error 422. I am doing a very similar process for GET and it works, but not for POST. function httpPost(BaseID,tablename, APIKey){ var xmlHttp = new XMLHttpRequest(); var url = "https://api.airtable.com/v0/" + BaseID + "/" + tablename +"/"; var propValue = { "id": "recIYykIMqJGcvNNi", "fields": { "Variables": "Test 1", "Value": "136" } } xmlHttp.open('POST', url, false); xmlHttp.setRequestHeader('Content-type','application/json'); xmlHttp.setRequestHeader('Authorization',"Bearer " + APIKey); xmlHttp.onreadystatechange = function() { if(xmlHttp.readyState == 4 && xmlHttp.status == 200) { console.log(xmlHttp.responseText); } console.log(xmlHttp.status) }; xmlHttp.send(JSON.stringify(propValue)); }

I have a table which is an inventory of all of our computers in the company, with several piece of information (RAM, etc.), with the computer name being the primary field. I have a second table which is a data export of all DEVICES that have our software installed on them and what the software version is, including work computers and employee computers. I’d like to create a field in the first table, that’ll grab the software version from the second table. When I try to use linked fields, it populates the first table with all of the devices from the second table, though. Is there a way to only list the devices in the first?

I have tables set up with Autonumber as the primary key. It’s basically my version of a CRM. I have the Contacts linked to the Company records, but it displays the AutoNum instead of the Contact name. Is there a way to choose what displays when you link records? I saw a previous topic that the recommendation was to have the AutoNum NOT be the primary key. Since there can be a number of Joe Smiths or JaneMillers in a given set of names (examples only), I’d prefer to keep the autonum to get a unique key. It would definitely be helpful to see ‘Jane Miller’ in the company record instead of ‘1’…

Can you create a picklist for entry into a primary key field? This would allow a standard and defined list instead of letting anything go into the field. Thanks in advance. charley

Hi, I’m looking to link records from one table to another. At the moment, the way I’m linking the two together is by linking via the main table using the lookup function. Is there a way to directly link from one table to another without using the main table as the core linker. Thanks in advance!

Here’s the same question about tags that I have and there doesn’t seem to be an answer… How to use tags in Airtable to find matching records Ask the community Hi I am new to airtable and appreciate any help. I am creating a table of info product f

Im positive this has been asked in the past because it seems like a standard thing in spreadsheets. but is there a way to view my data vertically? i have many columns with few rows and just wanted to flip the data somehow…