Base Design

Hello! Very new here, so bare with me.I have a table of employees. One of the fields in the table is which states the employee is licensed in.I then have tables for each state. In those tables, I would like the names of employees licensed in that state. I will then use tables to keep track of state-specific details, like license number in that state. I'm wondering how I can make it so that if I add an employee record, and then add a state to the state field, that employee also gets added to that state's table.Thanks so much!

Hi there, I've done a bunch of research here and on Youtube and I've not been able to replicate what I see here. I have Project and Tasks tables. I've created a template in the Projects table that adds a few tasks And it works - I get the tasks created, when I apply the template to a new project. However, I'd like to add the Project Name to the tasks that are created. I found an example of this in Airtable's docshttps://support.airtable.com/docs/using-record-templates-in-airtableThe Tasks in the far right column shows the Project name in parenthesis.But I cannot replicate this - how do I make this happen?Desired ResultProject = Project ATasks = Task 1 - Project A, Task 2 - Project AThanks so much for your help

I have several bases that I have removed nearly all the data and they still show as reaching plan limits or over limits. Even when I duplicated them and remove ALL THE DATA from the base it shows as over limits.This is making my DB's unusable and I can not upgrade not knowing how or why an empty data base can be showing as hitting limits.Or when I remove 90% of the data in a base that we have been using for two years that barely had 300 rows is constantly hitting limits and not being able to determine which limits we are hitting so we can manage the data and ensure we are being efficient. 

I own and operate a cleaning business. I have created a base that lists all the locations and the scheduled dates and times. I also created fields that show the day of the week by both number 0-6 or the actual name Monday, Tues, etc. I recreated the Employee scheduling base within my base so I could easily relate bookings with cleaners. So the employee table shows what days of the week the cleaner is available. I created a field on the booking table to be able to select cleaners to assign to the job and I included a lookup field to be able to compare the available days to the service day. So far the availability is only by day not by specific time ranges but if I need to expand it for days and times I can look into that.I can do basic automations and basic formulas so I am sure that this can be done but it is out of my skill level. Is there a way for me to be able to have the program give me a list of cleaners that are available that day of the week and not scheduled on another booking

Hello, I make my aplication on Grist but when I use it more it makes me more trouble. I wonder if I can make that tables in Airtable.I want to have tables with contacts, products, transport companies.Then I want to have sections with years - when I click for year I see table with months and every mont have table with transport my goods. (that table with goods will also have widget (document) I can print and use as delivery document for driver.Then I want to have summary table that will show me costs for transport on every month.Regards.

Hi all,I have a form where people put in their availability for a series of events. Their options pull from a table with all available event slots. I would like, on a that "all available slots" table, for all available people's names to show up automatically, so I can see everyone who is available for that particular day/time without having to manually fill in my options myself. Is there a way to do that? Thanks in advance!

Hi,I am quite new to Airtable but have played around and created my first working bases for a local youth sports club I am supporting probono but are now struggeling with this project.I am am trying to build a base that would allow me to rate a subject (organized in subject groups) based on several Main and underlying Sub criterias.So each subject group will have at least 2-4 "MainSkill"  and each "MainSkill" will have underlying multiple "SubSkills" assigned to the overlying "MainSkill"Each subject out of this group can then be rated on all his MainSkills and all Subskills.I am struggeling with the way how to get that organized correctly and have not found any template to copy from.  The rating of each of those skills for a subject should be changeable via a form.

Hi everyone, I am a beginner and I'm quite overwhelmed with how everything works!&#x1f605  The templates I am finding don't seem to help with what I need. I'm wondering if anyone knows how to build a simple airtable base where each staff member on the team can have their own private view to track their overtime hours and where the owner/manager can view them all? We don't actually pay for overtime, instead, we offer time in lieu, so a column that calculated their hours based on whether they worked the overtime on a regular day or statutory holiday is a formula I think I'd like to have in the base. Does anyone have any advice? 🙏

Hi folks, appreciate any help you are able to give here....  I have a base where the users enter pricing information from suppliers.  Sometimes the pricing is given to the users including tax and sometimes excluding tax.  At present all data is entered excluding tax forcing a manual calculation which is clunky.  I would like to have an either/or useability whereby the price ex tax cell is locked for input if the price inc tax cell is entered and vice versa... is this possible?Thank you 🙏 

You guys have been so helpful in the past, I'm hoping you can help jog my brain once again!Scenario:  Organization that wants to track membership recruitment efforts with something like a CRM funnel.  They will need multiple funnel / pipeline scenarios, each with its own set of steps.  Each step will need it's own metrics for tracking results.  For instance, if one step in the funnel is inviting new contacts to join a facebook group, the metric they would track is whether the new contact did, in fact, join the fb group.  So the metric will change for each step of the funnel.  Some of the steps may be common to multiple funnels.Each funnel can have multiple people in it simultaneously, spread across the funnel's varying steps.In addition, people could (potentially) be in multiple funnels simultaneously.Oy.Anyone have thoughts as to how to structure the base?  I'm struggling to wrap my brain around so many relationships all at once!  I will be fore

Is it possible to have an input Mask in the tables / forms? I want a field to be displayed in the format S0123, or another field to be displayed as 4 digits such as 0025 (not simply 25). Thanks in advance all.

I wish to add files to records from Google Drive.I thought Airtable's Attachment field had no native integration for this - but, actually, when I open the "Add an attachment" window, I see a range of files services including GDrive, with which I can authenticate (what's going on?)...However, there is also a problem...Whilst the subsequent file browser shows my GDrive files which I own, it does not show files shared with me to which I have access. While shared folders are visible, their file contents are not available to select.This is in contrast to Monday.com. In that, I notice that shared-with-me files are available to add just fine.Is there any way to enable this, please?

