Base Design

I have a table of Contacts where one column is the Companies where these contacts have worked. The Companies column is a lookup column to a table of companies. Contacts might have more than one company that they've worked for. I want to be able to attach a year range in some way to the company information, so that I can see that John Smith has worked at Company X between 2021-2022 and Company Y between 2022-2024. What are some ways I can think about doing this?

id like to format my "price" field as follow : 100€ not €100How ? 

Hello all!  I need some help please.  I can work spreadsheets all day long but database creations is not my forte, far from it.  I started using AT a few years ago to track my business whole goods by serial number.  Thankfully, someone helped me here and re-designed the mess I had created.  It has been working great so far, but I would like to change the way I enter the data.Currently, I just use a main grid and enter all the information, it then populates to combine all the same parts together.  From there I have managed (with some help) to create 3 other tables, one for each manufacturer so I know what is in stock. The reason I want to change the design is I am much more busier with the business transactions and I'd like to reduce the redundancy that I find the current design has.  When I set this up, it was basic and understandable to me. The main table currently has model, brand, part #, serial no., accessory, ven

I have a CSV file delivered weekly with information about grant opportunities. I've been importing this file into Airtable, however, many of these grants include multiple submission deadlines throughout the year so I'm struggling to find the best way to be able to use the submission deadline as a true date field for sortability.The CSV file has a text-formatted column for dates. The cells also include "Submission: " before each date. I was planning on find/replacing out the "Submission: " text and then formatting the text as a date, but some of these cells actually contain multiple entries. For example:GrantDeadlineGrant 1Submission: November 15, 2024Grant 2Submission: September 01, 2024Submission: March 01, 2025Grant 3

I am mapping out the content in an academic program with the following levels:Program ObjectivesCourse ObjectivesModule ObjectivesAssessmentsI have a separate table for each of these levels.Starting at the bottom, an assessment in one of the courses is connected up to one more Module Objectives. Each MO is linked up to one or more Course Objectives. Each CO is linked up to one or more Program Objectives.I'd like to visualize these connections. It seems the flowchart extension is what I need, except it only works with self-linked records. In other words, I would need to combine all 4 levels into a single table. This is problematic because I need the levels on separate Tables. I considered copying/pasting the primary fields and the fields that link each to the other level over into a new Table that I could use for flowchart purposes. I haven't tried it to make sure it would work ye

Hi, Airtable community!I'd love to pick anyone's brains at how I've set up my base.The issue I'm trying to solve feels rather simple. I want to display my attendance record when it gets marked.My current set-up:I have two tables; One with a record of all my lessons, and one with a record of all my students. These tables are linked twice. One link shows students scheduled for the lesson, and the other shows students who attended. I have automations that let me add students from my scheduled link to the attended link with a click of a button in an interface.I'd love some thoughts on how to display the attended students. I could have an empty "attended" field on the side that fills up as I run my automations, but I'd like it to be displayed directly on the students already displayed with the "scheduled" field.Here are a few of my current thoughts. I could try colour conditions, but to use this accurately seems t

Hello!We have former users with Creator permissions that we would like to move to non-billable to save funds for a nonprofit.When we disabled a former "Creator" user, other users were no longer able to manage rows through a particular view or interface.How can we locate (and bulk move!) all created/permissioned collateral like automation, views and interfaces from one user to another?I could do this with a regular SQL database, however the nonprofit prefers for data entry using Airtable and thus I need some assistance to work within existing management tools provided 🙂Thank you!

Hi,I find myself needing to change at least single select values, and would like to know if there's a way to do that without breaking automations and interfaces?I e.g. have names of event types that I need to change, for example from "Discovery" to "Discovery call" or status kind of values like "Ready" to "Ready for invoicing". Any of these are used in interfaces and automations as discriminating variables to either activate automations or filter what is shown.When attempting to edit one, I get a warning of dependencies, but I can't understand whether the update would actually break the listed dependencies.Thankful for any help how to do this safely. I have a ton of changes to make....Rgds,Björn

I am looking at a way to deplete inventory of items when adding a kit to inventory. For example:I have 1 kit that contains 2 A's 4 B's, and 1 C. SO when I add a kit to my inventory, it removes 2 A's, 4 B's, and 1 C. How would I make this work? Thank you for any help.

