Ask the Community

Hi! I noticed the following bug in airtable. The formula that I actually paste in a formula field is not getting saved . Here is a proof of this.:https://app.screencast.com/8pYl20QKMc0fM?conversation=yInYcEQeuFQHhsuAgeFxWNIf you have a solution for this please let me know. 

Hey there, I'm new here and I'm trying to access Airtable Academy (yes, we do have a Business plan), but the page doesn't open at all. Am I doing something wrong or is Airtable having issues with Airtable Academy today?Thanks,Carina.

I have been staring at this too long and thinking myself into circles, need some fresh eyes! I have a base set up with 4 linked tables: schools, which are then linked to 3 program tables for SFS registrations, YF events, and Grants (2 sub-programs, AP grants and YF grants). The overall structure:  Each time a school participates in a program, a new record is created in the program table and linked to that school. A unique record name is generated indicating the program, year, and a unique id # (e.g. SFS-23-24-001). All of this is working great - in my schools table I have nice linked fields for each program where I can see what a school is up to. Awesome! Love it! Where I'm getting myself confused is zooming out a

Hi everyone. I am trying to set up an automation where when a diagnosis field for a trip in one table is updated it finds the corresponding person (that is connected) in another table and updates a diagnosis field in that table where only different diagnosis is entered. Attached is what I have started. It doesn't run. I tried adding a find records step but couldn't configure the condition (screen grab also attached). Suggestions please!

Hi Airtable Fans, what I am going to ask will sound crazy, but bare with me :grinning_face_with_big_eyes: Sofar, Airtable has been a fantastic ace in my sleeve to build prototype and MVP (minimum viable product) applications faster than any of my colleagues can spin off a Java Virtual Machine. Saving, malaxing and serving data with Zapier and co. is absolutely fantastic. Some of those prototypes even landed “in production” and are still in use today because rewriting them “for real” wouldn’t have a high enough return on investment. Big THANKS to the Airtable team for that! Right now, I am facing the next challenge. The next prototype I’d need to validate a business application idea with, would require some kind of user- and user-specific-data management. And I have no idea if and how I could do with with Airtable. To make it easier to understand, let’s take the idea of a todo list. How could I create a distributed, mutli-user todo-list ap

Hoping someone here has the missing piece. Goal: In an Airtable form when selecting the Other option to a pre-defined list of options, and entering a single line text for that option, that text then presents in the original table with the other pre-defined options for future selecting. I have:Table 1 that populates via a form built in Form View. The form asks for the submitters State.Multiple tables that are predefined lists of Group names based on State. For example one table is all CA group names, another all MA group names, etc. Each table has an Other option.In the form when someone selects a state, the respective table of their state's Group options presents. If they select Other a single line text field presents to add in their required response. That  is working correctly. What is not working correctly is the aut

Very new to AirTable and I'm working in a file created by someone else. Right now, I need to know how to move a row. (The data is in Alphabetical order, and one entry name has changed. I need to re-order it. I just want to drag the row to a different place but it doesn't work)Also, I have grouped the data but can't seem to UNgroup it! The chat bot said to unselect the grouping criteria, but there is no way to do that. Help!

The List interface allows for Grouping of fields within records - which makes it visually much easier for users when records have many fields.Is this available for other types?  I would like it on Record detail but cant make it work.Margaret  

Hi,Our process includes creating hundreds of Google Drive folders for client sharing during a year. This is now done manually, and I am looking at automating it if possible. Ideally a trigger in Airtable would the use some information identifying the client, create a Google Drive folder, make the access "Anyone with the link", fetch that link back to Airtable, and send out an email to the client.Alternatively, Airtable would be watching a specified Google Drive directory for creation of new directories, then initiate the process of changing access and pushing the link to Airtable.Any ideas?Rgds,BjörnPS. We use Zapier, so that is a viable option for us. For cost and maintenance reasons I'd like to avoid other 3rd party systems.

