Base Design

I have been tasked with developing a system for individuals to evaluate (with a rubric) a series of proposals related to a strategic plan coming in.Individuals are submitting ideas using a Form that feeds into an AirTable Base (Base 1). We are doing this because we also want to visualize the ideas.The idea is that once individuals submit their ideas, a group of people will be able to evaluate them using a scored rubric (Base 2). Initially, I figured I would create another Base and then Sync the Two Bases (One Way) While also adding a form that would input the scores into the New Base (Base 2). I would link them based on either the AirTable ID or the Title of the Proposal. I was then going to create a third base (Base 3) that scores and averages the results of the evaluation.The challenge I am running into is that MULTIPLE people will complete the evaluation – up to 15. I am trying to think of a way to use AirTable for the scoring phase, but there need to be MULT

HiWe have an Email Tracker table in our base with a lot of data rows, so I want to move that table to it's own base to avoid maxing out our limits too quickly.The Email Tracker table is fairly independent, with the exception of 2 data columns:1 linked records field (linking to the Campaigns table)1 look up field that is pulling in the "campaign owner" from that same Campaigns tableI'm not sure how to best maintain the 22,000 rows of data already linking to the Campaigns table in our primary base.The Email Tracker base will have a Campaigns table that is synced to the original one in our primary base. However, I'm not sure how to get the linked records fields that are currently looking to the primary Campaigns table to now look at the synced version of that campaigns table that I created in the new base, short of manually updating all 22,000 rows!I did a test, pulling in all the information of the Email Tracker. The linked

I'm using a Google Drive Sync integration with the intention of avoiding going over the storage limit in my base. On the FAQ's for this integration I found this information:Will the attachments in a synced table count toward the destination base’s attachment limits?Yes. Similar to record limits, attachments in a synced table will count against the attachment limit in that synced table's base.If I were to simply not sync the attachments field, will that avoid taking up storage space in my base? With this solution, I could simply rely on the urls provided by the Google Drive Sync integration to interact with my files.Thanks in advance,

Hi allI'm organising a straightforward, but extensive catalogue of books. My users are frustrated when they apply a filter, or do a Ctrl-F search for, say "Fried" and it returns all occurrences of that string, such as "Friedman", rather than the word on its own. Any ideas? I'm sure it's simple . . .ThanksEd 

Hello there! I've built a Base to track "Vacation Requests" and 'balance vacation days' in two simple tables:1) Staff: where fields are name, email, role, hired date, accrued days (formula based on hired date), used days (roll up from the sum of all approved vacation requests), balance days (accrued-used).2) Vacation Request: where fields are req. id (formula), name (linked from staff table), email (linked from staff table), start-date, end-date, requested days (formula), status, duration (formula, only populate if status approved, this field is used on a roll up in the 'staff' table). Up to there, everything's perfect. Where I'm stuck is how to keep track once the 12 month period is reset for each team member. Picture below illustrates an example:   Technically, for that team member that used 27 days alr

Hi Everyone,i am new to Airtable and try to build a small solution for our cycling club. We like to keep track of group rides, so i have three tables:Members (List of all Members)Routes with the fields:NameDistanceRecords with the fields:Member (multiple records, from Members table)Route (from Routes table)DateI have a form there a member can create a records and add a records for a group ride on a date and can select multiple members who joined the ride. A member can do the same route on multiple days.Now id like to create a view which shows a member list with the sum of the distance of the routes.Expected output:Marianne Westhoff, Distance 40Marcel Mertens, Distance 30Daniela Feuersträter, Dis

Hello community! I am looking for assistance with the design of a table that involves records with a field linked to other records within the same table. I know how to include differed records in a field but I donk know how to see in the second ones that have been connected. Let's see an example: I have a table with a list of schools. I mark in a field of one of the records (school 1) that collaborates with 2 other schools (school 2, school 3) (I use a field linked to the base that permits multiple records). The question is: how can I see inside the records school 2 and school 3, that they have been linked to the record school 1? Is it a way to get this? Thank you very much Marta

I wanted my user records to have a field determining skills and proficiency for each skillsSay for exampleFull Name | Language ProficienciesElsa | English - Beginner, Dutch - Mid-Level, Japanese - FluentHow do I achieve that?  

Hey team, I’m looking to create a form where our team members can submit updates on the Objectives / Steps they’re working on. Ideally I’d like to have the member select the Objective and based on that, the Steps option will filter to the steps within that Objective. Is that possible?

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

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 impo

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