Base Design

I have a question about displaying more records at a time in calendar view. My company uses a variation of the Shipley method, which employs different colors to denote different stages in a project. I have my entries set to display with a project name, stage, and start/end times, with color formatting determined by certain fields in the record. As far as I can tell, you can only see a maximum of 8 entries at a time in a compact format, which is the 2-week view. This seems to be the same both in the interface and the regular view. Is there an alternate way to see entries with this type of coloring in a similar compact view? I am not happy with the Gantt, Timeline, or List views, which either spread things out too much or don't have the same coloring options. I would prefer to have a 2-week calendar format that simply has more rows, but I can't figure out if there is a way to do this within the calendar option or if there is something similar available in another feature t

We are setting up a Booking system with Airtable and trying to find a way to hide / disallow our customers from selecting weekends on the Form View. We want to be able to see weekends on our end in the calendar view, but the customer should not be able to select a weekend as a start or end date. Any ideas?

Hi!Is it possible to show on a public page some field of a row and ask the guest to fill some other fields?Thanks!

Hey all! Working on making Page Designer work hard to create the thing I need 🙂 A couple of limitations I have run into that I haven't found a workaround for yet:1) Flowthrough to another column. Currently I have this list of information:But I want to be able to run it over 2 columns like this (duplicated the field to illustrate what I want):The information would flow from the bottom of the first column to the top of the second in my perfect world.2) Grouping within the field in Page DesignerI love being able to do this in the regular tables, and this particular list I need to have grouped by Department in the same way:So the table above that I want in 2 columns...I also want sub-grouped by Department. The simple sort by department is ok, but not ideal because I need this form to look like what my film guys are used to seeing. Any thoughts?Thanks!!  

Hi,I have a question and when it could be solved I will be a lot further in the development of my Airtable database.I have a database with 3 tables.Table1 with 1 field : Company.ShellBPEssoTable2 with 2 fields : DB (Text) and Company (link to another record)ShopDB    ShellTRA           ShellOil             ShellTrack        BPBounce    BPEloy          EssoYama        EssoAOC          EssoTable3 with 3 fields : Company (link to another record), Database (link to another record) and Amount (Currency).I select the Company : Shell (link to another record).Now, in the field DB (link to another record), I only want to see the DB’s that match the selected Company,so ShopDB, TRA and Oil and not the

Hi everyone,I am in commercial real estate and we own a bunch of properties.  We have a leasing checklist we run through every time we are about to sign a new lease at any of the properties.  I am trying to think about the best way to set up the checklists so that each time we enter a new lease, the checklist will be created for that tenant.  I am new to Airtable and I am not sure if I should have a different table for every tenant and checklist, or create one table that has the checklist for each tenant (but then how would we view just one checklist at a time, etc.).  Thanks!

Hi Airtable gurus,I'm working with a set of bases structured in the following logic:Partner base: list of partners and their metadata (e.g. legal status, primary contact, website etc.)Case base: list of cases and their metadata (e.g. region, industry, case manager etc.)Practice bases (multiple): combines where partners are impacting cases. (Yes ideally this would have been one master base, but for reasons outside of my control right now that is not something we can play with)Case x Partner rollup: base that rolls up all the individual practice base activityWe are now trying to build a single interface that can display the partner information and to display analytics for cases by partner (and for e.g. region and industry cuts of the case activity) but I'm finding it difficult to connect back the partner base to these transactional records of 'cases x partner' so that it can be displayed in a single interface. I have tried various hacks to aggregate and send case coun

Today I noticed that when adding records to the the bottom/Level 1 of a List view that is filtered on that bottom level, none of the filtered conditions pre-populate, so the new record is automatically filtered out. I tested this in several Base List views and Interface List views, and the behavior was consistent.This is easy to fix with as simple automation, but the thing is... I was working in the same base and interface yesterday, and I swear this wasn't happening then. Yesterday, adding records to a filtered view prepopulated the filtered fields with the filtered values, just like in a grid view.Is this a new bug, or am I just misremembering how the List view behavior was working previously?

