Base Design

 I have created a base in airtable. I have a multiselect column called "Attendees". One of the options in this column is "Product". I am currently trying to create a calendar view in airtable that is specific to the Product team. To do so, I have created a filter that says "Where "Attendees" has any of "Product"". However the records that have Product tagged do not appear on the calendar. How do I get the records tagged with "Product" under the multiselect column "Attendees" to appear on the calendar? I do not have the option to choose "contains" when I set up the filter. 

Hello everyone,I have a question regarding the multiple/single select fields.I've built a database for our team and we recently started using it. The only hiccup I encountered is with Multiple select fields: what I would like to have is a restriction for editors so that they would not be able to create new options within a multiple/single select field. Unfortunately, I haven't found a way of doing it, and as for now, all the editors are able to create new options. This leads to the creation of new options if someone, by mistake, presses enter after having typed a non-existing voice.Would you know how we can avoid that?Thank you very much in advance

This will be challenging!I have a Table with around 350 rows that i would like to export automatically as database file tha can be opened in excel, something like Timebale.xlsOnce generated this file i would like it to be inserted automatically in a cell as "Attachment" in another Table. Are there any extensions or functions that allow me to achieve this?Any help will be very well appreciated!

Hi,i am creating 3 tablesINVENTORY, SUPPLIER, PRICEINVENTORY contains every items SUPPLIER is just supplier namePRICE containsLinked table INVENTORY, linked table SUPPLIER, currency field.thefeore i have:SupplierA ProductA usd10SupplierB ProductA usd9 I want to design my INVENTORY table so that i can see the min price with the corresponding supplier. I did rollup the price and it is easy. How about the corresponding supplier? How do i rollup this?Thanks

I am a solo lawyer but I collaborate on some of my cases with other lawyers.I need to be able to see all of my cases in one place, but I need to share information with the other lawyers only for the cases that they are involved with and they need edit-level permission.  “Views” are not sufficient to share information in a usable format, so I have created “interfaces” to do that.  The problem is that interface sharing seems to require base-level collaborator access, but all of the cases are currently in one base and based off one master table with several related linked tables for specific things.Under this arrangement, some of the data for cases that are not associated with a given collaborating lawyer may be visible to those nonaffiliated lawyers, but it is impossible to know or to control that easily.I don’t know whether to divide the cases into bases according to the co-counsel or not.  If I did separate the cases into separate bases, I would still want to have one in

Hello, we are hoping to build an ad inventory management system that allows us to track when certain ad products are booked.Each ad product has different frequencies (some can be booked 1x a week or some can be booked only for thursdays or can run a flight period). What we'd ideally like to get out of it is also being able to track what is not booked/available to share with our sales team. Does anyone have a similar system already built out that can share a template or suggestions for how to show availabilities?

Hello Airtable experts!I'm a newcomer to the world of Airtable and am slightly overwhelmed with my goal. I'm looking to set up a "button-click" automation within an Airtable interface, aiming to create a private Airtable base with the click of a button. This base should be created within the workspace housing the interface. The goal is to create this private base with one table that references specific records from a source table in another base. I'm curious to know if this kind of architecture is feasible and if yes, can someone please help me get started with some reference code or tips? Would highly appreciate your insights, TIA!

Hi all, We are an organization that runs a lot of webinars, and we want to evaluate each program and get participant feedback so we send a survey after every program.The evaluation questions are the same for every program and I want to design a base that will collect all these responses, and for me to have a way to see all the responses by program, by type of program (for example- a one time program vs an intensive) and aggregated as a whole for the year so we can know how we do in general.I have one table that "holds" all the programs themselves as we use it as a workplan to plan the program from start to finish. I would love to find a way that i can send a survey/form to participants (obviously not users of Airtable), and that all replies will be matched to the program they attended (without them needing to choose the program from a long list).I would love to brainstorm a good way to get this done! We're also currently paying for a couple of third-party software that integrate w

My daily use of my base involves a lot of calculations. Lately, AT is slow to the point of being unusable while doing these calculations. The base just hangs at "saving" until I manually refresh. I've split the base into four so that the base I'm now working in has a quarter of the records I used to work with, but this has not improved performance. Is there anything else I can try?

Hi all. I'm trying to embed a base that has five tables. Only the first table embeds. When I click it open I can see the other four tables (linked) but I can't click through to them. What am I missing? I know it's probably staring me in the face but I can't figure it out nor find an answer anywhere here. Thanks!

Hello, I'm using Airtable to project manage a fabrication project where multiple units will be built throughout the year. One scenario I would like to track is when there is a single task that needs to be done for each unit, but only when that unit is ready. For example, the task "schedule logo wrap" needs to be done for each unit, but only when that unit is ready for it. What I would like to be able to visualize is how many units have been completed, and how many are left - maybe display a percentage or some other visual indicator. I'm not sure if I should just duplicate the same task for each unit, or I can role all units up under one single task.My current setup is:Unit Table - Lists each unit numberThanks!Tasks Table - List each task that needs to be done.

I'm working on creating a .csv to upload time shift data into another management system. (I don't have control over it.) The datetime format it requires is YYYY-MM-DD, HH:MMa. Airtable is setup without the comma. I'm struggling to create a formula to add the comma in. 

