Ask the Community

Hi,I need some help auto creating weekly calendar entries a few weeks in advance.Currently my automation is set to create 8 calendar entries every Sunday, which shows on a Calendar view for one of my tables. For instance, if my automation ran on 9/3, it would create 8 entries on 9/3.Ideally, what I would like for my automation to do is to create the calendar entries 2-4 weeks in advance so if my automation ran on 9/3, it would create the entries for 9/10 and 9/17. Thanks in advance for any help!

I have written several Scripts and an Extension. Both of these use the Base, Table, View, Record, Field classes provided by Airtable. I would now like to create a node service running in the cloud that needs to get and set information stored in Airtable. Is it possible to use the same JavaScript classes as with a Script or an Extension to access Airtable data from node? Cheers  David

Hello,I have records of 4 thousand rows in Airtable, with around 100 views and about 50 columns. Two of them have attachments fields where we store pictures.Every month, we need to create a new table organized by month, and we want to retain the previous month's views and settings, but the data itself is not required. Currently, I use the duplicate table feature without including records, but it has become quite problematic and slow. I am wondering if the Airtable team is working on improving their servers to address these issues.I need some assistance. Is there any other method or workaround to synchronize all the views and create a new table for this month without including previous records?Thank you.

Hi there,I am creating a simple extension that creates a record with an attachment. I am using createRecordAsync  from the blocks API for the record creation and the the native URL interface from the Web API to create an URL from the file loaded in by user via an `<input type="file"/>`.URL objects const handleFileChange = (e) => { (...) const newFiles = Array.from(e.target.files) const fileData = newFiles.map((file) => ({ filename: file.name, size: file.size, type: file.type, status: FILE_STATUS.LOADED, url: URL.createObjectURL(file), })) setFiles(fileData) } then (...) table.createRecordAsync([{attachment: {filename: file.filename, url: file.url}}]) A record is created succe

I am struggling to get a Formula that would return my age, where the number after the decimal point indicates the number of months in duodecimal format. For example, my current age is 34 years and 3 months, therefore I want to see 34.03 as the return.So far I've managed to only get this:the formula I am using is:(DATETIME_DIFF(TODAY(),{DoB},"Y"))&"."&((DATETIME_DIFF(TODAY(),{DoB},"M"))-((DATETIME_DIFF(TODAY(),

I am not sure what is the best approach to this. I have a single Network chipset card with 40G speed total.With this controller:We have 2x SFP  which are 10G each and it has a unique Device IDWe also have 2x RJ45 which are 10G each and it has also its own Device IDFor clarity purposes, this is how I use to track it (items marked in red are unique) it: https://drive.google.com/file/d/1K7YCYDiabyWvc_EJ9XSEnqFzSunNUOWE/view?usp=sharing I have tried to do the same in Airtable, but I can ONLY select x710-TM4, Carlsville 1 time. It seems it filters this out by default from the list. I have the option to select other chipsets from the list, but cannot select the same one.What is the best way to approach this? I need to be able to tell that the card with this chipset has 2x SFP+ port and DID for it is 104E. A

Hi there!I am trying to find in the form interface to be able to submit multiple records with the same information in the easiest way possible.I have a form for production to submit GFX requests so we can better judge workload. Request is attached to a project, and in the form you can enter in information like a description of what the GFX should be, starting assets, etc. There could be multiple rounds with the same info so I want to be able to select a  project and add multiple dates/requests with the same information.I'm not sure if this could be done in one form with adding additional date options somehow or if there's a way to duplicate existing requests. Let me know if anyone has any ideas.Thanks!

Hi there, I guess the interfaces don’t work on Airtable mobile app yet. I cannot build an interface, ok, but I don’t even find the interfaces I made for my table… At least when I try to get to my new interface from my iPhone, I only can find a mention of it in notifications (but not on the workspaces overview), and it looks awful when I try to open it. And if I click on the link in my email from my iPhone - no way to get to the interface either… Or is it just a bug of my iPhone?.. Thanks! :winking_face:

I have a description field, and would like to generate it based on values.  I could not find any way to format numbers, like there is DATE_FORMAT for dates.  The TEXT function in Google Sheets allows you to format exactly like you want it. In my case, I want to format the number as 0.00.  else, Airtable will sometimes show as 213.3, or 214.57777777 which is very ugly. 

HelloI have an automation in grid mode (so I can select records). I want to create a Google Sheet of those records.How do I Find Records based on those selected? The google sheets bit I can do.