Hi,We need to collect longer testimonials (round one A4) from hundreds of clients during a year, process them (re-write and polish before publishing) and have the clients approve the edits.Ideally I would just create fields for this in Airtable (draft -> approve button -> final -> published), but to my understanding Airtable doesn't allow free user to edit anything sent out form the base. And forms are made to be one-to-many, not enabling a form per client to be sent out, non?We use Google Sheets so I somehow vaguely think this should be doable with some creative Sheets integrations, but I can't envision it concretely.Anybody out there who could see this clearly, what would be the elegant and robust way to do it?BjörnPS. We use Zapier also, so that is a viable option. For cost and maintenance reason I'd prefer not to use other third party systems.

Hello, I'm trying to compare "name" field between two different tables and trying to fetch records that matches both.Table 1 - Name, Table 2 - Legal nameWhat's the best method to achieve this? (New to Airtable)

I've built a scheduling app on the Airtable interface. While the interface is ready I realised I cannot give open access to users to use my app as they all have to be on my paid plan from my understanding. Can someone guide me on how I should make it accessible to all. I thought of setting up authentication in bubble and embedding the interface there with forms so that the user can update the info but I cannot find embedding code for interface without making it public. this is urgent please

Hi all,I have met an issue where i've created an interface page that can be drilled down to a record detail. However, although i can see the fields perfectly fine, my team mate who has editor permissions only sees the fields as 'deleted' and I'm not sure what the issue is.  This is what my team mate sees. This is what i see.I have re-shared the interface with her, edited her permissions, created a new record detail page but none of it worked so far. Did anyone else encounter this issue? How did you resolve it? Thanks in advance! 

My colleague and I are trying to build a base where we can compare the payroll data from a csv. file (outsourced data) with data we have already stored in Airtable. We would like to compare the expected payrate we have stored in Airtable to the actual pay in the payroll report csv. file. We are having a difficult time figured out a way to compare two tables within the same base. We are importing a new csv. file into a table every 2 weeks and then we have a second table where our stationary data from Airtable lives and we hope to cross check both of these tables to make sure everyone is receiving the correct anticipated pay and if that is anticipated pay is not aligned with the expected pay then creating formula that would indicate to us that the amounts do not match. We were wondering if there is anyone out there who has any advice for comparing two sets that are on two separate tables but within the same base and creating a way to indicate to us the mismatch

Hello, I'm trying to import csv files into existing tables and wanted to perform upsert/insertion of only new records by comparing it with the records in the existing table.I'm using import csv extension to accomplish this, but ended in duplicate records for some rows. The merge operation is not accomplishing the task of avoid insertion of duplicate rows if its already present in the existing table.Message: Detected records with merge field value "". All matching records will be overridden to match the first matching row.In this case, its neither overriding nor avoiding the row and inserting both two rows with the same value resulting in duplication. The Merge column chosen is unique.Can someone assist with this issue.

Hi. I'm new to airtable, but I have a background as an ERP developer. I'm doing baby steps on my application to see if I can get airtable to help me manage a member-run makerspace. Currently I do it with excel and google forms. Hopefully this is something easy to do with an automation, but I'm very green at present.I have google sheet that gets filled in each time a person fills out a google form, including their photo that is stored as a url to a google doc folder.  When I import the data from this google sheet, I can assign it as a url, but is there a way with an automation to take the URL and add it to the record as an attachment?  The end result is that I want to be able to send out a form to the board members to approve, along with the photo of the applicant, if they submit one. Currently I can do this in google forms, notifying the board via an email, but this is the first step of converting our system to airtable.Thanks in advance.Jeff

Hi, I'm setting up an automation so that a webhook from another app (Instantly) triggers it. Webhook contains 'email', 'label' and other values. The goal is - when LABEL is added, it should create a record or update the existing one.I want to set up the following but so far failed:- After the trigger of adding a label...- If a record with the same 'email' field doesn't exist - create a new record.- If a record with the same 'email' field exists - update the record and its label but DON'T replace the old label - just add the new one in the same field with the old one (multi select)-----I think I managed to set up the updating part (pic below) but I don't know how to prevent overwriting the 'label' field when the record with the same email exists.Any ideas?Thanks! 

