Base Design

HiI have a list of business divisions (business divisions table) within an organization like, 'Large Projects', 'Innovation', 'Small Projects', 'Government Projects' etc.There is a employee master (employees table) where in each employee is mapped against a business division. One division can have multiple employees linkedThere is a need to create new project(projects table) for a division  and select an employee for the project. While selecting the employee (a linked field in projects table pointing to employees), is there any way to restrict the employees that are belonging to the business division selected (a linked field in projects table pointing to business divisions table)If there are any alternates please suggestThanksSri

Hello Community,I need to have an address table that deals with some people having different street and mail addresses and some having only a street address. How can I structure the table to allow for both while being able to filter for a list for mailings? Any thoughts would be appreciated.Thanks, Scott

Hi, I am new to Airtable, so apologise if this is basic. I have records: CR001 record detail CR002 another record detail is there a way to auto fill CR003 if i add a new record? Thanks, Simon

Hi All -  I'm trying to get a better understanding of the Google Calendar Table Synch. Goal: Add attendees one by one to a Google calendar event as they RSVP through a front-end system that uses Airtable as the backend. Current setup: Events Table that is synched to our GCal, second RSVP table that connects 'Members' to 'Events' Every time I try to find a workaround I ended up running into another issue. I'm not able to edit Synched Tables directly and there isn't a two-way table synch, so I wouldn't be able to add Attendees directly in the Airtable.Automations worked almost perfectly, but you aren't able to add attendees, you can only replace all attendees. The problem here is that I would create so much email spam if every time someone new signed up for an event, we send all previously RSVPd guests another email.  Are there any Airtable native solutions? Is Make.com or Zapier the only way? Am I missing an understanding of the Synch works? Any input

I have a look up field set up with a condition, but i want multiple records that meet the same condition to also populate.  how do i do this?

