Base Design

Hi, I’m really enjoying Airtable. First some context, I’m an individual user using Airtable to keep track of various aspects of my life and I am only on the free plan. Onto my question. I have a base that I use to record recipes and use as a meal planner. I would like to be able to generate a shopping list from the recipes marked as going to be used in the next week. In my main table Recipe, are obviously the recipes. I’m using 2 linked fields to two different tables: one for ingredients and one for when the recipe will be used (as that’s the way I found to show multiple dates for one recipe). In the usage table I have a view that shows me the recipes for the next week. I cannot however wrap my head on how I should go to create a view (in any of the tables) that says “show Ingredients matching Recipes where Used date is within the next 7 days”.

Hi I hope someone can help, I am new to Airtable and have a project for a customer and wondered the best way round creating the solution. My customer is wanting to create a list of blocks that when exported as a CSV will create a shopping list for the actual ordering of the material. For example, they could have a number of orders per week for different products and they then need to create a list of all the parts to purchase. My initial idea was to create drop-down lists of the options across all their products and then my customer as they get orders will select the part and the number required for each part, but there could be a number of sections to the list on each order line so could have multiple of the same items (let’s use different screw sizes as an example) My other thought was, as I am new I don’t know if this is possible, they create somewhere all the parts for each product and then when they get an order, they select the product agains

Every day, a pizza shop offers a different specialty slice pie of the day, which I have listed on Airtables. The chat bot platform I'm using now is bad at telling time, so when someone starts using the chatbot, I would like to make an API call to my base to see(1) what time it is and if the pizza shop is open; (2) if the pizza shop is serving slices [which serves between 11:30 a.m. and 2:00 p.m.]; and(3) What specialty slice pie of the day they're serving?I'm a newbie, but I don't mind doing research. If you can just give me a general direction, I would greatly appreciate it. thank you

Hey All!I need some help! I'm relatively new to Airtable and currently diving into setting up an inventory/project management system for my team. Our approach involves utilizing Airtable as a combined solution for both project and inventory management.Here's a quick rundown: We've established a "project-specific" base to monitor products that need to be ordered, received, and delivered for each project each product has up to 750 items to keep track of. Simultaneously, we maintain an inventory base to keep track of surplus inventory and items that have been received for a project. For instance, if we need 3 units of product A for a project but have 2 in surplus, we only order 1 for that project.Now, I'm facing a challenge. We want to mark products as received in the project base and have our inventory base automatically update when we receive products. Essentially, if we order 1 unit of product A, I'd like to mark it as received in the project base and have our i

Hello,Is there a way to have two-way cross-references between entries in the same table?For example, there is a table [Companies]. Each entry, a company, can have clients and suppliers. If a company has clients, it means that those clients have at least one supplier - the company. I'd love to be able to connect entries so that when I assign clients, those entries automatically get updated with supplier info—and vice versa.Another example is Investors/Funds and Portfolio companies. I want to be able to add portfolio companies to a Fund and automatically have this Fund added as an investor to all its portfolio companies.Such two-way cross-reference works fine if I have several tables, for example, [Investors] and [Companies]. Airtable shows all the investors associated with a company and all the portfolio companies associated with an investor.However, I am looking for a solution to keep all the companies (portfolio companies, investment funds, client

I have 3 tables in a gsheet - Meals, Dishes and Ingredients with a one to many parent-child relationship through IDs - meal ID, dish ID and ingredient ID.Is it possible to upload this data along with the relationships or I need to establish the relationships in airtable again manually?If it is possible, kindly also explain how?Thanks a lot. Grateful to the community.

Hi,My airtable gets slower and slower each day. Last night I couldn't get data from a look-up field from another connected table.The main data which I have is about 800 hotels (with 6 pictures each max 1 MG) and 200 attractions 2 images each. (In total I guess less than 4 GB images in 2 tables)I tried also for browser (Safari) hard refresh, but it didn't work (I checked it on another PC same problem).Any advice?    

This list sorts correctly:why is 'b' coming after 'c' in this list (same table and list view)The remaining items in the list sort correctly.Any clues?

Hi community, I'm wondering whether syncing attachments from one base to another will take up space in both or only accounts for the origin base? Is it the same of data library sets? Thanks!

