Base Design

We are a non-proft in the education/employment space. We need to link multiple bases and are getting a tad confused/ time poor and we need to make sure airtable saves us time and is effective for our funding reporting! We are looking for someone to help us with this to ensure we are using the system as effectively as we can. If you can help please leave some details below. Thanks!

Hi, I was wondering if there is any way to use Airtable automations to automatically join data from two different tables into a 3rd table. In my case I have a jobs table and a companies table. I’d like to have a 3rd table that is a “master” which joins the columns from both tables. The jobs table will have data that is constantly changing. The companies table will have data that will remain static. Ideally as a new job row record is created another separate new row record would be created in master that can join the new dynamic data added in jobs table with the static data already in companies table. Is this possible to do within Airtable or will I need to use third party approaches? In either case any advise would be appreciated. Of course a reference to existing entries in the community is welcomed as well. Thanks!

Hello, I am in a pickle and would like to know how to achieve the following Context: I am creating a table with contract details as both an internal database and also as a database that external contractors can use to check specific contract details based on the serial number of a hardware in the contract. Problem faced: I cannot figure out how to allow external contractors to search based on serial number without also allowing them full view of the entire database. I have tried using Interface for it but the vertical format it displays the results in, isn’t ideal as I require the results to be shown in a “table format” (horizontal) How can I achieve this? Thank you

Why and how do all of these extra fields get created?

I work for a non-profit animal sanctuary with 200+ residents and am trying to figure out if switching our database to Airtable would make sense. I’ve got a great start at setting up our base but can’t figure out two major details that could make or break Airtable as our database: Is there a way to track numerical values over time? It’s super helpful to be able to see past values like weights over time to recognize patterns throughout seasonal or age-related changes. I think I’ve seen some potential solutions but I’m not savvy at programming beyond the very basics and get lost pretty quick… Ideally each of the 200 records would have a way to track the historical weights of each individual and display it in the record. Is there a way to display multiple notes from different dates in a single record? This may be the same solution as the previous question? My current setup is to have a separate table that has a field to link each individual note to the corresponding record in the main

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?