Base Design

Hi Dear community I'm new on airtable and looking for how to control my stock Inventory 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 😅 I 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 clients. I thought about

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 will Look up the assigned Resource's Monthly Rate. The rates are displayed, separ

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 suggestions, general layout, literally anyth

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 the problem I’m experiencing programmatically?

I’m new and just learning Airtable. I know that other flower farmers use Airtable already, but I haven’t found many resources about how exactly their Workspace is set up. I’d love some input regarding keeping track of items such as a master crop list, year to year crops, maps, task calendars, inventory, clients, products, newsletters, vendors, etc. It doesn’t necessarily have to be flower specific as the veg community has a ton of overlap.

Lets say I am linking a People Table and a Projects Table. In the People table I want a column that has all the Projects Associated with that specific person. In the Projects table, I already have all the projects listed along with the associated person. When I ‘Link from Another Record’ from People to Projects, nothing populates. I’ve tried the LookUp as well but nothing populates as well.

Hi everyone, I have a problem with Lock view. I have a view that I lock so that other people can’t modify/change my data listed there. but when i try to share this view. the toolbar for fields, group, sort, etc is not locked and the person that is using the shared URL can use it. Is this a bug or thats just the way it is?if yes, then is there a workaround for this? thank you in advance

I have a base indexed by project name. Each project is assigned a salesperson and a department number. I want to learn how to create a task template within this base. Each project will have the same set of tasks/subtasks. It would be great if there’s a way to automatically populate a task list when I create a new project in the base. Any direction you can provide (guides, etc.) would be greatly appreciated!

The app doesn’t retain login. I login into the app as normal, go through the bases etc.. no problem. After close it by swiping the app (so it’s still running) or by terminating it, when restarting, the app asks me to login again. I just submitted another issue with Airtable app crashing on uploading images so this seems a separate issue with this current version. Submitted ticket for both issues but I am wondering if anybody else experiencing this. I live in the mobile all so this is quite a problem for me. In the meantime I need to create a Fillout form to be able to update Airtable records.

Hi, I am importing raw data periodically, let’s say monthly. Every import includes a data field with the date of import. Given the repetitive imports, the key differentiator (let's say Supplier ID) is repeating. I added a locked view where I filter by import date. => I now want to analyse the data for two of the imports, e.g., 1. January and 1. June and see if any supplier was added or removed and what data in a specific field (e.g. performance) has changed. The closest I got was partly manual and didn't work: I copied and pasted all Supplier IDs from both import dates into Excel and then removed duplicates. In a new table with auto number index, I added that list into two linked Supplier ID fields, and each of the fields linked to the views 1. Jan und 1. June. Then, I added two look-up fields for the performance of each date. My goal was to have a list showing either the relevant performance per different date fields or blanks if newly created or deleted suppliers. Unfortunately, both

I am using the new form builder and want to filter the values of a dropdown field, Product, based on the value of another field, Designer, on the same form. Although I found the "filter records by a condition" option, I cannot see a way to use the Designer field's value as the condition for the filter. Any help appreciated.

I’m having an issue with two-way syncs in Airtable. I have a Source-A table in a Base 1, which is synced to Base 2. In Base 2, the Target-A table is linked to a B table. The problem arises when I want to remove duplicates in Source-A: I have no way of seeing whether one of the duplicates is linked to a record in B in Base 2. If I merge duplicates and delete the one that is linked to a record in B, the connection between Target-A and B is lost. How can I prevent this loss of links? I tried using the Dedupe extension on the Target-A table, but I got an error saying I don’t have the necessary permissions. I understand that if Source-A is synced to multiple bases, removing duplicates can be problematic because additional data entered in Target tables isn’t reflected in Source-A. Is there a better way to handle this situation?

(I suspect this has been answered before, but I’m having a hard time figuring out how to search for it. Apologies in advance.) I have a table that includes several hundred rental product models. This table is called ‘Fixtures’. I have a table for individual projects called ‘Projects’. For each given Project, I will want to link a Client (I know how to do that) and then I want to create a document where I can list an allocation of equipment needs for the project that pulls in data from Fixtures. The final output needs to be a multi-page printable document that looks something like this… -- Project Client (Qty) (Fixture B) (Qty) (Fixture Q) (Qty) (Fixture AN) … -- So this is roughly equivalent to creating a sales estimate, but ideally pulls in data from the Fixtures table to then populate additional related info. If anyone could point me to a relevant sample base or offer any insight, I would appreciate it.

I am evaluating various platforms to build a custom production scheduling application for a client. Here are some details: Customers place orders for products they need produced Each order can have multiple line items for different products they would like produced Each order line item needs to be scheduled on one or more machines to be produced. The scheduled jobs for each line item need to be run sequentially, but not necessarily back-to-back. In fact, some products need to sit for a set period of time after one job before it can be consumed by the next job to make the final product If the date of the first job scheduled for a line item needs to be adjusted ahead or back, the other subsequent jobs need to be adjusted by the same amount of time as well. For example, if a customer orders “Product A”, which needs to run on “Machine 1” on 3/20, then “Machine 2” on 3/21, then “Machine 3” on 3/25, if the job scheduled on “Machine 1” is changed to start on 3/21, then the job on “Machine 2”

Hello Airtable community, This is my first Airtable project having previously used Trello and Monday.com. I am looking to create a project management tool with standard features (client, contact, team member, project, etc). Where I am getting stuck when mapping out/setting up is: Projects are to have a start and end date (proposed) or a timeline that can be changed depending on progress on-site. This ideally will have subitems as stages or tasks. I see this as quite straight forward. Team members will be assigned to a project, which can change daily. For example: Team member 1 works on Project 1 next week, however on the following week we need team member 1 on project 2 for 2 days, then back to project 1. Equipment/machinery TO be treated similar to team members or as items? So they can also be allocated to a project for differing times. With the above in mind, my boss would like to continue sending out a daily (or weekly) schedule showing who is where on what day and what equipment ne

Hi there, It has been a while since i last made any significant updates to my Airtable projects so I am a bit rusty. I am struggling to find the best way to create “a table inside a table” .... I have a table called “Quotes” that has these fields Quote ID (single line text) Option (some clients will review different configurations) Line items (multi-select) I want the Line items field to select multiple (static data) records from another table called “products” and then list them inside the quote record. Is this even possible? Any other way to achieve a similar result?