Ask the Community

I am trying to create an Overview with Buttons for Forms.  When I finish it, it looks normal, but when I have others test it, it does not appear correctly.Here is what I see: Here is what I would like to see:  I have done the following:Clear the cache and cookies.Used multiple browsers (same result)This way on both Mac and PCChanged credentials of users accessing the site.Same result for any table that I have built with OverviewAny assistance is appreciated Thank you,

So close to getting the whole base working the way I want I can see the light at the end. I think the final hold up is getting the "Find Records" step working properly.My automation triggers when a new record is created in "Trainings". The "Trainings" table has the following fields:Training Type (Single Linked Record to Another Table Called Training Types)Date (date field)Attendees (Multiple Linked Record to Another Table Called Employees)Expiration Period (Roll-Up from Training Type Table)Expiration Status (Formula Based on Date Field and Expiration Period Roll-Up)Expiration Date (Formula Based on Date Field and Expiration Period Roll-Up)The other table "Training Assignments" has the following fields:Employee (Single Linked Record To Employees)Training Type (Single Linked Record to Training Type)Assigned (Checkbox)Trainings (Single Linked Record to Training Type)

Hi everyone,I'm working with the Kanban view in Airtable and wondering if there's a way to modify the tooltip that appears when hovering over a status or add a "Sub-Status" field to provide more details. Right now, I have stacked columns for different statuses, but I'd like to display more information without renaming them completely.Has anyone found a way to:Show a "Sub-Status" field in the Kanban view?Modify the tooltip that appears when hovering over a status?Add descriptions directly in the stacked columns?Would love to hear if anyone has a better approach!Thanks in advance!

Hello! We recently built an Airtable base to use as a Project Management system to track milestones and tasks. We primarily work out of interfaces, and rarely go into the actual data tables at all. When someone @mentions another user in the comments section on the interface side, the email we all receive links to the data side. Is there a way to adjust the links we get in the emails so that it takes us to the interface side instead? Also, can these emails be further customized to give more information as to which deliverable/milestone/tasks it's coming from?Thank you in advance!

I am trying to create a google App Script, which contains columns mapping to an Airtable table. I would like to sync one-way from the Google Sheet, into Airtable.  The first column is the primary key, and is used to match. If the record exists in Airtable, it will update. Else, it will create a new row.I am trying to execute the below function, to find out if the record exists already by primary key value (Note - NOT record ID). function upsertAirtableRecord(apiKey, baseId, tableName, primaryKey, fields, primaryKeyFieldName) { var url = 'https://api.airtable.com/v0/' + baseId + '/' + encodeURIComponent(tableName); // Search for the record to update var searchUrl = url + '?filterByFormula=(' + encodeURIComponent(`{${primaryKeyFieldName}}='${primaryKey}'`) + ')'; var options = { method: 'get', headers: { Authorization: 'Bearer ' + apiKey, }, }; This is returning an error: 

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",

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'

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

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

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("Publ

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!