Base Design

Howdy! I have a list of all of my vendor partners, which includes a single select column for the type of vendor. I would like to create another table with a filtered list of my partners of a specific type, web integrators.I would like to do this because I have some additional columns of data that I would like to add and track, but they are only relevant for the web integrators and not relevant for all of the other partner types. The Company Name would be the primary field on both tables.Ideal, I would be able to create a new table will all my tagged web integrators, such that when I add a new partner to my main list and tag them as a web integrator, they will appear on the new table and I can update the additional columns in the new table. What is the best way to achieve this use case?

I have a question that I can't seem to find the answer to. I have two tables within a base. One is a list of employees with their names and teams. The other is a list of Scheduled trainings. On the Scheduled table, I have a field that I fill in for possible training attendees. It is a multi-select field linked to the Employees' table, but I have to add each individual 1 by 1, which can be time-consuming.Is there a way to add multiple people easily or be able to add everyone from specific teams? I'd want to be able to select operations, for example, and it adds everyone's name from that team to that field. So I can see the attendees, but people can also have the training linked to them directly. 

So with the linked records field you can limit the available records to a view. I would however like to link a record to a certain view within another table. So if I click on the link I would like it to take me to a certain view in another table. This view will be different for each link though (although limited). So I have a table column with tools for example. That will list Blade. Now if I click on blade I would like it to take me to the view of all the different blades in the Tools table. I don’t just want to link to all of them because that would be horrendous to click through all of them. Any ideas?

I have two bases: Contacts and Matters. In Contacts, there are two tables: People and Companies. In Matters, I have a table (Matters) with a field for Clients. I know i can sync People and Companies to the Matters base. However, is there a way to link the records for People and Companies to the Client field? I only see a way for one or the other. 

Hello,I have a client base that needs to be shared and synchronized with more than three different bases in a one-way sync (from the client table to all other bases without allowing any modifications to the client data from those other bases). I noticed that there's only an option to sync it to one base. Is there a way to sync it to multiple different bases?Below is the schema I wish to build: 

If I change the default value for a field will the new default value only apply to newly added records?  Or will this cause existing records to be updated with the new default value also?

Hi,I am a Airtable newbie and am having a bit of a challenge figuring out how to properly link 2 tables.  Table 1 (Vehicles) stores Vehicle data - Plate, Make, Model, etc. Table 2 (Fuel Log) stores  - Plate, Litres and Fillup DateI would like to include a field in Table 1 that shows the total litres for each vehicle.  I have tried linking by Plate (not sure if that is correct) and can't figure out how to show the total litres in table 1. I would also want to be automatically update the total in the Vehicles tables when a new row is added in the Fuel Log table.Would appreciate any assistance.ThanksSteve

 Hello Community,I hope you're all doing well. I am currently working on a project where I need to create an accounting table in Airtable to manage financial transactions. The table should include columns for "Date", "Amount", and "Event Type", and it needs to track various financial events such as existing non-financial debts, personal financial debts, business debts, and loan transactions.Here's a brief overview of the data I need to incorporate:For the date 2024-03-01:Existing Non-Financial Debt: -15,000,000Existing Personal Financial Debt: -31,000,000Existing Business Debt: -8,000,000For the date 2024-06-01:Startup Loan Transaction: -100,000,000Additionally, for 2024-12-01, there is an event of "Sacrifice" which involves an 80% forgiveness of the combined total of the Existing Personal Financial Debt and Existing Business Debt.And for 2025-02-01, there is a "Loan (Business Closure)" event adding +100,000,000.I am looking to not only input this data but also calculate the total

We run a weekly vege bag program, and I need some help scaling up and improving our record keeping. Members can get their vege bag delivered for a fee, or pick it up.We ask members to commit to being a delivery or pick up, but there are always a few who need a one-off delivery each week.This creates 2 checkbox fields:"regular delivery"and"one-off delivery"On vege-bag day I create a view that filters only "one-off delivery" and "regular delivery" to create my delivery list.However, for tracking payments, we need to be able to see a history for each weeks' "one-off-delivery" (to make sure the delivery fee is being paid), so simply unchecking the "one-off delivery" doesn't work that well. However, creating a new field each week with "Delivery 30 march" and then a new view which filters "regular delivery" and "Delivery 30 march" is cumbersome and prone to human error.This might seem fairly menial, however there are several other pieces of information I need to be able to track si

