Ask the Community

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!

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!

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/timeline/lists.So; How do I combine

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? 

Hi! Is it possible to add a new record to a synced table but it not be added to the original synced source? If it is possible, can you tell me how to do this? Thank you!

 In an interface, I have a form to add diligences. And inside i have a field to choose the author from a limited view but when we want to choose the author there is no item to choose. It was always working until today I have the same trouble in other forms since today.Is that a bug?

Brand new to Airtable, so forgive me if this is a dumb question.  I've shamelessly stolen a formula to calculate start and end dates based off a T- or T+ from a specific event. DATETIME_FORMAT(DATEADD({Calculated End date},{Days Needed to Complete},'days'),'MM/DD/YY') The dates are calculating just fine, but when I try to add a Gantt view, it doesn't allow me to choose these fields to determine the dates for the Gantt.  What do I need to do to have Airtable recognize the output of this formula as a date?

HelloI am beginner using airtable.I would like to make automation when create calendar event. There is configuration place for Google Calendar account in trigger details. Is there any way to do dynamic in that configuration for multiple account.I would like to do automation for multiple account. Thanks in advance.

Hi all!I have a list interface and I use two tabs all and focus. I know that a tab is essentially a predefined filter. But on top of the filter I want to have predefined ordering as well, e.g. the tab all ordered alphabetically and the tab focus by creation date. How can this be done?Many thanks for suggestions and comments!