Base Design

I have an interface that pulls data from our working base.We have recently begun to approach our max limits on that working base. I have duplicated the working base and called that duplicate "Archive01".  I plan to delete all but a year's worth of data from our working base to free up space, leaving the "Archive01" base to contain past historical information.I have an interface that currently looks to the working base to import data and produce charts to assess the past 3 years worth of work. I now need to change that sync to have it pull the data from the "Archive01" base instead so I can maintain all the charts.However, when I go into the sync configurations to change it, I am only allowed to change what VIEW I want to pull data from. I am unable to change the BASE.Any idea how I can keep my interface connected to all that data so I don't have to redo all the charts??

HelloWe have 50,000 max record limit on our plan.On our settings page, it says we're up to 35,500+ records thus far.However, when I manually look at all our master tables of data, it only ads up to 28,000So I'm wondering where is that 7,500 record discrepancy is coming from?If I have ONE record in my master table that shows up in 10 other views, does that single record actually count as 11 records?? (in the master table + the 10 other views)I always assumed that views simply pull select filtered items from the master record set and didn't count toward the base record max, since they are just regurgitating data that already exists, and not adding more data rows. Is that incorrect thinking?Thanks.

Hello!I have 2 bases with a table that has two-way synchronization.In the destination base I have added many formulas to calculate prices and costs.Now I need to return the final result value to the source table.I tried using automations, but using "Update Rung" is not allowed in these syncs.I also tried with formulas, but it is not possible.Is there a way to do it within Airtable?The other option is to use third-party tools, such as Make or Zapier, but I prefer to avoid that for now.

Help! We are a Charity that trains Assistance Dogs for Autistic Families. I have a table with ALL the people that have ever had to do with thecontact/dealings with charity at some point... however, this is my dilemma:Mr X is currently a 'Volunteer' and a 'Subscriber' but he used to be a 'Fostererer' so his Contact Type is currently a multiple select field where all three are listed. BUT it doesn't tell me which Type is active and I have been asked to show who's doing what currently and not previously. What do I need to do to my base to identify that Mr X has 'Active' status on both Volunteer and Subscriber but 'Inactive' status for Fostererer.

Hello,We are one of many Homeshare programs in California, that operate out of different agencies with different tracking systems etc. but we try to collaborate across programs with the understanding that we all are working towards the same end goal.Another program showed us how they use Airtable to track their participants, and their workflow is very similar to ours. They built the database themselves, with much research, tutorials etc.Would it be possible to import the structure of their database to use it on our end, without any of their clients' info? How would that work?Thank you for any insights!Julie

I just imported an Excel Spreadsheet but one of my formulas did not come through – namely, =INDIRECT(SUBSTITUTE(fieldname," “,”_")) The value of the previous field determines the single select options for the subsequent field. I notice another user posted this request last year, but for some reason the topic was closed a short time later. Does anyone have a workaround? Dynamic dropdown options on forms Ask the community I am trying to create a mentor request form & table for our community and I haven’t been able to figure out the setup to meet our requirements. Here they are: There will be a mentor request form that is sent out to all users in our community asking them to select an available mentor from a dropdown list. available means that the mentor has less than 2 mentor requests in the current month We would then keep track of mentor requests and close them as they get done How would one go about setti… Dynamic Dropdown Re

Hi!I'm trying to design a database where products are made up of a number of different units. Let's say there are a maximum of 10 types of units, but the quantity differes from each product.For example:The product Box1 consists of 64 units of part X and 64 units of part YBox2 consists of 12 units of part XBox2 consists of 128 units of part X and 400 units of part Z.How do I design the database to make it easy to add a new product and enter information about the units?

Hello Airtable Community,I am currently facing a challenge with importing data into Airtable and properly linking it to existing lookup fields. I have a set of customer names that I've exported from a FileMaker database into a CSV file, and I'm trying to import these names into my Airtable base. My goal is to link these imported names to a lookup field that references customer names in another table.Here's a brief overview of my setup:I have a table (let's call it "Customers") that contains a list of customer names.There's another table where I'm importing my data (let's call it "Orders").In the "Orders" table, I have a lookup field that should display information from the "Customers" table, based on the customer names.The issue I'm encountering is that the imported customer names from FileMaker are not correctly linking to the existing customer names in the "Customers" table, hence not populating the lookup field as expected. The names in my CSV file match the names in the "Customers"

I have a base that has all of our employees (~200) in a people tab. Every month our finance department sends me an updated Excel with everyone that months actuals in terms of employees. Given the number I would like to be able to CSV import this file and then be able to update the people, as well identify who is no longer on the list - and who is new to the list. Additionally, it would be helpful to be able to use this information in the extensions/interfaces to show charts on the over month-to-month headcount change.I think I will need to have some record indicator for each person that the records can align to but every idea I have had so far seems overly complicated. 

Hi, I want to know if:1) Are there are any extensions that would help me with the ability to see the 'saved' information on the lengthy forms started by my customers but not submitted yet?2) Can one customer start multiple forms and save and come back to complete the form at a later time? Example: Adding multiple employees information one at a time by filling up a form for each employee.Thanks! 