Dear Community!When creating a timeline view with a "Day" timescale the horizontal axis ranges from 1st Dec 2023 to 20th Aug 2024. Is there a way to adjust these start and end dates of the timeline?I'm trying to make use of the timeline view for planning shifts during an event that only goes for a few days and the massive range on the horizontal axis makes the view basically unusable.Best regardsHenry

HiI am a curriculum coordinator in higher education and have multiple bases/tables/forms that contain/gather information about course units in the curriculum. All information always relates to a course unit, e.g. Business Economics. All the information needs to be linked so I can always look up information in other bases/tables, but I'm not sure when to create a new base, create a new table in a base or create a new view. These are some of the data I have:Curriculum 'technical information': per course unit how many credits, elective or not, prerequisites, timing (SEM1 or SEM2) etc.Curriculum task allocation: information that comes from an export from our CRM which shows which lecturer will be teaching a particular course unit in which semester(s) to which class group. The unique key here is a formula field concatenating course unit - class group - semester - lecturer, e.g. Bachelor Thesis - Class Group 2 - SEM2 - John Doe. There should be a one-to-many relationship here, where one reco

Hello! I have created a student database and while the linking between tables worked as recently as last week, the copy/paste function appears not to work anymore. Specifically, on the ‘Contacts’ table (see screenshot), any time a new record (student) is added, I would like to copy and paste that name into other columns which link to other tables such that the names show up in those other tables. For example, as seen in the screenshot, I would like to copy and paste the name ‘Kamala Harris’ to ‘Snapshot_link’ such that it shows up on the Snapshot table. However, I’m unable to do so-- I get a ‘Pasting…’ message and nothing happens. Currently the Name field is a formula, but it won’t work even if I make it a single line text.

Hi Everyone! I'm trying to design a judging system for a science fair styled event but I'm wondering if there's an easy way to do the judging assignment through airtable or if I can do it through Excel then transfer to airtable. Right now I have three tables: 1. Judges (All the judges are named and given a unique number) 2. Projects (Each team & their assigned table) 3. Scoring (A grid + form view where each judge can select their name + the team they're assessing through the form - I use linked records to group the teams and get final score). Is there a way you would recommend assigning each team 3 judges with team receiving any one judge more than once. Maybe there's some trick by using a number to represent each judge and the random formula... Would love any ideas. 

Hi all, I am building a base that should help me build diets for my customer. In one of the tables, there are all the foods I can use (800+ records), each of them with nutritional data, as the nutritional tables on the foods boxes, to be clear. In another table, I would like to link records from the food table, and summarize nutritional facts from each of them. This is easy, also with multiple records linked, using the rollup field. The problem is: I would like to add a specific amount of each food (a quantity, so to speak), and calculate nutritional facts from each linked records and summarize the results. For example: I would like to add an apple to my diet, but the food table has nutritional fact for 100g of apple and I would like to add 250g of apple in the diet table. If I have to link just one record, it would be simple, I add another numeric field and use it as a multiplier for the nutritional facts. But since I am not sure how many food items

Hi, I would like to request allowing the fields to become collapsible in the detail view.This is both on the web and on the mobile all.When I click to expand the record, I get the whole view of the record and the fields expand to show all contents in the fields. While this is great, it poses issues if text in the fields is long and if there are multiple fields with long text. The same issue (even worse) is on the mobile application for Android and iOS because there it requires tons of scrolling down to get to the field I need in the record expanded detail view. What would help is adding a collapsibility to fields. I do not want to hide fields from the view but if select very long fields can be preset as collapsed, whenever I view the record, that would allow me to scroll faster and find what I need and then click to expand the collapsed field if I need. 

Hi! I'm working with a customer who needs a general warehouse control for his business. I have created the base and all works fine. Here is my problem...When merchandise enters his warehouse, it goes into his inventory. Currently, he adds 1 or 2 products manually in a form(Writes 1st item, clicks submit. Writes 2nd item, clicks submit). The issue comes when he needs to manually input 5+ items. Is there a way, a form or a template, where he can add X number of rows, click “send“ and for them to load to a page? *As a reference, the input is in an “inventory“ tab that is linked to: product tab, supplier tab, invoice tab.

HiI think I've been overthinking this and have brain freeze.Two tables Contacts (all contacts) and Students (people who have been trained, should exist on contacts)Both tables have email address as Primary fieldContacts has a Verification field which I want to show on the Students table for each studentI just can't figure out how to link the two tables! I did the straightforward link and nothing appears to happenThanks in advanceMike

