Ask the Community

Hi, has anyone had a similar problem and knows how to solve it? I have a field in Airtable with links to images. When I share these links, people cannot access it because they are not AirTable users. Help!

Hello,In two different tables, there is a “customer” field linked to the “customers” table. This field can contain several customers (not unique).I would like to be able to copy the customer names from the field in table 1 to the customer field in table 2 without deleting any existing data, but adding to it. (Copying and pasting deletes the old data.)Example:Table 1: John; Paul; AliceTable 2: Richard; Linda; John After copying to table 2:John; Paul; Alice; Richard; LindaKeep Richard, Linda, and John, and do not duplicate John, who is in both tables. How can I do this?Thank you and have a nice day. Translated with DeepL.com (free version)

I’ve been exploring ways to connect Airtable with analytics platforms like Google Analytics or Looker for better campaign insights. Since much of my work involves managing projects in “digital marketing in Jalandhar,” having all performance data centralized in Airtable could enhance reporting and decision-making. Has anyone here tried setting this up? Do you rely on native integrations or prefer using third-party automation tools like Zapier or Make? 

H! I’d like to use AirTable to help prioritize a set of ~50 project ideas, soliciting input from 10-15 stakeholders.I’d like to let users rank the projects in terms of Customer Value and Strategic Alignment (fit to our organization) using a simple semantic scale (very low, low, medium, high, very high).A very efficient way to do this is through Airtable’s Kanban views, where they can drag each idea into a column representing that attribute, going once through the list for Customer Value, and again for Strategic Alignment.I’ve looked at examples of how to do group voting in AirTable through the templates and discussions in this forum, but they all seem to suggest using forms to capture input, sometimes one candidate at a time. This would require voters to open and submit 50 different form submissions.Is there a way to provide each voter their own Kanban view of the projects that allow them to drag projects around and have those actions save out voter-

Is it possible to export a list of record comments from a base? I need to be able to summarize and track comments without reviewing each record.

Hi! I’m building an internal interface for my team to manage tasks. While I love the clean look of Interfaces, it’s frustrating that we can’t manually reorder records (drag-and-drop) within a list or table.In the base view, we can reorder records manually, but in Interfaces we’re stuck with sorting rules or creation order, and new records always go to the bottom.For teams using Interfaces to manage workflows (without exposing the full base), this feature would be incredibly helpful.Are there any plans to enable manual ordering or drag-and-drop within Interfaces in the near future?Thanks!

Anyone else have issues with numbered lists in long text boxes in their forms?For a numbered list I would expect: But I’m getting this:  

I am trying to figure out how to build a workflow that would allow multiple user to approve a creative asset before status changes to approved.Right now I'm using a user column to assign an approver.  Then the record viewer interface to approve using a button tied to a status change automation. Ideally I would like to be able to assign multiple approvers and somehow only use the automation, once ALL approvers have approved. Thank you in advance

What does this mean?"cannot assign list of object to collection of complex types"I can't select any field values. And how do I make it so I can select it.  

I have a number of automations that have been working for years that suddenly stopped finding records as of the first time they ran in July. They were supposed to be looking for records in a related view, but were listing Condition Filters that had nothing to do with that view.I tried changing them to use Conditions instead of a View, and there were condition filters defined, apparently from copying another automation and then modifying it. They have been this was as far as I know from the beginning, but worked based on the View filters until July.I have cleared out the unused condition filters and am waiting for the first run in August to verify it is fixed. Just wanted to figure out why they used to work and quit without changes on my part.

Hi everyone,I’m hoping to tap into the community's wisdom here because I feel like I'm missing something obvious.I'm currently working in a base where I frequently need to link a large number of records from one table to a single record in another. For example, I just added 75 new [Tasks] for a marketing campaign and needed to link all of them to the one [Campaign] record.My current process involves either manually clicking the '+' and finding the record 75 times, or setting up a fairly clunky workaround with automations that feels like overkill. It’s incredibly time-consuming and prone to errors.This got me thinking about building a simple extension to solve this once and for all. Before I dive in and spend time building it, I wanted to ask if this is a common pain point for others too.Here’s how I imagine a simple tool could work:* Open the extension and select the table and view you want to work on (e.g., the Tasks table and the New Tasks view)

Ante todo, mucha gracias 🙏necesito que se cree un registro nuevo y se grabe de forma automática el correo electrónico de la tabla “usuarios” al campo email de otra tabla “test clientes” y no hay forma. Se crea el registro nuevo en la tabla pero no muestra el campo email. Me podrías ayudar.mil gracias 

Good afternoon,I'm trying to use Airtable automations to send an email to folks through my Gmail account. Airtable is directly connected to my Gmail account. The emails send successfully, but the problem is that when the email shows up in the recipients' inboxes, the sender name is just my first name in all lower case (e.g., "matt"), but I'm sending it on behalf of an organization. This is unprofessional and isn't what I'm trying to communicate to my recipients. So my question is:How can I change the "Sender" on these emails when using Airtable Automations to send emails through my Gmail account?I already confirmed my Gmail settings, my Google account settings, etc. Honestly, it looks like it's just pulling the info from my email address (e.g., "matt" from "matt@company.com").Surely there's a way around this???TIA,ML  