The table column I work with is usually in the monitor screen's center. If I need to edit a description or a formula, I press the arrow on the right side of the field name and then press the "Edit field". The edit window appears in the center and to the left. It appears right below the main line with the field names. This window immediately overlaps the data in two or three fields. Often this is the important data I need for writing the formula. How can I move this window down for two or three rows? 

I want certain fields in my table to auto-populate with the designated default values I've given them. While it is working as expected when I add records manually, it does not work when I import records. I am trying to avoid using automations as I want to keep my automation runs low, and this particular use case would cause them to run up rather quickly. Anyone else run into a similar issue? Thanks! 

Good day y'all,I have an issue with my Base page freezing whenever filter is changed to find another item. Browser will then very often freeze and a window will appear asking me if I want to "wait" or kill page. Other tabs on the browser will work just fine (as long if it isn't this particular Base). Other notable mentioning: Used/test on Brave and Chrome browser and Airtable Windows Desktop App Desktop/laptop systems resources are not 100% (CPU or Memory) utilized48,284 / 50,000 Records utilized8 active Automations6 tabs (the majority of data) are synced from other BasesQuite a large amount of columns consisting of Formulas Is there any reasons particular this is happening? What issue would I need to address first to relief the system from the stress?This is pretty critical for the business the daily operations. Unfortunately the support team hasn't responded since yesterday. So here I am 😞

Hi there! Hoping someone can shed some insight!Context:My primary table tracks billing for the month for multiple clients.  The total amount billed for each client is calculated from a reference table based on the current services each client is using. These totalare  updated each month and then sent to our billing department for invoicing. For simplicity sake, fields are:Field 1: CompanyField 2: Total Current Monthly ChargesGoal: I would like to send the total current monthly charges for that month for each client to a separate table so I have a record of what each client was billed that month in order to track month over month revenue and have a historical record. I'm weary of a date specific automation as billing finalization date can vary.  Ideal End Result:1. Finalize totals for the month2. Click button that says "Finalize" for a record3. A new record is created in a separate table with the following info:Field 1: Record Name ("Client" & "Sign Off

Hello everyone,I was wondering if there is a way to avoid people adding users as builders. I often have to monitor and check my users in order to make sure none has been added as a builder because it is risky to let anyone build and modify bases and also in terms of pricing can cause issues.Thank you very much for the help

