Base Design

Hi AllI have a base with 3 tables: Routes, Passengers, and Absences. The Routes table has multiple passenger fields, which are linked record fields to the Passengers table. The Absences table has a passenger field, which is a linked record field to the Passengers table and has a lookup field to the associated route field - as well as a date of absence. When an absence is added to the Absence table, it pulls the route the passenger is on. If a passenger changes route, the linked record lookup field for the route in Absences will change for past absences. This means the data in Absences is no longer historically representative. What is the best way to preserve the original route that is pulled through onto records in the Absences table? Preferably I would avoid: a) having the route name in an extra text field or b) creating a linked record field directly to Routes rather than using a lookup field, but open to all solut

How do I have a formula based on 2 different multi-select fields, that will add a specified number to the resulting formula, based on how many options were selected for each multi-select field?Remember that each multi-select will be adding on different number.Here is my formula so far.   (IF( {Pull Factors Attract}, LEN({Pull Factors Attract}) - LEN( SUBSTITUTE( {Pull Factors Attract}, ",", "" ) ) ) + 0 ) * 2 + (IF( {Bonus Pull Factors}, LEN({Bonus Pull Factors}) - LEN( SUBSTITUTE( {Bonus Pull Factors}, ",", "" ) ) +0 ) + 2 ) * 1   You can see an example base here.&nbsp

HelloI'm testing airtable and I want to make a database with all my trial cases. These are cases that we must check  with some regularity, the idea is that each case generates a record and that once the record is created, it will be assigned to a role of periodic reviews, meaning, each case must be check by my staff every 3 months to update de info of each case an check the task or actions that we need to take with every case.  So  My desire is to create some kind of automation to generate monthly an e- mail to me an my assistant to check those cases that reach the 3 month period and need to be checked for updates.  Also, I already have a lot of existing cases, and my goal is to divide those cases in groups to not overwhelm my assistant with all the cases needing a review at the same time, but I don’t know how to do that.  Hope someone can help me, and sorry if my English is not good, is not my native language

Hi.I have a large table with Approx 110 Fields, 90 Views, 6,500 records and a number of automations etc. The table was created using the Emailed Data Sync as its Source. I need to duplicate this table, delete the records and then start using a fresh set of records. I receive the below error when I go to duplicate, I can only assume due to the size of the Table. It says to contact Airtable if the error continues to occur, which it does. I contacted Airtable, only to get the automated 'Please look at the Help sections' or use the chat function, neither of which have worked for me.I have cleared my Cache as suggested by Airtable, but this doesn't resolve the issue. I can see that I can't toggle off the option to Dulipcate the Records when I go to dup. the table - this isn't an issue from myside, but maybe the number of records is causing it to fail?! Just wondering if anybody has any work around for being able to duplicate an Emailed Data Source

Looking for a way to use Conditions to view something like this: Where Lookup Field  matches Linked Field I want to show all the date/times from a lookup field that corolate with the same employee who completed a form. Hopefully, the screenshot below helps explain it better?  

I'm having trouble creating a Form that I can use for Performance Ratings, and having that Form's fields update the Record field for the table. I believe I might have this architected in not the best way. Let me explain below.I have a Table that list Vendor Records. Each Record tracks, names, locations, services, cost, etc.Additionally, these Vendor Records also track 4 Performance Rating Fields.In the Table Table, I created a Form, with the intention that I could provide this form to managers quarterly, and Have them fill in the 4 Ratings fields for the Vendors they manage. The full intent is that I would automate a quarterly email to send to the manager, for each Vendor they manage.When I test the form, I feel like I have set something up incorrectly, because there is no way for me to select a specific Vendor record, or even Default that for the Manager.When I fill in the rati

HelloMy brain is stuck on an operation that doesn't seem so complicated... butI have an "Event" table   and a "Days" table   Is it possible, or how can I achieve this result ("expected" page)?   I have a project in which events are created over time. When I create these events, I don't yet know the day(s) on which they will take place and their quantity (number of days).Would it be possible that when I add 1 day (or more) to a project, it creates a new record on another page ("expected" page)?

