Base Design

I am writing to seek assistance regarding a record limit issue that my organization is currently facing with our Pro plan. Yesterday, our base had a total of 13,000 records, well within the 50,000 records limit of our Pro plan. However, I imported an Excel sheet with an additional 44,000 records to test a formula. Subsequently, I deleted the table containing the 44,000 records, expecting the record count to revert to 13,000. Unfortunately, despite the deletion, it still shows that we are over the limit. I have already tried emptying the trash, but the record count remains unchanged. Any advice and assistance is greatly appreciated Thank you in advance.

Hello im working on linking two tables in a base that we use for asset tracking. One table is MOV 24 (movement records) and the other is ASSETS 24 (asset records). In the Movement table (which has a forum to generate movement records), there are multiple Lookup fields that can only look into specific views of ASSETS. For example the radio assets are all assigned an asset number {ASS-ID} in the asset table. In the MOV forum there is a pathway to record the intake of an item from the radio vendor. When recording the MOVement there is a field for Serial Number. I have successfully created a Rollup that is taking the serial number from golf cart intake movement records, but when i try to duplicate the same process for the radio records i am not seeing any information roll up. Any advice would be appreciated! Here is a view of the Carts View on the ASSets Table(which only shows records which have C/UTV in the field {ASS-Which}) and you can see the golf cart SN is rolli

Hi, I am new to Airtable. Just learning to use the calendar view. Instead of being able to view the contents of relevant records in the calendar, I can only see the numbers of relevant records in the calendar and I need to click each date to see the details of the records.How should I set up to view the details directly in the calendar?

