Ask the Community

Hi All.  What’s the best way to set up the automation below—either in Airtable’s native automations or in Make—to reliably populate the linked field with the Trade’s subcontractors (particularly struggling to get the list of record IDs), and avoid reseeding after manual edits?Base: Dupl Construction Project https://airtable.com/invite/l?inviteId=invh3YFKHVkgkcl8h&inviteToken=ebe29e4b636f906f9bde46e9282074acf77e1634caac54dee00c188723eac427&utm_medium=email&utm_source=product_team&utm_content=transactional-alertsThe goal:  when a record is added/updated in the Subcontractor Review table and Related TRADE is set, auto-populate Selected SUBCONTRACTORS (link to Subcontractors, multiple) with all Subcontractors linked to that Trade. It should seed once (only when empty) and remain editable and continue to be linked to the Subcontractor table records to create quote requests from the selected Subcontractors (which may be different to the initial allocation) later.What I’ve tri

Hello,I have a table with a file field, there I also have a “file url” field where I add the expiring downlad url of that file. As this url expire after 2 hours, I search for a solution to update this url every 2 hours so it stay available. I tried with automations first : Tried a repetition group but the problem is that all I can do is add the whole list of url (separated with comma) from all the records, i cannot find how to add the url of this record only. For exemple I want to have :File url of record 1 = url 1File url of record 2 = url 2File url of record 3 = url 3 But what I have is :File url of record 1 = url 1, url 2, url 3File url of record 2 = url 1, url 2, url 3File url of record 3 = url 1, url 2, url 3 So I tried with scripts, I found a script extension that work perfectly (its named “Convert attachments to URLs”) but I cannot find how to execute it automatically every 2 hours. So I tried the “run script” option in automations, but it seem I can’t connect scripts from exten

Hello Airtable community! I’ve got a new IF formula that’s giving me trouble - I’m trying to format titles from our database for a distributor that needs the components in a certain order, which changes based on other parameters. To begin with, I was able to set up a statement that only targeted records where the format is listed as “Issue” and then get the root of the new title created with existing fields like so:UPPER(IF({Format Type}="Issue",CONCATENATE({Title w/o Article}," ","#"," ",{CVR A, B, C}," ",{Cover Artists}," ","VAR"),""))That gives me, as an example, MADE UP TITLE #1 CVR A PABLO PICASSO VAR and also returns an empty field for anything that’s not an ‘Issue’. The problem with this formula is that if it’s CVR A, then there shouldn’t be a ‘VAR’ at the end. So I tried to modify that with an IF(AND( statement, and every version I’ve tried breaks down, like this:UPPER(IF(AND({Format Type}="Issue",{CVR A, B, C}!="CVR A", CONCATENATE({Title w/o Article}," ","#",{Issue #}," ",{CV

Hi all, we’re a custom sportswear company using Airtable to track orders. At the moment we have a single line item for each garment ordered, and the numbers of each size. The view is grouped by contract number so we have all garments for each client grouped together. So for example we might have: Line Contract Garment XS S M L XL 1 1875 Bobs Bikes Cycling Jersey 1 2 3 2 1 2 1875 Bobs Bikes Cycling Shorts 1 1 1 3 1 3 1875 Bobs Bikes Cycling Jacket 0 2 2 1 0 My question is whether I can collect this information in an airtable form to auto populate our airtable? I have tried creating a form for this but under Garment it will only allow me to choose one garment, OR I can setup the garment field to allow the form filler to choose multiple garments . But in the former case I can only collect information about

I will not go into full detail because it is exhausting, but I have run into a situation where data written into my base occasionally has a trailing space character, which caused confusion and havoc between airtable and softr over the past 4+ weeks.The extra [space] character is really just typo. But to the naked eye, it cannot even be seen. How can I prevent any trailing [space] characters being written in the future?? Is there a native trim function?

Good day everyone! I want your feedback on how to complete this. I have a table of ‘Projects’ listed and includes a linked field where I select multiple records that represent rooms of a house. This is what I want to do: once I select multiple rooms of the house, I want to auto-create a list for that particular project that includes default furniture and accessory pieces for each associated room of the house. That way, I’m not having to manually write it for each project that comes up. It may be easier for me to create an excel document to include the most common rooms with associated furniture and décor pieces. What are your thoughts? If it’s possible to complete, do you have any recommendations on how to make it happen? Thank you!

I run my market garden business on airtable. The market price for my vegetables change monthly or seasonly. At the moment I use a formula field to calculate the return on my production each month . I have a table for each vegetable price but when my prices change how do I stop the new price altering all my previous months. Do I need to use a script?

How can I turn off spell checking? I use this entirely for foreign-language content (all non-English words) and Airtable is underlining every single word!

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 redo a significant amount of work.If anyone has experience with th

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,"M月D日"),"令和1年","令和元年"),"平成1年","平成元年"),BLANK())

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 tried pulling the SOW Form from both the trigger step and the first update record action, but neither seems to find any records. I’ve tried changing the condition for the project #’s to “has any of”, “is exactly”, “contains” (which doesn’t allow me to select th

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?