Base Design

I am new to Airbase, having used spreadsheets for many years. I am trying to create a learner progress tracker, but have hit a brick wall and need some guidance please. I think I have structured the base incorrectly to be used efficiently. I am trying to set up a base that will have learners who are linked to a qualification which contains multiple units that contain multiple criteria that have to be passed twice for each criteria. I have so far created linked tables for learners, qualifications, units and criteria. These work fine for one learner. My issue is that when I add a second learner, I have to duplicate the a copy of the units and criteria tables and manually link it to the qualification table. As I have over a hundred learners this will get quite large. In a spreadsheet I can split cells to form sub headings, but I can not do this in Airtable. Any ideas would be greatly appreciated. Thank you in advance.

Greetings! I’m managing forecasts and actuals in a base with multiple tables. We built all the budget line items for each project in Table A. For example, forecasts for Q1 Project Sock has wage = $10k, prof services = $20k, and contract labor = $55k. Basically a table with each column as a PnL item. We have a separate table and view for finance partners to complete the actuals against these forecasts. However, to avoid having 50 columns and causing fatigue, we have Q1 Budget as a column. As such, the individual line items show the project total ie wage = $85k, prof services = $85k, contract labor = $85k. How can I connect or create a formula that pulls from Table A only the line item amount into the finance partner view line items? Thank you!

I am trying to keep track of a modest inventory of trailers. Sometimes they are here, and sometimes they are out… But I want to audit everyday… looking to easily find the trailer brand/serial number and check of several conditions (location, contents etc…) and print this information… is this possible in Airtable, and if so, how?

Been tinkering away with systems and methodology - this evening I got thinking (dangerous in itself) of how I could use Airtable to design/showcase product codes, and hopefully even allow users to develop their own products with this base. However, preventing me from pushing forward is a limitation of Airtable that’s stuck year on year - but interestingly it really hasn’t bothered me until now… where I realise it’s kind of in the way and a big deal… so I figured I would try my luck and ask for some opinions on these lovely forums. So for an example - Let’s say, we’re Willy Wonker’ing it all up in our bases :tophat: :lollipop: ; We can use this “Candy Code” table to name and design our candy products and associated codes - however, as the colour red can apply to both strawberries and apples, we have a slight dilemma with a need for adding multipl

Hi there, Fairly new to Airtable, and I’m wondering if it’s possible to add fields to the view you see when you access the pop-up related to a linked field. It looks like it only show three fields. Does Airtable allow you to add more. See screenshoot. Thanks, Sam

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