Hello,I would like to update the data in an Airtable table from an Excel spreadsheet.This is a “Customers” table (approximately 1,500 records) which includes a ‘Department’ column. The data for these “Departments” for each customer has changed, and the new values are in an Excel file.I would like to be able to replace the value in the “Department” field for each “Customer” with the corresponding value in the Excel file.If anyone has any ideas on how to do this...Thank you

Hi Airtable Community,I’m trying to use the prefill feature in Airtable for a form, but I’m running into an issue. I want to prefill a field that is a record selector, but the selector has a filter applied. When the filter is active, the prefill doesn’t seem to work as expected.Has anyone found a way to prefill a filtered record selector in a form, or any workarounds for this limitation? Any advice or examples would be really appreciated!Thanks in advance!Nico 

The user field options on our interface incorrectly display all previous accounts, even those that have been removed. This issue only affects the interface, not the data view. How can we resolve this.  

I’m seeing some sheets, owned by me and owned by others, but many I’ve created on worked on recently (even when I sort by most recently modified) aren’t on the list, even when I search by specific names, don’t show up in the list. I tried deleting cookies. Any help? 

I wanted to share a recent experience in case anyone else has run into the same thing, and if not, to bring it to the community’s attention. It’s one of those odd edge cases that can cause a lot of confusion when troubleshooting automations, and I think it’s worth having on the radar for anyone building complex workflows. Recently, I was troubleshooting an automation that ran in an unexpected way. While reviewing the automation run logs and the record’s historical logs, I couldn’t figure out how it had been triggered. The revision history showed no relevant edits, yet the automation clearly had fired. After digging deeper and testing different scenarios, I eventually discovered the cause, the collaborator had unintentionally undone an action almost immediately after performing it, either by quickly unchecking a box or pressing Cmd+Z (or Ctrl+Z) on their keyboard. Airtable’s automation system is sensitive enough to register the initial change

I’ve been trying to make a button that will dowload the attachment in a field and upload it to google drive. cant find the way to do it. I use intagromat but i get only file names not the actual PDF or Photo

When creating a trigger using the “When Record Matches A Condition”, is there a way to enter a table value into the matching field, other than a hard-coded value? For example, the table has 2 columns, [Cost] and [Original Cost]. Want to trigger an update when [COST] != [Original Cost], but it seems to only allow entering of an actual value. “When Record is Updated” trigger does work to accomplish this, but it can take about 10 seconds to update the destination field, and begins to execute the trigger the moment the value box is changed (If the value entered 100, it seems to run for 1,0,0 and then 100, as I can see the other fields updating with multiple values until the final value). Sometimes, if we type too quickly, it doesn’t update and will update based on “10” rather than “100”.

 Hi everyone,I built an MCP (Model Context Protocol) server that lets you query and update your Airtable base just by chatting with it; no scripts, no complex formulas.Try it out: Intro + demo: rashidazarang.com/c/i-built-an-airtable-mcp-that-lets-you-chat-with-your-database Live server on Smithery: smithery.ai/server/@rashidazarang/airtable-mcp GitHub repo: github.com/rashidazarang/airtable-mcp If you want to test it, share feedback, or talk about custom use cases, you c

Any plan to launch an Airtable MCP to allow us to manage AirTabLe from CLaude chats as efficiently as we’re currently able to manage Notion from CLaude?

I have created an interface with a grid of all my contacts and deals, not sorted or filtered in any way so that I can just go in and see certain records that I need.I created a filter for each of these lists and want to have the ability to filter depending on what I'm looking for at the time. However the filters I'm creating aren't dynamic.If I want to filter by "created date", I need a specific filter for that. If I want to filter by "Total Revenue" I need another one, and so and and so forth.Can't I just create one filter and then when I'm using it select which field to filter by? Seems awfully redundant the way I currently have to use it.

I'm building a script that will eventually be part of an automation to create records for upcoming coaching calls in one table based on conditions from a separate source table. We've successfully implemented a similar script and automation combo in another base, but I'm having trouble getting this one to function properly. When I run the script, no error messages appear, but none of the expected records are added to the destination table, despite the fact that the source records clearly meet the script’s conditions. I've triple-checked the data and logic, and everything appears to be in order. I'd appreciate help troubleshooting this issue and identifying what's preventing the script from creating records as expected.

I have a sign up process where users can invite other users to join their organisation. As such I have 3 key tables: Users; Invited Users; and Company Information. Users have a linked field to an Organisation ID field in the Company Information table so that the site can display information about the company they are assigned to. When a user invites a new user to join their organisation the Invited User table is updated with a new record including their Email, Name etc. anda linked field “Organisation ID, linked to the Company Information table. Then when an invited user signs up they are added to the Users Table and there is an automation that pulls over information from the Invited Users table like their access level and assigned Organisation ID. However, pulling over the Organisation Field results in a  "Field "Organisation ID" cannot accept the provided value: Cannot modify a computed field." error.I have tried changing the transfered value to a static value (plain