Base Design

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 - Description: Lodging - Amount: $350Line 3: Materials: Account: 300 - Description: Widgets - Amount: $500I could do 1 form per line, and compile the invoice from multiple forms, but that is not very helpful.I know exactly what is needed in a sense, but I don't know how to build it so that I can elimi

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 that makes sense. Thanks.   

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_descr(Health 50)......Curse Potioncurse_pot_descr(Health -25), (Energy -25)......So is that possible? I.e. referencing the attribute value in the Attributes Table from the Potions Table with an additional value of some type (in this example an integer)?The use case there is pretty simple and straightforward. I was also wondering if that's not possible if we could join then two columns into one? Something like:NameAttributeModifierAttribute ModifierHealing PotionHealth50(Health 50)Curse PotionHealth, Energy-25,-25(Health -25), (Energy -25)This at least allows us to preview the values in the table

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 a feeling it may be something to do with Lookup but

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 TypesDocument TypesWhat I need is a way to display (and ffilter) all employees and their documents, including a placeholder for missing documents.  In this example, Jane is missing documents for both here B and C licenses.Is this possible?

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 can store that as a record against the date, so I can archive that. I currently have an "inputs" table, which has the

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 😞

Hi all! I have a base in which we create and track educational programs that we put together. I have a date and time field that shows when the program starts, and a date field that shows when the program ends. Some of our programs are mutli session or span throughout a long period of weeks. For example, a program may have 3 sessions on non-consecutive days, let's say 9/22, 9/25 and 9/27 (9/27 being the end date) and each runs from 9am-2pm. Sometimes the times are different for each of the sessions too.I want to show that each one of those sessions are from 9am-2pm but the start date field will only show 9am. I can't use the end date field to show that it ends at 2pm if the time is different for each session. Is there a way to easily show a range of time? (i.e 9/22 from 9am-2pm)

Is it possible to limit the number of records syncing from one table to another?For example "Table A" has 15000 records and I want records 1-100 to populate "Table B", 100-200 in "Table C" etc.

trying to create a standard column names to be in multiple tables acroess a data base- the data below differes so I don't want to link the WHOLE column - just the top field names- anyone know how to do this? 

Hello!I run a grant application processing Airtable base that needs to seamlessly take titles of records, notably the name of the organization, and link it to other facets of my database. However, when some records to linked to other tables, it contains quotation marks around the linked record. My system does not change the record name by any means such that it is crucial that the names stay the same since my automations require to search records in other tables to grab information. Help would be appreciated! Here is a picture of what is happening to a linked record. I suspect that the ",Inc." might freak out Airtable to quote the text. 

Hello,I cannot figure out why I have a field which has multiple records linked to it even though I have not selected 'Allow linking to multiple records'.My tables are 'Materials' and 'Inventory by Location'. The top photo is 'Inventory by Location' table showing the linked field to the Materials. Preferably, if materials are linked to a storage location a new record would be created instead of linking multiple materials to one inventory record because I have not selected 'Allow linking to multiple records', or if I need to make an automation for that to happen then airtable would block linking of multiple records instead of what has happened in the photo. Also, I would like to know why, in the bottom photo, there are repeated links to the same storage locations. Thanks for any advice/clarification!  

I'm working on a project wherein I'm trying to display the diversity characteristics of several universities (50+). I have an existing base with a list of all the universities I'm studying with various facets as fields across (location, size, focus, student life comments, admission criteria etc), but I also wanted to include information on the demographic makeup of each school. Ex: X University is 25% White, 15% Black, 10% Latino, and so on. What's the most efficient way to go about this so that this is also able to be displayed as pie chart via the Charts extension? I started by making an additional base, but as a beginner user I stumbled trying to find a usable format that allowed for readability and reporting. 

I have a list of schools and I'm trying to track demographics I have about the schools:raceincome levelsgendersI have reports with the aggregate data, not the individual student records. Therefore I'm not able to do rollups but tracking each demographic for an individual students in a linked table.What would be the best way to store the aggregate values, so that I can generate charts per school or across all schools? These categories have different amounts of choices too.