Is there a way to make a timeline's summary bar display different values over a given object's duration? I'm trying to make a map of the effort levels for various projects to forecast my team's workload at a given time (not using utilization because I'm assigning to users instead of a user-entity table). Each item on the timeline is a project, happening from a start date to an end date, with an effort level associated with it. The timeline is grouped by the user assigned to the project, and I've set up the summary bar to sum the effort levels so I can see how much total workload a team member has. However, the projects don't actually take the same amount of effort the whole way through - the second half of the project is a lot easier, so having the same effort value throughout the project's duration makes it look like the 2nd half is harder than it actually is. I'd like to program the summary bar to do something like "first half of project = full effort value, 2nd

I’d like to link a record in one workspace table to a record in another workspace table. Is this possible?

I’m currently facing a challenge with syncing publish dates across different Airtable tables and bases and am looking for some guidance or a potential workaround.Here's a breakdown of my workflow:- I have two Airtable bases: "Marketing Campaigns" and "Content Marketing"; Campaign Managers work out of the "Marketing Campaigns", the content team works out of "Content Marketing"- When a Campaign Manager adds a new campaign that includes "Blog" as one of their tactics, that "Blog" record is added to a view in "Marketing Campaigns" called "Blogs in Development"- The "Blogs in Development" view in the "Marketing Campaigns" base is the source, and syncs to a "Blogs in Development table in the "Content Marketing" base - These records are then automatically added to another table called "Content in Progress" through an automation; this "Content in Progress" table is the content team's workflow/project tracker for all things content marketing- I don't

I have 3 tables - meals, dishes and ingredients.use case: Users should be able to add new dishes and meals through a form. A meal is a combination of 1 or more dishes. Each dish comprises of many ingredients (note ingredients is a separate table)So in a form submission, the user should be able to do two things:1. Add a new dish including its ingredients (note ingredients is a separate table so should be stored appropriately)2. Add a new meal and map dishes to it (a meal is a combination of one or more dishes)Many thanks in advanceHimanshu 

In a long text field is there a way to create a global entry text for some headings so that whenever I want to enter new content i don't have to enter the headings as well?  For example, the headings I use are:VOA ITZAVOA Total sqftML ITZAML Total sqftLA ITZATA ITZA   

I'm trying to build a database comparing similar products and their features. I have a Product table and a Feature table. On the product record I can select the features that particular product has (link to external record, allow linking to multiple records). How would I create a grid-type view that looks something like what's below? I can only seem to get it to show as a single field with a list of linked records. 

This is my first post to the Airtable community.  I have searched through lots of posts about linking records and tables, but I can't seem to find an answer to this...I have two imported tables that have a StudentID field in each.  When I edit the StudentID field in one Table to change the field type to "link to another record", Airtable deletes all the StudentIDs in the table I am working in.  I am attempting to create a linkage between these tables because I want to know if a student in Table 1 is also in Table 2 (and the student may be in Table 2 multiple times, however I just want to know if the student is in the table...I don't care how many times).   Can someone help me figure out what I am missing?  Many thanks, in advance, for your assistance with this issue!My apologies if this problem has already been solved elsewhere, I just couldn't find it.

I am currently facing an issue while trying to release an extension created in Airtable using the "Block Release" command. I have encountered the following error: The block could not be found. Make sure your API key is correct and that you have access to the block.Code: airtableApiBlockNotFoundI have verified that the blockId and baseId in the remote.json file are correct. Despite this, I am unable to proceed with the release. I believe I have the necessary access permissions, and my Access Token is accurate.Here are the details of my configuration:

Hello, I'm new to airtable but absolutely love the potential! I've set up a Social Media Marketing Calendar that my VA and I have access to for writing, scheduling, and planning Instagram/Facebook content. The trouble I'm having is within the same base, I'd like to have a master Calendar for all of my marketing channels. I want a calendar for my email list, a calendar for my planned blogs, and a calendar for my Youtube Content. With all of these calendars I want a Master Calendar for all of my marketing efforts that pulls in all of the sources into one calendar so I can make sure it syncs has a cohesive message. I don't want to gunk up the Social Media Calendar with my other platforms because it could get overwhelming with my VA who only works on Instagram/Facebook. I'm sure it's user error because I'm new to this, but can anyone give me guidance on how to pull information from each of my calendars (Blogs, Emails, Social Media

Hello,I am trying to link a cell in 1 base to a cell in another base. Due to formatting differences, I cannot have it be a full column linked to another full column.Thanks!

Hi everyone,I'm looking to create a use case catalog to help me define the functional requirements of my clients, such as data and system integration.The catalog should include a unique identifier for each use case category and allow me to choose which categories to include in a report and which to exclude, depending on the client's needs.The ultimate goal is to create an environment for the client to experiment with the use cases and required functionality without exposing them to the full repository of use cases and their categories.The goal is to eventually generate summary insights through a dashboard/summary table that shows the use cases by data or integration slices.Has anyone come across a solution like this? Do you have any ideas on how to approach the topic?Thanks in advance for your help!

Hi all, I am using Airtables to set up my cost database for my cafe.For each dish, the items can come from 2 sources. 1 -  A raw material table - i.e. chicken, eggs, which i have already listed it's unit cost. 2 - From a Prep material - i.e. like pasta sauce which we make in house. This table, I've already calculated the cost per portion for each item (making reference to items in table 1) Now to build a recipe, I need to pick items from both table 1 & table 2.   I am not sure if this is possible to have a selection field that reads from 2 table.  or I need another way around it? Thanks!

I have a synced table which I would like to not sync anymore, but I want to keep all the data currently in it.  I know I can just duplicate it, but that would mean I lose my interfaces and automations.  Anyone know if there's any easy way to turn a synced table into just a regular table?

We have SKU's that are bundles and comprise of a combination of other SKU's.So an SKU can be sold individually and also be sold in a bundle.Example -SKU-1 is a bundle comprising of SKU-2 X 1 unit, SKU-3 x 1 unit and SKU-4 x 2 units.We will be pushing sales data into Airtable that will give us monthly sales by skuWe would like to see sales data of all SKUS by accounting for the components in each bundle.Sample base here.Products Table lists all products. Any SKU which is a bundle is marked as a bundleSales Table shows the sales for each SKU by monthBundle table shows all components of each Bundle and the quantity of each component in the bundle.(Multiple bundles can have the same SKU)So SKU-2 should show it's individual sales as a product (31 in June) + it's sales as a component of SKU-1 (12 in June)In the s

Hello, I have a primary field that is a number field that contains sequential invoice numbers. I would like to know if that number field can be converted to an autonumber field that starts at and continues the sequential numbers. It seems silly to have to keep track of the sequence when a computer can do it.Thanks, Scott 

Hello So we have database with pictures and wanted to know if its possible to have Logos like in picture attached to database and if possible how?