Base Design

I've got a table in one of my bases where I keep a list of what we charge customers for items.  We're a services company, so nothing is set in stone, but we use this table for a guideline (and the prices rarely change much, if ever).I haven't updated the design of this particular table in a while, so I'm reviewing it now and not 100% sure of the best approach.I have a second table where I actually keep every single item we ever put on an invoice.  44 in total.  And then we just reference the table with pricing, but mainly because it has more granular information.  For example, I might have a "Facility Fee" as an invoice item, but then I have multiple "Facility Fee" entries in the Price table for different durations.  I now realize it's a bit silly to split things out in the manner we've done...at least how we're during it currently.Invoice table (each "Item" is a possible invoice item).  Very simple, but more things link off of here in a separate process.&

Hello'I am trying to create a table 'Customer Interested Events' which maintains basic customer information (customer e-mail is PK) and additional fields  (selectable fields) 'Event Category' , 'Event Location'.Based on the customer interested events another table 'Event Manager' would be populated which is linked with above table 'Customer Interested Events'. Purpose of this table is to assign a suitable manager against each Event Category. The PK in this table is a computed field "Event Category+Location" and has additional fields like 'customer name', 'location','event category' (lookup fields from the linked table), 'event manager'.I am trying to maintain one unique record against each (event category, location) with all corresponding customer names, locations merged in the respective fields (if multiple customers booked for the same event category, location) so that one manager can be assigned.While merging customers against an (event category,location), I could see PK 

I have a BASE with an Events Table, a related Contacts Table (One to many), a Schools table related to the Contacts, and a Groups table. related to an event where a group can be associated with multiple Events. In the Groups Table, I have a lookup that finds all the Contacts from all Events related to the group and another lookup that finds the School related to the contacts that show up in the first lookup. Because the same people attend multiple Events related to the group, the result in both lookups have duplicate values. My goal is 2 field that only shows the unique values present in each lookup. (Unique Schools and Unique Students) related to a group. I looked at using UniqueArray but couldn’t get the desired result and am looking for any Step by Step help that you can provide.

Hello,Referring to this Volunteer Management template:Volunteer Management Template - Free to Use | AirtableHow can I combine all of the tables into one 'Master' type of table so that I can run queries across table fields?I understand that there are lookup fields.  But each Volunteer Event has multiple Volunteers.  Each Volunteer can have multiple skills.  So if I want to run a query where I want to find out the pool of skills that the pool of volunteers bring to Volunteer Events between Sept 2023 and Octo 2023.  How would I construct the Master table (or some other method) to run such a query?

First of all, I'd like to thank all in the community who helps in advance!I have chosen Base Design for this post's location, though formulae etc will also be appreciated.I'm running a SMMA and am still new to Airtable despite making good progress over the last week and need guidance setting up a base in Airtable to gather metrics via scraping. This base has three main tables, Post View, (Social Media) Account View, and a client View.In Post View, info about each individual post our clients make such as # of views, # of shares etc as well as the time and date of posting is collected. In the Account View, data pertaining to view, shares, data the view, share, like and comment count data for both (Today) and (Yesterday) are displayed. The third table is further aggregation to give a better top-down view.I have two main questions. In the second table and third tables how can I ensure that the data for 'Views Today' becomes the data in 'Views Yesterday'?Also, specifically for the

We have a "Last modified time" field that updates when either of two other fields are changed. We discovered a group of records all modified on the same date and time (05/11/2023 at 12:50 PM) but when we opened each record to see the revision history, there is no trace of how the records were touched. How could that happen?There are no automations that run on a schedule.There is an automation that runs when certain triggers are met. We looked at the run histories but none of them ran at that time.Any ideas?

I have been using Airtable for a little while and can get the basics of what I need.  However, I'm now getting much more complex with multiple bases linked together and I'm having a hard time figuring out the best way to link my tables together.   In a perfect world I will have a table called Customers which has the name of each customer as the primary field.     What are best practices for keeping this up to date?  If I add a new record (customer) to Customers table, how do I ensure that it will add that customer to all the linked tables?  Do I use a formula for the primary key in additional tables and then an automation that runs a script once a day to sync?  It seems like there has to be another way.  Any help is appreciated! 