I see that lookup fields now have an option to limit the data shown, but it seems very limited to only showing you the data associated with first or last record linked?Is there any way to limit to unique selections only but retain the color labels? We use color on single select to indicate different things like status and priority. So while i can use a Rollup Array Unique, that loses all color and becomes a comma separated list. And no, i do not want to make a special automation to then copy said results to a new field showing the results, as this is excessive and not 100% reliable when there is automation errors or server errors, etc.Would love if Rollup field could retain color on the unique array, OR lookup fields to offer more flexibility to show the unique selections.

Our team ran into what seems to be a pretty annoying bug with the timeline view.After a while if you keep on scrolling up/down, eventually the sidebar where it shows how things are grouped by completely disappears. To me this feels like a bug where whatever is suppose to trigger redrawing it hasn't been fired. To fix it you have to scroll again to force it to redraw, though sometimes it also still disappears. Another way to force it to redraw is to resize the splitter.I managed to replicate it in a new Base with a very simple table (see attached gif). Although it doesn't look so bad in this example, in our actual Base this can be incredibly frustrating as it's happening frequently enough, hurting Airtable's ux. 

Hi everyone,I am no Airtable expert or whatsoever so I am really struggling here....I used to have a team that produced social media post content for my FB and IG pages. I have access to the Bases they created because I used to review the content before they scheduled it. I am no longer working with them but would love to reuse all the content they had crated for me (since i paid for it) so I tried adjusting the posting dates on the different entries but nothing is being posted to my pages.....can anyone help? I suspect they may have done something on their end to sort of disconnect Airtable from my social media accounts and that is why it is not posting but I really don't know. Airtable customer service won't help so here I am hoping somebody knows what I am talking about!Thanks a lot in advance!Jean T.

I have a 'Last Modified By' field in my table that has a user object. I have another field that says 'Last Modified By (Name)'. It needs to be populated with only the name of the user.  Is there a formula to retrieve only the 'name' from the Last Modified by object? 

Hi all,I am wondering if there is an easier way to create similar tables.So, each column is the same and works the same.I can duplicate the table, but what I am looking for is more like a template.I have to do 106 tables, and it just seems like I am doing it the wrong way.They are budgets that get pulled into an interface.Thanks,  

Hi all,I find myself working on things a lot as I understand Airtable.I am trying to do a budget spending, and I have multiple school locations showing the month-to-date spending.I then wanted a table which shows all the schools.The issue is I can only link one table.I want to be able to link to multiple. So I can have all the budgets in one view.Thanks,Judd    

I am looking for a developer who can help me set up and automate my real estate business on Airtable and integrate it with my facebook page

Hoping someone can help figure out the best way to set this up.We have students taking various assessments that range in length from apron 20 - 100 questions. The assessments feed into a table with the submission ID as the primary record field, and then all of there responses as individual fields associated with that record (columns.). Some of the info collected is demographic, some is self-reflection (no single correct answer), and some is multiple choice or short answer, for which there are correct answers.I'm hoping to set up a separate table for scoring.  It would references a student's response, compare it to the correct answer (which could also be a record in the student answer table, or preferably, a separate "question key" table), and record 0 or 1. We would then have separate fields that would tabulate the raw scores for each section and covert them accordingly.  In an ideal world, we'd then also figure out how to power generating individual score reports w

Hi, this notification is showing on my form embedded on my website - "Starting January 31, 2024, Facebook and Web Search will no longer be available as options to upload attachments." (see attached image)Does it mean that users will not be able to upload files when filling out the form? Is there any way I can modify it so users can continue to upload files when needed? Thank you! 

Hello everyone,I have an interesting problem that I would love your input on.What you’re looking at here is a database for a comedy club. The idea behind this specific database is to look into the different events done and to be done. A part of the fields is the date, location, show type, role of artist, and artist.Each event (with specific date) has multiple artists with different roles, I am currently adding multiple records per event in order to separate the artists roles and get a count of each artist’s role in each show type through a related database as seen belowIs there a way to add 1 record per event and add as many artists to this specific event while picking a role for each artist which would then give me an accurate count?

I have spent a HUGE amount of time on semi-functional base design. However, I keep making iterative mistakes. The relational databases is, of course, the big appeal in airtable.But I keep making mistakes with flow through consequences, and kind of need to rebuild our bases from the start.There are many convoluted connections in this base design, and I am looking for advice on a framework for knowing how to rebuild without making the same mistakes? A lot of these issues come from "learning by doing," which has created a vast amount of data that isn't very easy for us to use (or input)!I had a look at the beginner articles on airtable again, but they don't really seem to cover relational database design at a first principles level.

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 against the order and it auto-populates with

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