Ask the Community

Has anyone been able to successfully use the Airtable API Request action in Zapier to make a PATCH request? I was able to get it to work for a DELETE request but no matter what I do the PATCH is returning “The app returned "Could not find field "fields" in the request body".”. Even when I test with something simple n the Body like like {"fields": {"Name": "New Value"}}Am I missing something obvious or could this be an issue on the backend? 

Hi, is it possible to sync a Firebase database with Airtable? I want to use Airtable as a way to support additional workflows but also update the original Firebase collections with any changes made in Airtable.

I’m looking for a consultant to help customize my Airtable  project. I’ve started to build my list of team member and each task for them to do but want to have them using a simple interface for their job, keep track what has been done or not ect. I’m on EST time zone will pay $50/h, I’m estimating a 4 to 5 hours.

Hello, We are considering using Air WP Sync to sync data with our website for things like a directory, conference agenda, etc. However the Air WP Sync screenshots are only of the admin functions. For anyone currently using it- are you willing to share urls or screenshots of your pages?Thank you!

We have a variety of projects and ask teams to log their cumulative monthly hours worked for each project. We have an "Hours" table where each row is associated with a project, a month, and a year. Then the team goes into the table to enter # of hours worked for each project. I have the table grouped by month. For example, the grouped field for January 2023 group has a list of 8 projects:TeamMonthYearProject# Hours WorkedOperationsJanuary2023Project A 

Can Airtable manage version control with attachments to ensure that when a file is replaced with the new file, only the new file is visible or clearly identified as the current version whilst retaining access to historic versions?Any best practise on how to set this up or use some form of approval work flow? Thanks, 

Hi Airtable!Can you please give the community an update on when dark mode will be implemented in the upcoming New Feature Spotlight on March 8, 2023?Maybe it could fit in the visibility section of the presentation.We're waiting. And we're not recommending this app without it.

I’ve managed to get Markup URLs {[Text](URL)} working when sending emails by automating a field to be written with an automation. However, I’ve lost the ability to separate lines in the email. So, this automation:Gives me this (one is grid and one is line):Any thoughts on how I might be able to throw a line break between these items?

Hello, I work at a nonprofit using Airtable’s Team plan. We recently had a coworker leave but she didn’t delete her account before she left and I’d like to delete it now so she no longer shows up on our user drop downs, etc. She now has read-only access to everything she was formerly editing, etc. so she doesn’t show up on our billable collaborators list. Is the best way to have her account deleted to reach out to support? Is there any other way we can close down her account? Thank you for your help!

How do i filter records with same tag (like status = ‘Active’ in a multi-select column) inside the multiple tables ( within the same base ) ? I want to see the filtered records in another view maybe ?

I set up automations for my team so that the next person in the workflow gets notified when the previous step in the process has been completed. However, since I set up the automations, they all come from my Teams account. Is there a way to change this so that the person who enables the automation “sends” the message? 

HI guys, I’m trying to use the Concatenate function to help with my primary field names, but the date I’m pulling in from a ‘date’ field is a little messy. Here’s my formula... CONCATENATE(Client," ",'|'," ",{Month Date}," ",'|'," ",{Record Type}) And this is what comes back…Crystal Maze | 2025-09-01T00:00:00.000Z | Income - Forecast Is there a way of amending the date format within the concatenation formula?  Ideally it would look something like this…Crystal Maze | Jul-25 | Income - Forecast Many thanks in advance!

This automation is designed to automatically update two fields of a newly created record submitted via form. Neither of the fields being updated by the automation is "Formula Name", which is the field that appears to be causing the failure. Anyone have any idea what is going on here?

Hi Airtable builders! As I needed it, I created an app (SyncBase) to do real-time sync between Shopify and Airtable. It turns out that hundreds of Shopify merchants are finally using it.Today, we’re releasing a key feature: Shopify metaobjects sync with Airtable.  You can now update your metaobjects entries (it syncs both way) and even create ones from Airtable.If any builder of the Airtable community is keen to try it, just ping me here. I’ll let you access to the demo.🤙Théau

I have several automations set up to send emails through gmail based on certain conditions (dates coming up, status changes, etc.). They have been working like a charm until yesterday! 2 different gmail accounts should have automatically sent 200 or so emails each. 1 gmail address seems to have worked fine. The other sent maybe 5 or 6 of the emails but not the rest. However, the automation log shows all 200 were successful. I know they didn’t actually send because I have the emails BCC myself, to ensure they show up in my gmail account. Now when I am testing the automations, no emails are sending, even from the address that worked yesterday. I tried relinking the google accounts to airtable. No dice! Any ideas??

