Ask questions, get answers and engage with your peers
New here? This is a great place to start
Get support directly from your peers
Celebrate your Airtable wins
Forge connections with other Airtable users
Explore and RSVP for upcoming events
Read the latest news the Airtable team
Setup Create a table called “To watch”. Keep the default fields (Name, Notes and Attachments) Get an OMDB API key: http://www.omdbapi.com/apikey.aspx Script Add a scripting block with the following script: // Get an API key from OMDB here: http://www.omdbapi.com/apikey.aspx const OMDB_API_KEY = 'YOUR_API_KEY'; // Shows all the button groups together and waits for a button click // Returns the first button that was clicked async function chooseFromButtonGroups(label, buttonGroups) { output.markdown(`## ${label}`); return await Promise.race(buttonGroups.map(([label, options]) => input.buttonsAsync(label, options) )); } async function addTitle(title) { const info = await fetch(`https://www.omdbapi.com/?t=${title}&apikey=${OMDB_API_KEY}`); const { Title, Runtime, Plot, Poster } = await info.json(); output.markdown(`  # ${Title} ${Plot} Runtime: \`${Runtime}\` `); const table = base.getTable('To watch'); await t
I have a bunch of columns/fields that use the same list of single-select values. I have changed the colors of the selectable values in one of the columns and I want to apply the same change (colors) to all the other columns with the same range of values. How can I do this short of manually edit the colors on all the other columns?
AirTable is not allowing me to upload my CSV file. I click on the + sign, select “CSV file” under “Add from other sources”. I drag in my CSV file under the “Local Files” section and click “Upload 1 file”. It seems to work, I select “Create a new table” under the “Import your file” dropdown. It shows me a beautifully created base with all the column's I’d like. However when I click “Import” I get an error sign saying “Can’t import CSV file” with the statement “Invalid data” underneath. Does anyone know what might be going on / how I can fix this. The only option airtable gives me is to click a button saying “Okay” and I’m back to the start.
They are in the same base.
Hello, I'm stuck and need your help.I created a 6-page contract using the Airtable Page Designer extension.The problem is twofold: I succeeded in the first step but not the second.Basically, the Page Designer extension only allows you to edit a single page. I found a way to extend the page height by multiplying it by 6. Except that Airtable doesn't allow you to insert page breaks, and I'm exporting a very long PDF file that I can't split. And no matter how hard I search, I haven't found an acceptable solution for printing this contract correctly.Do you have any solutions or advice?Thanks!
Hello all:I have a table that stores our department's class offerings schedule. The important fields are:Lecturer's name Course number Day of the week (Multiple select - as there can be multiple days the class is offered) Start time of the class (the date does not really matter here; We only care about a typical week) Duration of class (in minutes) - helps to compute the end time of the sessions. I would like to generate a view that shows us the Weekly Schedule that is “date Agnostic” for an entire semester. The columns will be the weekdays, and the rows will be the time frames of each day (running from 7am to 9pm). I would like the classes to be filled into a “calendar-like” view based on their time and day of offering. This will aggregate across all classes, and i would also like to apply filters to it. We achieved it in Tableau, but it would be nice to have it in Airtable, where all our data are typically stored. Thanks for your help.
Hi, Many of my automations that worked for months are failing after the recent update. Is anyone else experiencing this?
Are there any airtable builders based in the UK. I need to find someone registered here to qualify for funding for my project which is a client facing portal. Thanks
Hi, I’m building a page to track hours — comparing what we’ve budgeted versus the actual hours spent. We’re tracking time in Harvest, and at the moment I’m manually entering that data to match it up, which means there’s no direct link between the two systems. We use the same standard phases for every project (example: B01-B09). Each time a client signs a fee proposal, I want to add these same phases to the new project and allocate the initial budgeted hours. In Excel, I’d simply copy and paste multiple rows, but in this system I can’t duplicate more than one row at a time, which is slowing things down.Ideally, I’d like to be able to duplicate all phases (B01-B09) and assign them to a new project in one go, then input the hours. I also update the actual hours weekly, so it needs to be easy to maintain. I’ve been exploring whether an interface with a button (plus an automation) could do this — so that with one click it would add all the phases for me — but I’m a bit stuck on how to set t
Hello,We are using the “Phone SlackID” field in Airtable and passing its value into the body of a message using the “Slack Send a message” action in an Automation to send mentions.In the “Phone SlackID” field, we’ve set each user’s display name in the format @last.first, and it has been working correctly for almost all users.However, after one staff member changed their display name, they no longer receive mentions. Specifically, @last.first now appears as plain text.Could you please advise us on how to resolve this issue?
Hi Dear community i’m facing a scipting error pleaase help mei need to connect my ingredients tables to the API open food factsThanks let tableIngredients = base.getTable("Ingrédients");let tableOFF = base.getTable("Open Food Facts");let ingredients = await tableIngredients.selectRecordsAsync();let offRecords = await tableOFF.selectRecordsAsync();for (let record of ingredients.records) { let ingredientName = record.getCellValue("Nom ingrédient"); if (!ingredientName) continue; let response = await fetch(https://world.openfoodfacts.org/cgi/search.pl?search_terms=${encodeURIComponent(ingredientName)}&search_simple=1&action=process&json=1); let data = await response.json(); let product = data.products && data.products.length > 0 ? data.products[0] : null; if (!product) continue; let nutriments = product.nutriments; let energie = nutriments["energy-kcal_100g"] || null; let proteines = nutriments["proteins_100g"] ||
I’m trying to make an extension that generates a file using base data and then re-uploads that file back to Airtable. However, I’m not able to find any way to access the upload attachment HTTP endpoint from within the Blocks SDK. The API reference only shows examples of “uploading” attachments using public URLs.Is there any way to access this functionality (properly) from within a blocks extension? Or alternatively some sort of internal PAT or similar I can use to make the POST request without hardcoding something that will be exposed in the browser?
Accelerate your learning journey with comprehensive learning paths and validate your knowledge with Airtable certifications.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.