Ask the Community

I'm using the new Form Builder to create a form to share publicly. I published the form, and created a link for "Anyone on the web."  However, if anyone tries to submit the form without being logged into AirTable, they get the following message, and the form never submits. Any ideas or workarounds?: Refresh page to submit formThis form has been updated. Refresh the page to submit your form. Any information you already entered will be saved, but not submitted. 

I’m trying to create a form that will allow club members to order multiple products. Each product has different color and size options, and I can’t figure out how to build the table to then create the form with all the different options. Any suggestions? Thanks, Dave

Hi all,This has been asked before, but the previous topic didn't get any replies:  We’re encountering the same issue: the record revision history looks different when viewed from the Data side versus the Interface side. Is this a bug, or is there an underlying logic we might be missing? DataInterface 

I noticed differences in the revision history of a record when i open it in an interface vs. when i open it on a table. How? Why?in interface, last edit 4w ago (but last edited date shows 1 day ago...):in table the edits from 1 day ago show up. they relate to a linked record...:  

Hi, as a new Airtable user i could really do with some help. I help organise a small cat rescue so have built my 1st ever database (whoop lol) so we can organise who needs adopting, what sex, colour etc… a couple of us cant access the information via the browser on our phones. it comes up with a ‘header’ screen so to speak but you cant access any of the info. I am fine as I have an android so I just downloaded the app. But one person is making excuses that they can’t and so far cannot see anything. Does anyone have any advice or hints / tips as to get it working on phone browser? thank ya’ll ever so much x

It looks like I no longer have access to the what's new page. https://www.airtable.com/whatsnewIs anyone else seeing this?  Does anyone know if it's a policy change or a problem with the page? 

Hi all, I’m at a stage where it’s no longer legit to make changes directly on the prod env.What are your best practices for managing changes in the base’s structure and design? (changing field type, editing formulas, editing scripts, adding tables etc.) For example, is there a way to connect to git and keep track of changes to table schemas (not data sync)?How do you make changes in a DEV base, and then push them to production? Do you use dedicated branches in git for these changes? 

Hi, I’m trying to follow the extension first tutorial and I have an issue when I load the “http://localhost:9000” website : “Cannot GET /”. Any idea for this issue? Best,

Hey all,so weirdly enough, when I setup the formula for a total time calculated it shows this: 120 minutes, correct?However the resultant display shows this:Just curious, why is it showing up as 0:02 instead of 120, even though in the sample it shows it’ll be 2?

When you have multiple independent instances of the same database schema (Base) along with their corresponding user interfaces (UIs) and separate data records, you might be looking for efficient methods to implement changes to the database schema or UI across all these instances. What strategies or solutions are available for applying updates or modifications to the database schema or the UI consistently and effectively to all instances?To provide some illustrative context. I would like to add a Field 3 to the Master-BASE and rollout this change to all instances.MASTER-BASETable AField 1 (Single Line)Field 2 (Number)Table BField 1 (Email)MASTER-UIView 1 Instance1-BASETable AField 1 (Single Line)Field 2 (Number)Table BField 1 (Email)

Airtable novice here! I’m trying to create a set-up that will field team names and scores from a typeform trivia survey to create a simple leaderboard to sync to the commonninja leaderboard widget. After *so many hours - whyyy* I finally got the simple set-up ready but for the life of me, cannot get the new entry from typeform trigger automation to work. It seems to fail at the Update Record step. See screenshots of two set-ups below - any help would be so greatly appreciated! Also open to any other solves that might reduce the number of apps I’m bringing in. Also note that I have to set Team Name as a single select with options in order to connect with typeform properly. Arghhh. Halp!!!! Set-up 1 Attempt 

Hey,I have a “project management” table where I keep all my projects, with a lot of different linked records.When I change the status of a project to “send invoice” I have an automation that sends an very basic email to my accountant that looks something like this: Hey!The Project "PROJECT NAME" is done.Send invoice to “COMPANY NAME”:  “AMOUNT” + VATInfo: “NOTES”Contact: “CONTACT NAME”Email: ???Best//OscarI have ran into a problem however, I can’t for my life figure out how to add the “contact’s” email adress. Since the contact is only a linked record from “people” where all the details for that contact exists. I do NOT want to add an email field to my project view, since I have a LOT of people and different other linked records there, it will become a mess. Can anyone help?THANKS!!/O

Hi there! I have an automation currently setup in Airtable that sends a slack anytime a tag is updated when an order comes through our system. The automation sends the customer name and total in the order and a link to the image. I am trying to find a way for it to send an actual attachment of the image, as currently I have an employee going in and manually sending it. This is what Airtable support said below. And attached is an image of what the automation looks like.  Let me know if anyone can help guide me through this. Thanks!  “As a workaround, this could be achieved by setting up a custom script in your automation that uploads the file directly to Slack. That path does require some scripting knowledge and familiarity with Slack’s API.If that’s of interest, you might consider reach

I am working in grid view and need to move several records to different places in the same table. For example, record 101 needs moved to 43, etc. Can someone show me how to do that?

