Ask the Community

I have a formula created that is predicated on creating a count by a criteria. We have a list of records and each line item has an associated email entered. I'm trying to create a formula that will be a running count based on the emails. Essentially this is a count of shifts someone works with us. Can anyone help with this?

I tried copying a script from the extensions section and using it in a script for an automation.Safe to say it did not work and gave me multiple errors.What would be the easiest way to transfer the code from one to another? @kuovonne Script:let config = input.config({title: '📎 Convert attachments to URLs',description: 'Output comma-separated URLs for all attachments and write to another field for each record. Can be used for sending URLs to third-party integration services.',items: [input.config.table('Links and

Hi all, I’ve got a column for ‘date of birth’. I’m looking for a formula that will input their age in months and years. (At the moment, it will only let me do one of these) DATETIME_DIFF(TODAY(), {D of B}, ‘years’) I then plan to add an IF statement along the line of (if months = 11 show an alert) so I remember to send a card. Thank you for any help

I love the way airtable universe pages look. How can I publish or create pages for my database like that to share with others? Databases that wouldn’t be helpful for the universe community.

I am a business specialist for a company and I also teach workout classes for the women in our office 3 times a week. I have a fitness Airtable base where I have added all the exercises I like with a muscle group field. I am trying to find a way to automatically generate a workout to reduce the time I have to spend coming up with a set of exercises. For example, we worked chest and triceps yesterday so today I want to generate a workout that includes x number of exercises with x number being bicep workouts, x number being back workouts, and x being ab workouts.I have very minimal developer experience but I can edit and update pieces of a script if given the outline. 

Has anyone created an API between Workfront and Airtable? We currently use Airtable for project management/planning and sharing of projects, but creative requests/approvals go through Workfront… would be looking for one-way communication from Workfront to Airtable (specifically relaying dates from Workfront tasks and moving final assets/creative files from Workfront to Airtable once they are approved in the Workfront system). I’m only familiar with Zapier to connect platforms and unfortunately Workfront is not available there, so wondering if anyone has had success connecting these two with a custom API? TIA!

Hello, greetings to all!I am looking for a solution for my table, I hope you can help me.I need to create a button with a Script, and this button should change a single select and in turn fill a text field.It is for an inventory, I need to know the item where it is located, with the single select I have the different warehouses, and the text box is a comment about its location.Do you think this is possible?I am very new to airtable, I started using it a month ago.I try to create a great Workspare to present to my superiors and request an upgrade and thus be able to work the entire company with this wonderful APP.Thank you very much in advance

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!