Base Design

I have two tables, one with products and one with parts of the product. On the parts table, I include a team member who's responsible for that part. Sometimes the same team member is responsible for all the parts, and sometimes the responsibilities are split.In the products table, I'd like to summarize the team member who's most responsible for the product, who'd be the person assigned to the most product parts. I can't figure out a way to do a rollup that shows the most common value of the linked parts, though. Is there a way to do that?

I've been researching and trying to create a table for my needs but having problems and doubting if this is possible with Airtable.I'm importing a csv/google sheets everyday with ID, date and amount fields. What I'm trying to achieve is, import another csv, if there is a matching ID, it's date and value fields should be added to their relevant fields instead of overwriting any previous values.ID1 should have both 09/12 date and 500 amount should be linked, in addition to 10/12 date and 1000 amount getting linked too.And be able to see an IDs amount on a chosen date and also able to sort for last weeks IDs with the highest amounts.I'd really appreciate if someone can briefly explain the method I should be using or if this is possible at all. Thanks!

Hello,I would like to create a database to manage my purchases and compare the prices of different suppliers.I have products in one table and suppliers in another.I would like to have the possibility to enter a price for each new product created according to if it is proposed by the supplier.I have created a linked record between the two databases but then I get stuck.Thank you for your help.

I am trying to use Airtable as a resource to build concert programs for a music organization. I have one table (called Compositions) that contains what will be a very large list of compositions, and each composition may have anywhere from 0 to 6 movements. The movements are currently input as text fields. I have another table called Program Builder where I will be selecting from those compositions and the movements contained therein.I have successfully linked the Program Builder table to look up compositions from the Compositions table. However, for any given program that I'm building I would like to be able to select specific movements of that composition, but not necessarily select all of them.For example, I have the composition Cello Suite No. 3 in C Major, BWV 1009 which has six movements: I. PreludeII. AllemandeIII. CouranteIV. SarabandeV. Bourrée I /

I have a base that currently has a single table which is populated via an integration with Jotform. There may be more than one record per customer and I'd like to create a view which will only show the most recent submission.I've got "last modified" as a field and I'd like to use that as a filter along with the customer's name.Is it possible? If not is there a workaround?Thanks

Hi, I'm trying to figure out how to work with attachmentsAfter looking at several posts on the subjectFor example regarding photos from my website or from Google Drive.If I upload these links in the attachment field, will they become invalid after a few hours?So currently it is not possible to display images in the table without using the automation that uploads the images each time?Or is the problem only in using the link, but the image will still remain displayed in the table?I would appreciate recommendations and insights.

Hello, Im looking for a solution to my request form routing. Is there a way to create a new table in a base for form requests, where I can approve a form and it will automatically link to the main projects table in the same base?

I'm trying to see if there's a way to do a look-up on a linked record that's in a look-up field?I have three tables, one for the overall project (like, "Q1 Product"), one for production phases (like "planning," "writing," "design," etc. so I can show them on a timeline), and one for production pieces (like, "magazine," "packaging," "instructions," etc.).The phases for a project get linked to the overall project, and the pieces for a project get linked to the overall project. That's already a lot of linking and record creation for a project, and the phases are only loosely associated with the pieces, so I don't have the phases and pieces linked together, just to the overall project.What I want to do is pull some info out of a phase record and pass it to a piece record. So I was thinking, just do a lookup of the linked phases on the overall project, and then make another lookup field to pull info out of that lookup of links. However, it looks like lookups only wor

Hi Guys,After hours of trial and error, all errors, I cannot for the life of me figure out how to join data from two different tables.Table 1 has INVOICE NUMBER, CUSTOMER NAME, and CUSTOMER EMAIL, one Invoice Number per row.Table 2 has several rows with the same Invoice Number, and one item on each row. So, if the customer just bought one item, there would be only one row with Invoice Number and Item.If customer bought three items, there would be three rows, with the same invoice number on each row and one item per row in the Item field.What I want to do is to build a THIRD table that has Name, Email address, and Item, so I can then sort who bought a specific item, or all the items a specific client bought.But try as I will, I can't figure out how to do it and ANY help would be VERY appreciated.So, Table 1:Invoice 1 - Client 1 - Client Email 1Invoice 2 - Client 2 - Client Email 2Table 2 hasInvoice 1 - Item

Yes, I was going to post this. Why is this so old and nobody responded. I want only download CSV of selected records. I don't want to go to have to create a filter if it is a one of quickie export.I don't like this new forums. The interface is confusing and adds zero value to me. All is somehow boxed and convoluted and tacked away. Why has Airtable switched. Don't break what is not broken. https://community.airtable.com/t5/product-ideas/exporting-downloading-selection-as-csv/idi-p/96470  

