Other Questions

Context:  I'm working on an Animated TV Show and have made a Base for tracking the Production.  The main function so far has been tracking all of the various Meetings/Milestones/Working Periods that happen within a certain Department.  I also have a Crew List Table and another Table that tags those Crew Members to specific Teams all within the same base.  I then have tagged those Teams to the Events that they're needed for, so I could add those people to Google Calendar for Meetings, but also to track what Teams are working on at any given time and what Milestones they have to be aware of.  One feature I'm trying to build is a way to quickly evaluate Time Off requests by plugging in their requested start/end for their Holiday and then seeing all of the Events that fall within that range - see screenshot for the filters I started with.Problem:  I had a Working Period in this instance (see screenshot), that the Team shown needs to be involved in, that w

My boss - who has been using Airtable with the rest of our team for years - has suddenly been unable to log into the site and gets a privacy error whenever she tries:None of the rest of our team has any problem accessing Airtable. She has tried using different browsers, clearing browsing data, and using incognito mode, all to no avail. Have any of you seen this issue before, and do you have any other recommendations? I created a ticket with Airtable support, but they seem to be particularly slammed at the moment and haven't responded yet, so I thought I'd try here.Thanks!Joel

I'm trying to set up a formula and could use some help. The first part is simple and is working: IF(Actuals <= {Approved/Expected Amount},"✅ On Track","❌ Over Budget") However I would like it to provide a different result ("Profit") if the Type of record is "Income" vs "Expense" and I'm having difficulty getting that second part to work. Any help is appreciated! 

Is it possible to disable CSV export for some users?

I’m using Airtable, but whenever someone tags me or mentions me I do not receive a notification. I may have unsubscribed from email notifications at one point. When i go to settings it still shows my notification settings as being on. Any ideas please :slightly_smiling_face:

I've been getting notifications from Airtable that I need to verify our domain (for enterprise). It says:By June 1st, your domain(s) will be disabled if not verified. If disabled:All users on your domain will be treated as external users and may not become organization members.You can neither configure SSO, nor require login with SSO on your domainSCIM cannot be used to provision usersI'm in the process of doing this, but if it doesn't happen by the end of the day, does this have access implications for my users? If they are treated as external, will they lose access to existing items?

I have two Tables in the same Base.One field in the table (APPAREL) should look-up the value in another (SC APPAREL SYNC)Here is the Field (TEST2) in the APPAREL table which should look up the SAMPLE COORDINATOR in the SC APPAREL SYNCAs you can see, every record in my SC Table has a value (no empties)As you can see... all records are empty in the APPARELThe field I am looking up is a synced field from another table. How can I fix this?

We cannot figure out the lost payments. All this time, access to Pro has been blocked. We have been unable to continue working for a week already.Please respond to our request:Your reference number is: 00564457

Certainly! Here are some ideas on how you can create a fashion pants community database on Airtable:Pants Inventory: Create a table to track various types of pants available within the community. Include fields such as pant style (e.g., jeans, trousers, leggings), brand, size range, color, material, and any additional notes or descriptions. This helps members discover and explore different pants options.Member Profiles: Set up a table to keep track of community members who are interested in pants. Include fields such as name, contact information, preferred pant styles, size, and any specific preferences or requirements. This allows members to connect with like-minded individuals and exchange recommendations.Pant Reviews: Create a table where community members can share their reviews and opinions on different pants they have tried. Include fields for the pant brand, style, review rating, fit, comfort, quality, and any other relevant comments. This helps members make informed purchasing

I am trying to upload an attachment and I am unable to do so.  If I am on another machine, I can upload an attachment by either clicking on the + button or by dragging and dropping a document to a record.  I have checked the permissions, checked in another browser and cleared the cache for the browser that I am currently using and I still end up with the same results.  Please advise on what I should do next. Thank you,M