I have a script that I'm having difficulties with. The script is part of an automation block which is triggered by a new record being added to a table called Projects. This record in the projects field has some info about it, (how many episodes, series number, etc) but crucially, has a multi-select field. The automation is supposed to look at the trigger record, which has a field for how many 'episode' records it should create, and then makes the episode records and links them back to the project. It is supposed to also copy the multi-select entries that are in the triggering record and make them the same in the newly created 'episode' records. But it seems to be failing at that, and I'm getting an error: Error: Field "fldYr1BVOeRj2DLLz" cannot accept the provided value. at main on line 43 Can anyone see from the script what might be the issue. The field mentioned above is the 'El

I have created a timeline that summarizes the data. Different ranges are colour coded based on conditions like less then 50 is light blue, between 100 and 200 is orange and anything above 200 is red. This means that values between 50 and 100 are not coloured.  The values are based on calculations in the grid view and sometimes they produce Infinity. This is desired as we want them to show as infinity instead of blank when people miss doing the data entry and we find the infinity makes this very obvious in the timeline view. Is there a way to define a condition that when the value is equal to infinity is become purple? 

I have an unusual filter requirement. So how I need this to work is: I only need to go into the view on Mondays and Tuesdays. The data will be imported in every Tuesday. Once that data is imported I need to see data from the previous week, For example I import the data on April 23, 2024. Then I need to only see this data between April 16th - April 22nd Then when I look at the view on April 22nd I still need to see the 16th-22nd of April. So if I import the data on April 30th I will need to see records between April 23rd - April 29th. If I look at the view on May 29th I see the 23rd - 29th. Is this even possible? Or what is the best way to achieve this? 

Hey guys,I am so excited about the updated Record Review layout, my team has been waiting for a way to filter and sort within the side record picker. I am trying to find a way to update my current record review layouts to use this new feature but can't seem to find a way. Is there a way to convert the old layouts? I don't want to have to rebuild my pages. Thanks!

I have a student financial table named OTA Financial where the OTA number and other information is manually added. That is synced with the Financial workspace tab in the student table. Then the students are connected through the OTA number in the main student table to import information from the OTA Financial.  I have spent several hours setting this up and connecting the OTA's.  They were working. Then the next time I go into the table it is not updating the financial workspace tab with the information that is listed in the OTA financial.  It is not letting me just sync the tables and I can't keep going over this and resetting it up every time I add a new person.  What the heck is going on and why does it not work over a period of days?

Hi there,I tried to empty the data in a certain view however that deleted all the information from the original base also. I am unable to undo the action, and when I look in the trash the information is not there either. The base still recognises that are 87 applicants from my application form, however there is no information in the base. I have also created a snapshot from yesterday, however since then more people have submitted an application form and so there is some data missing stillThanks in advance for any helpThanks in advance

I have seen the same question asked elsewhere (link below) but it didn't really deal with another implication of combining a table and separating items by a type record.My question is, what is the best practice for setting up a contacts table in Airtable where those contacts could be clients or suppliers etc. If I was designing this in a traditional database my practice would be to make 1 contacts table and distinguish these by a field that indicates what type they are. The advantage is I dont need to maintain all of the different fields needed for a contact across multiple tables. The issue with doing this in airtable seems to be that I cannot easily create forms to add a contact or add a supplier (where the default values are hidden from the user) and as a result I cannot seem to trigger any automations from these actions. I dont want to spend time working on work arounds to achieve what I would like to do.So what do most developers

My Production Schedule is synced to an external calendar subscription informing our entire cast and crew WHAT we're shooting - WHEN - but even though the physical address of WHERE we're shooting (i.e.: where they all need to be) - or even zoom hyperlinks (with the passwords embedded for virtual production meetings) - are detailed ON the customized labels, that doesn't transfer to the calendar subscription.All they get is an Airtable URL - and even if they click that link - it doesn't reveal the address - which is selected as an option for the customized label. What's the point of the customized label when it doesn't sync the info you select?How/where can I add LOCATION to my calendar subscriptions? 