I have 2 automations that takes ~2500 new records. The first one clears the link field and links them to their matching records in another table. The second takes all of the ones that failed in the first automation(these failures are due to the imported list having items that dont match up cleanly and need to check another field) and ADDs them to the link field.These work >95% of the time. My issue occurs because so many automations run at the same time and some of these records need to link to the same record in the second table. This causes them to overwrite each other. I would like to find a way to slow this automation down and have it run in chunks or even 1by1 since it doesn't take too long per record. Does anyone have any ideas on how to trickle this automation or break it up into chunks?

Anyone have any experience with geocodeing? I’m working with Airtable and Integromat to try to create a few integrations with location data that I’m collecting in airtable. I’m looking to be able to geocode or reverse geocode any record in a table. I have a webform that will detect and capture gps coords if available, or the user can hand enter an address. When capturing the data I would like to use integromat to to geocode or rervese geocode so that the database contains both gps and physical addresses. Another thing I’m hoping to figure out is how to do route planning, which I believe is possible through the google maps api, given a selection of addresses. Does anyone have any examples or experience here they could share.

Hey guys,I'm totally new to Airtable and just trying to find my way around. I am or was a private Notion user for a long time, but was looking for a DSGVO-safe alternative with end-to-end encryption for a simple database or customer overview. Currently, however, I can not yet implement the idea, which I have in mind. I imagine the following scenario:I have a "customer database" where I can store all customers with name, address and contact details. The respective customers I can assign a "tour", that would be either tour 1,2 or tour 3. Tours because I drive out food and have 3 different tours, on which different customers are waiting for me.It also happens that a customer appears several times a week in the same tour. I would like now that I have created in addition to the "customer database" 3 times the respective tour as a calendar view. In the calendar view I would then like to assign the customers from the customer database to the respective delivery date.

Hi everyone,I'm having trouble accessing Airtable Academy. Whenever I try to log in, I get the following message:Sorry, you do not have access to this page.I've attached a screenshot of the message below.Has anyone else experienced this issue? Does anyone know what might be causing it?Any help or advice would be greatly appreciated!Thank you!

Table A is a list of customers and each item they bought. I have a Table B where every time a new customer is added to Table A the customer name and a few other columns are added to Table B. If a customer buys something but the customer name already exists in Table B then nothing happens. Feel like this should be easy but can't figure it out...    

I want to add a button field that will open one of two page design extensions, depending on the value in a particular field.  For records with value 'INV' in that field I want to generate one page design extension; for records with value 'ILL' in that field I want to generate a different one. I have created two button fields, one for INV and one for ILL, but I cannot see how to only show the appropriate button depending on whether the record is marked as INV or ILL. I tried a formula field but this didnt work. Any ideas please?

I run a research lab. I'm setting up Airtable to manage purchase requests and inventory. I have two tables:1. Purchase Catalog, with fields 'Item' and 'Current Stock'2. Order Line Items, with relevant fields fields "Quantity' and 'Status'. 'Order Line Items' is a table that represent specific instances of wanting to puchase something. Purchase Catalog represents different items one would purchase. The two tables are linked. When we received an item, I will change the status in 'Order Line Items' to 'Received', at which point, I want the field 'Quantity' (from Order Line Items) to add to the value in field 'Current Stock' (from Purchase Catalog). I asked ChatGPT to make me a script and it looks like it would work but it's not doing anything to change 'Current Stock'. Could someone help me figure out how to do what I'm seeking?

Hello - I'm VERY new to Airtable, though I think I have a basic understanding of databases.  I'm looking for examples, templates, pointers to further help.  Or even the right terminology to use.While I want to create a larger base, I got started with a simple event tracker (types of events, different leaders, different sponsors, etc.).  Now I'd like to expand this to keep track of who has attended AND enable some options for adding the list of attendees and querying.Adding the attendees seems fairly "obvious" - table of people; table of events; table of attendees (people + event).The thing I don't know as is how to make this easy to use - how to get data in easily AND how to query easily.  The obvious thing for data entry is to type into the table or a form.  But what I'd love to be able to do is send an (structured?) email with the event information and list of attendees.  Maybe even forward the meeting invite?And on the que