I'm creating a database to track the donations of our organization members and their households. My goal is to be able to create an interactive Interface for our Board to see the percentage of giving households vs non-giving households in any particular month. For example, if 6 out of 10 households gave in October, I'd want to see 60%;  if 3 households gave in December, I'd want to see 30%.Here's how I have the base set up so far:Donations: Every donation we receive is marked with the date received, the amount donated, the Member who donated (linked), and the Household the member belongs to (linked)Members: We have 100 members, each listed in this table and each linked to their Donation (if they've donated) and a designated Household (below)Households: For simplicity of illustration, I'll just say that we have 50 households (two Members in each Household record). Because all the records are linked above, each Household record shows the two linked Members and all the linked Do

Google calendars that are imported to Airtable - it looks like only 20 google calendars are allowed to be imported on a base. If we need more calendars on a base, then we need to create a new base? Is there a way to get more than 20 google calendars on a base? Please see screencast and pic attached

I would appreciate an option to limit the available times to schedule records to work hours (9 to 5). We can limit the dates shown to just weekdays, but available times are all over the date (2 am, 10 pm, etc.). This needs to be an option as someone may have events or projects outside of work hours or use the date field for something else. I have a manual entry date field for scheduling tasks on the calendar, and the UX is not optimized for selecting a time within work hours.

Hello community! I’m creating a table to manage a music school. To help with registration, I created a form and I’m quite happy with it. We want to give access to the form through our website so customers can register. I now need this form to be available in both French and English. My concern is mainly with dropdown fields. How would you proceed? Do you know of a way to avoid using a paying app? Thank you guys so much!

Hi. This seems like something trivial, but I can't seem to find any way to do this. I had synced two tables from a base to another.  During that time, various fields were renamed in Base A (the source table).  I noticed that the fields in Base B do not seem to get renamed as well, yet the sync remains active.  How can I know which is the fieldB name in Base B, which maps to fieldA in BaseA, without having to resort to guessing? 

I have a target base in a Workspace that is synced to several other bases all in one separate workspace. If I move this target base into the same workspace as the others, will this cause any issues with syncing or interface design?

Created a basic table in Grid View. Shared and embedded the List and was able to select multiple records, then select Download CSV and export the selected records. Nothing changed in the table, share, etc but now when selecting download CSV the selected rows are unselected. Even if all Rows are selected as soon as Download CSV is clicked the selection clears. In have searched the community and entered a support ticket and it does not seem like anyone has an answer here- I can download my entire table as a csv but that is not what I want- just want to choose the selected rows

First post here- I know I can easily build a form and connect results to Airtable- but can I connect a Form to an existing table for the user to select data from it? I have a table of workers by department with email address- I want the user to be able see and search this table (no problem) and then select users by email address from the table entries that will be submitted with the form.

Hi! So here's my problem: I manage an intranet platform for a very large company and I use Airtable for our editorial calendar. There is a special section on my platform of regularly scheduled content that is user-generated. There are four business areas (mine makes five) and together we are responsible for providing this user-generated content on a rotation each week. So each week there are four slots available but five business areas. So how do I create a scheduled rotation so that each business area gets a regular number of slots and that the total number of slots for each business area is more or less equal at the end of the year? Super basic example below:Week 1: 1, 2, 3, 4Week 2: 5, 1, 2, 3Week 3: 4, 5, 1, 2Week 4: 3, 4, 5, 1

I have created two forms within my base. As of last week, the fields for both form, #1 and form #2 were visible in my base and form #1, however, this week I noticed that many of the fields from my form #1 were missing from both the form and the base. I assume another editor went in there and messed around. I was able to recover form #1 based off a previous version of form #1  and was able to recover the base that showed fields from both form #1 and form #2, but I was wondering if there was any way to restore the previous version of the base and form #1 without having to rebuild form #1 completely and lose all the information that has already been submitted to the form.Thanks in advance for your help! 

Hi all!Here's a question... I'm making a basic task list in my base, I added a {Due Date} column with field type 'Date' and I have the time also showing in the same column. This will help me schedule tasks by date and time.Values in {Due Date} look like this '2/14/2024 5:00 pm'. I have another column {Date} with a simple formula DATETIME_FORMAT({Due Date}, 'MM/DD/YYYY') so I can get the date alone without the time.Heres the problem... Everytime I schedule a task pass 6:00 pm in the {Due Date} field, the {Date} value changes 1 day. Example:{Due Date} 2/14/2024 5:00 pm{Date} 2/14/2024{Due Date} 2/14/2024 6:00 pm{Date} 2/15/2024Help!

I am trying to build a B2B application and I want to keep the logical separation of data between the two customers. Let's say I want to give the ability to my user from Business X customer to choose an employee name from drop down that should be relative to their business. When a user from Business Y clicks the drop down, he should only see the employee names from their own business and not for both Business X and Business Y (which seems to be the current case). It is a privacy issue. I can manage this manually by creating visibility filters on softr.io or having a separate view on airtable for each customer, but it is not scalable. Is there an easy way to manage that?

I have a table of feedback for two cafes in a base. Each bit of feedback has an assigned category. I have another base that is linked to the category so that I can view aggregated data such as average feedback score by category. This data is then visualized outside of Airtable. The problem is that in Airtable as category is the primary, it lumps the cafes together in each row, so from this table I can't distinguish one from another. I need an output where I can see organisation as a breakdown of the  category. Something like this (almost like a pivot table structure):How would I go about designing my base in order to achieve that?IMPORTANT - the data needs to be in one view ideally rather than filtered views because my visualisation tool can read at the table level, but not view level (I do my filtering there).