Hi folks,I'm looking for ideas on base design(s) for chemical formulations. I've taken one stab at this where I hardcoded some columns, but that fell apart pretty fast. I'm hoping some Airtable creatives have ideas. Here's the general problem:An ingredient inventory has some number of ingredients A, B, C, D, E, F... etc and can have an arbitrarily large number of entriesA formulation has some number of ingredients (an arbitrary subset of the ingredient inventory, so maybe B, C, F as a random example) and a defined amount of each included ingredient (xB, xC, xF). That amount could be a fraction or a mass in most casesSimple case: how do I deal with a formulation having arbitrary composition of ingredients?More complex case: How do I deal with the above, but ingredient inventory can also include formulations (so it's getting recursive)?Any ideas are most appreciated!Regards,Scott

At work I have an Airtable base as in the attached screen share.I need to create one like this for my daughter soccer team. Is this a timeline view? meaning I would have to pay to create one?Thanks M

I uploaded a bunch of portrait character wardrobe photos but they all flipped landscape. Sucks, but I can’t even figure out how to flip them one by one once in - or even how to reload and ensure it doesn’t happen again. This is the first time this has ever happened - it’s never happened on headshots or location photos. Is there a setting I need to set in the table? Or can I rotate or edit a photo once uploaded? I know Airtable is more of a storage device, not photo editing - but this is not the way I uploaded them originally. Thank you!

Is it possible to get AirTable to generate X number of records in a table? Example: Table: Batch Col: Date Col: Batch Number Col: # of Units Produced Table: Units Col: Batch Number Col: Serial Number I’d like to create a record in Batch table, and if I say 10 units were produced in that batch, then automatically 10 NEW records appear in Units table (all of them linked to their batch in the Batch table) and all of them assigned automatically a sequential number (starting number would be MAX of whatever serial number is already in tab from PREVIOUS batch). I can’t even begin to wrap my head around this one. So, the two main issues would be automatically creating X records based on the event of another table AND auto generation of serial numbers starting off at the last serious number of previous batch. Is this impossible?

I can't find all the data I input on 12/20/23, I believe I may have created my spreadsheet under tutorials vs. base. Now I can't find any of my data. I've looked everywhere and can't access it.Help!!!

Hello, hope you are good!I've created an Interface view that i'd like to share to others without granting them the access to the entire base.Right now i just found this  I'm using the free plan, does it mean that the only way i can share my Interface to someone (maybe just by using a link) withouth giving them the access to the base, is with a Team subscription? I think i shared Interfaces in the past, or at least i'm quite sure Anyone faced the same problem?

 I have created a base in airtable. I have a multiselect column called "Attendees". One of the options in this column is "Product". I am currently trying to create a calendar view in airtable that is specific to the Product team. To do so, I have created a filter that says "Where "Attendees" has any of "Product"". However the records that have Product tagged do not appear on the calendar. How do I get the records tagged with "Product" under the multiselect column "Attendees" to appear on the calendar? I do not have the option to choose "contains" when I set up the filter. 

Hello everyone,I have a question regarding the multiple/single select fields.I've built a database for our team and we recently started using it. The only hiccup I encountered is with Multiple select fields: what I would like to have is a restriction for editors so that they would not be able to create new options within a multiple/single select field. Unfortunately, I haven't found a way of doing it, and as for now, all the editors are able to create new options. This leads to the creation of new options if someone, by mistake, presses enter after having typed a non-existing voice.Would you know how we can avoid that?Thank you very much in advance

This will be challenging!I have a Table with around 350 rows that i would like to export automatically as database file tha can be opened in excel, something like Timebale.xlsOnce generated this file i would like it to be inserted automatically in a cell as "Attachment" in another Table. Are there any extensions or functions that allow me to achieve this?Any help will be very well appreciated!

Hi,i am creating 3 tablesINVENTORY, SUPPLIER, PRICEINVENTORY contains every items SUPPLIER is just supplier namePRICE containsLinked table INVENTORY, linked table SUPPLIER, currency field.thefeore i have:SupplierA ProductA usd10SupplierB ProductA usd9 I want to design my INVENTORY table so that i can see the min price with the corresponding supplier. I did rollup the price and it is easy. How about the corresponding supplier? How do i rollup this?Thanks

I am a solo lawyer but I collaborate on some of my cases with other lawyers.I need to be able to see all of my cases in one place, but I need to share information with the other lawyers only for the cases that they are involved with and they need edit-level permission.  “Views” are not sufficient to share information in a usable format, so I have created “interfaces” to do that.  The problem is that interface sharing seems to require base-level collaborator access, but all of the cases are currently in one base and based off one master table with several related linked tables for specific things.Under this arrangement, some of the data for cases that are not associated with a given collaborating lawyer may be visible to those nonaffiliated lawyers, but it is impossible to know or to control that easily.I don’t know whether to divide the cases into bases according to the co-counsel or not.  If I did separate the cases into separate bases, I would s

Hello, we are hoping to build an ad inventory management system that allows us to track when certain ad products are booked.Each ad product has different frequencies (some can be booked 1x a week or some can be booked only for thursdays or can run a flight period). What we'd ideally like to get out of it is also being able to track what is not booked/available to share with our sales team. Does anyone have a similar system already built out that can share a template or suggestions for how to show availabilities?

Hello Airtable experts!I'm a newcomer to the world of Airtable and am slightly overwhelmed with my goal. I'm looking to set up a "button-click" automation within an Airtable interface, aiming to create a private Airtable base with the click of a button. This base should be created within the workspace housing the interface. The goal is to create this private base with one table that references specific records from a source table in another base. I'm curious to know if this kind of architecture is feasible and if yes, can someone please help me get started with some reference code or tips? Would highly appreciate your insights, TIA!

Hi all, We are an organization that runs a lot of webinars, and we want to evaluate each program and get participant feedback so we send a survey after every program.The evaluation questions are the same for every program and I want to design a base that will collect all these responses, and for me to have a way to see all the responses by program, by type of program (for example- a one time program vs an intensive) and aggregated as a whole for the year so we can know how we do in general.I have one table that "holds" all the programs themselves as we use it as a workplan to plan the program from start to finish. I would love to find a way that i can send a survey/form to participants (obviously not users of Airtable), and that all replies will be matched to the program they attended (without them needing to choose the program from a long list).I would love to brainstorm a good way to get this done! We're also currently paying for a couple of third-party s

My daily use of my base involves a lot of calculations. Lately, AT is slow to the point of being unusable while doing these calculations. The base just hangs at "saving" until I manually refresh. I've split the base into four so that the base I'm now working in has a quarter of the records I used to work with, but this has not improved performance. Is there anything else I can try?

Hi all. I'm trying to embed a base that has five tables. Only the first table embeds. When I click it open I can see the other four tables (linked) but I can't click through to them. What am I missing? I know it's probably staring me in the face but I can't figure it out nor find an answer anywhere here. Thanks!

Hello, I'm using Airtable to project manage a fabrication project where multiple units will be built throughout the year. One scenario I would like to track is when there is a single task that needs to be done for each unit, but only when that unit is ready. For example, the task "schedule logo wrap" needs to be done for each unit, but only when that unit is ready for it. What I would like to be able to visualize is how many units have been completed, and how many are left - maybe display a percentage or some other visual indicator. I'm not sure if I should just duplicate the same task for each unit, or I can role all units up under one single task.My current setup is:Unit Table - Lists each unit numberThanks!Tasks Table - List each task that needs to be done.

I'm working on creating a .csv to upload time shift data into another management system. (I don't have control over it.) The datetime format it requires is YYYY-MM-DD, HH:MMa. Airtable is setup without the comma. I'm struggling to create a formula to add the comma in. 

I'm creating a database to track the donations of our organization members and their households. My goal is to be able to create an interactive Interface for our Board to see the percentage of giving households vs non-giving households in any particular month. For example, if 6 out of 10 households gave in October, I'd want to see 60%;  if 3 households gave in December, I'd want to see 30%.Here's how I have the base set up so far:Donations: Every donation we receive is marked with the date received, the amount donated, the Member who donated (linked), and the Household the member belongs to (linked)Members: We have 100 members, each listed in this table and each linked to their Donation (if they've donated) and a designated Household (below)Households: For simplicity of illustration, I'll just say that we have 50 households (two Members in each Household record). Because all the records are link

Google calendars that are imported to Airtable - it looks like only 20 google calendars are allowed to be imported on a base. If we need more calendars on a base, then we need to create a new base? Is there a way to get more than 20 google calendars on a base? Please see screencast and pic attached

I would appreciate an option to limit the available times to schedule records to work hours (9 to 5). We can limit the dates shown to just weekdays, but available times are all over the date (2 am, 10 pm, etc.). This needs to be an option as someone may have events or projects outside of work hours or use the date field for something else. I have a manual entry date field for scheduling tasks on the calendar, and the UX is not optimized for selecting a time within work hours.

Hello community! I’m creating a table to manage a music school. To help with registration, I created a form and I’m quite happy with it. We want to give access to the form through our website so customers can register. I now need this form to be available in both French and English. My concern is mainly with dropdown fields. How would you proceed? Do you know of a way to avoid using a paying app? Thank you guys so much!