Ask the Community

I use proprietary software in my line of work that allows me to export client data into a CSV file. One of the fields in this CSV file is called Household ID. Let’s call this CSV file “Household Assets”. In airtable, I already have a table called “Households” with has the exact same Household ID field and number for each household. Is there any way to import the CSV into its own table in airtable and automatically link both tables given they already have a common field, Household ID? This would be useful as I could simply import once per month all my household asset updates and somehow track the trend and progress of my client assets. Any ideas how I might be able to accomplish this? It would be great if I could even somehow automate this process too.

I use the free version for my card making inventory. I've been uploading images to my base and I'm concerned that I might be getting close to the new storage space limit of 1 GB total storage per base.How do I tell how much attachment storage space I'm using?

I have two tabs. One table with a list of weekly events and a second that collects those into weeks. I'd like to quickly reference a range (let's say 10 rows from the weekly list) into the 2nd table on a weekly cell.Currently, I do this very slowly. I type in the row number. Airtable shows a preview and I click that record to add the row.What I'd like to do i just type rows 12-22 and hit return. I just don't know if that's possible or what the syntax might be to make that happen.

On Table A I have a linked record field that allows multiples. It pulls records from Table B. These records on Table B include a Date field. Records on Table B are not necessarily entered in chronological order. For example:Table B Record 1 - 1/1/2023Table B Record 2 - 3/1/2023Table B Record 3 - 2/1/2023On Table A, I'm trying to pull the most recent record linked using a Lookup field with the "limit the number of items shown" option turned on and set to "last 1" but I believe this is giving me the date of the linked record that was most recently created rather than using the date field of the record to give me the most recent. I believe I could play around with an automation that could accomplish this for me but before diving into that, is there a more simple way to achieve this?

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 Tools', {label: 'Links and Tools',description: 'Select a table with records that have attachments you want URLs for',}),input.config.field('Attachment', {label: 'Attachment field from the selected table',parentTable: 'Links and Tools',description: 'Select the attachment field from the table above you want URLs for'}),input.config.view('Grid view', {label: 'View from the selected table',parentTable: 'Links and Tools',}),input.config.field('Attachment URL', {lab

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.

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 successfully and I get no error or warnings, however, the file is never attached to the record. I wanted to avoid having to go through the Airtable API.  Is it possible to create an attachment directly from an extension?   Thanks,Pedro

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(), {DoB},"Y"))*12)) It is pretty close to what I am looking for, but how do I get 2 digits after the decimal point by default?*I understand that it may be a weird request asking to combine decimal and dozenal numeral systems like this, but would really appreciate if somebody helped me solve this one 🙏 

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. Also it has 2x RJ45 and the DID for that is 15FF

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( {test3} = 0.56, "9x16", "" ) ) )Please note that {test1} and {test2} are numeric fields that store video resolutions.  However, the formula i

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 /////////// function syncData(){ //fetch table na

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 🧮 🏳️}, {[Prototype] Daily OOO 🧮 &#127987

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?