Base Design

Hi! I'm doing some work for a nonprofit with a limited budget to set Airtable to help manage their annual event.The event pulls in a variety of pieces of information about each of the following (and this is how I have drafted the workspace):SponsorsSponsorsSponsorship levelsContact logBoard membersTeams participatingTeamsSchool/Company/Org team belongs toContact logYearly baseVolunteers who have signed upVolunteer needsBudget (TBD on tables)Some of this should be carried over YTY so the bases could be re-used with new, yearly tables, and some is unique to the calendar year. I originally planned to have a base for each of these, and sync where needed. However, until they get a paid plan, syncs would have to be manual, which doesn't seem ideal. I'm wondering if it would be better to use a manual sync or combine bases somehow? 

HiI'm moving my automations from Zapier to Make and I'm struggling to get the airtable automations to work in the same way.Previously, when pulling the automation from Teamwork, the websites field showed a record ID, which then haulted the other linked fields.  I then created the Websites copy column to turn the Record ID into text.  Make does this differently and pulls the tag in as text, so I need to find a way to do the reverse, ie using the text in the Websites Copy column to find the matching record ID on another table, thus allowing the other lookup fields to function.I'm not sure if any of that makes sense, but any help for this rookie is much appreciated.TIA  

I have a database of my softball league and have the table grouped by team, but the count for each team is cutting off the team name, which I'd much rather see. Is there a way to stop the count from displaying? The only way I can see to do it is making the number column very wide, which makes the table look terrible. Is there a way to easily see the full group name?

Greetings Airtable Community,I am looking for someone to hire for Airtable help. The team I am a part of currently has a very base-level database setup but we are in need of some help when it comes to fine-tuning and streamlining capabilities through automation, sheets that correspond properly, quick and easy info/photo upload, etc.This is all property information on the database so someone who has past experience working with Real Estate Databases would be awesome!Please reach out to max@hornigpartners.com if you can help, thanks 

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 / IIVI. GigueSo for example, when I'm using my Program Builder, I can select Cello Suite No. 3 in C Major, BWV 10

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 work on linked record field

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 1Invoice 1 - Item 2Invoice 2 - Item 3Invoice 3 - Item 1Invoice 3 - Item 5Invoice

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 link back to the accepted name.Example: Mariosousa willardiana is now Mariosousa heterophylla. How do I replace the new name with the old name but still keep a record of the old name as a synonym and remove it from the cu

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 as the AT grid view. It is only

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 to the Stiffness test, it will add a record

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 change the pivot table to us

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 user might want to, for example,

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 to do those without pulli