Base Design

I have a table (let’s call it table1) that has a primary column called table1_id I then have another table (let’s call it table2) that has a column which is a link to that table1_id value. I then have another table (let’s call it table3) that has a column which is a link to that table1_id value. How do I create a column in table1 that looks-up a value from table2 based on the row that table1_id is linked in. I feel like I need to do a lookup, but I can only do that on linked Values.

I have an archive of text messages that contains a date field, direction, to_phone, from_phone and message content. Here’s how it looks in Airtable base: What I’d like to do is have Airtable display this in such a way where I would have it grouped by the phone number of the person on the other end. Now, in this table, for an external direction, the phone number is always the same 15_____55 in the 3rd column and for an internal direction, the phone number is always the same 15_____55 in the 4th column. I’d like to be able to click on the phone number of the person on the other end and then see all the back and forth conversations, sorted by the date (and ideally highlighted differently based on internal or external for easy readability). I have 0 experience with Airtable other than just storing data, so I’m not sure where to start. Cheers.

Hi, I am trying to build a formula to properly calculate the cost for an order whose input is a multi-select field of products. I did my best to follow these recommendations: https://support.airtable.com/hc/en-us/articles/218734758-Airtable-s-guide-to-many-to-many-relationships Calculate Multiple Select Values - #3 by Will_Bailey1 The tables are Products, Orders, and Line Items. The Products Table (includes lookup to the Line Items Table). The Orders Table (includes lookup to a Companies Table (not pictured)) The Line Items Table (includes lookup to the Products Table) I don’t know how to create the field for Total Cost in the Line Items Table to be able to calculate total cost dependent upon which products are linked. On the front end a user would select which products they wish to include in their order. Any pointers or reference to existing community content would be appreciated. Thanks!

Hi! When searching, I can only find examples (videos in particular) of how to create links between different tables. But never about the interest (or the best use) of such a practice. For example, someone was showing a database for an apartment search. There was a table “Apartments”, and a table “Districts”. And the District table was linked with the Apartments table. But why not just create a “District” field in the “Apartments” table? Then all the necessary information would be in one place! I guess this is a basic and naive question, but I don’t understand. I’m starting to create some databases for myself and I’d like to know if I should separate the data between different tables or not! + I noticed that you can’t do everything on the very first column (= hide or delete), so should I leave it empty (or just with numbers for example)? Thanks in advance for the tips!

Hi everyone, I started to use AT last week to build a book database (hard cover cartoons), it is a simple database with one table and fields related to one book : ISBN (codebar number), title (single line), picture (attachment), Serie (single select) and volume (number). So I can have different books that belong to the same Serie with of course each with a different volume number. I am trying to have a field that give me all the volume numbers related to a Serie to find out if I am missing one in the Serie. Any idea on how I should proceed ?

Can you please tell me what “Mini Extensions” are and where I can find them? I understand that I can use one of these items to add a “signature” to an attachment field in Airtable.

Hi there, Lets say hypothetically that I have 40 separate Linked Record Fields (Field 1, 2, 3 etc) that make the same connection between Table A and Table B. For each row only one of these fields will be updated. I want to therefore create a master field that summarises this data. I know this approach isn’t ideal but I am forced into this position since I need to collect data from clients via a form and I am using a category sub-category set of conditional questions to only display relevant records to a client based on their response to their earlier question. My questions are: Is this approach of multiple linked records the right one? Are there any tools out there that would simplify implementing dynamic dropdowns / category sub-category systems for forms? I had planned to use Automations to update the Master Field - is there a way I could create one Automation to check whether content exists in 40+ fields, and if so, copy that content into this Master Field? I understand that

I know we can upload links to URLs but is there a way to store/play the actual video clips in Airtable? Thank you!

Hi, I’m quite new to Airtable, and used to use Excel. For my company, I would like to create a Sales/revenue dashboard, to visualize when our revenue will be realised. I created a table where I distribute the total project value over the coming months, based on a start date and an end date. I have a column with the total project amount (e.g. 100.000€), and then 12 columns, one for each month. I figured out a way to distribute the 100.000€ over the different columns, using formulas: so far so good. Now, I would like to have a report with a bar-chart or a line-chart, showing the total revenue expected through the months January-December (in excel, rather easy). I really don’t know how to obtain this, and now I’m thinking this might have something to do with the setup op my table/base. Would be fantastic if anyone could help. Steven

I was wondering who could help me determine if AT can be a very good solution for our needs: I’d like to populate a table with potential people to contact, sourced by external searches: so manual import or copy or API actions, to be determined. The goal is then for a person to check those records, and either mark them as OK, or discard them as not valuable. I was thinking a dropdown menu, or checkbox, which would trigger an action. If said to be relevant, contacts would go to another table. Can I then move a qualified prospect to another table, or bd, and hence not keep the original record ? Is it better to create a table in a separate database, or can I hide 1 table from a database to some people so the view does not get cluttered ? If we adopt Airtable, I’ll transfer there some specific functions we currently solve with custom (Python) scripts polling our Trello board. I could not find whether I can do the following : For every record (currently record) that has not had an intera

I’ve seen a few answers to this in terms of looking up the most recent row, but how do I get a field that will link to the most recently created column? I am setting up an Airtable to manage the 31 preschools that our organisation feeds. On one table we will keep track of the number of children attending monthly (so we know how much food to order). So far it looks like this: How do I get a field in the master table that can update the current number of children at the creche by pulling in the most recents months’ data? Does that make sense as a question? You are all always so awesome , so thanks in advance!

