Base Design

Is there any way to set up an inventory tracking system where someone can scan a QR code, and fill out a form of what they are checking out as well as checking back in?The issue I’m running into is that its fairly easy to create a form with a drop down of what you’re checking out, but when it comes to quantity of what's being checked out, that's where it gets tricky, unless you create a sperate quantity field for each individual piece of equipment, which if you can imagine, you have hundreds of different pieces of equipment, that is extremely inefficient not to mention the form it self would have hundreds of conditional fields. What I had imagined is for example, I scan a QR code, a form comes up, I check out 5 harnesses, 3 lanyards, and 10 beam clamps and click submit. On the user interface, I can look at who checked it out, what equipment they have what department they are etc. When checking back in, they similarly scan a QR code and fill in what they returned. It th

Hey, I wonder how can I see or extract the database diagram of my base that I built here in Airtable. I there an easy way to do that? (the alternative hard way is to edit something in an external tool like https://dbdiagram.io/d) Regards.

Trying to link some fields and I keep getting this message - “No available sources to look up. Add a lookup source, then try to configure your lookup again.” I do have some fields linked but have run into this on others

Hi there, I’m watching an airtable demo from November that says field-level coloring has been added but I don’t see any options and they don’t explain how it’s done! I’m on the enterprise plan.

En la vista Kaban. Me muestra campos que no quiero que aparezcan. Y no tengo opción de sacarlos, solamente en la edición me deja ponerlos en el encabezado o ponerlos en el cuerpo. Pero no me da la opción de no ponerlos.

Hi Dear community I'm new on airtable and looking for how to control my stockInventory management  Need your help or if you have sample database Most welcome 

Hello!Our organisation has basically a large ‘to-do’ list table which includes a ‘Tag’ multi-select field which I’ve just found out our Editor users can’t add new options to – either directly in the table, or through an interface list/record view.We are on a Team/Pro plan so I can edit the field permissions, which I’ve set to Editors and up and it still doesn’t work.As I am the Owner, I assumed anyone could add new options to this field because I always thought the common issue was trying to stop users from doing that! I really am racking my brain because it feels so simple but I can’t test it without sitting next to an Editor, and also wild that I can’t find others in the community with a similar issue.

I am an admin of my company. My company works primarily within interfaces, but I would like to invite one of my colleagues to access the base data itself. How do I do this?

Have asked Google, the Duck, even Bing, and can’t find an answer to this question: How much wood would a woodchuck… No, sorry, that’s a different question for a different time. My current question is: How much text can be stored in a Long Text field (of a single record)?

Does anyone know a way to save Outlook emails for future reference? Something where you just click and drag the email in to Airtable and open it in Outlook when you click on it. I guess you can drag it in as an attachment but it won’t then you have to download it to again it instead of it just going straight to Outlook and opening it up. Anyone know the best way to store emails on Airtable?

I have created a form and I upgraded it.  I have published it, but when I try to copy the url so I can share it, it doesn’t copy.  Is there an alternate place to find the form url?  When I go back to my base and click on the Form View, it shows the old version, not the upgraded finished version.

Hello. An unexpected problem is that suddenly it is no longer possible to move views through the list of views in any table. The icon in the name of the "move" view remains, but the view does not move. What could be the problem?

Hi Dear community I'm new on airtable and looking for how to control my stockInventory management Purchasing Need your help or if you have sample database Most welcome  Thanks Tarik 

I am stumped on how to solve this problem.Our team has 1 table set up that is pulling data from a synced table. We added in new columns to the right of the synced data to be able to add in subtasks and a few other pieces of tracking information.The issue we are running into is there are other ad hoc tasks that need be done that are not on synced table but we need to be able to put the synced data in the same view with the ad hoc tasks.Our only commonality is that we have a linked record for both from an overview table of projects.Is it possible to bring together a synced data table and an ad hoc table into 1 new table for the team to work from?

Hi all,  I’m looking for examples or scenarios of when and how you are using components not for entire workflows and bases, but for fields and automations. I’m also interested in understanding the impact on time savings for creating components vs instructing users to just copy or set-up their own fields and automations. 

Hello to everybody, it's my first time here &#x1f605I want realize a Data Repository for all the departments in our Business, but i can't find Case History like this.Can someone have somethings like that? I can be very happy to learn the experience of someone.

Hi, I have a company table and a contacts table that are linked. When i click in the linked field of the company table, and click +, i see all the records in the contacts table. I would like to limit the shown records to only those contacts that belong to the company in question. Can anyone advise how i do that plse?

Hello,we run an agency and for every client we have a different base. The base is almost identical for every client. We now have access to the business plan, and we want to use a master base to consolidate the data from every client into one base, so that we can benchmark our performance as a whole, and dive deeper into every client if we wish. We have a table called KPIs in every client base. The KPIs are always the same. For that reason I have created the same base in our master base, and I am now syncing data from master into each client base. We also have a projects table for every client, which includes 3 fields (primary metric, secondary metric, tertiary metric). These field are linked records from the KPI table. In the KPI table (for each client) we can then see how many times a KPI has been used for that client, and the overall uplift for a KPI with a client. I want the same information to be shown in the KPI table in our master base, but then for all cl

Hello, I have a table where one column is a relationship to itself. So I can links records to each other.I’d like to have another column where I show the linked records. Sort of like a Lookup what records are linking to a specific record.I found this 3 year old thread, but it has no solution offered here: Is this something I could do today?

Hello, Been very busy and I suspect I’m going blind with what’s probably (hopefully) a simple data flow. As a picture says a thousand words, my problem is as per below; I can self link a record to its own table with a lookup field, which in this example I consider that as “Pushes to” - So A pushes to B. But what I’m needing, is another column that tells me the reverse of that relationship, so I can see that “B” is pulling from A - and then even create a filtered view around that very “Pulls From” data. I’m keen for your thoughts on this, hoping there’s something simple that I’ve missed that will allow this workflow. But I also have access to scripts/automations too if they’re the only way out of this.

I have two separate AirTable bases that I’m using to track our orders and inventory. I just upgraded from a free account because I wanted to be able to sync information from the two bases to be able to compare orders to inventory side by side. I’ve created a new base and synced tables from each existing base but cannot figure out how to get data from one table into either the other table or a new table. I’ve tried lookup fields and linking to new record fields and can’t get a new field to populate with information from the other table. Is this not possible or hopefully I’m just missing a simple solution?

Hi - I'm absolutely stuck trying to achieve the results I want, and I'm hoping for some focused support. I have 3 Tables in my Base:- Vendors - which contains companies I contract work from.- Resources - which contains the individual resources that work at those companies, as well as their individual monthly rates. Resources are linked to Vendors.- Monthly Cost - contains a list of records for each month of the year (eg; January 2025, February 2025, March 2025, etc).  In Resources, I'm assigning Months, from the Monthly Cost table, for when I expect this resource to work. In Monthly Cost table, can see the assigned resources by month, and I created a Rollup field to show the Vendor names associated with the Resources that are assigned to the month. This is using ARRAYUNIQUE, so if I have 5 resources at one vendor, I don't get the vendor displayed once. I also have a Monthly Resource Cost Lookup field that wil

Hello! I am trying to build a Base/Automation in Airtable to count how many times an event occurs in a week, and then add/subtract it. Essentially, to count how many times customers use the events that they paid for, and then subtract it from the events they have remaining. I set up a Pivot Table to do the count, but I am not sure how to set up the Table with the actual schedule in it, without have to create new fields/columns each week. Specifically, I am having trouble figuring out how to set this up in terms of the fields and columns. It’s the same time blocks each week, I’m just having trouble figuring out the skeleton of this table in the base… I looked through the Help and Templates section, but none of them seem to address this particular part of the scheduling process…  Any ideas/advice would be welcome, I’m sure this isn’t a unique use-case, I’m just having trouble with this one table… Thank You!

Hi,I’m relatively new to Airtable and I want to use it to help track inventory. I’m not familiar with coding or complex formulas and I’m thinking those are the exact things I’m going to need to pull this off…Ideally, I want a base that has a full list of inventory and user capabilities to allow checking in/out different items. I want quantity to auto-update based on in/out. The user facing side needs to be very simple and easy. Originally, I was thinking a form where the user will type in the ID and whether they're checking it in or out and it will auto update the quantity but now that I’m trying to work through that- it doesn’t seem very straightforward. A form recording every single response as a new line item is not useful in this case.Quantity number will be very important because I want a dashboard that displays what items are available and where to find them. Any guidance would be incredibly helpful- other posts, help pages, formula suggestio

I found this post: Help creating a script to tag products with keywords from product titles.  Using the code with the adjustments the script runs, but not well.  I am hunting keywords in course descriptions for a sustainability tracking and awards system.The problem is when this searches for keywords it's too literal. If the course description has "...equal.." then it will attach that link. If the description has "...equality..." it will not. Originally the keyword list had the asterisk wildcard, which meant there was a lot of things it wasn't finding because it doesn't seem to recognize that as a wildcard, but that lack of wildcard means it's missing possible links now. I would prefer not to add every iteration of "equal" to my keywords list though.How do I address th