Ask the Community

I am currently developing an integration with airtable base.It is very nice to have webhook notification from airtable api.1. How to respond properly to the notification?Once the record changes, the notification works via webhook.But it repeated more than once and I want to know how to stop it after receiving the first notification.2. How to clear payloads that already received?When the record changes with the attatchment field, there are two or more payloads for it. Here is a response data of payloads.{ "payloads": [ { "timestamp": "2025-02-05T15:24:39.621Z", "baseTransactionNumber": 300, "actionMetadata": { "source": "client", "sourceMetadata": { "user": { "id": "usre3JyKUosldgaGX", "email": "antman357357@gmail.com", "permissionLevel": "create", "name": "Ant Man", "pr

Hi team,Can someone help me with the following. I have abase with 10k+ records. I have created a chart, but because of the volume of data the chart shows more than I need. What I am needing is the chart to dynamically display only the top 10 values of any given variable. So if I have created a chart of the Titles I have been in contact with I only displays the top 10 titles, rather than all 100+ titles. How can this be done? Thanks for your support 

Hi there - I am an academic researcher and using Airtable to keep a database of primary source documents that I have scanned and will be using in future grad research. I am not collaborating with anyone on these documents at the moment.I want to link the actual files to the database entry, but don't think dropping in the actual file will be sustainable over time (thousands of high res scans of various sizes)?  I'll quickly overrun my Airtable space, I believe.When I scan the files at the National Archives, I use a program (ScanSnap) that is much faster and more reliable in saving the file locally to a folder than uploading to Dropbox automatically, though it is a built-in option. So, I'm somewhat torn.I am a Mac user and was going to go through the (somewhat tedious) process of using iCloud links to put in the columns where I want to link to the documents. I have plenty of iCloud storage space. The only thing throwing me off is when I'm on my Mac, that link just takes me to t

I had no idea what to call the subject for this post.....I want our company to donate £5 per 100 confirmed hours worked on site, to purchasing trees via ecologi.On the 5th of every month, I want the airtable to add up the total number of confirmed hours worked in the roster for the previous month.This number is to be divided by 100 with the result being x.x may be rounded up (optional at this stage), then the total amount is to be sent to our ecologi account using a webhook to zapier.Any leads onto how best to sum up the previous months totals please?Pro's and cons to watch out for?

Hi Airtable Community,I'm experiencing some challenges with RTL (Right-to-Left) text handling in my base, specifically when mixing Hebrew/Arabic with English content. I'd love to get some insights from the community on best practices and possible solutions.Current Issues:Text alignment becomes inconsistent when mixing RTL languages (Hebrew/Arabic) with EnglishThe reading flow is disrupted, making it uncomfortable to read and work with the dataThis affects both table views and interface elementsQuestions:Is there a way to set a default RTL alignment for specific fields or tables?Are there any known workarounds for handling mixed RTL/LTR content effectively?Does Airtable support RTL for automated emails and notifications?Use Case: I'm managing a project where we frequently need to input both Hebrew and English content. Currently, the mixed text appears jumbled and unclear, which impacts our team's efficiency and data readability.I've already tried:Using different field typesAdjusting fie

Hi all, I have set up an auxiliary table that has values in columns based on condition (the column name). I have a main table in which I am trying to pull data for items based on the condition of that item. So, I am trying to get Airtable to go to the auxiliary table, look up the requisite item from the main table, and find the value based on the condition that is noted in a field in the main table (please see screenshot attached). There is a field on the Inventory tab that notates the condition and a bunch of columns on the DB tab that have values for each condition. I need to write an automation or formula that tells Airtable to look up the condition of the item on the Inventory table, go to the DB table find the appropriate item, and look up the value based on the condition in the Inventory table.  Thanks for any assistance you can give me.

I want to create rent payment schedule to send to someone after they sign leases for an apartment using the data that I have in airtable. The rent payable is typically the same price every month but sometime if they start not on the 1st of the month the 2nd month is pro-rated. Also a few times are free month rent is given so that month no rent is due. Always paid at lease signing is 1st month rent and one month security deposit. The 1st Month they will always pay the entire amount even if the lease doesn't start on the 1st. The 2nd month is always pro-rated if there is pro-rated rent. I was things about having each month as a column (Sept 2024, Oct 2024, nov 2024 etc) then we can use ai and formula to look up the start date, end date, rent amount to put the data below in a table to send out in an email in automation or I can set up via Zapier. In Zapier I can probably also set up this type of automation but want to get an idea what the best way to do this.

hi Airtable users!I have a question regarding custom selection of Lookup Field Values in Linked Records.I have 2 tables (A and B). I setup a Linked Field and then 2 lookup fields in table A. This pulls in a Group name Category names from B.Now in Table A, I'd like to manually choose a specific Categories (based on categories from the lookup field).  The steps I'm trying: I choose a group (in the linked field), and then choose categories manually... but I can only see how to show ALL categories in the lookup field OR categories that meet certain conditions. But this is not what I want... I want to choose only specific categories, which vary for each record. There are no conditions for this.How would I do this? Maybe there is a formula?  Please help!How can I choose specific values based on a lookup field?Thank you

Is this something that is possible? I’m feeling limited by only being able to group by 3 criteria.

Oh, this one has me stuck!I have a table of 'Individuals' with an email address and a unique ID on one table, and on another 'Audit' table, I have audit line items with the linked ID. I would like to use a checkbox of 'publish' in the Individual tab to trigger an email that sends a table of relevant data to the right individual. Right now, I have a trigger or 'when records match' showing a few conditions including publish. then Find Records, then Repeat for each List of records, with a send email and appropriate grid in the email. Problem is, I can't convince the automation to sort these, so person A only get their results ,and Person B get theirs. It's a mash of results, not getting split per individual. Because the list of individuals will continue to grow, I can't create a view per individual.Can anyone see what I am missing here?

Hi! I'm trying to set up a conditional automation and the "Otherwise" condition is giving me an error.Trigger: A record enters a view. The view relies on the field {1 week} not being empty. The two possible values are "1 week late" and "2 weeks late" First condition:If {1 week} contains 1Condition 2 should be either:Otherwise, or1 week contains 2 (or equals "2 weeks late")I get success after the first condition but the second condition failsIt feels like i'm missing something obvious! Thanks!

Hello, With the API custom with a filterbyformula, I would like to collect all record, corresponding to my needs, from two differents fields. “Conversation?filterByFormula=%7Bexpediteur%7D%20%3D%20%27${user.email}%27” Like, in this case i would like to get all records into “expediteur” field where {user.email} corresponding. But now in my case, I would like the same but into two fields. (expediteur & destinataire) is it possible ? And how to write that ? Thanks you

Are the record's previous values available in the "when record is updated" trigger?  I'd like to be able to compare the previous values with the current values and act accordingly.  Does this require a code step instead?

I have a database with ages, I have grouped the ages into views and I want to shuffle each members a particular age into a group of five. For example: Ages 18-24, I want the members to be grouped by five members each and at the end of each month, the automation shuffle the members so the members are different for each month.

In many other systems you have an "Edit" button. Until you click the "edit" button, the data is read only. Adding this basic feature would solve A LOT of problems using Airtable. Each and every grid (and maybe other views) should have the now famous Airtable slide switch: Locked or Unlocked. (A nice touch would be a green border around the entire page for unlocked, red for locked.) This would allowing sorting, grouping, filtering etc. and working with the data w/o accidentally changing  the data, something that has happened to us more than once.   

Hello there smart folks! I am building a base for small film productions, and the industry has some odd practices I have to work around. One of those is tracking scenes on scripts in page length in fractions - specifically 8ths.For my personal tracking I have a column that just holds the size in the total number of 8ths (so instead of showing 1/8 page it is 1, 1 and 3/8 pages is 11) which I can then total into total number of 8ths.I now need to convert that back into pages in fraction form to display on one of my reports. So say I have 10 scenes over 5 3/8 pages (so my total is 43). How do I create that 5 3/8 to display?I hope this makes sense!

Hi,how can I add my email signature for the email automations? 

I have a column of Job Names and would like to indicate which Job Names are unique in that column. Has anyone successfully done this? Essentially I want to do the opposite of checking for duplicates and returning duplicate values in a new column.

Hi, I am very new to scripting and managing a base for content production.  Want to create a script that will update a series of dates based off the publication date changing.  I'm getting errors and not sure why.  Any help would be appreciated.  ThanksHere is the scriptlet table = base.getTable("Deliverables");async function updateRecord() {let inputConfig = input.config();let recordId = inputConfig.recordId; // Fetch the record ID from the previous step// Check if recordId is valid (a string and not undefined)if (typeof recordId !== 'string' || !recordId.trim()) {throw new Error("Invalid or undefined record ID. Ensure the input provides a valid record ID.");}// Fetch the specific record from the tablelet record = await table.selectRecordAsync(recordId);if (!record) {throw new Error(`Record with ID ${recordId} not found.`);}let publishDate = record.getCellValue("Published Date");let Series = record.getCellValue("Series");if (publishDate) {let updates = {};if (Serie

Hi,I am working with a list of contacts in my main spreadsheet. I am trying to update a specific information of many contacts simoutaneously. So I created a second table, where I want to input the name of the person, and this information (books received). I want to be able to add a list of people and books on this second table and add these books to the already received books on the main table.I was able to do part of the way, but I am having a problem with the Record ID after the Find record step. For some reason I only see the option of 'List of Airtable Record ID', which I think is why it is not working. It seems like a simple automation, but I can't go around it. Any suggestions?Thank you!

I attended the advanced app building webinar this week (shoutout to the excellent host, Jen Johnson!!) and noticed this new visualization option in interfaces: swimlanes. Is this something that is coming soon? I don't see this option available on my end as an enterprise user. Super excited if it is coming, as it looked awesome in the demo! 

Hello! I am new to Airtable and have been poking around for awhile now to try and create the following / see if it is possible in Airtable.OverviewI am setting up a super simple voting table, it will just have an ID and 3 string vote fieldsI.E. test data, and/or the Votes table, would be like (made-up names used)IDVote 1Vote 2Vote 3582394John DoeSally Sue (blank)362344Billy JoeJohn DoePeter Thol623442John DoeBilly JoeSally SueWhich ideally would aggregate into this Votes Cast table, sorted greatest to lowest number of votes:NameVotes(aggregated from above based on string value)John Doe3Sally Sue2Billy Joe2Peter Thol1At first I was reading about Rollups, but I am not seeing examples utilizing multiple fields/and or creating dynamic lines for results, for example, if a new person submitted the name James Cullen, then a new row would appear about for James Cullen with their 1 vote.If this is not possible...is there a way to achieve this if I do 1 vote per row? I.E. If each vote (of t

I'm trying to set up a paypal scenario in Make.com that adds new paypal transactions into my airtable table. When I try to set up the airtable connection, I use OAUTH type, and it asks for a a URI Redirect URL. I don't have a clue what to use here. When I google, it asks what site I want people to redirect to, but that doesn't help me much.Anyone able to advise?Thanks. 

Hi all!Clicking an URL link in 'list view' does not open the URL in a new tab in the web browser. Instead it 'highlights' the URL in goes into edit mode.I want a click to 'follow the link'. How/is it possible to do that?Thanks for any suggestions!/Jonas

Does Airtable provide the access control, if we want to control read and write access at screen and components level?Means if there are 10 fields on one screen and we want to give edit access for only one field to one person and give edit access for all fields on the same screen to another person