Base Design

Hello Airtable Community! I have a question about creating an EQ reservation/checkout system in airtable. My nonprofit already uses airtable for keeping track of our film production equipment but lately we have started checking out filmmaking equipment to our youth participants. I was able to look at various templates and create a rudimentary checkout-checkin system in our eq base, but as of right now it doesn’t allow us to create EQ reservations for future dates. I would like to be able to make EQ reservations (with multiple EQ items) for the future and see what EQ is “available” during a specific date range. So I would need these future reservations to be able to look and see what else is reserved or checked out in any given date range… Im looking for ideas on how this could be possible, I have done a bit of research but haven’t found examples of what I am trying to do. Any help is greatly appreciated! thank you very much! here is a link to a simplified test base version of our

Hello If anyone has advice on best practice for setting up the following I’d really appreciate some tips… I’m creating a list of materials that has many columns detailing each materials qualities and uses. Each material will have multiple suppliers and I’m trying to find the best way of not overloading the user with information until they need it. I could add multiple columns in a single sheet for each supplier but wondered if there is a neater way of organising this? Is having a separate sheet that lists material name and then the various suppliers each in a separate column a better way? And link through to this? Many thanks for any suggestions you can give. Simon

Hi, I’m looking to create a set of nested questions on the submissions form view. For instance, the headline question on the form would ask ‘add contact’. When the user of the form clicks on this, a set of sub-questions appear, such as name, address etc. Once the sub-questions have been filled, I would like the user to be able to click ‘add contact’ again, and multiple times on the one form, as there may be more than one contact required for a single entry. I also would like the answers to the sub-questions to be collected on a separate tab in the grid view. I’m not sure if all of this is possible. Any advice would be much appreciated. Many thanks.

Thanks so much for looking this over- I have a odd request and I don’t see how to do it, so figured I would hit up the masters of AirTables. I have a few different AirTables, I would love them to link to another Airtable, or just a section of info. Is there a way to do that? Do I even make sense? Thanks

Say I have a whole table with various flowers listed, with bloom seasons, color, and whether or not they’re deer resistant. I want to be able to see JUST the records that are tagged “bloom season” in a new table. What’s the easiest way to do this? Thanks!

Hi everyone, I’m looking for a formula to check if any cells on a selection of 5 are empty. Hard to explain globally, but theorically the formula would look like this: IF (Cell 1) is empty OR (Cell 2) is empty OR (Cell 3) is empty… THEN display :white_check_mark: How can I achieve this on Airtable? Thanks in advance for your help.

Hi, I want to create a list grouped by date for me to keep track of email followups. Some of the dates will have the same email addresses as I do follow-ups. For example, if the single select drop-down options are: 1st contact, 1st follow up, 2nd follow-up, and submitted. I would like to have it, when I am dealing with a repeated email address in another date group certain options won’t pop up since they were already selected for that email address. For instance, if 1st follow up is selected, the next time I enter that email address only 2nd follow and submitted will show as options. Is this possible? Thank you!

Hi there, I just got started with Airtable and have imported a couple of records that make up a many-to-many relationship. The base structure is fairly simple: User (user_id = 5) <–> join table (join_id = 124 with user_id = 5 & group_id = 33) <–> Groups (group_id = 33) So users & groups each carry a primary ID / key and are connected via the foreign keys / IDs in the join table. I linked the records together fine and can add lookup fields like “user name” in the group table but those are merely text fields and not clickable – instead the ID field that ties the records together is the clickable one. How can I choose which field is used for switching between tables / triggering the popups and pulling in the data from other records? The client I am building this for won’t accept an ID field to have to click upon and I want a clean and logical interface… Or do I have to get rid of the imported IDs since Airtable uses its own unique IDs and tie the records together based

Hello, I am using masterdata tabs in my table to harmonise data. My problem is that every time a user enters data manunally or automatically in specific columns linked with the masterdata, this may create junk data if not recognised by the masterdata list; thus requiring constant clean-up. Is there any way I can block/limit the data entry for those specific columns linked to the masterdata ? if YES, can you please provide a step by step Thank you Cloé

Say I have volunteers who listed specific tasks they’ll do, along with the dates they can perform those tasks. How do I set it up so I can see who can do which tasks on which dates? Thanks

Scenario: I’ve got a membership product where orders get added to a Google sheet. When a new row is added, I can use Integromat or Zapier to add a new customer record in Airtable. I’m struggling to find out how to do the following If a customer cancels their subscription, I have a cancelled field and date which gets updated. However, if the customer buys it again in a few months, I want the same record to be updated but with the cancellation fields cleared. So in effect, if a new row is added to Google sheets, I want it to check whether the customer record already exists then just update it, otherwise add a new customer. Is this possible? I’m probably suffering from baby brain but integromat only seems to have a either add or update. I want to combine the two. There was something about smart links on there. Do I need to create an Orders table and somehow link the two then somehow use that to do updates if needed? Thanks