Hello, I'm encountering an issue with a formula I'm using to calculate video aspect ratios in my Airtable base. I would appreciate any assistance in identifying the problem or suggesting an alternative approach. The formula I'm currently using for {test3} is: {test1} / {test2}Here's the expected behavior of the formula I'm using for aspect ratio calculation:- If the value of the field {test3} is 1.78, I want the formula to return "16x9".- If the value is 1.00, I want it to return "1x1".- If the value is 0.56, I want it to return "9x16".- If none of these conditions are met, I want it to return a blank result. The formula I'm using for this is:IF( {test3} = 1.78, "16x9", IF( {test3} = 1.00, "1x1", IF(

Hey everyone! Im using a script (that I found here in the community, thanks btw!) to pull data from Airtable to Google Sheets in order to make some weekly reports for employees in a company. Problem is, it seems each time the script runs it retrieves the Fields in a random-ish order, which is a problem because those fields are referred to in the reports. Using Zapier is not an easy option since we have more than 400 fields. Here is the script var api_key = "XXXXXX"; //ADD YOUR API KEY FROM AIRTABLE HERE var baseID = "XXXXXX"; //ADD YOUR BASE ID HERE var tablesToSync_fromSheetRange = "A14:B15"; //UPDATE CELL RANGE HERE (for tables that you want to sync) ////////// add items to UI menu /////////// function onOpen(e) { SpreadsheetApp.getUi() .createMenu('Airtable to google sheets sync') .addItem('Manually sync all data', 'syncData') .addToUi(); } ////////// function to trigger the entire data syncing operation ///////////

I'm doing an extension and I need to get some data from the table. Specifically all the records from the table or selected records, but when I go and select records it only  shows me the ids or names of the first field or "primary field". Is there a way to get all of the other ones? 

TLDR: I'm trying to mark employees as "OOO" if they are OOO for 3 or more days of the week (vs if they are only OOO for 1-2 days of the week they still show up as available). I have a system set up where I have created an "open space" record for every week and previously I had it set up so if the employee was OOO for any part of the week (even if it was just one day) the open space record will show up in red as "unavailable". But I want to adjust that to only showing up as unavailable if they are gone for more than 3 days of the week.I have created fields in my table that shows all the days of each record,  so for the Open Space records it lists out all 5 days of the week vs for any OOO records it lists out all of the OOO days.I'm looking for a formula that compares the two. When the person is only OOO for one day, the formula below works great (as you see for my 12/1/2023 example) IF(FIND({[Prototype] Daily Dates 🧮 🏳&#650

I have created a Description and have associated it with a dashboard.  The dashboard is not displaying the Description Extension no matter where or what I try.  How can I get the extension to display on my dashboard?

I am not sure what I am doing wrong. When I use the script I have written on the scripting extension I get the desired output, however when I put that same script into an automation, the output is all wrong.Is there something I am missing?

Hi there,I am hoping there is a formula for what I need. I want to be able to have a date populate when I put in 30 days from today, or 20 days, or 45 days.Example: I need to follow up with sales lead A 30 days from today. What is that date?Thank you! 

Hi All,I'm juste trying to write a small script in node js to get a list of a db I have here in Airtable.As the documentation said, I've used https://www.npmjs.com/package/airtableand my code is as follow :  import Airtable from 'airtable'; const baseId = '****'; const tableIdOrName = '****'; Airtable.configure({ apiKey: **** }) const airtable = new Airtable({endpointUrl: `https://api.airtable.com/v0/${baseId}`}); console.log("airtable",airtable); ==>>> {} console.log("airtable",airtable.getTable("tableIdOrName")); ==> "TypeError: airtable.getTable is not a function" Thank you for your help!

Hi AT Community,For a project I am doing resesarch on record templates. I was wondering if Airtable has any limitations on how many new records can be created at once when using a task template table to insert new tasks once a project has entered a table with certain column conditions.So, there is a project table where a new record will be created with certain columns. A combination of columns will set of an automation that will trigger the creation of new records in a task table, based on a task template. I currently have 90 tasks related to a certain project label, which need to bo copied from the task template table to the task table (the projects are pretty standardized regarding tasks). Is this possible in Airtable, or are there any limitations on how many records can be created at once through an automation?Looking forward to your reply, thanks in advance.Regards,Arjen

I prepared an api script (with the baseId, tableId and the token). I tried to run it on a console and I get error massage. We should I run it?

Does anyone think it is possible to use Airtable to manage ads for a website?I am running a small niche website that I would like to sell ad space for. As such, Google Adsense will not work for me because my website is not big enough, and it also runs under a subdomain.Therefore, I figured I could use an "image carousel" for the ads.But how would I display these ads from Airtable? Is it possible to automate? For example, if you paid for the ad, it will automatically appear in the ad space. If you have not paid, it will be taken down.I figure people could fill out a form with their ad and add it to an airtable database and if it's paid/approved it can appear on the website. Just trying to brainstorm, thanks!

Hallo community,I have two tables: "Bestellungen", "Bestellung Positionen".Table "Bestellungen" has 3 Lookup fields "Artikelnummern", "Anzahl", "Einzelpreis". So the values will be not correct sorted like in a table "Bestellung Position".I think, it is a big bug in Airtable.P. S. If it is not possible to sort automatically in "Bestellungen" table, how should I sort it in relative table "Bestellung Positionen", which filter should I use. I know how to sort Table "Bestellung Positionen" by a field with a type "Created time", then the result with be ok, but I still need an option to order it how I want... And table "Bestellungen" should automatically bring me the same order.Thanks in advance. 

I want an automation to update the linked records. It works when a record only has 1 linked record that the automation should update. But when there is more linked records to update it will not change any of them.   any suggestions?   

I just set up my first multi-source synced table. The information is syncing correctly, but the lookup and rollup fields aren’t working, those fields will only pull source data related to the first synced table, not the second. This seems like a glitch since it completely eliminates the benefits of having multi-sync functionality, has anyone else experienced this? Could this be related to something I did incorrectly at set up?

Does anyone know whether the Webhook API contributes to the new API limits on the Free/Team plans?