Base Design

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

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 seve

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

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. 

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 for

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

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 f

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