Hi,here is the solution to this frequently asked question. Just replace the value in delay( ) to change the time of delay. The maximum delay you can give is 30 Sec per action or automation will fail. For adding more delay the work way around is to add two scripts actions one below the other (See Image).function delay(ms) { var limit = new Date(); limit = limit.setMilliseconds(limit.getMilliseconds() + ms); while ((new Date()) < limit) { // do nothing ; } } delay(20000); //delay 20 second

Hello Community,I’m fairly new to Airtable and relational databases at that, but would like to create an application that helps me distribute allocations to my top accounts for my wine import and distribution business. We receive certain highly sought after wines in small quantity and need to distribute them to top accounts. Most of the time, accounts take the full allocation, but other times they just accept a portion of the offer or none at all. My post here is looking for guidance from experienced designers on the overall base structure and how I should develop and connect things. Here are my thoughts so farTables w/ - wines available / pricing, distribution of wines by account, total quantity of wines still available Table w/ - List of accounts with email information Interface showing each account their allocation **or Automation sending out an email with each account's allocation Maybe there is some way for

Hello everyone,I'm using an automation that links to my Outlok account, sending an email via Airtable.After a successfull 15 emails sent, I get the following error message.Microsoft reported an error while processing this action:This action is being rate-limited by Microsoft due to excessive requests.Does anybody knows why and could help me fix it ?Thanks, and kind regards

Hi Airtable community,I’m trying to set up an automation and could use your help.Here’s the scenario: Whenever a new record is created for a specific name (NAME 1) and a new name (NAME 2) (see screenshot for reference), I’d like the automation to trigger a notification to the specific people who have modified the  previous data in the past.  

I’m setting up a base that is hopefully going to help me organize my finances with my boyfriend. We have a joint bank account, and I need to be able to show how much money is going in and going out. It seems like he is not leaving enough money to pay for his bills. So, I’m wondering if I can calculate who owes what in the account. Like … I import the CSV of the bank account, then create a table for people (which would be just two), then add up the balances of all the expenses that are the responsibility of that person … What about stuff that is both our responsibility … would I create another person and then divide that into two … I’m so confused. :crazy_face: :frowning_with_open_mouth:

Hello!I have a question regarding the batch_upsert method in the pyairtable library.Does batch_upsert update records even if the incoming data is identical to what's already stored in Airtable? Specifically, will the “Last Modified Time” column be updated in such cases?Example usage (python):table.batch_upsert(records=batch, key_fields=key_fields, typecast=True) From my testing, it seems like some records are not showing an updated timestamp, even though they were included in the batch. I'd like to confirm if this is expected behavior.Thanks in advance!

My primary field is an employee’s full name in this format: Last, First. The catch is that some employees have a middle initial or a middle name, so it looks like this: Last, First Middle.I want to create two separate columns that separately extract the last name and the first name. I want the separate first name column to include the middle name/initial (if they have one).I’ve been able to create the last name field with this formula: LEFT({Person Name}, (FIND(",", {Person Name}, 1)-1))However, when I use that same formula for the first name field except with the RIGHT function it doesn’t pull out the first name correctly for everyone. RIGHT(

Hi everyone 👋I’m building matchmaking system using Airtable + Make, and I’m stuck on the neighborhood matchingHere’s my setup: Properties table{Address} field (e.g. Monterrey Street, Roma Norte, Cuauhtémoc) {Neighborhood} (single select → “Roma Norte”,Clients table {Preferred Neighborhoods} (multi-select or linked) – clients can choose multiple neighborhoods they are interested in. In Make.com, I also created a variable neighborhoods_string that looks like this (from {Preferred Neighborhoods} [] array) : Parres El Guarda|Isidro Fabela|San Pedro Mártir|Miguel Hidalgo 3ª Sección|San Andrés Totoltepec|Tlalpan Centro|Tlalcoligia|San Nicolás Totolapan|Héroes de Padierna|Jardines del Pedregal|Roma Norte What I want to achieve:

I can’t believe I couldn’t find an entry about this in this forum yet. Hmm ok, here’s my problem:  Every time I open Interfaces it goes straight into the editor and I have to click launch to use it. For me (main administrator and builder) it is annoying but works. Now my user back from holiday wanted to access and couldn’t. It gives a message that says to click on launch or ask the owner. No launch button though. I opened the interface on my side, had to click launch again did so and she could get in. This obviously is quite an annoying and NOT acceptable behavior. I have no idea where and how to change this behavior?Please help  

We are a small manufacturing company, and have moved most of our inventory into Airtable for our current build and possibly will continue to use for future buildsIs there a script I can use to stop duplicates from happening within a table? Is there a way to move about parts from one ”location” (which is already a table in the base) to another without physically having to continuously go into the data base?  continue question from above - is there a way to have 1 part but with multiple locations? We have parts that are stored in multiple staes (eg: flat parts and then folded parts but both are the same part) what is the best way to show this other than having multiple part numbers or prefixes for the same part.Hope that all makes sense…..

I am building a base for our clients. Goal is to have them access their data through a portal. They will want to print professionally formatted reports with our company logo and page breaks. Are the print options in portals the same as interfaces? If so,  this will not fit our needs. Would you suggest we use a 3rd party such as Documint?