Ask the Community

My field has a name followed by a number - SAM ADAMS (1234).   I need to put the 1234 in it's own field.   What is the best way to write a formula to do that?   

I received the following email about a Base that uses Zapier integrations.The Zapier third-party integration's access to your Airtable account has been automatically revoked by Airtable due to security concerns around refresh token usage. This sometimes occurs due to misconfigurations of the third-party integration.To continue using Zapier you may re-authorize it. If you would like to contact the developer about this issue you may contact them at contact@zapier.com.You can manage your third-party integrations from your account's integrations panel. The third-party Integrations tab in  Account > Integrations (as described here)  is now empty. What is the best way to restore access to Zapier whilst ensuring the prior configuration was saved?

Hi all,I need help getting my new records in Google Sheets to show in Airtable. I created an automation as followsAfter successfully testing the automation, I see the new record in the automation window; but when I go to the data table, it is not there. What could be causing this, please? Thank you 

Hi all- When a campaign needs to be created in CRM to manage email/email journey, we need to inform the digital team which CRM instance this is for. How can I create an automation to allow users to indicate which of our three CRM instances to choose in an activity? 

Hi, I am creating a chart that shows Purchase Orders grouped by status, but I am getting a group for "null." The status field is a drop-down single select with the 3 options below.  I've confirmed that the status of all records is not empty. I have also tried manually adding a filter to filter out records where the status is empty, but I still get the "null" group. How can I get rid of the "null" grouping in the chart?  

