Base Design

I'm trying to create an inventory management base. I have two products that use several parts to make. I want to be able to enter the quantity when I buy the parts, and then when I manufacture, have those numbers subtracted from the quantity of each part.So product COF01 uses 1 jar, 1 lid, and 1 desiccant with 70 grams of coffee. I don't know how to get the 1000 quantity manufactured to translate back to deducting 1000 pieces from each part and then 1000x70 from the coffee product.In my products table, I don't know if I can list all the supplies in one field or if each piece needs it's own field.I feel like this should be simple but I'm completely stalled.

Is it possible to create conditional views of events in Calendar View?I'm trying to build a publicly-accessible calendar of events. Some events are open to the public. Others are private. For private events, I want to limit the information about the event (just showing that something is taking place on a date during a specific timeframe so it's known that time is unavailable). For public events, I'd like to show information about the event (I have Event Title and Event Description fields in my table).So there are two overall goals:Show all events so that viewers know those times are unavailable to rentFor public events, show some details about the event.

Hello. I have two information bases which from I plan to create a project. The first base is a list of equipments. The second one is a list of template rooms, each room has own list of equipments, equipment is a link to the first base and it has a multiple choice for equipment. My plan with a project to create rooms and link it with template room from rooms base and get list of equipment by vlookup. My problem is one row for each room in destination and list of equipments just in one cell. Is anyway to get common table to transform multiselect field of equipments to several rows for each kind of it? Desired result in attachment. 

Hi everyone - I feel like there should be an easy, elegant solution to this challenge, but I can't figure it out nor find a similar solution that applies and it is driving me nuts.I have a personal expense transactions table with some basic fields: date, expense, category, person, account, etc. I have a Budget Month field that I populate manually to tag and group transactions to a monthly time period, though I can probably do this with a formula (?).There is a 2nd table "budget summary" that attempts to summarize the Expense Transactions table by Budget Month AND by person. I was able to create a link to all the transactions for the Budget Month, then individual roll-ups for each category. I was able to do the same by person on a separate table.However, I cannot figure out how to filter/roll-up by Budget Month AND person. If I apply a filter to the person field (person = x), it filters out all transactions since it sees the person as a combinati

I have spent conservatively 3 hours reading posts and watching videos on linking records, lookup fields, etc. It seems that an enormous number of Airtable users are facing something similar - the need to automatically relate to tables but pulling data from one into the other. I have two tables, (Table 1) A table of submitted results/answers and (Table 2) A table that pairs each potential answer with a "response." So as a new record is created in Table 1 (through API with Typeform) with user email and user ID, the answers are now available in Table 1 - and each answer has an empty field next to it for a "response." I want Airtable to take each "answer", look it up in Table 2, and return the "response" - populating it in the designated field adjacent to each "answer" in Table 1. I cannot do this manually, where I create a link and then go clicking plus signs, finding the answers etc. I need this to just happen. I have found a workaround where I can create an automation triggered on re

This is not so much a question as it is a request. I think the fact that having editable sync’s views is such a win in terms of cross base collaboration. I’m curious that why this is not achievable with lookups.  I often use parts of a sync’d based records to fulfill another tables needs but even though the shared view is editable as soon as you use a linked field to those records the ability to edit almost becomes mute. it would be great to be able to have these lookups be editable, it will bring so much more power and flexibility to how we can cross collaborate on our bases. 

Hello All, I'm somewhat stuck when it comes to transitioning to Airtable, so any help would be appreciated. I have a Table, called {Pricing} and another called {Quote}. My intention is to extract multiple entities from {Pricing}, perform conditional formulas and return a final price in {Quote}. The values in {Pricing} will never change, however, the requirements for what will be extracted from it will have to change. I have created the above in Excel, where I was relying on the FILTER formula, and VLOOKUP, I'm just looking to perform a similar task in Airtable. For more context, my products are Gates. And in {Pricing} I have the gate listed in a Matrix, height increments of 250mm and Width Increments of 250mm, with a price in each field. I'll try my best to illustrate.Model&Height    - 1m          - 1.25m     - 1.5m      - 1.75m     -

I'm trying to do this exact functionality from excel, within airtable: Dependent Drop Down Lists Essentially, the single field drop down list will update depending upon the input to another field, as seen below Fruit & Vegetable have two different list options. Is there an easy way to do this, maybe through linking back to a key in another table? Any suggestions help!   