In this table I have a list of plant names (taxa) plus other information about the plant's habitat, etc. Plant names frequently change, and the old name is considered a synonym, while the current names is the "accepted" name. Accepted names can have multiple synonyms because the names have changed several times. I want to show only accepted names in the main Taxa Table view. If a name changes, the currently listed name will become a synonym. I want to be able to automatically separate synonyms into a different view or table once I have designated them as synonyms. BUT the new accepted name will need to have all the same associated information (habitat, etc.). The synonym view/table can just be a few fields with the old name and related information, but it will need to li

I have an automation that when we add a project, it creates 15 linked records on an Expense table. Each record on this table is tagged as a different stage expense. I then have 15 or so rollup fields pulling in the different dates from the linked project (using MIN(values)) and total values of each stage's expense. Then I have 2 formula fields:- Date, which checks the tagged stage and pulls in corresponding date using a switch formula- Expense, which checks the tagged stage and pulls in corresponding expense using a switch formulaFor some reason, when I pull in all 35K records, the pivot table is giving very different sum total than the grid view. I think it has to do with the date field possibly. IS there something I have to do when pulling in a rollup date field into a formula field so that pivot tables read it correctly?I verified the grid view filters on the date field work, and exporting it to CSV into Excel pivot table resulted in same correct sums

I am trying to create a simple donor database for a local charity. The “Donors” table would list all donor details (name, phone number, address, E-Mail etc.) while the “Donations” table would show all donations made by the various donors. The “Donations” table would include “Donor” as a linked field to the “Donors” table.It is straightforward to copy and paste details of donations into the “Donations” table. However, I can’t import data into the table because Airtable says the “Donor” field is unsupported. Is there a way of doing this? I don’t really want to copy & paste data. I want it to be more automated.

Hello!I have a question about the best way to set up workspaces and bases for our marketing department. Our department has five digital marketing teams, each digital marketing team has different social media editorial calendars to manage, which we're going to use Airtable bases for. People from the different teams should not be able to see the bases/calendars outside of their own team. Let's say the company is "Company A," each team is named "Team 1," "Team 2" etc and each social medial calendar is called "Base A" "Base B" Base C" etc.How would we best set up our workspace and bases. Should there be a workspace for each team, completely siloing each of them (with bases for each calendar within the workspace)? Or should there be one workspace for all five teams, with bases each all social media calendars? If we were to do that, is it possible to add all teams to the workspace, but relegate their visibility only to specific bases?

I have played around with importing my trello board and making one base. I have the sense that I could use airtable instead of 12 trello boards to track work in different projects. What I would like is the ability to see a timeline that unites multiple tables (projects) and allows me to edit dates or other info about records where I think they will be in different tables or bases. I feel at this point I’d do better seeing a model of something akin to this than trying to read lots of templates or theory articles. Does this sound familiar? My main needs: replace multiple trello boards create views by timeline or kanban of distinct tables/bases possibly collaborate with a few people be able to edit or MOVE records based on certain views. i.e. something that is “writing” becomes part of “podcasting” or “research” which are I think distinct tables.

HI, I am new to Airtable. I reached for my query before i am posting this in forum.Let's say I have 2 records.ID, Type, Item,FYxx_Total1, Fixed,A,2001, Fixed,B,1001, Variable,null,0As you see, ID is 1. When the user enters the FYxx_Total, the first and the second row shouldn't be editable. Meaning, user shouldn't have the ability to alter the numbers for the Type = "Fixed". The 3nd row, I want user to enter the data for this ID: 1.is it possible to achieve in Airtable?

Hello all!We are a small company setting up production. I don't need to use AT to track every single part, but we want to use it as an engineering tool to track prototype lots and parts pulled in for inspections, testing, experiments, etc.I have used the API to automate the creation of parts and automated test logging, and have designed some forms for Real Live Humans to update and add comments, requests, etc.The core of what I have built so far is a PARTS table, with one entry per individual part, and then an UPDATES table which has multiple entries for each part, referenced back to the key in the PARTS table.So, for example, when part ABC is tested in the color testing machine, my API will first check for an existing entry in the parts table under it's SN (say, SN=101). If it doesn't exist it's created.Then it will log the test by adding a record to the UPDATES table, with TYPE=TEST (selection) and DESC="COLOR" (text).If we then move it on