Hi all! pretty familiar with Airtable however having some issues figuring out best way to accomplish my goal: build an on call sheet for my maintenance team. ever week of the year a different tech is assigned to be “on call”. For example: 1st week of Jan: Darius 2nd week of Jan: Steve 3rd week of Jan: Al 4th week of Jan: Martin 1st week of Feb: Al 2nd week of Feb: steve 3rd week of Feb: Darius 4th week of Feb: Martin and so on and so forth for the entire year. Goal would be to have a base that i could easily sort/group by Tech AND month. Additionally, show a calendar view that could show each tech listed for each week. make sense? can Airtable accomplish this? thanks!

Is there a way to turn off when you click on an empty row that a new Row is automatically created? I want to just be able to click the + and I get a new row. I keep getting empty rows.

First of all I would like to say thank you for everyone contributing to the Airtable Community, I have been saved hundreds of time by the ideas and solutions posted here. Now, I would like to pose a problem I’ve been dealing with: I’m creating a data base to keep record of project ideas pitched by a team. I want to be able to prioritize ideas from people who have already suggested something before AND had their idea chosen for further development. I managed to indicate all people that already submitted an idea thanks to this: Can I find unique values and put them in a column? Now I would like to have a field indicating if that person has had an idea picked for developement before, but I’m stuck and can’t find a solution. I have an array with all the people who have submitted an idea before, now I need to know the status of these ideas. I believe the way to do this is create an array for each recurrent user with all values from the idea status column so I could verify if any status is ‘

I’m an old Oracle DBA. My first day using Airtable and I like it already. Here’s my issue. I’ve been building my base creating tables and demo data to test my design. When linking tables I included the fields that would provide context in helping me select the right record to link. Looking back, I should have included a few more link fields to give my grids/views better context as well. How can I add these now without dropping/recreating these links and all my data? Any help would be much appreciated. Mike P.

Greetings! I’ve looked everywhere, but can’t find a way to jump from one letter to another in a column. I’ve just started a large research project, and have 1,110 entries, based upon LAST NAME. It would be fantastic if I could easily jump from where I am in the table to the beginning of the letter a new entry begins with, since I need to check for duplicate entries (not simply based on the last name…it’s more complicated than that). I’m familiar with the search function, of course, but that takes FAR too much time. I can use the keyboard shortcuts to get to the top or bottom of the chart in a flash, but that doesn’t help me much when I have to look up and see what I have (if anything) for Molly Mergatroyd! Thanks in advance for any ideas you can offer!!

Hi, I have a long list of contractors with different work experience, skills, availability, preferences, etc… I’d like to create a form that a client can complete when sending in a new project request that will then provide a list of the most suitable contractors for said project. Has anyone got any ideas on how this could work either on Airtable or with API? Thanks in advance for your help!

I’ve added new question fields to my existing gravity form and I want to edit my Zapier zap and my Airtable base to show us the new fields/responses. Are there instructions on how to do this?

I am trying to set up my inventory to track shirts given to my employees. I can’t get the look up and/or roll up feature to work. Here’s what Im looking for… TYPE OF SHIRT | SIZE | QTY ORDERED | QTY ASSIGNED TO EMPLOYEE | CURRENT INVENTORY If I could get here I’d be set. I don’t know why i can’t get the look up feature to work or the rollup but please help!

I want to have one base that uses a same customer record in different ways. I have an “Intake” table that I’m hoping can auto populate my “Outreach” table for consumer outreach. So, what’s the easiest way to set it up so that these two tables will talk to each other? The records will be the same, so maybe I have to design the base with this in mind? If someone populates data into the Intake table, I’d like some of that data to auto-populate into the Outreach table.

I already receive submissions to my Airtable via a form, and would like to allow submitters to pick a date from a list of available dates from a calendar field. Once someone reserves or picks a date and submits the form, that date should be removed from the list of available dates. I would also like to allow people to reserve dates up to 3 weeks into the future. Calendly already supports this functionality (and in fact I have a Calendly for this purpose) but would prefer to be able to collect submissions from a single Airtable form. Is this possible?

How i design a base when i send data from kodular ,the new data is inserted at top …i mean 1 number row…any one can help me

Hi, I understand the idea of normalizing a database - and I see that I can create a column type for a drop down list. Why use a drop down list instead of a linked table? Is there a configuration/structural reason to do so, or is it just easier?

Hello I’ve a base to add questions, question can be text or image? How to make this field? Am using airtable as db for questions then use the api to sync with ios app

I have a table titled “BIO” where I’ve made records for each player on a football team. I also have a “REPORT CARD” table that includes a record for each player and a field for each player’s grade and a field for the players GPA dependent on their grades. This GPA is used as part of a disciplinary points system for the team. Points are stored in a separate “POINTS TRACKER” table. I’ve created a ZAP so that when a new record is added to the BIO table, a new record for that specific player is also added to the other tables. My problem is this: I used a linked field to connect the REPORT CARD and POINTS TRACKER tables. This allows me to pull that GPA score into the points tracker to be used to calculate a points system score for each player. However, when I add a new record, this linked field does not update the linkage for the new record. Any tips are appreciated!