Ask the Community

I must be missing something very fundamental.  I converted Airtable's sample extension into my own, and it's running beautifully over localhost:9000, displaying as an extension in my sample base, as you can see below.  Everything functions when I check "simulate marketplace extension"But when I try submitting it for review, running "block submit" from the root (same place I run "block run" from) I got this:What permissions is it talking about?!  What is the "requested model"?  It's my own Airtable account, own workspace/base etc--and the code runs locally.  What am I missing?Thanks!  

I'm trying to use an automation in a base, but there's something wrong with my flow. And it may be that what I'd ultimately like to accomplish isn't possible. In Base 1, I have a single-select field named "Status" with various color-coded options as variables to select from. In Base 2, I have a duplicate of the fields in Base 1, but none of the data. My goal: When the single-select field Status is changed to a particular option (in this case, "Delivered"), the record is copied from Base 1 (Active) and duplicated in Base 2 (Archive). But the flow I have is definitely not correct. So, one, is this possible? And, two, does anyone know what I need to adjust in the automation flow? Thanks so much for your time!

Background: Source table has no records, but fields have been configured. This is a blank copy from another base.Issue:  When in EDIT mode and with Creator access, Interface Layout "Record Review" does not show any page elements (page is blank) and does not allow me to add or remove elements.  I am unable to configure the interface page. I am only able to configure the "Record List".Request: Is there another way to add elements to a Record Review when the source table has no records? 

Hi all,I'm wondering if it's possible to add an option for users viewing an interface (who have access to the base too) to sort/group/reorganise fields in a grid, without having to go to the interface editor.This article seems to think so - https://support.airtable.com/docs/getting-started-with-airtable-interface-designer - but I don't seem to have those permissions on my interface editor.Thanks!

When I query the Airtable base, the image does not appear. In the Pager Design extension, the image fails to load.

I am working on a job board project and have this challenge. I have gone through some of the community posts but cannot figure out a solution.The marketplace is continuously updated with titles, urls etc.I want to convert the URLs to hyperlink. As well, I want to create a solution that will apply to the entire field. I saw a post but I think that is valid for permanent  urls, not where every record has a new url. Is this possible? Any help will be greatly appreciated.