While working in a Timeline view, is there a way to select a record and alt-click-shift drag to duplicate? Moving a record between swimlanes is a convenient action. Duplicating a record by clicking the three dots to the right of "expand" and choosing duplicate is convenient action. It would be really handy to just alt-click-shift-drag a record or records to duplicate it in the same swimlane or another swimlane.Certainly, I'm not the only user who might find this helpful.Thanks!

Hi folks, It's just a simple question that I wasn't able to find an answer inside Airtable documentation. Is there a maximum number of files allowed in an attachment field? Or is it tied to the max size limit of 5GB?Thanks

I have a table from Base A that I've synced to Base B. I no longer need this specific table in Base B, so I would like to delete it. If I delete the synced table in Base B, will it also be deleted in Base A?I checked different threads and couldn't find a definite answer and I definitely don't want to proceed until I know for sure.  Thank you!

I'm creating a workflow/process tracker using Airtable. I have the following tables:WorkflowsStepsWorkflow RunsStep RunsThe Workflows table contains a list of workflow names, e.g. "New client onboarding workflow".The Steps table contains all the steps within each workflow and I have a link back to the workflow table to know which step relates to which workflow.I have automations in place so that when someone wants to run the workflow it will add a record to the Workflow Runs table and then another automation that will pull all the steps from the Steps table and add them to the Step Runs table linked back to the relevent row in the Workflow Run table.This has allowed me to create an interface where anyone can see the progress of the Workflow Runs and Step Runs that they're assigned to.What I'm struggling with is how I can add unique sub-steps to each step similar to how it is done on the dedicated workflow software below (not Airtable):In their software, each step can have any number of

Hello, I need to create an "budget base", I've these tableincomeexpensesIn the expenses table I have different categories for each expense, but for some of these I would need also sub-categories like exemples:salariesPerson 1Person 2Person 3What would be the best structure to obtein this?I hope it's clear, thank you for your help!

Ok, I'm trying to build a product catalog and inventory management Airtable. I'm trying to work out the basic structure before I get too deep into adding all of my stuff.We have components, with a Part #, which are sometimes sold on their own as a SKU.We have Products, which are made up of multiple components, sometimes more than one quantity of each component in a product. These are sold as a SKUWe have Bundles, which are made up of multiple SKUs.I want to bring in data from another source which shows SKUs sold by SKU and quantity (some are bundles, some are components, some are products), and I want to be able to drill down to the number of each component sold from that same data.Any suggestions here?

I've been building interfaces that have "add record" buttons in them, and because of that I've realized that I've miscategorized some primary record fields for what a record is called when I first created a table. For a table that is based on personnel records I somehow selected "company" from the dropdown list when I first made the table and now in the interface for a personnel record I have a button that displays "Add Company". Ideally I could change the "What should each record be called?" option in each table, but I'm not seeing any way to do this once the table is created and the initial selection is made. Alternatively, I would love to be able change it to "Add Person" as one of the options in the interface designer, but doesn't appear that's an option either.Does anyone know a way to do this either in the interface designer or after a table has been created?

I would love to have Airtable help me to map out the prerequisites for an academic program but I'm having a little bit of trouble. Imagine a list of courses - some are required for the program, some are electives, etc... Many of these courses have prerequisites. For example, before you take course F, you have to have already taken course B.If it were that simple, I'd be able to use the flow chart extension to map everything. Unfortunately, it gets a little complicated when prerequisites include multiple courses and even "this OR that" cases. For example, "before you take course F, you must have taken both course A AND course B OR you must have taken course C". I tried to use different fields for each case with an "or". For example:Multiple Linked Field 1 includes "Course A" and "Course B" records.Multiple Linked Field 2 includes "Course C" record. This would indicate that you must take Course A AND B OR Course C. The problem I'm having is getting Airtable to map this out

It would be awesome if Airtable added 'This Year' and 'This Month' to the filters. This way, I could create a view of records, like expenses or invoices, that apply to this month or year. I'm actually surprised this is not already a feature. It seems like it would be a simple addition. 