I am trying to recreate a page designer extension on a new table within my base. When I switch the tab over and go to edit the page, the image field is not loading. I am copying the image url with the attachment uploaded and receive the message in the screenshot below. Is this functioning correctly or am I doing something wrong?  

Hey,I recently came to the conclusion that many of my existing spreadsheets would actually make much more sense if they'd become databases. So I started playing around with designing some of those, and while majority was smooth, my gym workouts became a big challange for me.First of all, I struggle with design correctly the base. I had a couple of different approaches I've tried, and everything seemed to be overly-complicated. The problem is, whenever I get somewhere, all I have in my head is a possibility to export this base in a fairly simple format, which I could take and send to my trainer (I do it weekly). I've attached a screenshot of my existing plan in Google Sheet. I'd love to generate something similar in Airtable. I'd appreciate any kind of brainstorming 🙏

I'm a new user.When I make a Kanban board, and click on an individual task (a row in the grid view), then it opens this in a separate window that overlays everything else. What is this separate window called?Is there a way to do this from the grid view, so that I can click on an individual row, have a window pop up with all of the fields just for the row?Thanks

Hi,I have 2 databases with sync tables on one AirTable Account. I would like to move them to another account without loosing the syncronisation between tables. Is there a way to do it ? ThanksF. 

Hey Everyone!I'm hoping you can help me out with a tricky one. We currently use a check-in system (VisitU for those that care) to keep track of when/why people use our space. I then take that data, dump it into airtable on a weekly basis and it does a bunch of cool analytic stuff already.Now for my ask. It records a time in field (with an exact time like 15:57) but that is linked to a date field. I was tasked to figure out if being open past 6 is worth it on Monday's and Wednesday's. Figured out how to seperate the day of the week (using DATETIME_FORMAT(timeIn, 'ddd')) but now I want to give me a list of those who checked-in after 6 that I can then use the two field (Day Name and Time In After 6) to tell me how many people used our space. Make sense? Any ideas on how I could separate that time field? 