What could be causing the Pivot Table extension to have a different sum than the grid view the pivot table is pulling from?I have a table with 35K records. Each record is tagged as an expense payment or a revenue collection. I then have a view called "Expenses" that filters for only the expense records (around 25K records). I also have a date associated with each record. I group by category in both the Expenses grid view as well as the pivot table. Since grouping by a date field in a grid view does not allow buckets like pivot table does, I have a formula field that does a grouping date string: DATETIME_FORMAT(Date, 'YYYY-MM (MMM)')If I use the date group in the grid view, my totals for 2023-01 (Jan) in the grid are $-1,751,223.80. However the pivot table (grouped by date and bucketed by month) for 2023-01 shows $-10,121,244.13. Very different numbers.I have found that if I filter for less records, the numbers match between grid and pivot. I also found if I

Perhaps this is an introduction/need for pivot tables. I have a form collecting multiple submissions per brewery. I'm trying to create a menu that could draw from a table that shows the summary of those 4 submissions per brewery.If I create pivot table, which I'm not experienced with, it seems to count each column as an extension, so I would need to upgrade to accomplish this. (Which I don't want to do, if I'm not certain it's going to work.)I'm relatively familiar with Airtable, but not in advanced manipulation. I have it setup with breweries as the primary records, because they're using a form to submit multiple beers per entry. However, now I want the beers to be the identifying record, while still maintaining their brewery info (contact, distributor, etc.).Any help will be appreciated and you will be supporting craft beer in the process!Thanks in advance.Cheers.

Hello there community,I have an issue I'm not finding an answer to in this wonderfully useful forum. Perhaps I'm just not searching correctly.I'm using a system of entering Purchase Orders where we have an internal SKU and a supplier SKU. These are one to many. There can be many supplier SKUs for a singular internal SKU. I'm in construction, so for example, the internal SKU is a 16ft 2x4: DL-SPR-#2-2x4-16. An example of a supplier SKU is 20416S.When I'm receiving invoices, I'm entering the supplier SKU which allows my system to link to an existing internal SKU so that Airtable knows everything about that product (width, thickness, length, weight, etc, grade). However the other way around - if I want to generate a purchase order with the supplier's SKU on there (so they know exactly what I'm asking for, no confusion...) I'm having a hard time conceiving how I can look up the supplier SKU when the user might not necessarily know what that SKU is. So, the

Hi all, I think I’m getting crazy trying to use the Airtable. I tried it because I wanted some sort of simple database with some simple “app like” interface to submit hours and payment for the hours. I did not wanna overcomplicate and use database and start learning something like wordpress. Currently it does not seems I could avoid that. What am I looking for is to simply create a database with table for hours that can be submitted by the form where table 1 catching Start Date (date/time), End Date (date/time), Number of Hours (end date - start date), Price (Number of Hours * 250), table of payments that I will submit by the form from table 2 catching the Payment Date, Payment Amount. The problem that I’m not able to solve when using the documentation is how to get the Table 1 SUM of Price - Table 2 SUM of Payments. Honestly it is ridiculous that Airtable suppose to be to user friendly way how to create apps or even connect apps. Can somebody give me hand how t

Hi there -I have a base that we use to coordinate our deliveries and our pickups for our drivers. I have a view that is built for our dispatch team to "route" our delivery schedule for the next day that is filtered by all deliveries and pickups that need to made tomorrow.I have a separate view that is for our drivers to show all deliveries and pickups that need to be made Today, so that when they clock-in in the morning, they can see their route and begin going through their schedule. I need the Delivery view to adopt the routing order that was made in the routing view day-prior.How do I make that happen?

I'm super new to Airtable. How do you add a new table to a base? Sorry for the newbie question!

Hi, So I have a table called Daily Hits to which my Touchpoints are linked to - so a day might have 30 touch points as an example - I’ve created another table called Journeys… what i want to do is have a number of columns representing a customer journey - each column would be a step as an example… and I need to make sure that step is done or how many of htose steps are done. So for example my Touchpoints include ‘Booster Shots’ where I send a prospect some information - in the Journeys example if I have 50 rows of prospects I want to have a column for ‘Booster Sent’ and so I could quickly see how many of the prospects got a Booster sent - for that I was thinking I could create a lookup field for Touchpoints… like a Loopup… but have that Lookpu filtered by only those that have a Type of ‘Booster Shot’ don’t know if this makes sense but any input/help would be much appreciated. I should probably make a video one sec

Hi I have a question - Im a neewbie so excuse my ignorance. My primary field consists of 300 sporting fixtures throughout the year which take place at 26 different venues, so the venue is repeated throughout the year meaning the ‘value’ in the primary field is not unique.(one venue could have 20 fixtures) How do I deal with this as I’m worried this will cause a problem down the line.(from my research it states primary cells should be unique) I could merge the date and venue fields to the primary field creating a unique record for each cell? However, I suspect there is a better structure? I have attached a screenshot to illustrate my query. thanks