Ask the Community

Hello! I’m trying to put together node js logic to find record ids for two concatenated fields as the key field. I’ve gotten through my issues of having commas in my search strings, but now I have compound issues with both commas and single quotes in my strings. I’m ending up with a filterbyformula variable that looks like this: {Song ID} = ‘“A Midsummer’s Breeze”-“Meditations for Relaxation, Vol. 1”’ My logic has found both the single quote and the comma, enclosed both of the constituent pieces in double quotes and then enclosed the entire string in single quote. Airtable doesn’t like this and cannot find the record. In the DB, the record looks like this: A Midsummer’s Breeze-“Meditations for Relaxation, Vol. 1” Before I make myself nuts trying to suss out a solution, I thought I would ask you trustworthy and kind fellow coders… Thanks in advance for any help! Cindy

Hi every one, I'm just trying to create a table that shows 3 tables together. Each table is been filled by data fetcher, each table is a channel sources. Meta, Google, etc, with the results grouped by year, month and week (Is like the data comes from data fetcher)I need to do one table with all the channel together. The thing is, in each table of source I have 3 columns that identify and probably link each raw of each table. Column user, year, month and week.Each table has the same first tree columns, so the resume table should have user, year, month and week, and then, the linked results from the table meta, google, etc.In excel is relatively easy, but here I don't find an easy solution. Thanks for any help.

Hello! This isn't the most important thing if it's not possible, but I'm embedding multiple lists into my email automation. (Based on each piece of legislation's changed status.)I'm wondering if there's a way to hide the plain text when it corresponds to a grid that returns empty. For example, in the below, if only the heading "Floor Vote Result" could be displayed/sent, since it's the only grid that returned content, while the other headers would be conditionally hidden. Any tips? Thanks!

I keep a large database of images in my Airtable. The jpg files include "document title" and "description" in the metadata. I would like to automatically insert that text into different fields in my table.The closest thing I can find is this EXIF extractor api but as far as I know this is different from the metadata in my jpg files (am I understanding this right?).This seems like a solution others would be interested in so I'm surprised I'm struggling to find information.

I am using the Update Record action type in airtable automation. However what I notice is that it completely replaces the existing data in that cell and overwrites it with new data. Is there a way to update the record by appending new data to the already existing data without overwriting? The field that I am updating is a linked record and would already have some ids existing. I just want the update record to append new ids to the existing list.

I have a column of time duration.  How do I add all of those durations together?Picture to show what I am trying to add up for a total time

Hello!I am having issues with automation emails showing they've been sent in the base, but are not being received by the users. This issue just started to occur. Automation shows "on" and run history shows that they have all run successfully and that the email sent was successfully completed. This is the first time experiencing this issue. Please advise if possible. Thank you!

I am trying to replace some code in Excel VBA that used API Key with a Personal Access Token. But when i just replace the API key with the new Token ID. It does not work, as in it fails in connecting to the airtable.Set objhttp = CreateObject("MSXML2.XMLHTTP")url = "https://api.airtable.com/v0/BASE ID/FSRates?api_key=API_KEY"objhttp.Open "GET", url, Falseobjhttp.SetRequestHeader "Content-Type", "application/json"objhttp.SetRequestHeader "User-Agent", "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)"objhttp.Send ("")UCase (objhttp.ResponseText)Dim json As ObjectDim usermatch As Booleanusermatch = FalseSet json = JSONTools.ParseJson(objhttp.ResponseText) ' root arrayjsncnt = json("records").countDim rng, cell As RangeFor i = 1 To jsncntSheet57.Range("a" & i + 1).value = json("records")(i)("fields")("Title")Sheet57.Range("b" & i + 1).value = json("records")(i)("fields")("Base")Sheet57.Range("c" & i + 1).value = json("records")(i)("fields")("SellRate")Sheet57.Range("d" &

I have written a guide for this and explained the difference between API Key and Personal Access Tokens. I speak a little bit about scopes too. I thought it may be useful here:https://www.csvgetter.com/blog/airtable-api-key-deprecation 

I'm a new user.When I make a Kanban board, and click on an individual task (a row in the grid view), then it opens this in a separate window that overlays everything else. What is this separate window called?Is there a way to do this from the grid view, so that I can click on an individual row, have a window pop up with all of the fields just for the row?Thanks

HiI need a function that I will use to count the numbers of the same value in a column here is an example that explainsthinks

Hi,This is my interface page where I select investor from the dropdown. I have added a filter below and I want the filter to have the value selected from the dropdown.I understand that this kind of dynamic value setup is not possible in airtable interfaces as of today. So I am thinking of using airtable automation.Now when the user clicks the Set Carrier button, a script runs saving the name of the selected carrier in a variable. I can add a 'Find Records' step in the automation to use the same variable and filter the results. Now is there a way to publish the output of Find Records back to the interface page? I am able to see the records while testing automation. However a feature that can publish these as a list on the interface page would really be helpful. Any thoughts/suggestions? Or is this kind of setup possible only through a third party tool?

Hey, for the past week or so I have been trying to upgrade my account from the basic free plan to a paid monthly Team plan. While trying to do so, I have been facing issues while making the transaction for the same. How do I go about this? This is the message I received on trying to make the payment "We were unable to upgrade you at this time. Please refresh the page and try again. If you continue experiencing problems, please contact us" 

Hi,I have 2 databases with sync tables on one AirTable Account. I would like to move them to another account without loosing the syncronisation between tables. Is there a way to do it ? ThanksF. 

