Ask the Community

Especially for the calendar view, if I could select the label image to be a collaborator field, so that it uses the collaborator's Airtable image, I think it would be really nice.That's it, really. I hope this made sense.

I am trying to recreate a page designer extension on a new table within my base. When I switch the tab over and go to edit the page, the image field is not loading. I am copying the image url with the attachment uploaded and receive the message in the screenshot below. Is this functioning correctly or am I doing something wrong?  

I have a column called “Date”. I’d like another column to look at my date column and if the date is in the same month as TODAY(), then it should say “This Month”. If the date is last month when compared to TODAY(), then it should say “Previous Month”. To be clear, I don’t want it to look at the previous 30 days. So, if a record has a date of 06/30/20 and today is 07/01/20 then that record would say “Previous Month”, but its month is in a previous month when compared to TODAY(). Does that make sense?

Looking at the great PowerShell community posts on GitHub, I cannot find an example of a JSON body formatted for Airtable for multiple records. the following CURL works, APIkey removed. While I can format the JSON Airtable likes for a single record in the payload, I cannot seem to get the script write to wrap the JSON with the "records";[ values that Airtable wants. I currently am trying the following in Powershell but the JSON is not formatted correctly. Any tips?  Depth 3 is works for a single record. #now wrap with fields value Airtable wants[PSCustomObject]$AirtableRecordsWrap = @{records = $AirtableWrap}# Convert the object to a JSON string depth of 3 is required to get extra '$jsonBody = $AirtableRecordsWrap | ConvertTo-Json -Depth 4  ============this CURL script will work, with API removed====================curl -X POST https://api.airtable.com/v0/appQxHpZdplpm8i6V/IPConnections -H "Authorization: Bearer [APIKEY]" -H "Content-Type: application/json" --d

Hello, I have a cell with a date picking like "20240204 12:00" and I would like to format the date to "Feb 4th".I don't find how to reformat in this particular format.  Thank you for your help ! 

I've got a single select field for an address, and I want to autofill a secondary field based on that selectionIf 123 Street is selected, then it returns the corresponding email, etc.I'm using the below formula, but it keeps returning info@email.com regardless of the selection. IF(OR(Address="1234 Street",Address="1234 Road"),"Info@email.com","Info@email2.com") What am I doing wrong?

All of sudden this morning, when I logged on to my base, I realised all of my PDF attachments are gone. Instead the cell displays a broken picture logo.  How do I get the attachments back, this is very important to me.

So, I have over 3,000 people in my database that people can opt in to help the charity in numerous ways like being: volunteers or subscribers or sponsors or trainers etc etc but some people has said they can help by doing a few of those options.My problem is that this data is pulled in from other platforms (Active Campaign, google forms etc etc) and I have zapier populating my CRM everytime a new form is submitted.  This means I currently have 3 records for a 'Mr Smith@email.com' as he offered to be a 'volunteer' and a 'sponsor' and he as subscribed to our newsletter.  So he now has 3 different record ID's as my CRM creates an ID for each new entry. I need a formula or an automation that creates a Unique ID that is linked to an email address so if he registers for a 4th option his Unique ID will automatically populate the ID field with the same ID as the other three if that makes any sense at all!! 

Context.  End user tool to help filter many products to a manageable few, filtered by users' selected constraints.  They can then drill into detail (data sheet attachment column) and ideally, select a subset of filtered products to get more info on.   Single table. ~400 products. 8-10 attributes any of which may or may not be selected/filter-constrained by user. *Dynamic filter:  from https://support.airtable.com/docs/shared-view-url-filters  I figured out how to collate filters   (  ..airtable form URL....?filter_sensitivity=presence&filter_colour=silver&filter_mount=wallCurrent thinking (please guide/correct me):1)  Customer (on mobile) clicks through to form  (imagine 10 drop down (attribute) boxes, appropriately labelled)2) Submit/Find button generates dynamic URL from user selection which filters shared grid view *(above)A)  My understanding is Airtable is unable to generate dynamic URL from a form submi

When you input a not existed value in a linked column. A new record would be created in the linked table. How can I stop it from creating new records automatically?

I created an automation with a Webhook trigger. When calling that webhook, I want to run a script that reads the webhook data (POST) and use them in my script. I haven’t found how to do something as simple as that so far. I’m starting to believe this isn’t possible.

Hey,I recently came to the conclusion that many of my existing spreadsheets would actually make much more sense if they'd become databases. So I started playing around with designing some of those, and while majority was smooth, my gym workouts became a big challange for me.First of all, I struggle with design correctly the base. I had a couple of different approaches I've tried, and everything seemed to be overly-complicated. The problem is, whenever I get somewhere, all I have in my head is a possibility to export this base in a fairly simple format, which I could take and send to my trainer (I do it weekly). I've attached a screenshot of my existing plan in Google Sheet. I'd love to generate something similar in Airtable. I'd appreciate any kind of brainstorming 🙏

So, I have contacts that have been pulled into Airtable from different sources (Active Campaign, Google Form, etc). Each data source is in it's own table and I have created a fourth table where I have pulled in EVERYONE using automations, lookups and roll ups. I have then grouped the view using email address and what I now have is a brilliant view of a single contact and how they are involved in our company. In my example below, I can see that she is a 'Puppy Handler' (pulled in from google docs data) and she has also subscribed to a few of our marketing emails (pulled in from activecampaign)... However, autonumber have given her 5 different ID numbers as she has a total of 5 entries within the base... is there anyway I can create a singe ID for her using her unique email address as the unique value???

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?