Subject almost says it all. I would like to link selected text in a record to another record. Is that possible?

Good afternoon everyone, I have a completely stupid question and the answer to it should be simple, but I can not find it for too long. How to put a list with several levels of subordination in a cell (bullet list)

I am trying to convert grid of information with different prices for different writers into a workable Airtable solution that I can use every week for payment to them. Here is an example of the grid in the Excel file we’re currently using: So, say that Writer A writes a feature and Writer B writes two CD reviews. I need to be able to select the writers and the type of story and have the price come in automatically. Let me know if there are more questions that need to be answered, Thanks! ADDENDUM: OK, so the above grid exists in its own table. Then I have another table that I use to tally every week’s stories and payments. How should this first table be set up so the second table can reference the writer and the type of story to then receive the correct price?

I want to design a Post Production Schedule base that allows me to track multiple team members through multiple projects: 13 Editors working on 30+ different projects. Each project has the same milestones but at different times, and I want to be able to see all projects in one calendar, as well as each project in one calendar and each team member in one calendar. Do I set up a Table for each Project, with a template of “EVENTS” for the repeating milestones, then other Tables for each Team Member with linked fields to populate their particular scheduled milestones? Any advice on a base design approach would be most appreciated. Total Newbie to Airtable but familiar with relational databases. Many thanks!

Hi, I work for a community development corporation, and am developing a database to store information on businesses, individual properties, and residents/ partners/ misc. individuals. I have organized my base into three tables with the primary fields: Addresses, Business Name, and Contact name. The idea is that sometimes we want information on a property (state of repair, vacancy, etc), sometimes we need info about a business (sector, ownership demographic, etc), and other times we need info on specific people (if they are residents, touchpoints, contact info, etc.). We also want to know how these different sections interplay. For example, if I am looking up a property, I would also like to see what business is in it and who is the business owner and who is the property owner (if we have already collected that information). Now, for my problem: I want to make it easy for people to add info to this base without having to update each table every time. For example, if I talked to a Jane

I have a table that gets a lot of log data – about 8,000 records per month. Since a table can only hold 50,000 records and a base can only hold 100,000 records, I’d like to move the table to another base (on a given date or after a specified amount of time or when it reaches near capacity). Is there a way to do this programmatically? Also, is there a way to create a base or table programmatically?

Does anyone know a workaround to display nicely a lookup field??

I have a basic question but couldn’t get an idea even after watching many videos and reading articles as I am trying to compare them with Firestore. Please explain if possible with some example. Are the Bases in Airtable similar to Collections in Firestore? Are the Tables in Airtable similar to Documents in Firestore? And, are the Columns in the Tables similar to keys and rows/records similar to Objects ? I see that the records per base for the Pro plan shows as 50,000 Maximum number of users however shows as Unlimited. Lets say i am using Pro plan and have an users collection APP is publicly available for users in playstore/Appstore and the number of users installed and registered crosess above 50,000, will the later users be registered in a new base/table since the record limit (50,000) already reached under pro plan? If it works in a different way, please explain. And, if its a Chat App and users can delete or update only their own messages, Will that be taken care by Authenticated

I’m using the app on Android, and have a file (pdf) on my device I want to use on my task, but the only local files the app lets me attach are images. Why?

I’m trying to organize a summer arts camp. I have 4 tables: Guardians(parents), Campers(their kids), Weeks(the weeks we are operating), and Invoices. I’d like to set it up so that: The Weeks table contains the week and the cost of that week (different weeks can cost different amounts). I have done this already. In the Campers table, I can assign the Weeks that each Camper has signed up to the camper (we are able to assign more than 1 week to a camper if they sign up for more than one week). I have done this already. In the Guardians table, we can assign Campers (more than one if they have several kids attending) to each Guardian. I have done this already. Here is where I am having trouble: In the Invoices table, I’d like to assign a Guardian to each Invoice. I’d like to be able to look up the Campers assigned to each Guardian and the Weeks assigned to each Camper assigned to each Guardian so that I can get the total cost that each Guardian needs to pay for all of their kids.

Hi, A client of mine is using Airtable form on Squarespace. How can I add custom CSS to the form? I found this Better Whitespace Use with Custom CSS but I don’t understand where to add the CSS. Thank you

I have a table of employee records with one field being a link to the manager record. Id like to count the number of employees that a manager manages. How do I do that?

The overall goal is to show what trainings a person has not taken yet. I have a table that lists all training modules, a table listing roles that is linked to the trainings table to indicate which trainings are required for each role, a table for people that is linked to roles, and table for completed trainings linked to person and training. I need to show, for each person, trainings that are required for their role(s), but that have NOT been completed. How can this be accomplished?

Not sure if this is possible, but I have a number of things I’d like to track a daily basis (workouts, journal entries, meeting notes, etc.). Each of these tracked items use numerous unique fields that don’t overlap, so combining everything in one table would result in a huge list of fields—too cluttered. I would prefer to keep each tracked category in its own table. However, it would be nice to have a separate “overview” table that shows all of the records from these various categories. For example, the “workouts” table contains daily records with fields for reps, weight, etc. The “meeting notes” table contains daily records with fields for client, topic, etc. The “overview” table aggregates and links to all of the records from “workouts” and “meeting notes”. That way, I could reference all of the records combined in a central location but they are stored in their respective tables. I could have a table that contains records for each date and link to those, but then the overview would