Hi all! Here's what we're trying to do, and what we tried that isn't working:What we're trying to do: (example table: https://airtable.com/appKiBFGhHOgFeXf2/shrrTAISY39Rx8mL5)We run an exam, and have two tables:test_takers - each person who is taking an examexam_instances - each instance of an exam, 1:1 linked to test_takers.In other words, a single test taker could take an exam multiple times, generating multiple exam_instancesWe would like to store the status of the exam (e.g., not started, started, passed, failed) in two places:In exam_instances - each instance will have a single exam_statusIn test_takers - each test taker will roll up the "maximum" of those statuses. For example: if someone starts the exam twice and passes the second time, so one entry in exam_instances has the status 'started' and the other has the status 'passed', the entry in test_takers linked to each of those exam_instances should be only 'passed'.In other words, it doesn't matter how many times some

We would benefit greatly if a timeline view could be set to week (or preferably a user-selectable qty of days) but still show the records by hour. Today it seems to be only possible to show records by hour when in the single day view. When using any date setting other than Day, even if something is only 9-11am on a given day, it will simply show as an all-day event. This is not effective for scheduling events that are not all day, or, in our case, events that occur through the night.The calendar view does have a 3-day option that can be shown by hour, but it does not allow for grouping so the calendar view is not an appropriate solution for resource planning.

Hello!I would like to figure out how to share a database between two users for personal use. The paid plans that allow for Airtable Sync are a bit too expensive for me to be able to justify for just this use, so I would like to understand what my other options are.To expand on the use case, I would like to set up a career search workspace. In this workspace, two users that are applying to the same companies (and sometimes the same jobs) would be able to track applications, interview, and job offers for various jobs across different companies. I am envisioning a base that contains a "Companies" table and a "Jobs" table. Each job, when entered via a form, would be marked as being applicable to one or both of the users. These jobs would then sync to the applicable user(s)'s unique Application-tracking database. In my mind, splitting Companies/Jobs into one base and Applications/Interviews/Offers into another base (vs. all in one base) would prevent the need to create several user-specific

Hi there,I have a table 'users'. Each month, users must pay the breakfast. I need to check, resend the task, count and confirm that all users have payed before the first of the month.I was thinking to create a table 'breakfast' and... I am stuck &#x1f605How are the step to do that pleaseThank you in advance  

I am trying to build a functioning workout log for this new workout plan I am planning to start.  I want to be able to create it on interface designer and be able to update it on my phone as I am in the gym.The workout is divided into 12 weeks with 4 workouts a week, each workout day is divided into two sections.Here is an example: Each week there is a slight progression and every three weeks the plan updates with new exercises, but overall stays within the same model of 3 days of Strength work and specialization, and one day with special workouts.I would love to be able to easily add in the weight of each set I perform as I do each exercise and organize the base so I can simply track what workouts come next.The difficulty I am having is how to structure the tables properly and how to make them relate.  Also to be able to go to the gym and fully rely on AirTable to know what exercise I am to do, how many sets, how many reps in each set, the RPE, and be able to enter the

Hello the community,I work with airtable since acuple of year and it is great. But now, i can't level up my base because i don't have enaugh knowledge and programming skills. So i'm looking for someone that can upgrade my base with my actual needs. I need a pro service and i'am ready to pay for that. It can be in a remote loaction or whereever. But it should be in french (best) or at least in english.Thank's in advance, best regards.Thierry

Hi everyone,I have a start and end date field in one of my tables and I am trying to find a way to get airtable to tag each month within the range. Essentially I want to know how many were active between 8/30/2019 and 7/31/2020. I haven't been able to figure out the filters because if a record was 7/30/2019-9/1/2020, it wouldn't show up. My workaround is getting the months range and then I can use that multiple select field to do the filtering.Any suggestions?Thank you in advance

First time poster here and beginner in AirTable!I am trying to create a generic Employee table. This table would have all the generic info about an Employee (i.e. Name, Address, Phone, etc). I am then trying to create other tables that would contain specific type of info for the Employee type that they are. An example of this would be a Driver table. A Driver is an Employee but I want to have more specific data about them like Type (i.e. OTR, Regional, etc.), Truck Assigned To, etc. I created an Employee table and then a Driver table in the Driver table I linked back to the Employee table and brought in all the redundant data. I then added in the additional columns that I needed, that are specific to a Driver on the end of the table. The problem is I want to create a form that makes it very easy to someone to create a Driver without having to create an Employee and a Driver. I hope this makes sense! 

The attachment field, specifically for image generation, is populating at such a micro size. Typically, you can at least see a bit of a preview but on my most recent bases it's microscopic. Is there a way to enlarge (5x or more) the image preview within the Attachment field? Attached is a photo of the current view (Red Base) and a previous client's view (Green Base) where the preview was more appropriate.