Hello everyone,Any clarity or information on this time and date issue would be awesome!I have 2 tables which are linked through a record. In each table, I have a formula field which produces a date. I need the dates to match. Unfortunately, the formulas are not the same. One is based on a date field in the first table and is a dateadd formula. In the second table, it is a createdtime formula. On the first day of operations, the date is submitted through a form to the date field in the first table. The formula field in the first table adds one day to this date so that process which happen on the second day are kept track of. In the second table which keeps track of the processes which happen on the second day of operations, I have the createdtime field. I need this field to match the dateadd field so that I can automatically link the records. However, something is happening with the formulas such that they are not the same day when I want them to be. Does anyone know ho

 I am looking for the best way to set up an Airtable to keep track of a lot of book publishing details with minimal repetitive data entry and as human proof as possible. I’m on the free plan.  The situation:I have several book series (Power of Five, Dragons, Talonswood, Trident, Draken). Each book series has multiple books. Each book can be published in multiple formats (ebook, paperback, hardback, discrete paperback, discrete hardback). Each book is being translated into multiple languages (English, German, French, Italian). After translation, each book, in each format, needs to be uploaded to several platforms (KDP, Kobo, Ingram, Tolino, D2D). Not all books get uploaded to all platforms. For example, English language books don’t get uploaded to Tolino.  I need to somehow keep track of this mess so me and my assistant know what’s been done and what hasn’t. Also would be good to keep track of an error log so we know what’s needs to be fixed. 

Example Of URL/Link in email thats broken, and I need help fixing: Image 2021-02-11 at 10.40.0... Use Case: This email gets sent from an air table automation. The URL is from a field in my table that I’m using CONCATENATE to dynamically add an email to the URL. DT HR: General Phase 1&2 - ... When I click on the URL in the cell in airtable it works. Example: docs.google.com

Hi there!I want to transform a ChatGPT output (30 words/names) into a multi-line column (30 lines) in Airtable. I'm using Make as my automation engine and its Iterator module. I'm having trouble finding the right array formulahere is the one I have: split(trim({{5.choices[].message.content}}); newline)It would be awesome if someone could help me!! 

Hello,Quick question: when I use a record picker in an Interface, why can I create a new linked record… but not pick an existing one?It is called a “picker”, right? 😅Context: I’m building a CRM to manage photography projects. A project can have multiple venues. I’ve got a field linking to my “Venues” table, and yes — the field allows multiple links.But in the Interface: I can only select one item at a time, I can’t pick multiple existing venues, But weirdly, I can create a new venue every time. Which… leads to dozens of duplicates, breaks the logic of relational design, and honestly makes me want to go back to Google Sheets and sticky notes.You used to have this working (RIP Record Lists and side panels). It was beautiful. It made sense.Now,

Hello,I am working with a formula field that I have created to take a Select list value from Field 1 and change it into a number. Example:Switch ( {field 1}“Choice 1”, ‘1’,“Choice 2”,  ‘2’)The output of this is a text value of 1 or 2 not a numeric value. The tool will not allow me to use the following , the 1 and 2 turn red.Switch ( {field 1}“Choice 1”, 1,“Choice 2”,  2)Using the first switch function how do I now set the 1 and 2 to a numeric value?

Hi friends! I work for a cleaning company and we are trying to find a better way to manage our cleaning supply inventory better. We currently have a complicated situation where our cleaners need to notify us when they need cleaning supplies, we then move it to a master list, and then onto a distribution list. Cleaners often will forget to ask for a product and are in need of something so they’ll ask to grab something the day of. This always messes with our ordering process as sometimes it will be so busy when they come in, we forget to mark it down and we’ll run out of products faster than expected. Wondering if there is a way through airtable to scan the barcode and have it automatically subtract one from the master inventory.

I am hoping to use a cutdown “form” or interface designer method to enable stocktakes of our database items via mobile phone and the airtable app. I have created an interface with a barcode field to be used as a key to all the items and an associated display of the fields for each record that can be changed - location, number of items etc. As others have mentioned I was surprised ot see that sharing the interface also shares the entire base but this doesn’t worry me as its only for internal use. When I look at the barcode field for the base/table on the phone app, I can see the camera/scan option and can scan in a barcode. But when I launch the interface and see the barcode field, I can’t see a camera option. If I select the barcode field it just shows a screen keyboard and I can’t see how to enable the camera. I want to use the camera/barcode to find the item in a record list then manually enter the associated data. Also there doesn’t see to be a way to access the interface fro

Hello everyone, I am looking for barcode readers for my company, has anyone used the services of hdwr? I’m thinking of buying these readers https://hdwr.eu/en/products/30/barcode-reader-hd73 anyone recommending?

From this URL Webhooks table changed webhook suppose to send notification for below actionsdestroyedFieldIds createdFieldsById changedFieldsByIdI have added sufficient scope permission to my webhook to get these triggers payload. When I create new field proving type and description I am not receiving response via webhook. Where as if I add new record entry to that field on Airtable web ui then I get notification in changedRecordsByIdCan anyone check if these are working functionality in webhook. Thank you