Base Design

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. 

My base is a table copied from and synced to another source base. Is there a way to break the sync with the source base but still retain the data so that I may edit the table?

Hi Airtable community,  I'm new to airtable and your classic overthinker and I'm having a difficult time designing a simple Lunch Order Base. I read lots of articles and asked AI chat bots and can't seem to find what I'm looking for. I have to collect lunch orders for a list of attendees over a 3 day conference. Data I have:1. List of attendees names, allergy concerns and their emails addresses. 2. I know which days they are coming (some are coming for the full 3 days while others are opting for partial attendance). 3. We will be ordering from 2 - 3 different restaurants. Would be nice to put a restaurant menu link in for attendees to review their choices ( but I have not found a workaround (I understand) to add a link to a form view. 4. We have a price cap per/person per day. Base design  dream of (but can't quit nail the workflow down) 1. Send a form with a menu link for the days we pick for that restaurant for attendees to review and

Hi there!  We're setting up a volunteer shift database for a large festival. I assume we can let volunteers sign up for shifts using forms, but is there a way for them to change/drop shifts without having to email us to do it on the backend? If not, is there an extension that would help?

On table A, I've added a linked record field to table B. On table A, I can add lookup fields from the linked record on table B.But on table B, I cannot add lookup fields:> No available sources to look up. Add a lookup source, then try to configure your lookup again.I created a new linked record field with the same configuration on table A and the lookup works both way. Is there a way to fix my original field to work both way too? 

Hi (newbie here),Can you do a rollup on a Lookup field in a different grid?I have a table of employees.  There is a table of Trips where we look up the employees from the employee table.  Then I have a Departures Table that pulls in the Employee information from the Trips table. Now I would like to do a count(rollup) of the number of departures each employee has.I am having problems figure out how do this.  Any help would be appreciated.

Hello,My sister operates a bakery from her home, and I want to make things easier for her by creating a system in Airtable where she can take orders for her products.As a bonus I'd like to be able to track repeat orders from customers as a way to determine customer preferences, habits, trends, etc.There are a few problems I'm finding with this. Airtable has no way for customers to "make an account" so to speak. I'm inclined to create a table for customers, but...Customers would need to complete a separate form if they're a new customer, then come back to the order form, which feels cumbersome.For each customer that already exists in the base, Airtable will reveal all of the names in the customer table whenever a returning customer begins to search for their name, which just doesn't sit right.We could simply request name and phone number each time, but I'm not sure if that will allow me to combine those records based on phone number in order to be able to assess trends based on those or

Hi! Recently I've been encountering a table syncing error ("Last sync failed 1 minute ago (external resource id could not be mapped to a rowJson)"). It's easily resolved by manually syncing the table with the error, but this is obviously inconvenient - we have a LOT of synced tables. I haven't been able to detect a pattern in which tables get this error or when. Has anybody else seen this?

Hello!I need to create a data entry form that will limit dropdown menu choices based on the selection made in another field. I am looking at the possibility of establishing nested lists to define the hierarchy of options, but so far I'm not succeeding in creating an interactive drop down menu.Is nested lists the right approach? If not, is there another way to do this?Here's the example. Imagine I have a table that has 30 birds and 20 fish in the records.In question 1 I want the user to be able to select "bird" or "fish", and then in Question 2 I only want the 30 birds or 20 fish to show in the species selection box, depending on what was chosen for Question 1. (In reality, I have an intermediate grouping level, and many more species than 30 or 20.

Has any headway been made toward the goal of being able to display the results of the survey during live group polling? I remember seeing some community debate about the need for such functionality around a year ago. Still, I haven't seen anything recent that indicates any work being made in that respect. Many thanks!

In my rollup fields (on multiple bases), I don't have the option to add a condition shown in this article: https://support.airtable.com/docs/rollup-field-referenceWhy would that option not be showing up for me? (I have a Pro account)Here's what I'm seeing...Here's what's shown in the article:

I am trying to create a table that is linked to a Box folder where I have hundreds of folders inside the root folder. Those folders contain other sub-folders and tens of thousands of files. (Root Folder>Folder>sub-folders/files). I don't want all the (sub)folders and files to be synched to my table, just the folders. In other words, I want all the information to live inside of box and just have a button/link to click to open the folder where the (sub)folders and files reside. There doesn't seem to be a way to just have the folders synched without it trying to synch all the (sub)folders and files. Needless to say, it quickly hits the 10,000 record limit. Howevere, all the folders I actually want to see are included within the synched table. I can create a filter to weed out the sub-folders and files, but I don't want that information just hanging around burning up records (counting towards my record limit). I hope all that makes sense. Does anyone know a way to just synch the fold

I have several views that show the icons without the words - it's driving me crazy that I can't figure out how to put them back, or how they got this way in the first place.Please send help! And please also don't ever make me have to deal with that truly circular, frustrating and unhelpful bot on the help bubble.

I have a base with two tables. One table is contacts while another is companies. For my contacts, I have a field called location which is a series of metros: NY, SF, DC, London, etc...I'd like my companies' table location field to have the same list of locations. Is there a way to reuse the field, but not have them link to one another?(I dont anticipate wanting to ever connect a contact to a company, and if i do it would be with different data than what i have in my contacts records anyway)

Hi,My problem is I have a team of 3 including me, and I created 3 tables, the problem is when I update the other table for my other team it change the 3 tables including mine and theirs. Anyone can help me here? pls pls pls

When I paste more cells into a table than it has, the expand table message comes up. I click ok and nothing happens. Happening in all bases in my account... JL

copy paste of data to base not working .. had to import 

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 solutions. Thanks in advance for your help!

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. Here is the scores I would like added for each option chosenPull Factors Attract: 2Bonus Pull Factors: 1However it's not quite working with records with an empty field.

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 table or any idea about the error. I r

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 ratings, nothing updates, and it creates a new Record in the Vendor table - Again, pretty sure because its not co

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)?