I’m trying to create a Single Page App in Airtable because I want to be able to change which components are displayed to the user dynamically. My approach is to use react-router-dom’s MemoryRouter, NavLink and Switch. Here is my code. import { initializeBlock } from '@airtable/blocks/ui'; import React, {Component} from 'react'; import { MemoryRouter, Route, Switch, NavLink} from 'react-router-dom'; import ReactDOM from 'react-dom'; class Home extends Component { render() { return ( <div>Welcome to Home page</div> ) } } class About extends Component { render() { return ( <div>Welcome to About page</div> ) } } function MyApp() { return ( <MemoryRouter> <div> <NavLink to="/">Home</NavLink> <NavLink to="/about">About</NavLink> </div> <Switch>

Hello,I'm a fresh user of Airtable. During Pro trial I created some basic table with a form for people to sign up for an event. To avoid any accidental changes to the form after it was shared, I locked that form.Now the trial period has ended and I cannot unlock the view, or even delete it (after duplicating).In all the places that allow for unlocking the view, the option is gone. When clicking on the view's bar on the lock icon, then "Locked view / Collaborative view", nothing happens.This means that I cannot e.g. stop accepting entries. Link settings cannot be changed. The view cannot be deleted.I wrote to the support, but I'm afraid of being forced to pay $20 for Pro just to unlock one form...Any other ideas on what to do? Thanks

I've been running a form for 2 years and a few weeks ago I stopped getting email notifications when a new response was submitted. I've gone in and toggled on/off on everything but it hasn't changed.Any one else have this problem?

Hello, friends.I have two tables. Unfortunately I can't change how they're structured, or I would. So I'd love some advice on getting what I need from this setup.The first table, "readers," shows a "profile owner" associated with a "branch." Then there's a list of readers in the third column, titled "reader name." I need to associate those readers with their branch so I can show how many readers there are per branch in an interface report.The second table, "totals," shows an aggregate of how many readers are associated with each profile owner. But in the "totals" table no branch is listed.I'm hoping that I can choose "totals" as the source for my "readers per branch" element by matching "first name" to "profile owner" from the "readers" table. This would create links between "number of readers" in the "totals" table and "branch" from the "readers" table.I hope I'm explaining it well. It's complicated. I searched through the community, help docs, etc. to no avail. Perhaps one of you can

I'm encountering an issue while trying to download and attach images from Airtable to my Rails application. I'm using a rake task to transfer data from Airtable to my PostgreSQL DB and everything works fine except for the image attachment part which happens through Cloudinary. I need assistance in resolving this problem.The main problem is definitely downloading the attachment from the stored URL in my attachment field to then have a valid image file (.jpeg format). Has anyone experience with this?The issue I'm facing is that when I run the rake task, it throws an "Invalid image file" error. I have checked the URL and confirmed that the image is accessible. I suspect that there might be an issue with how I'm downloading and validating the image file.I would appreciate any insights or suggestions on how to resolve this problem. Thank you in advance for your help.Best regards,Lis

If I create a View Share link in Airtable and email it to someone so that they can see my view, will that person be prompted to first create an Airtable account? Or can they just view the link (as I had intended...) by clicking on it? 

How to delete ( " ) input, when the other input a wrong format. i try delete and reinput, but it seem i can delete ( " )

It's a bit of a silly question, but I am a little alarmed that I have used up 39,000 automation runs out of the 50,000 available for my workspace ( I am on the pro plan ). Just wondering if it renews monthly, and how can I add more if I need to?My business is expanding and the amount of automations might reach the limits eventually, there should be a way to add more runs separately hopefully? 

I have 3 tables:1. A Contacts table - lists each contact, their email, their phone number, and their Company. 2. A Company table - links to all the Contacts for that Company.3. A License table - lists all license numbers, their expiration dates and links to the particular Company the license is for. I was able to use a lookup field in the License table to figure out who the Contacts are for that particular Company. Is there a way for me to pull those Contact(s) email addresses into another field in the License table? Or do I first need to use a lookup within the Company table to lookup the emails of all the Contacts associated with those companies, and then pass it over to the Licenses table with another lookup of the Company table? 

Hey AllI have a business producing about 10 000 records a month, that's going to double in a few months. Will it be feasible to create a new base each month and move the previous months data to a "backup" base?Thanks in advance!

Is there a way to choose a multi-select option more than once? For example, if I have a list of A, B, C, D for a job, and that job requires 3 A's and 2 C's, is there a way to choose those options in the multi-select more than once? Right now I can only choose A once and C once. 

I have been using Airtable for a while now and have quite a good grasp of how I can use it. But somehow I can’t seem to figure out how to track my different social media stats in the best way. In excel I would just have a row per stat and a column per month but that is hardly effective now, right? Who has a show and tell for a great stats tracking base?

I'm running into a problem. I have a "projects" table and then I have a "tasks" table. In the tasks table. Within the tasks table, certain tasks are subtasks/child tasks. Under each project, the tasks for that project appear. I have nesting enabled. The nesting works for the parent/child task. But the child task appears twice in the same list both as a subtask/child task as well as a parent task (without subtasks). It isn't a duplicate record. It's the same record. When I make changes to the record, the same change is immediately reflected in the alternative record. Not sure why it is doing this.

HiIs there a way to send a record by email (manually not an automation) that does not show the titles of each column if it is an empty field? Even if the column is hidden it still comes through on the email.To explain further, I'll have a meeting to present concepts, each meeting I could show between 2 - 10 concepts and for each concept there is a name, image, description and link. My problem is that I need to set the table up for the max number of concepts shown and then I email the client after the meeting with the record of what was presented and all the info for each concept. If I send the record with just 2 concepts the email also shows the title of each column which is empty making it appear as if there is info missing. i.eConcept 3Concept 3 descriptionConcept 3 link etc etcIf someone could help me please I'd be very grateful. Many thanks 

Greetings all, I am building a non-profit membership tracking system that pulls in new member requests from our Mailchimp list and invoices from our Xero system. I am used to the standard unique key, foreign key database structure and am struggle a bit to understand Airtable’s relationship structure. As of now, our mailchimp list and xero invoices link OK on somene’s primary email address, which is my unique identifier for the Contact table. I realize that if they change / udpate their email address (which happens), that connector will break. It took me a long time to realize that the first column of each is automatically the “unique” ID, even if it allows for multiple identical string entries. So, originally I had full name as the first column, but John Smith and John Smith can exist and are not the same person… which screws up the linked tables. “Name” + “Company” (or any secondary field) doesn’t work well either, as often times people don’t fill out too much in the forms. Phone numb