Hello,I'm reaching out for ideas for doing an Accounting Forms (like a Check Request form) through Airtable. I love using forms to reduce data entry, however, I haven't been able to find a form that I can use to complete something as "complex" 😂 as a check request, specifically with multiple itemized lines presented in a Grid Format. Among other things, this Check Request Form would need Account Code, Description, and Dollar Amount *for multiple lines*. For example:Check #234 paying a contractor for services, expense reimbursement, and materials.Line 1: Fee for Services: Account: 100 - Description: Services - Amount: $1,000Line 2: Expense Reimbursement: Account: 200 -

Hi everyone! Well I’ve been using AirTable to help me organize my inventory and sales orders. But now I’m trying to build a template to help me organize my construction project. In general I’m trying to set up a tab in my table that tells me how much money I have available, so that it takes all of the money we’ve received from the client in different instances and subtracts all of the money given to different contracts and shows us how much is available. Is this possible? Thank you everyone beforehand!

When using linked records, is it possible to apply a value to only the first linked record in a cell?So if I have two tables.Table ATable BWith Table A, I'd like to find a way for the Revenue to only be a logged against the first linked record in the Products column. Is there a way to do this?(I can't do it the other way around - so applying the rollup to the first linked record only in the Sales column on table B, since I do need to be able to sum multiple Sales in this column). Effectively, I need to be able to roll up revenue from sales against each product, but in cases where multiple products are placed against a sale in Table A, I only want the revenue to be assigned to the first product in the list. Hope tha

Previously, the table was shared and synced, but troubleshooting was done after disabling it.  Once I delete records, it re-generates deleted records back within a few minutes (less than 2 minutes), just like the undoing delete operation. Any ideas about possible scenarios? No automation is relevant to the table.

Hello there! I work with an organization that produces a 50-concert summer festival. We have about 120 Season Pass Holders, about half of whom show up to any given concert. We would like to check them in at each concert and track their overall attendance.Each person receives a physical Season Pass (a 3x5 laminate) that they bring to the concert, so my hope was to include a unique QR code on each pass that corresponds to a unique ID for each pass holder. Then our Front of House staff could scan that QR code via the Airtable app on their phone, and it would create a record of them having checked in for that concert.One thought is that each concert could be its own view, and then any check-ins within that view could be clearly reconciled. Maybe that check-in could just be a timestamp, or it could be that when the staff scans their QR, it gives them an option to toggle a "check-in" switch.Open to any all suggestions, and grateful for your help!

HelloI'm trying to do something like this:Attributes TableNameMin ValueMax ValueHealth-99999999Energy0164000000Potions TableNameDescriptionAttribute ModifiersFooBarHealing Potionheal_pot_

upgrading to Airtable's Enterprise plan would remove the base row limits and allow more automations, but as of my knowledge , it is very expensive around 10k$?We have a large dataset that exceeds the 100,000 row limit per Airtable base. We also need more than the 25 automations allowed in the base. Upgrading to Enterprise is not feasible due to high cost.  We're looking for more affordable solutions to handle our large dataset size and automation needs within Airtable's business solutions. Has anyone found creative ways to structure large datasets across multiple linked bases or integrate affordable supplementary tools to overcome Airtable limits?We'd love to hear any cost-effective ideas or solutions that don't involve upgrading to the expensive Enterprise tier.Even partial solutions could give us ideas to explore further. We greatly appreciate any insights the community can offer!

I’m creating a database of training staff have completed. I want to be able to cross reference between a table of staff and a table of training so I can:pull up a staff member’s records to see what training they’ve carried outsee the different training that has been carried out and expiry dates of thoseSo I can store the data, I’ve currently got it set as one table that does everything but when I add new training for a member of staff, I need to copy their data (team etc) for that new training. Or when I create a new training for lots of people, I’m having to copy the course details for everyone (course name, date etc).Complications are that there will be courses that staff will complete on different days but it would be good to view them in the training table all together.I can’t visualise how the two will work together or how to set it up. Can anyone make any suggestions or send a snapshot of something similar you’ve created? I have

