Ask the Community

Hey guys, I’m working on a custom script, and I need to use the value of a rollup field. I’ve tried:record.getCellValueAsString("Publishing Breakdown");inputConfig.itemsitems is added as a variable which pulls the value from Publishing Breakdown.I either get null or empty array.

Dear community,I am currently using several Teams licenses within my organization, and we are considering transitioning to Business licenses to take advantage of the additional features they offer.One of my main concerns is related to workspace management. I understand that Business licenses allow the use of multiple workspaces. If I decide to migrate certain bases from our current workspace (under Teams licenses) to a new one under Business, will I lose the existing connections those bases have with other parts of our system?Additionally, I would appreciate clarification on the following points:Will the URLs of the interfaces linked to those bases change after migration? Will the URLs of the forms also change? Will the BaseID remain the same even if the base is moved to a different workspace?These are critical questions for us, as any disruption could affect the functionality of our system and potentially require us to

Hi,We are an academic library. We don’t have a facebook account or any connection to facebook that I know of. However, I noticed when an interface was loading, that my browser said “waiting for facebook.”When I looked at the html of the page, I found this:<img height="1" width="1" style="display:none" alt="" src="https://www.facebook.com/tr?id=418406606004092&ev=PageView&noscript=1"/>We’ve found similar non-displayed links to facebook on other pages.Is this expected? If so, what does it do? And is there a way for us to turn it off?Thanks,Joe Montibello

I’m having a hard time finding the correct links for the columns-  airtable API key (which tells me I’m supposed to create a token for it which I did but not too sure on how to copy it and paste it on there) Airtable database app (not to sure where to find this located either.) My goal is to make it close to the template that it provides with the leaderboard. I‘ve created my own already with the AI source.  Would like help!! 

I was looking for something like this, but couldn’t find an airtable formula so I thought I would share mine. This only covers the last 3 Japanese era’s.I would be great if something like this could be added to the Set_Locales function for Japanese, but I didn’t see any others that changed the year numbers so it might not be possible.Administratively I have deal with a lot of dates that need to passed to the local government and for birthdays we need to use the era years instead of the Gregorian years.And if anyone has a better one please share.IF(Birthday,SUBSTITUTE(SUBSTITUTE(IF(    IS_BEFORE({Birthday},DATETIME_PARSE("Jan 8, 1989"))=1,"昭和"&(DATETIME_FORMAT({Birthday},"YYYY")-1925)&"年",        IF(        IS_BEFORE({Birthday},DATETIME_PARSE("May 1, 2019")),"平成"&(DATETIME_FORMAT({Birthday},"YYYY")-1988)&"年","令和"&(DATETIME_FORMAT({Birthday},"YYYY")-2018)&"年"))&DATETIME_FORMAT(Birthday,

Hey everyone,I’m trying to imbed an image of our plant into a dashboard I have created. The goal is to create a “heat map” of all existing product based on concentration and location. I have everything else completed, but can’t figure out for the life of me if I’m able to do this as it’s crucial to the completion of the dashboard. 

I want to be able to see more information for my events in the calendar interface, similar to Notion and/or Clickup. Airtable only allowing me to show everything on a single line makes it really messy - I want to be able to see it as multi-line. Putting it all as labels is insanely messy. Hoping that someone has a possible solution for this - is there a place where I can put in a feature request? This seems like something that exists on most scheduling apps I’ve seen, really disappointed to not have it in Airtable.

I’m struggling to get an automation to work properly with a Find Records action. I’m trying to update a record in a table when a record in another table matches certain conditions.  Here is my current automation: Everything works for both conditions until it get to the Find records action. The records are linked in both tables. In the table initially updated (IRA Projects) the field SOW Form is the link to the SOW & Invoices table (secondary table I’m trying to update a record) In the SOW & Invoices table the field IRA Project # is the link to the record in the IRA Projects table These 2 numbers are the same, so I would think it should be a simple matter of finding Here is my configuration (same for both conditions)

I’ve seen something like this asked, but not really seeing responses?  But it got me thinking….  Is it really possible to have two different forms feed into a single base?  My thought process is this.  Creating an onboarding base so we can make sure we get everything completed for every hire.  But questions we ask on applications can vary based on the job(s) they are applying for, so having several forms with the specific questions would be great instead of having questions that only certain people would fill out or verbiage that is correct for some, but not for others.Is it REALLY possible to do this?  Yesterday I was trying to determine if there was a way to set up a form with sections so that each section of questions was for specific jobs, but the form will be LONG.  Having different forms based on the job they are applying for would be much better, if it will truly work.

Hi, I created my first form today and liking the tools, however i find the linear scrolling required to access a multi-field form a bit long winded… Can i modify the layout and locate fields where i need to, to make the form more compact and intuitively laid out, and potentially all fields on a single screen/page? I looked at a thread from 2020, and it mentioned JotForm using Zapier ? Has there been any changes since then to Form layouts for Airtbale? Thanks You, Simon.

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