Hi community,I am using integromat to create Gslide presentations from Airtable data.In each airtable record, I have elements like name, position, company and a picture from our student.My scenario was working properly until recently, because there was an evolution regarding attachment URL behavior in Airtable.Since, every element is "transferred" on the Gslide presentation, but not the picture.I have created a field with a formula to mimic the old link (like: https://dl.airtable.com/.attachments/c3514c423036281518ab5715eca5c650/04c00db3/Swile_Rebuild_by_Superflow) but it's not working.The URL file starting by "v5..." isn't working either.Ideally, I'd like to be able to download the file from a link (I haven't figured how to get a working link yet) on Gdrive, and get that file to add to my presentation. I'm new to no-code and I may not have the correct approach, and I'd love to learn more about that if some of you are willing to help.I'm attaching a screenshot of the scenario

Hello, I'm running a group hostel, and to track the activity I created a table that list every client I have, their day of arrival and departure. When I create a new reservation (new record), I add the day of arrival and departure. And a formula takes out the month and year of the arrival, and a group setting that group the reservations by the month, so I have every reservation group by month.But I have one issue : when a customer stay on 2 different months (like you can see for client 2, staying in may and june) he is only in the 2023/05 group, and not on the 2023/06 group. I would like to see client 2 on the 2023/05 groupe AND the 2023/06 group, so when I look at the 2023/06 group, I know he is here.You can see the table right here. (I remove all of the irrevelvant fields for (as payment tracking, details of reservation ..) to make it more easy to read). Thank you for your help!

Does anyone have a database with all cities in the world? I'm hoping to use it so that people can select/search from a drop-down when selecting their location when filling out a form. I found one with all countries here.Many thanks in advance!

I have a Yes or No question in one column. I only want to enter data in the following column if the answer is Yes. If the answer is No the following column remains blank. So what I am looking for is the following:Caregiver Field: Yes or No.Caregiver Name: If yes, enter name of caregiverIs it possible if the answer is Yes, enter name of caregiver in the following column, and the next column would allow to enter a type of relationship. For example: Caregiver Field: Yes, Caregiver Name: Jane Doe, Relation: Daughter.If Caregiver Field: No, Caregiver Name: blank, Relation field: blank 

Hello everyone,I want to allow a list of people (whose information are already stored in a table) to book different events in a Calendar they could access. The booking system would allow them to see all upcoming events, and register to the ones that we still have availabilities for (let's say 5 participants maximum per event for example).I had access to the "No-Conflict Asset Reservations" template, and it seems promising, but it implies that the Assets will be available 24/7, whereas I would like to let people choose among a list of pre-defined slots.All the registrants will be pre-existing records in my "People" tab. Ideally, I would like the process for them to be:They receive a unique link to a view/interface they can bookmark and share internally.They open this, and see the event they want to take part in. The number of participants is displayed next to an event, and only events where we still have slots remaining are visible. (In a perfect world, they could even toggle betwe

Hello Airtable gurus!!Our org is relatively new to Airtable and we are starting to design towards interface and analytics output. We are using Airtable as a mini- partner relationship management database and have a series of synced tables already set up with this rough structure:Partner Table: list of partner names and metadata associated with the accountsCase Table: list of cases our company runs, with associated metadata (e.g. region, industry, client name)Practice Tables: teams indicate where a Partner impacts a case (yes, unfortunately this is set up so each practice has it's own table for other logic reasons; ideally this would have all been one master table)Case X Partner rollup table: fed by all the Practice Tables, acts as a master for all the practice table activities. Data that rollsup is read only, but I can add columns manually and link other basesThe question we face now is that we want to report out all the interesting details about partners in our partner interface,

I have two tables: Tenders and Companies. Each record in the tenders table is a tender (contract) between a governmental entity and a company. The tender table has a column "keyword" which is a way to group similar tenders.I'll try to explain my problem with a demo base. Here are the two tables:As you can see, the companies table has three columns for each keyword. It's of type 'count' (it is filtered only to count each keyword)Now, to turn the table from wide data schema into a narrow one, I can just use the table optimizer script available in the marketplace. The issue appears when we talk about my real data and real base. I have 81 Keywords and the tenders table is updated every week so a new keyword might be added anytime. In order to follow the same procedure I explained with the demo base above, I need to create 81 columns for each keyword, and since the table optimizer script doesn't take count field (it needs to be text field) so you need to change these count fields to te

Hi,I'm trying to create a new table using CSV file with field name and data type only, without sample data using Airtable interface, not API. For ex, Field 1,Field 2,Field 3text,number,dateThe expected output is a table with three fields named “Field 1”, “Field 2”, and “Field 3”. The first field should be a text field, the second field should be a number field, and the third field should be a date field.However, instead of setting the data type for each field, the second row was treated as a record.I tried a different format and result is the same.  Row 1 is treated as field names, and rest of the rows below were records:Field Name,Data TypeName,Single line textEmail,EmailPhone,Phone numberAddress,AddressDate,DateStatus,Single selectNotes,Long textTruly Appreciate any help you can provide.

Hi, I am new (1 week) to Airtable.I have a Base with 2 tables. Table 1 has 1 Company field. Table 2 has 2 fields : Company and Database.Table 1 is filled with 200 records.Company1 / Database1Company1 / Database2Company1 / Database3Company2 / Database4Etc.....When I choose the Company Company1 in Table 2, then in the Database field I only want to see the records that are linked to Company1, namely Database1, Database2 and Database3.Is this possible!RegardsMichel

My company current has a pro plan.  Is there a way to group users by either creating another table or is Airtable planning on releasing this feature to pro plan users?

The column name is too long and doesn't move to new lines when I shrink the column. Can you suggest a way to move part of the name to a different line? Thank you for any suggestions!

I tried to contact Airtable support for this and they refused to help me. Here is my question:John books Studio A on Mon 1-2PM and Friday 4-8PM from Sep 1 2023 to June 1 2024How do I set this up?