I was at ONA24 in Atlanta last week and, as someone who has used Airtable in my last four newsrooms, I can say Airtable would make a killing signing up new paid users. It is by far the best content management system available (I've tried them all).You really need to have a midway presence at ONA25 in New Orleans.

Hi!I have a table where I am tracking when a certain item (Lot) needs to have its lab testing updated. Each record has a {Lab Status} single select field, a {Latest Lab Date} date field, a {Next Lab Due} field that calculates a date 6 months out from the date field, and a {Send By} field that calculates a date 1 month prior to the next due date. The rest of the fields are linked to records in another table of the same base but are not pertinent to this.Record   Lab Status   Latest Lab Date    Next Lab Due     Send ByLot AA    Up Next        08/01/2024          02/01/2025        01/01/2025There are two functions I would like to implement, if possible, either into the table or with automations:1. (automation or formula?) When we enter into a given month, I would like for any records with a Send By date in that month to automatically update the Lab Status to 'Up Next'. F

Hi all,I want to expand a script that assembles an e-mail using a few field values and sends a nice and simple daily report to stakeholder.I want to add images inline from an attachment-type field. I use something like this:    if (clippings && clippings.length > 0) { for (let clip of clippings) { let imageUrl = clip.url; imageUrl = clip.thumbnails.large.url;    and later:     if (imageUrl) { entryText += `<br><img src='${imageUrl}' alt='Clipping' style='max-width: 100%; height: auto;' /><br>`; console.log(`thumbnail added: ${encodedUrl}`); }    I then pass my output over to the next step:    outputText += `${entryText}<br><br>`; output.set("emailOutput", outputText);    Although all URLS are definitely good (I paste them into the browser and

Hey everyone,I’m excited to share a new tool I’ve been working on: Formula AI.Formula AI is an AI-powered assistant that helps you create Airtable formulas instantly. No more struggling with complex formulas—just describe what you need in plain English, and Formula AI will generate the exact formula for you.Key Features:Natural Language to Formula: Type something like "Calculate total sales this month," and get the perfect formula instantly.Smart Suggestions: Get tips to optimize your formulas and follow best practices.Time-Saving: Reduce the time spent on formulas from hours to seconds.How It Works:Describe your need in simple words.Get the formula with explanations.Copy and paste it into your Airtable base.We’re launching soon! Join our waitlist to get early access: Join the WaitlistI’d love to hear your thoughts and feedback!    

Hello,I have a very simple formula that is taking the values calculated from other fields and giving a total.  The problem I am running into is unless I have the formatting set to 5 decimal places the results will round.  For the work we are doing we need the data to not round, but the issue is for the exports we have to do to input the data into another system we have to remove the extra decimal places. Is there a way to keep the 2 decimal place formatting while preventing the rounding?For example if a value is 2543.54546 we would like it to be 2543.54, but if I change the formatting to two places the number ends up being 2543.55 which for reconciliation is a problem.  The values change daily so the direction of rounding also changes.  My formula is super simple {value1} - {value2}I did try adding the ROUND function, but that didn't seem to help at all.  ROUND({value1}-{value2},5) I tried various values for the precision and none of them did what I n

Hi there,I have two tables and an interface with a form. The first form is used to add an entry to the table. I have this displayed as a nice gallery.I wanted to add a button on the gallery, so the user can click the button on the record and it will take them to another form to request a change to that record. I've got about 90% there, but getting the field to prefill with the record_ID has been miserable. I've tried every combination and it just doesn't work.On the form I added a new field "Link to another record". I select my primary table and select some columns to bring in via lookup. It looks great, the user can use the drop down to view all submissions and select the one they want. But the prefill doesn't work to auto select it. https://airtable.com/HIDDEN/HIDDEN/form?prefill_Vacancies=["rec1YlesldDRjs06V"]https://airtable.com/HIDDEN/HIDDEN/form?prefill_Vacancies=rec1YlesldDRjs06VNothing prefills the entry. If I try another field, like Name or Title which isn't a linked reco

Hi all, I am not sure if I am going about this the right way, so I’d appreciate some ideas. Goal: I have two tables. A “detail table” and a “main table”. The “main table” has a related list “link to another record” field to the “detailed table”. In interface designer, I am hoping to create a search that lets me find records from the “main table” and by selecting an item it lets ‘grabs’ the related list of items from the detail table. So, if I select three records from the main table, that each have 3 records in the detail table, it would show me the total of items from the detail table = 9. Appreciate any thoughts! Thank you!

I don't know if it is possible.. we know that on excel we can have live data and refresh the table to include the new data. And we know that we can link an excel file to airtable and export the data on it.So my question is can we create a dynamic airtable table that refresh every time I refresh the excel file?I don't know if it is something impossible.. Thank you🙏 

Hello,I am trying to create a web app using Airtable and Softr. I have already created a fully functional application, but now I want to scale it so organizations can create their own profiles and customize them as they like without affecting other users. I am thinking of creating separate databases for all organizations and connecting them with a central database, similar to how we do it in native PostgreSQL. However, I seem to be stuck with Airtable. Can anyone help me achieve my goal? 

I am new to Airtable. I am wondering whether you can send an email to an airtable record. Eg a follow up item to be added as a task. (This can be done in Evernote and other task programs). Thank you in advance

My company exports a .csv file every week containing the current inventory of the same objects.  Each object has a count that may change week over week.  We copy this .csv into an airtable weekly.  I would like to capture the old counts from the prior week so that I can track the differences week over week.  How can I set up a scheduler to move the values from the "This Week's Apples" field to "Last Week's Apples" field automatically?

I'm sure this an easy one - but I am stumped.  Here is the scenario: I want to create a view so I can send out a daily report that shows all records that are on tomorrow's service schedule, yesterday's service schedule, and 2 weeks ago service schedule.  The current airtable filter options of tomorrow and yesterday work great until it comes to the weekend - meaning on my Friday report, the Monday activity is not showing up and on my Monday report, the Friday activity is not showing up.  I have created formula fields that calculate the next work day but Im still stuck on how to filter it.  I tried to filter using "is after" "today" but then it gives me all records in the future when I just want the one next workday.  Maybe I am approaching this all wrong and making it more difficult than it is - but my brain is not computing 

i have a record table like this (simplified)idcreated at (datetime)category(text or link to category table)contentcatrgory record count (?)12025-1-2cat-1 222025-1-1cat-2 132025-1-1cat-1 1my idea ist to use a formula like this:count records, where category = category and {created at} <= {created at}somehow, all my approaches fail. tried rollup and formula.if it helps, category fields are linked to another "categories" table. but i could not filter over linked cecords, because that would require linking two times -  to the categories table and then back.i want to avoid using an automation, because i have a large number of existing records, and an automation seems hacky for me. if there is no other way, i'll go this route, though.i'd be glad for a hint or a lin to a documentation for a similar case 🙂

I’d like to integrate photos into Airtable but would prefer not to have to upload them directly as an attachment but would prefer to link them to someplace outside of Airtable. Currently I do this with an Evernote link. But ideally I could find a way to link it directly to my “Photos” app on the iPhone. The impetus for this is to avoid redundancy of having a photo stored in multiple places (Photos and Airtable, or Photos and Evernote). I store all my photos automatically to iCloud so I was hoping there is a way to link directly to a photo or link directly to an album? (Selecting photos and using the “Copy iCloud Link” feature doesn’t work b/c that link expires in 30 days…) Anyone know of a way to do this? Or any other interesting ways of tackling this problem? Thanks to this awesome AT community

Hi! I'm new at this. I want to send a scheduled email to a subgroup of contacts and pull in specific Airtable data into the body of the email and pull in the email addresses from the database. I'm using the gmail integration.In the "To" field I'm using the + to pull in email addresses from the base structure and the test keeps failing. It says "Invalid email address in the "to" field: fldU4hKNRZaMDR6U3".  The other fields in the body of the email that I'm pulling in from the base structure say FIELD ID instead of what the actual field name is and so I think those are also not working properly. I feel like I must be doing something incorrectly. PLEASE HELP. Is the email address in the To field what will act as my key to pull in all the other relevant data? I'm not clear if I need to set up a lookup/key mechanism here since the trigger is a specific time and not meeting a condition. To get to the subset of companies I plan to add a condition. THANK YOU!  I'm havi

I have filled this form but I didn't receive a reply. Is that working? How long does it take for the team to respond?Or have I to do anything else?Thanks!

Hello! I have a field in every record for zip code (number field) I am looking to have a sheet to count up how many records I have in a specific zip code. Interfaces can give me a chart on the zip count but I can not figure out how to get a table of it. I can group by zip code in the table by I need that data in it’s own table.

I'm based in the UK and we've had an integration working on a booking database for over a year which automates the creation of an Outlook event when a booking is made. No changes have been made to this automation but today the events which are in Airtable as dd/mm have started coming through as mm/dd. I'm really at a loss with this and what I need to be looking into.

Hello!I am trying to create a graph to show how many records where submitted in each month of each year, and for some reason I just can't think of a way to accomplish this.Example Jan 2020 =1, Feb 2020 = 3 .......... 12 2024 = 89, 1 2025 = 90 sorted in orderAnyone know how to do it?