Ask the Community

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).* Use checkboxes to select all the rec

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 even if it’s quickly reverted. However, Airt

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 can reach me at rashidazarang.com.— Rashid 

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?

Hi ,I'm based out of india and using Visa Card to upgrade from Free to Team License. I tried few times but I'm getting below error everytime "We were unable to upgrade you at this time. Please refresh the page and try again.".   I tried to refresh and re-do this transaction with other visa card, but that is also not working. Any help on how to get out of this problem would be great? 

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 text), using the

Bit of a messy title, I couldn’t think of a good way to phrase this question…I have a table that stores inventory items, each item can have one of three status’ “Available”, “Gifted” or “Sold”. I’m trying to create a view that only returns the name of an item where there are none with a status of Available. So for example the view shouldn’t return this item:But it should return this one Is this possible to achieve and if so, how?

Thanks in advance for posting your question! When someone provides an answer, **remember to mark their reply as the :white_check_mark: solution.**I have opened my app and it has reverted to a new installation. I cannot find my existing table. What can I do to retrieve my Old table?

I am reaching out here in desperation because the “contact support” feature in Airtable does not work at all in my workspace, across multiple browsers and devices. Firstly, my “Team” plan workspace has a base, and my base has a form. It is the only form present in the base.After the recent UI update, that form is not visible in the “Forms” tab on the top middle. The system pretends that my base doesn’t have any forms.However, I can still access the form via my bookmarked public link. Additionally, I can submit the form and it successfully will add a record to my base.I need to edit this form, but it is currently not possible to access the edit page of the form. Normally, I would reach out to Support about this. However, when I click the “?” icon on the bottom left and then select “Message Support”, it opens up a blank white rectangle on the bottom right of the screen that does nothing.I know from experience that this should be a chatbot interface. But instead, it is a blank white box t

I create a GDOC with MAKE I get fields from AIRTABLE and update the DOC I get the DOC link and put it in a URL field in the AIRTABLE record ALL IS OK till here I am trying to get the PDF export link and upload it to the attachment field in AIRTABLE, and it doesn’t work. I even tried a static PDF from DRIVE and it doesn’t work. Why?

I need to be able to print a form.  I have checked the user action “allow printing.”  I share a link with users and they do not see the three dots in the top right corner.  Printing using the browser print function is horrible. There should be a button to print the form or when you click the submit form button it should generate a pdf form that can be printed.

Hello, I have a table where all records are auto populated by a Webflow form submission through Zapier. Everything works fine except one small thing. Every time a user sends a form and the main text field has commas in it Airtable splits this record in multiple records. Example: Form Submission: Watchmen #12 "A Clock at Midnight, Its Face Running with Blood, Cover Original Art" Airtable Records: 1st Record: Watchmen #12 "A Clock at Midnight, Its Face Running with Blood, Cover Original Art 2nd Record:Watchmen #12 "A Clock at Midnight 3rd Record:Its Face Running with Blood 4th Record:Cover Original Art Is there any way to avoid this? I just want the first record not the second, third or fourth. Thanks

Hello,In an “Agent” table, there is a checkbox field called “Check.”I would like to be able to check all the boxes in this field at once for all the records displayed.I say “displayed” because sometimes there are filters based on certain criteria, and only the boxes for records that match the filter criteria should be checked.If you have any ideas on how to do this...Thank you.