Base Design

I have Table A where a user inputs some information to make a record. This information gets concatenated to create a code (Input Code). This code I want to use to search in Table B for a matching code. Table B is my ‘Rules’ table. Next to each input code, is an output code. I want that Output code from Table B to be sent back to Table A which is then used to populate some further fields based on what text is contained in the code. So Table A is my main table. Table B is my ‘Rules’ table which is comprised of many ‘Input Codes’ and in the next field, an ‘Output Code’. I want to be able take my concatenated code from Table A (a.k.a. my Input Code - which is generated by concatenating info the user has just entered into a few fields in Table A) and search through Table B for a matching ‘Input Code’. This matching code has a correlating ‘Output Code’ next to them which I want to bring back into Table A. This output code is used to populate some further fields in Table A. I

Thanks in advance, attached DB schema and issue.

Is there a way to synchronize filters between tables? Table A: users Table B: books Table C: movies I want to print books and movies for a single user. I go to table B: filter them by user name. Then I print it. I go to table C: filter them by user name. Then I print it. I’d like to apply one filter (by user name) on both tables at once. Is there a way to do that?

Im made few tables and make “Link to Table” fields, how can i make disabled already choosen field?

Hello everybody, I created this multiple select fields, and as you can see in the picture after I put “102 &103” in the first record and move to the second record then the options “102 and 103” also show there. Now I know this is the basic design of Airtable but is there a way where if I put multiple options in a record I would not be able to or they wouldn’t be visible in any other record in the same column? Really appreciate your help and thank you for reading this

Hi, I’m new to Airtable, and I’m trying to make a field that registers the record number “1, 2, 3…”. I need it to be able to order items and map this order to a third-party app. Any idea how to do it? Thanks, Javier

I manage 3 e-newsletters for my non-profit. Ads come from the same group of advertisers. Newsletters monthly, quarterly and a set schedule. What is the best way to schedule all 3 publications in one base? For some reason I just can’t wrap my head around the layout. Lenette

I have two records that I am trying to combine into one record. Each record is uniquely linked to a number of other records. What I’d like to do is copy the data from one record and paste it into the other record, without replacing what’s already in the second record.

Hi all - We’re wanting to setup a new Button field in our Base that when clicked, takes the user to a Shared Airtable View URL that is pre-filtered for the row of data that was selected when our button was clicked. For example, in Table 1, we have a list of Projects. In Table 2, we have tasks or deliverables, linked to each project. We’d like a button in the Projects Table (table 1) to take the user to the Tasks Table (table 2) when clicked, and pre-filter the Tasks Table by the Project ID where the button was clicked. I was playing with a mixture of existing support articles from Airtable on buttons and shared URL filters but wasn’t having any success. Any assistance on this (or insight into if it’s even possible) wou

I’m creating an inventory management base and I want to have a count of product per location (shop, truck 1, truck 2, etc.) and I want to be able to move quantities from one location to another (3x product moved from shop to truck 2) without subtracting from the total product inventory. So for example, if I had 27 units of product A, 20 are in shop, 4 in truck 1, 2 in truck 2, 0 in truck 3, 1 in truck 4. I want to move 4 units to truck 3 from shop. When I add to truck 3, I want to be able to select the original location and subtract the number that I moved. I’m not sure if what I want can really be done or if my description makes any sense but I’d love any suggestions.

I have a table with an Employee Name and Manager fields. The Manager field is a self-referencing link to the same table using the Name field. e.g. | Name | Manager (linked) | |-------|---------| | John | Sally | | Sally | Peter | | Jane | Sally | | Peter | | What I would like to do is add a count of the direct reports of each manager. I’m aware I can see this if I group by manager but I need it as a field so I can aggregate and display the count using the org chart app. For example: | Name | Manager | Direct Reports | |-------|---------|----------------| | John | Sally | 0 | | Sally | Peter | 2 | | Jane | Sally | 0 | | Peter | | 1 | Is it possible to do this?

Hello! I have a long list of names in one of the views of my airtable base. I have indicated in my base who amongst my contacts is connected to each of those individuals. Currently, when I click the field to enter the names of of one or more of these people, it brings up the full contact list when I only want to filter by the column “ie. Prashant X” that lists that particular individual’s connections. Is there a formula for this?

Yikes. I mean, wow. Did anybody see this coming? Interfaces. First impressions after less than 30 minutes: Looks well done This is going to force me to reconsider everything ADDED NEXT MORNING: Here’s the official scoop — and a remarkably well-done video intro.

Hi everyone, I’d like to find out if it would be possible to add my interface to a webpage please? I’m using it as a time sheet for our volunteers, and basically just need it to stay open on a tablet so that it is easily accessible. Thanks