Hello all! Been struggling with this for a while with my current base. Subject of this post is a decent summary, but for explanation sake I've drastically simplified my base design:Link to the simplified base I'm describingtl;dr: The end goal is to look at a project, and total the number of hours spent on each task over the multiple scheduled events related to that project. There are three Employees:Employee AEmployee BEmployee CThere are three Tasks:Task ATask BTask CThere are three Projects:Project AProject BProject CThere are Scheduled Events.Each Scheduled Event assigns an Employee to a single Project, and various Tasks for that project. For instance... Employee A is scheduled on Jan 1 to work on Project B. They are assigned to tackle Task A and Task C. This is what I'm calling a scheduled event.Each day will have multiple scheduled events. Any combination of Employee, Project, or Task is possible for each day. Each employee mi

I am writing to seek assistance regarding a record limit issue that my organization is currently facing with our Pro plan. Yesterday, our base had a total of 13,000 records, well within the 50,000 records limit of our Pro plan. However, I imported an Excel sheet with an additional 44,000 records to test a formula. Subsequently, I deleted the table containing the 44,000 records, expecting the record count to revert to 13,000. Unfortunately, despite the deletion, it still shows that we are over the limit. I have already tried emptying the trash, but the record count remains unchanged. Any advice and assistance is greatly appreciated Thank you in advance.

Hello im working on linking two tables in a base that we use for asset tracking. One table is MOV 24 (movement records) and the other is ASSETS 24 (asset records). In the Movement table (which has a forum to generate movement records), there are multiple Lookup fields that can only look into specific views of ASSETS. For example the radio assets are all assigned an asset number {ASS-ID} in the asset table. In the MOV forum there is a pathway to record the intake of an item from the radio vendor. When recording the MOVement there is a field for Serial Number. I have successfully created a Rollup that is taking the serial number from golf cart intake movement records, but when i try to duplicate the same process for the radio records i am not seeing any information roll up. Any advice would be appreciated! Here is a view of the Carts View on the ASSets Table(which only shows records which have C/UTV in the field {ASS-Which}) and you can see the golf cart SN is rolling up from the MO

Hi, I am new to Airtable. Just learning to use the calendar view. Instead of being able to view the contents of relevant records in the calendar, I can only see the numbers of relevant records in the calendar and I need to click each date to see the details of the records.How should I set up to view the details directly in the calendar?

Hi folks,I'm looking for ideas on base design(s) for chemical formulations. I've taken one stab at this where I hardcoded some columns, but that fell apart pretty fast. I'm hoping some Airtable creatives have ideas. Here's the general problem:An ingredient inventory has some number of ingredients A, B, C, D, E, F... etc and can have an arbitrarily large number of entriesA formulation has some number of ingredients (an arbitrary subset of the ingredient inventory, so maybe B, C, F as a random example) and a defined amount of each included ingredient (xB, xC, xF). That amount could be a fraction or a mass in most casesSimple case: how do I deal with a formulation having arbitrary composition of ingredients?More complex case: How do I deal with the above, but ingredient inventory can also include formulations (so it's getting recursive)?Any ideas are most appreciated!Regards,Scott

At work I have an Airtable base as in the attached screen share.I need to create one like this for my daughter soccer team. Is this a timeline view? meaning I would have to pay to create one?Thanks M

I uploaded a bunch of portrait character wardrobe photos but they all flipped landscape. Sucks, but I can’t even figure out how to flip them one by one once in - or even how to reload and ensure it doesn’t happen again. This is the first time this has ever happened - it’s never happened on headshots or location photos. Is there a setting I need to set in the table? Or can I rotate or edit a photo once uploaded? I know Airtable is more of a storage device, not photo editing - but this is not the way I uploaded them originally. Thank you!

Is it possible to get AirTable to generate X number of records in a table? Example: Table: Batch Col: Date Col: Batch Number Col: # of Units Produced Table: Units Col: Batch Number Col: Serial Number I’d like to create a record in Batch table, and if I say 10 units were produced in that batch, then automatically 10 NEW records appear in Units table (all of them linked to their batch in the Batch table) and all of them assigned automatically a sequential number (starting number would be MAX of whatever serial number is already in tab from PREVIOUS batch). I can’t even begin to wrap my head around this one. So, the two main issues would be automatically creating X records based on the event of another table AND auto generation of serial numbers starting off at the last serious number of previous batch. Is this impossible?