Ask the Community

Hello,I am attempting to use Airtable's Kanban board in Interface Designer to replace Trello. It's been going really well overall, however, I just realized that Airtable is not letting me change the order of cards in each column. Whenever I drag-and-drop cards up-or-down in the column, they just go right back to the exact same place and order that they were in before without any change. Does anybody know how I can update my Kanban Interface so that I can change the order of my cards within each column? This wasn't an issue until my lists of cards required a scroll bar.There's not a clear logic to the order the cards are in, however, it appears they might be displayed in the order that the record was created. If so, it would be surprising to me because Record Creation Date isn't a column I'm keeping track of, so I don't know why Airtable would sort by that.I added a screenshot from the Interface Designer settings showing that the data is set to "Sort" by "None"... so I think I "turned o

Suddenly my api calls have stopped working and getting error code 422 INVALID REQUEST.  Didnt change anything its the same requests that have worked for months and now nothing works

Hello,I'm experiencing a bug with some of my clients using Airtable on Android tablets. They need to update a "long text field," but they can't type in the field, even though it's configured as editable in the interface designer. It works fine on iPhones and Android phones, and everything else in the interface functions correctly, except for the long text field on Android tablets.Do you have any idea what might be causing this issue? 

Hi All,Hopefully, there's more help here haha.My automations have stopped working, I've checked the run count and its around 15k well below the max. During my search for support I found my next invoice has changed from $54 to $257.20!!!!! Now I definitely did not permit this change and I don't know whats changed since my last payment. I've tried getting in contact with Airtable support via the chat but its been 30mins with no response. If you have any potential answers I would be very grateful to hear them.

I using airtable's api by connecting it to front end in flutter and a javascript backend using vercel function,these functions are working in dev environment but not in productionfunction call in front end in flutterFuture<void> createRecord(String firstName, String lastName, String address, String phoneNumber, String password, String personalMobileNumber, String salary, String role) async {final String url = 'crmvercelfun.vercel.app/api/addemployee';// Prepare the data to be sentfinal response = await http.post(Uri.parse(url),headers: {'Content-Type': 'application/json',},body: jsonEncode({ "fields":{"First Name": firstName,"Last Name": lastName,"Address": address,"Phone Number": phoneNumber,"Password": password,"Personal Mobile Number": personalMobileNumber,"Salary": salary,"Role": role,}}),);print(jsonEncode({"First Name": firstName,"Last Name": lastName,"Address": address,"Phone Number": phoneNumber,"Password": password,"Personal Mobile Number": personalMobileNumber,"Salary":

Super strange but I have an issue with airtable at the moment. Links are not clickable in the URL field sometimes. This is specifically if the table cell size is small.It renders an entire webpage! How do I make this a normal link again so our users can actually CLICK on the thing?

Is it possible to create a base that pulls in different tables from different bases? For example, if there are 4 different workspaces (brand) with it's own unique base, and each base has a tab called "X" - is there a way to create a net new base or interface that pulls in "X" tabs from the different bases so that this base can see all 4 "X" tabs in one place?If yes, if/when any changes are made in "X" tab in the original base, will it update/sync with the net new base or interface? Trying to find a solution in Airtable that can help with increased team access and visibility across teams that work on different brands to minimize duplicative work and increase cross-sharing, thus improve overall efficiency and productivity. 

Hi Community, i have a single select field with the following options. I want to add up the results from different columns in a formula. To do this, I need to extract the score from the rest. For example, only “2” should be extracted from “2 More then 20%” in the formula.What is the best way to do this?   Thanks & bestMirko 

I want to create a form with pictures in every question. From what i can see this is not currently an option in airtable forms. What would be the best, ideally free, way to do this? I need the data to end up in Airtable - I know i can build the form in Google Forms, but I am not super tech savy when it comes to automations>Any advice welcome!

 Every line created in the gmail integration adds a paragraph, so when the email is sent, it created huge lines between paragraphs and adds space in between lines. You can see in the inspect tool screenshot attached, it's added <p> without me doing it in HTML inside the extension, so I can't see a way to turn this off. Has anyone had experience with this? I'd also like to add a signature with a photo, but that seems too much to ask at this point! Is there an extension that allows text rich emails? I've spent 4 hours + searching for a solution to this.Things I have tried- Zapier / Make - same clunky HTML email field, and cant seem to insert responsive personalised fields into the email.- Looked for an airtable extension in Gmail- tried to paste the email copy as long text in another table, but can't get responsive fields and it's clunky. Also cant do signature.  

I have a conditional automation. One of the conditions is that the actions only run if Formula = 1. However, airtable returns an error when this condition is included. The field is formatted as a number field. How do I get airtable to evaluate whether formula = 1? And why won't it do so in this set up. It seems fairly straightforward, so i'm surprise this is causing a problem. It's able to evaluate whether a formula = string.

Hello,I'd like to compare the date between two columns from the same table.I've used the chart extension but I can't seem to add it on my interface. Here is how the data looks like : Is it even possible to compare it on the interface? Or add the chart extension on the interface?Would like some help please.Thank you