Good morning. I would like your advice on how to handle my needs.I would like to create a CRM-like contact database called "Contacts".Then I would like to create a database "Event1" where people can submit a form and register for the event. Then in this database I would like to create other tables always referring to the event in question.I would like the contacts to be linked to event 1 if present in the CRM "Contacts" and, if not present, to create a new contact in "Contacts" with the data of the new subscriber.It would therefore be two linked databases. One is the contact database and the other manages the contacts for that single event, but connecting them to the main database.I hope I explained myself, I'm waiting for yours.Thank you!

I am building a base for client follow up. When our clients are a couple, they are entered on the same row in our main table. I have the client name column as a look up field in our Client Birthday table, so it pulls the name from our main table. However, in the Client Birthday table we need them to be on separate rows. Is there a way to use an automation or script to split the client names into two rows?For example, if we enter John Doe and Karen Smith on one line in our main table, could we make them show up in two rows in our Client Birthday table?Thank you!

Hello, I've been using Airtable to create VFX shot lists for feature films and scripted TV series.I find it very useful to display general information (VFX name, Description, Status, etc.), as you can see in the example below:But in some productions, they need me to add specific info for every VFX plate that is part of a particular VFX shot (sometimes it's just one plate, but in some instances there are many). This is pretty easy to achieve using Spreadsheet software (see below):But I'm having a hard time to replicate this simple organisation and layout in Airtable.As you can see, some fields are common for all three plates (Thumbnail, VFX Shot Name, Description), but other fields are specific for each plate (Plate Name, Video track, Plate Durat

I guess I just don't understand how/why Airtable is set up this way.If I have a Pro account.And another has a Pro account.Why can't they just SHARE one of their workspaces and/or bases with me - with edit access - without my having to pay a 3rd time?! To be a Pro user on "their" account?!That makes zero sense to me. ;-/ 

I have a table that has a column, lets call it Food. I want to create datasheets for the drop down options I have set up for the food column and I am looking for a way to cater a page set up based off what drop down option is selected. For example: There are two drop down options. Option one is Soda and option two is Carrot. Some important information about soda would be sugar content, manufacturer, calories, etc... and some important information about Carrots would be, pesticide use, region grown, etc... I have all of these bits of information created in my table and I now want to be able to print of datasheets showing the information. The problem I have is that I don't want to display the same information for both Soda and Carrots because only certain fields apply to each. So my question is, is it possible to create separate page designer layouts for specific field values in a table? If not is there a clever workaround I am missing to make it possible.&nbsp

Hi All,I'm trying to set up a resource tracker using the summarise function within the timeline view.In short, I want to be able take the days associated with a task and spread these across the length of the task. So if a task takes 20 hours and the task length is a week, then the summarise function would say 4 hours for each day and would group accordingly dependent on the scale we were looking at. I'll be grouping by individual, so want to be able to get this value summed across multiple tasks. This must be what the system is doing under the utilisation function, as it'll this to compare the available days to create the percentage, but I don't seem to be able to get it to work. When I go to summarise, and go to sum, it just shows me the total number of hours and doesn't spread the amount across the days. Crucially I don't want the percentage of available time used, I just want the number of hours themselves.  Thanks in advance!

Does anyone have any ideas on how to label relationships in this CRM we are building? We have multiple relationships we want to label such as spouses, siblings, advisors, parent-child. We also want it to work in the inverse so it shows that Sally is the child of Tom and Tom is the parent of Sally. 

I’m an Executive Director for a non-profit who uses airtable as an additional layer for grants and program budgeting.The primary piece of data/source of truth is our transaction details exported from quickbooks. There are linked tables for many things but specifically I’m looking for support on building out functionality for our Chart of Accounts related to our Programs and Staff tables.From Transactions Details all transactions are linked to the tables: -Chart of accounts (i.e. Wages, Taxes, Benefits etc…)-Programs (i.e. Events, Residencies)-Staff (i.e. Joe Shmo, Jimmy John)Specifically to figure out the budget for a program we need to take Staff - within the Staff table, and assign a percentage of time to a program (i.e. Joe Shmo spends 50% of their FTE on Events). Because we have man