We are completely maxed out on automation runs! This is because Airtable hasn't reset after last month. On December 31st we were at 80% which is too close for comfort but with it only being a day until it should have reset we weren't worried about it. Here it is on January 3rd we're dead in the water!!!!!!!!! Obviously I cannot get immediate help from Airtable Support. I've talked to their sales department about upgrading us to an Enterprise plan but this is not immediate. Anyone have experience or know what to do? Maybe you've got a contact on the inside that could reset our automation runs for the month. How is this not automatic?!We have business critical functions relying on our Airtable. 

I feel like I can't articulate this question well enough to search for an answer -- maybe someone here can understand my brain.I want to copy a column of text strings in Airtable, put it in a search box, and have it bring up all the records that contain any of those text strings. Is something like this possible? Basically, I'm working off a synced base that I have additional columns I need to edit. (I can't change the main base in any way -- it's full of "secondary" records that are essentially 8+ copies of the first set of records that I do not want in my base) So every day I'm searching for 50+ strings, one by one, to update those records. Any ideas?

HolaWe are a charity/NFP who has been working on a basic "help our volunteers be able to do their job" system for a while. Tried everything, it looks like one of our key issues can be solved by AirtableWe are aiming to use Airtable as simple terrotory based CRM platform, because it is very straight forward and visual to use. Very impressed so far. our users are not technical and dont need to be fighting screens and awful processes. They just need simple sheet views.(Amongst other things, this is the first thing)We have a lot of contacts and great with Zapier etc. What we want to do is to continue to update items via Zapier as the customers are engaging with us. However wanted to know if a couple of things are possible. - Decent Visual emails out of the platform, as Mailchimp is great on the graphics but not good with much else. - Block list. So if a customer signs up who we have blocked, can we automatically remove them based on email. - Merging records. Record A exists,

All of a sudden, Airtable is freezing and only loading a small subset of the web interface.] I've tried clearing all browsing history in Chrome, and still same issue. I also tried with Edge, same issue. Anyone experienced the same issue? I'm completely stuck.d

Hello everyone and Happy New Year,I have a few tables in my bases which get updated on a nightly basis, via airflow jobs. I would like to lock some of  those columns down so only certain users can modify the contents, but that would mean I'd need to have Airflow as one of these approved 'users' so the nightly update jobs can continue. How would I go about adding a user for a 3rd party service like Airflow?Thank you in advance!     

Hey Everyone!I'm hoping you can help me out with a tricky one. We currently use a check-in system (VisitU for those that care) to keep track of when/why people use our space. I then take that data, dump it into airtable on a weekly basis and it does a bunch of cool analytic stuff already.Now for my ask. It records a time in field (with an exact time like 15:57) but that is linked to a date field. I was tasked to figure out if being open past 6 is worth it on Monday's and Wednesday's. Figured out how to seperate the day of the week (using DATETIME_FORMAT(timeIn, 'ddd')) but now I want to give me a list of those who checked-in after 6 that I can then use the two field (Day Name and Time In After 6) to tell me how many people used our space. Make sense? Any ideas on how I could separate that time field? 

Hello to all my colleagues,The query I have I think is kind of stupid, because it should work as I am configuring a button in an interface, so that when it is clicked, it triggers an action that in my case is to run a script. I am following the instructions posted at:https://support.airtable.com/docs/when-a-button-is-clickedI am blocked at this point "Connect the automation to an interface".The problem I have is that I can't select the action to follow when someone clicks on the button, because the option "Run automation" does not appear within the options to select. Only the following ones appear:- Open record creation- Go to interface page- Go to external URLIt is supposed to appear within those options "Run automation", and after selecting it, link it with the automation process that I have created.I don't really know what could be going on, so I would be grateful if you could help me, I would appreciate it very much.Thank you very much for your help.Luis

Hi there - all my automations are failing. I have disconnected and re-connected my gmail accounts but they are still failing to run. Can anyone offer a suggestion on how to fix this - I'm pretty new to Airtable but hope I can understand the solution to fix this. 

I am trying to create a request form, but when I try to add the logo, it tells me to subscribe, and I have a paid experience Billing history12/26/2023Changed from Free Plan to Team Trial Plan12/22/2023Workspace created  

Just found this while tinkering. If anyone else could test, I'd appreciate it.Steps to recreate: Add record via form in interfacesMake sure the form submission has a datetime field, and set that field's default value to Current Time.Toggle off 'Allow users to edit this field'.Submit formWhen the record is created, the date field will have 24 hours added to it.I originally thought it had something to do with my timezone settings and GMT, but when I toggle on 'Allow users to edit this field', the 24 hours is not added to the date field on record creation.I have a video here that shows it happening to me. 

I'm using a date field {Date Processed} and a formula field {Report Periods} to interpret that date and produce a comma separated list to find the year, quarter, month, week, and day. I use this for reporting. Check out this screenshot showing how 12/31/2023 (USA time format) is messing up the formula.The final day of the year should be in the 53rd week of the year. Instead it's starting over at week 1. I believe this is a bug in Airtable. But please let me know if there is any known solution. The formula for the {Report Periods} field is:IF( {Date Processed}, SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE( DATETIME_FORMAT({Date Processed}, "YYYY-ⓨ, YYYY-ⓠ-Q, YYYY-ⓜ-MM, YYYY-ⓦ-ww, L"), "ⓨ", "year"), "ⓠ", "quarter"), "ⓜ", "month"), "ⓦ", "week" ) )