Hi I have an Airtable sheet where I write the payment dates of a detailed budget. Then, a calculate field shows the week number and year for that specific payment. What I want to achieve is a way to generate columns (maybe in a new table) with the week numbers in the columns and a SUM of all the payments of that week, so I can develop a cash flow view with the SUM of the payments each week. Any idea? Thanks for your help!

Imagine one-to-many relationship between Customers and Orders. It’s possible to configure the link between these tables from the side of Orders so that an order record cannot be linked to more than one customer record. If you create the record in an Orders view, this rule is enforced. What I just realized though is that this rule CANNOT be enforced from the Customers table, that is, from the Many side of the relationship. As far as I can see there is no way to prevent a user from linking a customer to an order record that was previously created and linked to a different customer. Of course this doesn’t make sense and is a violation of the cardinality of the relationship. It’s interesting that Airtable permits a kind of quick-and-dirty many-to-many relationship (without the creation of a join table) by allowing both sides of the relationship to link to many records. This is a convenience permitted by some other database systems

Hi There, I’m unable to scroll horizontally even though I have more columns than what fits my screen. Shift scroll also does nothing. It was fine yesterday and now it’s not available. Anyone able to help? I’m on Windows 10 Chrome Thanks, Sam

have recently signed up Airtable and have been watching videos on youtube trying to work out of what I am trying to do is possible but more important easy to do. I would like to create a database that consists of 120+ trainees. All of the trainees work through 4 classes, Junior, Senior 1, Senior 2 and Senior 3. Each class has a 20 week syllabus and trainees complete one syllabus before morning onto the next one. I need to be able to track progress through the weekly syllabus and also to be able to keep a record of trainees achievement. Would it be possible to do this with Airtable, and if so can you give me some idea of where to start.

Hi All, I’m currently looking into how to build an image database that will allow for searching on Client, Director, Date, and Keywords. I’ll be taking image folders from past jobs on Dropbox and linking them to the base in order to allow for quick searching for relevant images. I need help with the individual keywords, is there a way to have them in one column / field but have them independently searchable rather than just have the whole field light up when searched? Thanks in advance!

I tried searching but couldn’t find the answer. I’m looking for advice on how to track who has the next step in a project. For instance, I have many projects, linked to my tasks (one table for projects, one for tasks). I am looking for advice for ways to track who has the next step, when that step is due or promised. Right now, I have the following columns on my projects and on my tasks: Owner, Due Date, status(planned, active, waiting, done). But, I am running into the issue where I have a hard time seeing when something is due vs when it is promised to me. Is the answer to make a column for due date, another column for promised date, and then a column for who has next step, and who is owning the task? Thank you in advance for your suggestions

Hi! I want to create a sheet that will allow me to view my upcoming bills, assign money from each paycheck to cover it and be able to see what’s remaining that I need to fulfill. Kind of like helping me keep track of goals. I assume this will take creating a few different tabs within a base, but I’m a bit lost on what’s the best setup and how to link records. I am a freelancer, so I would have many different paychecks at any time (ie, not a regular biweekly paycheck). Thank you for your help!

Hello Airtable community. My base went totally haywire this morning, including fields that are not aligned appropriately and data that went missing. I can’t even track the changes anymore or see editing history. Did something happen today? Any recommendations on how to recover? I had a TON of data on this base and I’m panicking.

Hi Guys !! I have a cattle management database and I do WEIGHTING every month for around 1000 animals. I need to keep record of each animal monthly weight. I have that info thru a RFID Hardware, and can export that data to txt, csv or google sheets, but I want to SHOW that info within the animal profile. Today, I´m creating ONE LINKED RECORD for each monthly weight which makes me create thousands of records, hundreds for each animal, and does not make any sense … Any ideas hoy can I accomplish something similar without creating so many records ? Thanks Guys !!

Hi everyone! I’ve created a base with two tables: Projects Tasks There is a link between both tables so that tasks can be related to projects. What I’m trying to achieve is something like this: The goal is to visualize all projects to see what tasks are coming up next, and if there are no tasks allocated to a project, that should prompt me to think about what needs to be done. So I’d like to see: A list of all projects regardless of whether there are tasks linked or not The related tasks “nested” under each project Only the open tasks should be shown (anything with the “Complete” field checked should be filtered out) Does anyone have any suggestions on how best to achieve this? Here’s a link to the base:

Novice user here - I followed the videos and referenced some templates to build out a project management base with a linked tables for Projects and Tasks. We have several Projects that comprise the same set of tasks but are different projects (applied to different subjects). When I group tasks by project in a view of my Tasks table, I want to see them grouped by individual project. Currently, grouping tasks by project seems to treat every unique group of projects with the same set of tasks as “the project.” The intention of this view is to see all the tasks for each project as rows grouped by individual project. As it stands, I cannot even tell which projects are grouped together in the tasks view without widening the field to preposterous levels (see figs below) because the grouped-by field has a fixed height. Figures below show two groupings of tasks that differ by one project. I widened the field to be able to see all the project name