Ask the Community

Hello All, I have some fields in my database that are mandatory at different stage. I want to do a form with the first fields for the first time, and then send another form prefill and update the record. I do not see how to update. Is there a way to do it ? thanks

In order to compute a change in a value between a prior record and a newly inserted record, is there a way to get the most recent prior value for a field in a table?Assume table is sorted (e.g., by DateTime).Ideally with a formula something like the pseudocode below where the “Prior_Value” and “Current_Value” are a number, such as: an amount, a quantity, a weight, a height, a length, et cetera.Delta_Value = [Prior_Value_from_Prior_Record - Current_Value_from_Current_Record]Thank you for any and all suggestions!Rick

I use a lot of linked records.Occasionally I have an issue where a [Record from table A] is deleted (by a user or automation with script) which triggers the deletion of a [Record from table B] it is linked to (by a user or an automation). Because changes to from [Record from table A] look up fields in Table B trigger other automations, these automations start running before Record from table B is deleted. However Record from Table B has finished deleting before the other automations have finished. This isn’t really a major issue, but it is an alert in airtable and my emails that I need to check to make sure something else isn’t going wrong.  Is there a clever way I can simply check if the record still exists as a conditional action in running the automation? I realise this could be resolved by redesigning other automations, but that will require redesigning several dozen.

Hello community 😊I think I want to build an app that converts your paper documents into Airtable records. Just take a picture and it will fill out the corresponding record fields for you. But before building it I want to see if there’s interest. So, if this is something you would use, please let me know by filling out this form: https://airtable.com/appafp6Lmjx6JWTQT/pagXrEyUU67hnWu3Y/formIf you want to check out the concept video:  

I’m looking for an experienced Airtable expert to help develop an MVP platform for a modular workflow and data tracking toolkit focused on operational delivery of sustainability or performance commitments. The tool is designed to support teams and suppliers in delivering on tiered targets (e.g. Bronze/Silver/Gold), track data and activity at project level, and surface both progress and recurring barriers. The front end will be built in Softr or a similar no-code interface to allow intuitive access for different user types (e.g. project teams, suppliers, funders).  🔧 Core Airtable Build Requirements:  Projects must be able to select from Bronze, Silver, or Gold commitment levels, which trigger:  Tailored workflow prompts  Role-based task assignment  Procurement guidance aligned to the selected ambition  Data collection requirements (e.g. quantitative and qualitative inputs)  Generation of performance dashboards (e.g. % progress, commitment met/not met)  Calculations of efficienc

Did AirTable remove the ability to use forms on interfaces on mobile devices? We were previously able to submit forms on the mobile interface, but now we get the pop-up message that the page is not supported on mobile. Can we get this feature back?

Hello,  I am trying to write a script that will automatically match records. The Base set up is as follows. Table 1: Contacts. Table 2: Has. Table 3: Needs. Table 4: Matches. Contacts and Matches are self explanatory. The Needs table consists of “Buy Boxes” for real estate investors. i.e. Property type, max price, number of bedrooms, state, city, etc. The Has table is where new opportunities are entered. The goal of the script is to then automatically match new entries in the Has table with open Buy Boxes in the Needs table, then score the matches based on the number of criteria that match, different criteria will have different weights. Null in either Has or Needs table should not effect the result.  I am having a lot of trouble with this, as there are many variables in the Needs section. 

I’m trying to create a field that automatically tallies up the number of times each record has been modified. Does anyone know of a way to automate this? Thanks!

According to this support article, it says that we can use markdown formatting in any “long text field with rich text formatting on”. However, this doesn’t work. We have a long text field with rich text formatting on, but when we add markdown syntax into our text, nothing happens. For example, if we type the following into our long text field: **test** *test* test We would expect the results to look like: test test test (Notice that the 1st word is in bold, the 2nd word is in italics, and the 3rd word is plain text. That’s what we would expect.) But everything just stays in plain text, and looks like: **test** *test* test Thoughts on how to get this markdown formatting to work within a rich text long text field?

I am new to Airtable so forgive me if this is an easy answer. I have searched the forum and can not find the solution. I want to sum a field with several records {days worked}, by group {name}. I have accomplished this by grouping by {name} and the result shows in the group bar. I want to use the results of this in another formula calculation, in a different table. Thank you in advance for any help. Steve

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 OperationsJanuary2023Project B OperationsJanuary2023Project C OperationsJanuary2023Project D OperationsJanuary2023Project E OperationsJanuary2023Project F OperationsJanuary2023Project G Teams are asked to enter their hours by the first Monday of each month. I want to create an automation that sends an email to teams that haven't entered in their hours yet. However, I do not want it to send a separate email for every single record that is empty - I want it to be one email that says the team has

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??