Base Design

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!

Thank you in advance!!! So we are a very small charity and we are trying to track our COVID response in Airtable rather than the millions (only a slight exaggeration) of spreadsheets that we currently have. I think I know how to do that part which is exciting, where I am really really struggling though is the basic CRM side to stick all of our membership in. Our problem is that our membership form (currently on google forms and sheets) is the family data and then multiple child details on each membership form. I have worked out how to make a form for the membership details but where I am struggling is pulling up a report of the number of children if I use the link data tab I can pull through child number 1 but not the details of the other children - am I missing a trick? We have over 10,000 children registered and I need to be able to pull a report on the number of siblings, the number of children in total, how many are disabled and then be able to break it down into the types of d

I would like to be able to automatically import contacts with the status “closed-won” into a sales tracking table. Example: I have a travel agency, so when a prospect goes into “closed-won” status, I have to do a different follow-up (hotel reservations, excursions, etc). I’d like the contact to be automatically transferred to the customer follow-up file when it is in the prospect file. I’m a novice on the platform, thank you very much for your help. Beautiful day. Alexia

I have two tables that have information that is needed to create formulas to auto calculate gaps. For example, I have one table set up grouped by Month and Coach and has columns that are in currency format. They have revenue amounts and other count numbers. I have another table that is created to calculate the gap between the numbers in the first table and the newly entered numbers from Coach inputs in a form within that second table. So somehow I need to get the information that is sorted by Month and Coach into the second table to create formulas to calculate with the new information that will come from the form. Thank you in advance!

I’m not really sure how to ask this or if this is in the correct category, so please bear with me. I have entries grouped by Name. Within each name, I want them grouped by Type. However, I want those types sorted based on a percentage. Is there a way to accomplish this? Currently, when I make a group, it sorts the groups alphabetically. Then, within the groups, it sorts based on the percentage. But I want the actual groups sorted by a different value, not just within the groups. Is this achievable?