Hello!Is it possible to enable the revision history to show exact dates (instead of "1w ago, 3y ago," etc.?I continue to run into this--where I am trying to find out when a change was made and I get these approximations. Hoping there is a fix for this or maybe it can be requested on future updates.

It doesn’t look like searching in a table searches the comments. Can you help or is this a feature you are adding? Definitely need full text search across everything

Hey All,This forum has been of great use to me over the years, and wasn't able to find evidence of this solution in existing posts, so figured I would share!When designing a multi-button script in the Scripting extension, I found myself wanting to make buttons with labels of different character length of equal size.Turns out Braille Pattern Blank (U+2800) is a good enough solution.  // Create the initial buttons let action = await input.buttonsAsync('', [{label: '⠀⠀⠀⠀⠀⠀⠀⠀⠀New Business in Existing Storefront⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀', value: 'New Business in Existing Storefront', variant: 'primary'}, {label: '⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀Business Relocated⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀', value: 'Business Relocated', variant: 'primary'}, {label: '⠀⠀⠀⠀⠀⠀⠀Business Expanded To Additional Storefront⠀⠀⠀⠀⠀⠀', value: 'Business Expanded To Additional Storefront', variant: 'primary'}]); You'll note that I added both value and label parameters to each button, so as to not have to include the spacers in

I have a form embedded on a wordpress/elementor page, and it is loading extremely slow. On some devices it takes up to 15 seconds to load. This is impacting my conversions.I already reached out to support, but while I wait for them to get back to me, has anyone dealt with this and found a solution? 

I am facing difficulty in prefilling forms with 'Link to another record data type'Data is occasionally getting printed when the data type is 'Link to another record' with 'Allow linking to multiple records' switched 'ON' What changes should I make so that it works well? 

Hi Airtable ninjas, So I'm trying to build out an application form for new workshops that my customers can submit to apply. When I get their application, I approve their application and register them for the workshop. This triggers my automation, where I want to APPEND the new workshop data to the existing workshops that the customer attended (this happens on my Customers table).I've set up my automation to trigger with the Application status being marked as "accepted", then I used the Find Records action to find the related record in my Customers table. Lastly, I used Update Record action to update my Customers table, specifically the Workshop Registrations field, where I want all historic workshop registrations of a particular customer. As you can see below, I first selected the field from Find records that contained the existing workshops of a record, then, I added another field that brought in the new workshop selected by the customer in the form:The problem is, the LAST entry

I'm creating an automation that uses Brandfetch to download logos. This uses the format: https://cdn.brandfetch.io/[company website] e.g. https://cdn.brandfetch.io/www.broward.edu/ However, when I use this URL to upload an image (or if I directly upload an attachment from URL), Airtable is getting confused by the ".io" domain. It thinks it's the file extension, and will upload an image of the brandfetch home page.I've tried doing a script and have the same problem. Something about this top-level domain is throwing off Airtable.Does anyone have a suggestion how to get around this?

Hi everyone,I need some guidance on designing a base to support the following scenario.My product design team is responsible for approximately 30 distinct products, organized into eight groups. We need to provide weekly updates per product to leadership every Friday. The updates will consist of a few bullets per product.I am not sure how to design the base (and subsequent reporting interface) for these weekly time bound updates.Any advice will be appreciated so much! Thanks for taking the time to read my question and thank you in advance if you are able to assist!

Table 1 is a database of completed projects, table 2 is a list of invoices. How do I have the linked field in table 1 link to the next available invoice # in table 2? The invoice #s cannot be duplicated and I’d like them to stay chronological. All of this is currently set up, but it’s done manually. First, by searching what invoice # is next then in table 1 under the invoices field, create a new record with the next invoice # in line. Is there a simpler way to do this? Table 1 Table 2

Hello everyone,I am trying to get my formula to recognize numbers >= $0.00 in all of the columns listed:  My formula: IF({August FY25 Projections},{August FY25 Projections},IF({FY Start Split Formula},{FY Start Split Formula},{Original FY25 Revenue Projections})) For reference:The August FY25 Projections column is a currency fieldThe other 2 fields are formulated fields with a currency format.Attached you can see the "Updated FY25 Revenue Projections" column is skipping over the $0.00 amount that is listed in the August field. This is incorrect and should have picked up the $0.00 amount as per the order of the IF statement. Any help would be appreciated! 

Once a week I want to email a report from Airtable to stakeholders (who don’t have Airtable logins). This report is based on rows created in a particular table in the last 7 days. Basically a filtered view of the table. The report could be as text, PDF, Excel or HTML. I have managed to use Zapier to send some data on a schedule. But the ‘Find record’ zap only seems to be able to find a single record. Ideally I want to be able to send a whole view or block. Any ideas? This seems like a fairly basic use case.

Hi all,I have two tables: Projects and Tasks. Each task has one or more municipalities. What I'd like to do is check if all the municipalities in each task associated with a particular project are the same. I initially thought I could do this with a rollup and ARRAYUNIQUE(values) and a comparison of the Municipality field with the rolled up field. As you can see below "Glenville, Rotterdam" is a match, but that is not what I am looking for. I only want a match if all the fields are exactly the same.Any ideas on how to achieve this? 

Let’s say I have the price of several items in column A, and I plan to add more items periodically. How do I create a field that automatically tallies the total of column A as I add each item? Thanks for your help!