Ask the Community

IF({Last Renewal},DATETIME_DIFF(TODAY(),{Last Renewal},'days') > 365,"🔴","🟢") The above formula, without the first {Last Renewal}, works fine. But I have records that are empty and I want them blank. I obviously am not constructing my syntax correctly. I want to say that if {Last Renewal} is not blank, then do the following. as I said it works if take out the first {Last Renewal}. I'm sure it is simple. I just don't see it. Thanks, Scott

Hi,Would like to set up a Trigger Reminder with the formula;IF(AND({Reminder},NOW() >= {Reminder}),"Trigger Reminder")But instead of NOW, would like to customized it to xx hours from created TIME, specifically. Have only seen customize formulas for a certain date or number of days but nothing for a certain time period. Any help would be greatly appreciated.

Hello! This filter does not take into account the time part when applied in URL: filterGreaterOrEqual_Date=2023-10-17T22%3A00%3A00.000ZExcept for when I set it at 22:00 where it filters OUT all records with date October 17, 2023 and "allows" them back in when I set it to 21:59.Other settings such as 06:00:00.000Z or 18:00:00.000Z show every record of October 17. Dates on my table are:17 October 2023 00:00 UTC17 October 2023 00:00 UTC17 October 2023 10:00 UTC17 October 2023 10:30 UTC17 October 2023 22:30 UTCIf I remove the time altogether it catches Dates very well: filterGreaterOrEqual_Date=2023-10-17 works fine. Any Ideas please? 

I am trying to auto-number a group of records for one person in a table with multiple people listed with numbers 1,2,3, etc.. In Excel, I would use a formula to add one number to the above cell, and it would number all rows sequentially. I usually manually number each record, but I am hoping a simple formula would number the list.Here is a screenshot of my table consisting of the records I need based on a filter.  The row with # in the title is where I would put the formula.  Any suggestions? 

Hello! Please help 🙂 1. I have an "all expenses" tab where we input all of our event expenses. In this tab one of the columns is "event" where you select what event that expense is tied to. 2. We also have a "budget summary tab" that includes what was budgeted for each event as well as an "actuals" column next to it for each event. 3. I am trying to make everything entered in the "all expenses" tab populate the actuals column of the correct event in the budget summary tab. 

AirTable seems to have made a change to the sync implementation in a way that has crippled a critical support process/automation we have in place. Based on the fact that this support article was updated today and one of our sync fields that used to be a Lookup (and on which downstream logic relied upon) is now a text field, we can only assume that a breaking change was deployed with no advance notice.Anyone else experienced this or have any issues as a result of this?

When editing an automation that uses the Find Records module, the "Test Action" function outputs the resulting records in a nice pop up table. How can I get this same functionality with the published interface/automation? If I don't add an output, then initiating the automation from the interface (in my case a button), yields a "Started" notice at the bottom left, but then nothing. I've been able to get the output to go generate a GoogleDoc, but this is cumbersome. I really just need to be able to Copy the text (and paste it into an existing email reply).

I’m pulling in Google analytics data to one table in a base via a 3rd party extension, it includes a column with a pageview number and another with the corresponding URL. On my other tables on this base I have the URL already in a column. I’m looking to pull in the pageviews by matching URL in my other tables and cannot figure out how to do this. Any help would be appreciated. Thanks!

Hi All, I would like to create a button for the Airtable Interface which adds 6 months to today's date. Upon pressing the button, I want the date field to be updated to today's date + 6 months.Is this possible?Would love to hear your solution for this!Thanks!

I am about to embark on a large research project with the Royal National Institute of the Blind and one of the requirements is that the format we hand over our research should be fully accessible. Given there is going to be a lot of research findings I was hoping to use Airtable, but is it accessible? Thank you J

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

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 popu

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.)