I have a weird issue that I cannot find more information on. This is popping every time I try to input new option to my multiselect field. I do not believe I reached number limit (I'm on pro subscription). Appreciate if anyone know what this is 😞 Error: pgl4I6ngheDLjVwFb 

Hello!We have a table that our team uses to keep track of tasks. I have another table in a different base where I keep track of our email newsletter schedule.  Base 1: Table = TasksBase 2: Table = Newsletter CalendarI want to be able to create a task for each newsletter and use the two-way sync to link the tasks back to the newsletter calendar. I've created a shared view in the newsletter calendar. What I'm stumped on is how do I add each of the newsletters as a task record in the task table. Is there not a way to import records from a synced base into an existing table?  

Amazing and wonderful Airtable support team: Please create separate section on the community here for the MOBILE apps. Currently there is no place to talk. I hope the reason why no board is created is because the mobile apps board would be the board where you see the most reports about bugs. There are so many bugs and issues in the mobile apps that listing of them would obscure everything else being discussed here. The mobile apps are so faulty, it’s a shame Airtable doesn’t work on fixing issues. While I was discussing with the support people they encoutaged me to switch to desktop because the mobile apps are designed for viewing only and not editing. Well that’s not the impression I’m getting from the apps description. There are bugs, constant crashes when editing records or adding attachments. The issues are persistent across wide range of devices and operating systems. The issues are ongoing and for long time … well specifically since Airtable released the FORCED update of the

Hi, A few days ago, the display of the timeline records has changed. While previously the details of the records were limited to the strip of the entry, now they go beyond that (see screenshots). The timeline thus loses a lot of clarity, which is essential for our work. Is it possible to change this back to the previous state, change the display or is there an update that restores the former state?

I have 2 tables where I am trying to count the number of times project date changed. Table 1     ID Project Name Created DateChange Code  1Project 13/2/2022Project Date Change 2Project 23/2/2022Project Date Change 3Project 33/2/2022Project Date Change 4Project 13/22/2022Project Date Change 5Project 14/12/2022Project Date Change 6Project 24/22/2022Project Date Change                Table 2    Org-unitProject name Primary Business UnitLinked field table 1 Project name Project Date Count AMER-Unit1Project 1BU 1 3AMER-Unit1Project 4BU 4 0AMER-Unit2Project 2BU 2 2AMER-Unit2Project 6BU 6 0AMER-Unit3Project 3BU 3 1AMER-Unit3Project 7BU 7 0In table 2, I have a lined field from table 1 project name. The value is blank. I use the following rollup command rollup linked record

So, I'm trying to add a day to the columns, but I need it to add exponentially... if you know what I mean.  It would be nice if we could click and drag like in sheets with this stuff. 

Hi all, Guessing this is a popular question, yet when I am searching the existing questions I've not yet found the solution. There's gotta be an easy fix.... right???  We've a base listing our clients. Each client might have between 1-3 staff assigned to support that client. For example: Steve, Jill, Carl supporting Client ASteve supporting Client BJill supporting Client CCarl supporting Client DIf I group the sheet by 'Assigned Staff' I get a list that looks Similar to above, but I am trying to produce a sheet that looks more like: Steve Supporting Client A + BJill Supporting Client A + CCarl Supporting Client A + DWhats the easiest way to achieve this? Would LOVE it if there is a known video out there that can walk me through the steps. ❤️   

I've run into a strange issue that I can't figure out. For one of my tables, when I right-click on a record and select "Duplicate" it doesn't do anything. On all the other tables, when I right-click and select "duplicate" it works just fine. Could it be possible that a certain field type stops records from being able to be duplicated?Has anyone run into a similar situation?

Okay - I've been going along and creating stuff for a while with Airtable.  I was a master at Excel and could link cell information into other sheets and such from other records.I've gotten where I am using Lookup within in a base between tables, but I am puzzled by a result that makes it very hard to wrap my brain around it still after three years - I still don't get this.  (And yes I have watched the videos, read the articles, searched the community, only to become even more confused.Base: PeopleTable A:  Basic Fields includePrimary field - Function (Last Name, First name)Last Name (Single)First Name (Single)Email Address (Email) Table B: DetailsPrimary Field - (Still not sure what to do here)Field: FullName - Linked  to Basics / Question 1: Why is the Lookup Field here?  What real purpose does it serve/used for? I end up hiding the field anyway and the end of the field rows.Notice btw I have Allow linking to multiple records turned off here.&n

Hello,I'm trying to find a way to be able to export a view in a .txt file based on a template.Example view:Template would be like:Hello {Name} {Lastname}, you are a {Age} {Gender}So the .txt file would look like:Hello Martin Shelvi, you are a 22 MaleHello Lara Croft, you are a 29 Female

Hi, we are importing data with a CSV and have a few fields with currency.On the CSV, the amount reflects in the following example:397,00 €, but when we import it, Airtable changes it to; €39,7000,97 €, but when we import it, Airtable changes it to; €97.00Our field is set on Currency and €1.00.Please see the screenshot attached.Please, can you help rectify the fields so that the amounts are the same as in the CSV file?Thanks

Trying to do an airtable base for tracking lease contracts information. On one table I have the contracts data: Client, date of lease, term, area, price etc.On another table I have inflation data. (Either CPI or INPC), Monthly data.What I would like to do is to get the latest row on inflation table (let's say April 2023) and divide that value by the cpi data of the inicial term date. (I tried linking the contract table with the inflation table and instead of having the date of contract I would select the correct date from the inflation data).I did get the original cpi data with a simple lookup but I don't know how to get the latest row data so I can divide and get accumulated inflation since the lease was signed.   

My first community post...In a table Results I have a structure like this:Category field selects from another tableProcess field also selects from another tablePressures field selects from a third tableEach row of Results has a unique combination of Category - Process - Pressures for which it provides numeric data (analysis results) in subsequent fields. How can I create a lookup with both Category and Process to  identify the Pressures and numeric results? Another catch is that Process is also dependent on Category, as not all Processes are available to all Categories.So ideally the user would choose a Category and then see available Processes. After selecting a Process, they get a report of all the Pressures with the numeric data in a report.Possible in Airtable?

i’m creating a database where one of the tables is “people.” currently i have it set up so that the primary field concatenates the person’s first and last names to become a full name field. i also have this linked to another table in the base so that people in the table can register for events by finding their record in the people table to associate with their registration. however, it just occurred to me that i haven’t accounted for the fact that people in our database might have the same name, which would make the primary field not unique. i don’t really want to add their record ID to the primary field formula, which is the easiest solution i can think of, because then people would see that when they register for an event & find themselves in the list. i suppose i could create a more complicated way to handle RSVPs where it comes into another table & then matches with existing people somehow (i know this is possible, but haven’t learned how to do it yet). is there an easier w

Alright...I think I'm being super dense here, but I can't figure out how to do something that is probably super basic.In this base : https://airtable.com/shrKq03xsOCwHUmbLWhat we have:Projects table; a list of projectsPeople table; a list of people, with some links where I can assign them to a role, a team, and a project. Lifecycle table; here is where I want to be able to automatically assign task ownership, due and actual dates (although I haven't bothered putting the date fields here yet), etc. This is the table where I am struggling, as I will describe in a bit.Teams table; here is where I am creating project teams, assigning them to specific projects (via links to Projects), and putting people on those teams.Tasks table; this is a preset list of tasks and which role on the team owns the task. For example, Task 1 is always owned by whomever on the team is the Product Manager. Task 2 is always owned by whomever on the team is the Program Manager, etc.What I am tr

SituationI've got a base (with 2 script extensions) which I share publicly and with all sharing options (copy data & extensions) enabled. The base is also not over it's extension limit in the workspace.ProblemWhen another user accesses this shared link and copy it to his/her workspace, the 2 scripts are there but their code is overwritten/removed with the default 'hello world' script.I do see for example this shared (vlookup example) base  where the scripts are working when you copy that base.Do you have an idea why it does not work for me?Do I need this deprecated beta to share extensions?Thanks in advance!   

I have a base that contains an address table with the following 7 fields.Field: Address Season   Value: Year Round. -  Gets mail there all year round   Value: Summer. -  Get mail there online the summer   Value: Winter. -  Gets mail there only in the winterField: Address Type   Value: Street  -  Street address and where they get their mail   Value: Mail  -  If they get their mail at a P.O. BoxField: Address  -  Street Address or P.O. BoxField: Address 2  -  Apt. #Field: CityField: StateField: ZipI need to filter in the following fashion:Where Address Season Is Exactly Year RoundOr Address Season Is Exactly SummerAnd Where Address Type IF (Mail, Mail, Street)Is there a way to do this?Thanks, Scott

I want to build out an employee database. What I'm starting to run into is having 5000 fields in a single table, based off of employee name. There's a lot of data that doesn't need to be together, so while I can create 20+ different views, it seems like I might be overcomplicating things. Basically, I'd love to be able to have my employees as a record, and have different tables perhaps that all organize around the employee record.For example:Employee->Personal InfoEmployee->Social InfoEmployee->Employment History InfoWhat are some good ways of trying to organize this data? 

Hi to all.Happy to report that when I asked ChatGPT for an app that will display reactive table views that will adapt to the display size, it suggested AirTable.So I prepared a gallery view with info that I want to share with my co-workers ( i work in the location management department in film).Designing was quick and easy. But then... the character size is so small on my huge Note 20 display. And the web links were not clickable. Any way to address these issues? I mean... it must be 6 pts size.

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