When I am in a base and click the "Share" button in the top right, when I start typing a name under "Email invite", I get a bunch of auto-complete suggestions of people I don't know and aren't in my organization (some are from Gmail, some are from corporate domains we don't have any business with, like GSK).Where are these email addresses coming from? It kind of looks like a database leak of some sort. 

Hello everyone 🙂 Working on learning Interfaces, which are pretty neat! I have a pair of lists that I am bringing in with some fields I need NOT editable by the user, but some that are (see image, only the 3 arrows show the fields I want editable)Is there a way to do this without adding extra fields that are something like formulas to show name etc? I'm sure it is something very simple that I am missing!Thanks!

I have to get approval for all software on an annual basis. The software request form now requires the name and phone number of a support person from Airtable before I can renew for next year. There are no exceptions to this rule. Does anyone have a name and phone number I can put down for this?I will never actually call this person. I just need something to enter on the form. I know the official answer is that Airtable doesn't provide phone support, but I will have to use a different product if I can't find real contact info for an Airtable support person.  

Hello Community!I have run into a perplexing issue when trying to automate attachment field updates or use script extensions to convert a url to an image asset.In my automation script I follow these steps:- make call to external api to get order data- pass that data to a function- the function preps the data and creates an object that holds the table field names as keys and the response data as values.  // values come from parsing the api response data and assigning that data to variables // ex. let recordName = data.name let myObj = { "Order #": recordName, "Part Name": part_name, "Order QTY": quantity, "Image Url": image, "Image": [{url: image}], }   - The object is then passed as an argument to createRecordAsync(): table.createRecordAsync(myObj)​All the values populate correctly except for the image. I get a placeholder image and when I click into it, it displays a broken image link icon.  If I hard co

I can't use my Airtable base due to overlimit on the 1,200 records allotted. Upon checking, I found an insane inaccuracy; it says I have 3,330 out of 1,200, but my base only has 800 records. No attachments. Has anyone else had a similar issue, and if so, what can I do? 

Hi, I am interested in connecting an Airtable base to Tableau Desktop using Tableau’s WDC (web data connector) connection type similar to the example here: Glitch :･ﾟ✧ (originally found here: Community Portal) Has anyone else tried this and if so, what are the requirements/security implications (such as hosting the WDC vs using a publicly hosted WDC) to get this working? Perhaps more of a Tableau question - is it possible to access live Airtable data from a workbook published to a private Tableau server with an embedded WDC connection? Hoping others who have gone down this route may be able to provide some further insight on how to get started using a Tableau WDC with Airtable. Appreciate it in advance!

Hi team, I have created an automation scenario with Zapier to automatically create an interaction on Airtable when a google calendar event is created. Is it possible to add a filter to only create interaction when the event concerns a webconference like Zoom or Webex? Thanks for your help! Best, Ned

Hello everyone. I have developed a Content Management base in Airtable. Each record is an article or piece of content, with a draft due date and a publication date. I have used a zap to connect it to Google Calendar, so that each new piece of content will show as a multiday event from the draft due date to the publish date in Google Calendar. However, this zap only adds new events to Google Calendar, but if I change the dates to a record in Airtable or to an event in Google Calendar, these changes are not updated in the other app. Does anyone know if it is possible to keep Airtable and Google Calendar in sync using zapier, and how this could be done? Thank you in advance.

Airtable would instantly jump to one of my most used apps if it leveraged If This Then That’s platform for integrations. Think about instant integrations to apps like Trello, TodoIst, Evernote, Gmail, Google Drive, etc. It would be AMAZING!

Is there a way in IFTTT to retrieve a particular field of a newly created row? I’ve got a contact list airtable, and want to update a Mailchimp list whenever I put a new record into Airtable. I had a look at building this in IFTTT, but couldn’t see a way to get the value in (for example) the ‘Name’ field in Airtable so that I could put it in the ‘Name’ field in Mailchimp. There’s an ingredient called RecordJson, which I assume has all the data from the new record, but I can’t find any documentation about how to pull a particular element from the JSON. Is this possible with IFTTT, or only in Zapier? (I know there’s a recipe which claims to do this, but I can’t see how it’s able to connect the relevant fields.)

I am trying to connect Airtable and Google sheet through IFTTT Triggers I seek to a row of data entered in Google Sheet pulled from Airtable whenever a Trigger is fired in IFTTT. It all working fine. But the Google Sheet has data spat out and the data is scattered in the a single colum, and is not properly formatted, which is cumbersome to read as IFTTT is getting the row of data and adding the row to Google Sheets without adding the Colum Heads in the Sheet. Here is how the Google Sheet displays the date: all in one ROW… INV-10010100 {“Invoice Date and Time”:“2020-04-27T10:47:26.000Z”,“Invoice Number”:“INV-2004271047”,“Revenue Increased”:0,“Link to Client Database”:[“rec7OMmNrmhRjUCAx”],“Courses”:[“recIj3orTEDtSQQ7Q”],“Create Link to Education Provider Database”:[“rec9z2OcyOanZhakS”],“Education Provider Address”:[“13 Benowa Road Southport Postal: PO Box 4931, Bundall, Qld 4217”],“ABN”:[27620585615],“Link to Agreement Entities”:[“recBfs6qyHhEYCpYB”],“From”:["30609/9 Lawson St Southport

How to populate a blanc single column in Hubspot from a filled column in Airtable using integromat?

Hello, This is my first post. I’m thinking of using airtable to manage our website build project. We use Hubspot and I’m wondering if anyone has used Airtable to sitemap and integrate it with Hubspot. I’m an Airtable noob.

Hello,I wrote this code and it works perfectly as I want in Script extension but in Automation it is a mess. The first part of the code works fine in automation but not the second part, so only the second part needs to be adjusted. Here is the whole code : // first part of the codlet poTable = base.getTable('PO');let transpoTable = base.getTable('Output');let poRecords = await poTable.selectRecordsAsync();let transpoRecords = await transpoTable.selectRecordsAsync();let artikelDatumQtyMap = {};for (let poRecord of poRecords.records) {  let artikelID = poRecord.getCellValue('Artikel ID');  let eta = poRecord.getCellValue('ETA');  let qty = poRecord.getCellValue('Qty');  if (artikelID) {    let artikelIDMatch = artikelID.match(/^(\d+

Hi all,On of my bases shows a warning label: This base is over record limits.That's not possible, there are only 140 records in the base.I have bases with over 10.000 records that do not show this warning.How do I solve this?p.s. Why is it so hard to just reach someone at Airtable for support...?

I would like to know how to auto number based on the building link and location name in my base. as per the picture below. Can someone let me know if this is possible and if so the solution.TIA. James. 

Hi all, I have been playing with the SYNCH API for a while with excellent results. I found this capability very useful for creating and updating records. So far so good.My next challenge is to fill a table which one of its fields can hold a text coming from a legacy system. The problem I'm facing is that those texts include "," (commas) since they are descriptions and side information related to every record.I would like to keep the original format, otherwise it can be difficult to understand and read, however, when I try to use the synch API to move the data, I just crash with the CSV definition. I have not found a way to scape the commas in the string that is passed to the synch API, so it cannot process the request for those records.Has anybody faced the same situation? any hint? workarounds?... any help is welcome 🙂

Hi everyone, i'm a new user of airtable and just wanted to ask if there's a way to do this?The first Col row 1 (red box). If that specific row is not blank.It will fill out the entire next col (blue box).  

Hi everyone! Please give advice on how to sort a list of records inside a Google Doc. 

I'm trying to write a formula to check whether a lookup field contains a specific value.These lookup fields might contain one or multiple values, e.g.applesapples, pearspears, bananas, strawberriesI've been using the formula IF(FIND("apples", {fruitName}), "yes", "no") In this case, I would expect 1 and 2 to return as "yes", but only 1 is returning yes. Find seems to require an exact match, and if there are other values in the lookup field, it returns false. Does anyone know what I'm doing wrong here?