Base Design

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 inventory base reflect th

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, clients, suppliers, etc) in the same table.&

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 half of project

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 sync directly to the "Content in Progre

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) into one master calendar that I can color c

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 same way SKU-4 would show 76 + 12 X 2 ( as SKU-1 consists of 2 units of SKU-4)How could we approach this please?

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?

Hi.I have three tables: Teachers - in which all our teachers are listedMeetings - in which they upload their meeting notes with studentsGroup Reporting - in which they group and report meeting, but I'd like to make in easier on them and have the pop up that loads all the "meetings" only load the ones that have be done by the selected teacher. if possible also exclude the ones that already have been grouped and reported. How is this possible? does it mater that we are using the free plan? Also. Teachers aren't "user" they are records in the first table, and all this is done using forms. Thanks,Tomer  

I have a 2 tables Events and clientsI have a form based on events table that clients submit their event requestsi want to when they open the form to have an id field based on clients table  that once they type (or choose from a drop down list) All their  info is added to the form so they dont have to type first name , last name , email and phone