Hi everyone! I was wondering if it's possible to recover lost data after importing bases. When I copied and imported a whole table to a new blank one, some of the data was imported, but some other was lost and I have blank fields now. Namely; the attachments (pdfs). Does anyone know if/how I can recover those at all? Thanks in advance! 

Hi, We have different bases in a single workspace that correspond to specific projects. One tab in each base is the project schedule. We would like to link all of these up in a separate ‘master-schedule’ base that can house a Gantt chart to keep track of our project pipeline. We would rather not have all the projects (dozens of tabs) in a single base. Is this possible with Airtable?

Hi everyone, I build an internal tool for a company where they organise their Projects, Invoices, Employees etc. As the Data is accumulating, we would like to get a better overview,, especially in the sense of knowing how the numbers look on a monthly basis. However this seems to be trickier than expected. For example Invoices: I want a summary for each month. Sum ingoing, sum outgoing, balance.Or I have the hours worked by each employee. I'd like a table where I have those numbers for every employeee on a monthly basis. What would be a good way to collect all sorts of data based on predefined (month, year etc) timeframes? I dont want to work with a custom view for each month. I tried displaying the dates as "March 2024, April 2024" but i cannot group by that. I thought about creating a "timeframe" table where every record is one month for example, but then I'd have to link every record (from different tables) that falls into that timeframe. So most c

Hey,My main table has a few dozen thousands records. In order to complete the process, I also need data from around 10 different tables, each of them also has a few thousands records. If I want to aggregate data from all of them in the main table, I'm reaching the records limit. My thing is - it's kinda waste of my database space to keep the details from all the tables, if I just need it to lookup one field and it's not being used for anything else.What would you recommend, what's the best practice? Hardcoding with automation and deleting is definitely not one of them.A great solution would be, if it was possible to sync many tables into one, (but not in the way it has been released recently), for example:if one of the fields in DB 1 is license plate, I would sync just lookup fields from another base with all the plates, directly to DB1 without having to create linked records and another table.not sure if I was clear enough, what are your thoughts?

Hi there. For a while I have been trying to figure out the following. Maybe you can help.  For our participants we measure there progress over time. We do this by filling in a form about every 2 months.  We have one base with all the participants (personal data).Since one participant can follow multiple trajectories, we have one base with all the trajectories linked to the participants.  The results of the form also appear in a seperate base. For everytime the form is filled in, a new row is created (which is linked to the right  trajectory) My question is the following:Example:On 1-1-2023 John scores 6/10 on our communication scale.On 1-3-2023 John scores 7/10 on our communication scale.On 1-5-2023 John scores 8/10 on our communication scale.On 1-7-2023 John scores 7/10 on our communication scale.On 1-9-2023 John scores 9/10 on our communication scale. On 1-1-2023 Cristia scores 4/10 on our communicat

I am attempting to build a Crypto Liquid Pool tracker and trying to figure out my base design.I'm not sure if anyone on Airtable has done anything like it. If so, I would love to hear your opinions and what your base/ schema looks like. For those unfamiliar, it would be something similar to this.In adition to that, I would need, on occasion perform some of these tasks: and provide "Position value", "Fee Value", "Token Price" for each asset, "Transaction Fee", and status if Out of Range or In Range

Importing csv files with 18 digit numbers, doesn't work What I tried to import: 513267577250775049What actually got imported: 513267577250775040Simple terms: The 9 digit at the end of the number, got changed into a 0The relevant CSV file to import, is below.  name,server id,notes Ergonomic chair,513267577250775049, Wooden storage box,, Wooden pen holder,, 

Hi folks, Happy Friday. I am searching for some help/guidance on the airtable platform. I think/hope my client's needs are quite straight forward and have outlined them below 1) A full league table, with the following fields: Name, Golf Club, Handicap, Number of 2's this season.2) Needs to be easy to update at any time and sort to show who is in the lead etc3) The ability to create a league within a league to play directly against your friends. So for example the overall league may have 1000 players, and there may be 100 additional private leagues with between 2 and 10 people in each. So players would always take part in the overall league but would also potentially play in another league or leagues against a select group of friends4) This will be displayed on a website, and ideally should have the branding on it and have a golf/sports/competition based theme to make it fit in with the website5) Ideally the "join now" form on the website will feed the data directly into the o