Dear all,when I create a record from a form, I need that a field of #Number type is populated with a default value of 1.Unfortunately this does not happen and the cell remains empty; only if I create the record directly from the Grid the default is inserted.Have you any by-pass for the problem or I'm doing an wrong operation?The only by-pass, at the moment, is to insert the field in the form and writing the default manually.Thank you. Best regards. A. Borriero 

I've got a table in one of my bases where I keep a list of what we charge customers for items.  We're a services company, so nothing is set in stone, but we use this table for a guideline (and the prices rarely change much, if ever).I haven't updated the design of this particular table in a while, so I'm reviewing it now and not 100% sure of the best approach.I have a second table where I actually keep every single item we ever put on an invoice.  44 in total.  And then we just reference the table with pricing, but mainly because it has more granular information.  For example, I might have a "Facility Fee" as an invoice item, but then I have multiple "Facility Fee" entries in the Price table for different durations.  I now realize it's a bit silly to split things out in the manner we've done...at least how we're during it currently.Invoice table (each "Item" is a possible invoice item).  Very simple, but more things link o

Hello'I am trying to create a table 'Customer Interested Events' which maintains basic customer information (customer e-mail is PK) and additional fields  (selectable fields) 'Event Category' , 'Event Location'.Based on the customer interested events another table 'Event Manager' would be populated which is linked with above table 'Customer Interested Events'. Purpose of this table is to assign a suitable manager against each Event Category. The PK in this table is a computed field "Event Category+Location" and has additional fields like 'customer name', 'location','event category' (lookup fields from the linked table), 'event manager'.I am trying to maintain one unique record against each (event category, location) with all corresponding customer names, locations merged in the respective fields (if multiple customers booked for the same event category, location) so that one manager can

I have a BASE with an Events Table, a related Contacts Table (One to many), a Schools table related to the Contacts, and a Groups table. related to an event where a group can be associated with multiple Events. In the Groups Table, I have a lookup that finds all the Contacts from all Events related to the group and another lookup that finds the School related to the contacts that show up in the first lookup. Because the same people attend multiple Events related to the group, the result in both lookups have duplicate values. My goal is 2 field that only shows the unique values present in each lookup. (Unique Schools and Unique Students) related to a group. I looked at using UniqueArray but couldn’t get the desired result and am looking for any Step by Step help that you can provide.

Hello,Referring to this Volunteer Management template:Volunteer Management Template - Free to Use | AirtableHow can I combine all of the tables into one 'Master' type of table so that I can run queries across table fields?I understand that there are lookup fields.  But each Volunteer Event has multiple Volunteers.  Each Volunteer can have multiple skills.  So if I want to run a query where I want to find out the pool of skills that the pool of volunteers bring to Volunteer Events between Sept 2023 and Octo 2023.  How would I construct the Master table (or some other method) to run such a query?

First of all, I'd like to thank all in the community who helps in advance!I have chosen Base Design for this post's location, though formulae etc will also be appreciated.I'm running a SMMA and am still new to Airtable despite making good progress over the last week and need guidance setting up a base in Airtable to gather metrics via scraping. This base has three main tables, Post View, (Social Media) Account View, and a client View.In Post View, info about each individual post our clients make such as # of views, # of shares etc as well as the time and date of posting is collected. In the Account View, data pertaining to view, shares, data the view, share, like and comment count data for both (Today) and (Yesterday) are displayed. The third table is further aggregation to give a better top-down view.I have two main questions. In the second table and third tables how can I ensure that the data for 'Views T

We have a "Last modified time" field that updates when either of two other fields are changed. We discovered a group of records all modified on the same date and time (05/11/2023 at 12:50 PM) but when we opened each record to see the revision history, there is no trace of how the records were touched. How could that happen?There are no automations that run on a schedule.There is an automation that runs when certain triggers are met. We looked at the run histories but none of them ran at that time.Any ideas?