Hey everyone,I am building a sort of meeting room booking system.So the meeting room will have a fixed availability between 9am to 6pmHowever, the bookings can have 5 variants:15min30min45min60min90minHow can I allow people to book meetings based on the time they want, but block out the availability despite the duration differences? I'm happy to compromise and limit it to 2 options if necessary.

Hi all,I am trying to create a grid view in which I keep track of projects (the latter come into through Airtable forms).Each project goes through 6 stages with specific tasks associated to them (the tasks are always the same for each project). I would like to have a list that shows the tasks that have been completed for each project against the ones that are missing and, on the basis of this, I'd like to be able to track the progress (through a progress bar/formula?).Is is possible? If so, how could I set this up?

I am trying to create a base that tracks documentation-compliance.  Essentially, I have employees that have one or  more licenses, where each license requires the presence of a variety of documents to be in compliance.I created four tables:Employees - obviousDocuments - a list of each employee's documentsLicense Types - a list of licenses that an employee can holdDocument Types - a list of documents types, to be assigned to a document and required by a licenseMy current structure:EmployeesDocumentsLicense Types

Hey everyone, I’m looking for an option to quickly add another record within a multi select field at mass without having to do it manually for each one. Eg. Taking geographies as an example. I have a bunch of fields that have Europe and I want to be able to easily add ‘France’ without having to go into the cell manually, in fear that France will just override Europe and there will only be one value. Would appreciate any help! Thanks

Hi all,I am stumped but I feel like the answer is staring me in the face!  Hoping yall can help!I have a membership tracking base set up as follows:TablesPeopleEventsAttendancePeople and events are stand-alone tables.  The Attendance table basically links them with a field for People and a field for the Event.What I need is a total number of events (within a date range) to be used in calculating a minimum attendance requirement per person.Anyone have an idea how to accomplish this?  TIA!EDIT:  I know how to calculate how many events each person has attended.  What I need is the total number of events so I can do a formula something like {# Attended} / {Total Events} = % of Events Attended.  Thanks!

That's a bizarrely framed title, but I'm unsure how to surmise..Here's what I'm trying to do:I run a garden. We have 3 different nutrition programs, that use a different mix of ingredients, and share some ingredients. The amount to make depends on how many m2 are to be treated (or how many L of water are used to drench seedlings).These programs are:Foliar 1 (mixed for m2)Foliar 2 (mixed for m2)Transplant Drench (mixed to vol of water used for seedling drench).I need to keep records for our organics certification on what inputs are used, and when and where they are used.So I want the user to be able to select "Foliar 1," input how many m2 of garden they are treating (or how many L of water they are using to drench seedlings). I then want Airtable to "generate" the quantities of each input they need, without needing to do any potentially confusing math. It ca

Hello, I'm trying to create a view that is tasks stacked by owner in Airtable as a kanban but it keeps creating cards with deactivated users in them but there's no way to delete or hide those users. I think this will be irritating for my team because it's more people to sift through. Any ideas?Thanks,Emilia 

I'm building a Project tracker with the following tables:Projects / Tasks  / Sub TasksI'd like to add a list view on the Projects table which would show the Projects > Tasks  > Sub Tasks in that order. But it looks like I have to put the List view on the Sub Tasks table? I'm not sure my users will get that.Am I doing something wrong when setting up the List View? If I try to make a List View in the Projects table Airtable tries to put the Projects at the bottom and work up to Sub Tasks.

I manage a large media plan with multiple users. As due dates approach in the following increments, 60, 30, and 15 days, I want to trigger an email that will inform that user if they have not provided the necessary information to deploy the ads. I have set the first trigger up at 60 days however it is sending per record, not per user. Is there a way to consolidate all the records into one email?Thank you in advance!

Hello,I would like to share a base with collaborators in read only or comment only, but I would like them to be able to edite view, specially the filtering field to be able to search throu records more efficiently.So far i'm only able to share in editor mode for them to have acces to the filtering button, but then they can chage the data 😞