Ask the Community

 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: '⠀⠀⠀⠀⠀⠀⠀Busines

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:

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!

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. T

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!

The interface makes zero logical sense.  There are no error messages.  The Help documentation is written for a specific example, not understanding of how to use the tool. The Interface is broken and non consistent.I'm a big advocate for Airtable, but this is just atrocious in design and implementation for something that is so simple in concept. 

I am building an inventory table for a company that I am integrating into their duda website to display their products. On the main inventory page, the "main" image connects to the gallery widget with no issue. On the dynamic page that showcases each individual product, I'd like to highlight the 6-8 additional product images that I've uploaded into a field in Airtable titled "product images". When I connect a gallery widget to this field, nothing appears. Is it possible to connect a widget to a group of images? If not, how can I showcase all images without creating a separate field in airtable for each on and then connecting those fields to individual widgets on the site? Image attached of my setup. 

Hello, everyone,We have already added one List page at interface designer.  Under the "User actions" section, we set the "Click into record details" and create one new Layout.   We set the field from "View" to "Edit". Now we can click the list row to slide new edit page, but we can't find the required field validation in edit mode.Is there any other approach to add the "required field" validation in edit mode?  You can find the the capture of record detail at interface page. Thanks very much !   

I'm trying to create 4 automations that update Field B when Field A matches the conditions [both are multi-select fields].For example, if Field A has any of Clothing/Fashion, E-Commerce/Retail/Wholesale, Entertainment & Sports, Field B should be updated to Traditional Industries. If Field A has any of DEI, Education, Government/Regulation, Field B should be updated to Service-Oriented. And so on.However, most records in my base fall into multiple categories, and Airtable is defaulting to the first automation listed. How can I adjust my automations to allow Field B to be updated with multiple options?

I have an automation that sends an email. Now to my question, when sending a message, there is always the sender's email address at the top and then the following (see attachment). Is it possible to remove the text highlighted in red?

I have a table that syncs from emailed data from CSV attachments. I need to be able to delete some individual records. (The data is not valid, and it's messing with roll-up calculations.) When I try to delete a record in the main record UI it's grayed out and says "To delete this new record, update this table's sync configuration so that records are deleted when deleted or hidden in the source." But I don't know how to get to the source since it's an emailed CSV? Can anyone advise on how I can get some records deleted from the synced table? Either through accessing the source data (how?) or through a script or API override of sorts? Open to any suggestions. TIA!

Is it possible to prefill and hide fields within forms in Interface Designer?Example... Hide and preselect project type based on where the user is coming from within the Interface DesignerYou can do that with forms outside the Interface Designer https://support.airtable.com/docs/prefilling-a-form 

Hello,I would like to know how to hide some options from a field in an airtable form.For example, my grid has a column that offers the following choices: "Office", "workshop" and "housing".In the form, I would like to display only "Office" or "Workshop".The reason for this is that this form is intended for people who are not supposed to be looking for "housing". On the other hand, in my overall grid, i would still like to see which actors are involved in "housing".How can i do that?Thanks a lot for your help,Pierre@Jeremy_Oglesby 

Hi All,I'm struggling with finding the right way to deal with multiple links between two tables.I have a Base with a People table, and a Milestone table, as well as a Teams table. Milestones have an Owner (link to People), and several teams (link to Teams table). Each team has a link (multiple entries allowed) to the People table. This works great for assigning people to different roles on each milestone and have a singular Owner who is leading/responsible for the milestone.However, I want to be able to go to the People table and have a list of all milestones a person is assigned to, no matter whether the person is the Owner or in a team. I have found a way to use a lookup to get all the milestones a person is assigned as a team member, but I need to add the Owner to this list. I don't want to do a simple formula doing a concatenate, because then I can't filter by People in the interface to show everything a person is working on in the calendar/timel

I have a series of automations with various linked fields, but there is one user action I am struggling to create. For some minimal context, this is for recording and calculating mineral amendments to garden beds on a small market garden.In a particular use-case, I end up with multiple records for each bed. When this happens, I need to be able to consolidate the records that share a common field (bed) into a single record. So in this case, the 6 records need to become 2 records (GH3 & Gh4) that have multiple "amendments" linked.Can anyone advise how to go about this?