I have been using Airtable for a little while and can get the basics of what I need.  However, I'm now getting much more complex with multiple bases linked together and I'm having a hard time figuring out the best way to link my tables together.   In a perfect world I will have a table called Customers which has the name of each customer as the primary field.     What are best practices for keeping this up to date?  If I add a new record (customer) to Customers table, how do I ensure that it will add that customer to all the linked tables?  Do I use a formula for the primary key in additional tables and then an automation that runs a script once a day to sync?  It seems like there has to be another way.  Any help is appreciated! 

While working in a Timeline view, is there a way to select a record and alt-click-shift drag to duplicate? Moving a record between swimlanes is a convenient action. Duplicating a record by clicking the three dots to the right of "expand" and choosing duplicate is convenient action. It would be really handy to just alt-click-shift-drag a record or records to duplicate it in the same swimlane or another swimlane.Certainly, I'm not the only user who might find this helpful.Thanks!

Hi folks, It's just a simple question that I wasn't able to find an answer inside Airtable documentation. Is there a maximum number of files allowed in an attachment field? Or is it tied to the max size limit of 5GB?Thanks

I have a table from Base A that I've synced to Base B. I no longer need this specific table in Base B, so I would like to delete it. If I delete the synced table in Base B, will it also be deleted in Base A?I checked different threads and couldn't find a definite answer and I definitely don't want to proceed until I know for sure.  Thank you!

I'm creating a workflow/process tracker using Airtable. I have the following tables:WorkflowsStepsWorkflow RunsStep RunsThe Workflows table contains a list of workflow names, e.g. "New client onboarding workflow".The Steps table contains all the steps within each workflow and I have a link back to the workflow table to know which step relates to which workflow.I have automations in place so that when someone wants to run the workflow it will add a record to the Workflow Runs table and then another automation that will pull all the steps from the Steps table and add them to the Step Runs table linked back to the relevent row in the Workflow Run table.This has allowed me to create an interface where anyone can see the progress of the Workflow Runs and Step Runs that they're assigned to.What I'm struggling with is how I can add unique sub-steps to each step similar to how it is done on the dedicated workflo

Hello, I need to create an "budget base", I've these tableincomeexpensesIn the expenses table I have different categories for each expense, but for some of these I would need also sub-categories like exemples:salariesPerson 1Person 2Person 3What would be the best structure to obtein this?I hope it's clear, thank you for your help!

Ok, I'm trying to build a product catalog and inventory management Airtable. I'm trying to work out the basic structure before I get too deep into adding all of my stuff.We have components, with a Part #, which are sometimes sold on their own as a SKU.We have Products, which are made up of multiple components, sometimes more than one quantity of each component in a product. These are sold as a SKUWe have Bundles, which are made up of multiple SKUs.I want to bring in data from another source which shows SKUs sold by SKU and quantity (some are bundles, some are components, some are products), and I want to be able to drill down to the number of each component sold from that same data.Any suggestions here?

I've been building interfaces that have "add record" buttons in them, and because of that I've realized that I've miscategorized some primary record fields for what a record is called when I first created a table. For a table that is based on personnel records I somehow selected "company" from the dropdown list when I first made the table and now in the interface for a personnel record I have a button that displays "Add Company". Ideally I could change the "What should each record be called?" option in each table, but I'm not seeing any way to do this once the table is created and the initial selection is made. Alternatively, I would love to be able change it to "Add Person" as one of the options in the interface designer, but doesn't appear that's an option either.Does anyone know a way to do this either in the interface designer or after a table has been created?

I would love to have Airtable help me to map out the prerequisites for an academic program but I'm having a little bit of trouble. Imagine a list of courses - some are required for the program, some are electives, etc... Many of these courses have prerequisites. For example, before you take course F, you have to have already taken course B.If it were that simple, I'd be able to use the flow chart extension to map everything. Unfortunately, it gets a little complicated when prerequisites include multiple courses and even "this OR that" cases. For example, "before you take course F, you must have taken both course A AND course B OR you must have taken course C". I tried to use different fields for each case with an "or". For example:Multiple Linked Field 1 includes "Course A" and "Course B" records.Multiple Linked Field 2 includes "Course C" record. This would indicate that you must take Course A AND B OR Course C. The problem I'

It would be awesome if Airtable added 'This Year' and 'This Month' to the filters. This way, I could create a view of records, like expenses or invoices, that apply to this month or year. I'm actually surprised this is not already a feature. It seems like it would be a simple addition.