Builders Board

Hi community!Leandro here the creator of the Airtable Pack for Coda sharing some news 🙌Integrating Airtable tables with Coda documents opens up a world of possibilities for enhanced collaboration, organization, and automations:1️⃣ Select your Base2️⃣ Select your Table3️⃣ Drag and drop4️⃣ Optionally select a View5️⃣ Airtable in sync with Coda 🔄 If you want to learn more, check the launch on Product Hunt and join the conversation ❤️https://www.producthunt.com/posts/airtable-pack-for-coda 

I use Airtable to track and monitor several backlinks, which I manually track with a Va i.e. do-follow, no-follow, live, removed. Now, I’d like to have a column in Airtable that automatically updates the status of the backlink without having my VA do it. Here’s a custom app that does it well: BacklinkManager.io

Hi, I would like to ask if this is possible. So we have an airtable view that contains all the schools in the Dallas metro area. Under Dallas, there are 58 schools. But we want to get the top 20 schools base on their School score. Is there a way to get the top 20 schools with the biggest "School Score" via the formula field or scripting? Though we can use the "Sort" but we want to have a field that will be updated into "Yes" or maybe "To be uploaded" when their school score is included in the top 20 biggest school scores.   

I want to add/update an existing table with a new CSV file.I used this article: https://support.airtable.com/docs/csv-import-extensionIt was perfect till the point that I had to choose only one field under "Merge with existing records".How can I merge based on two or more fields? 

Goal: A user can create a post including any version of a youtube or twitch URL. When the post is created it appears in a repeating group and the link appears as an embedded video. Current State: The entire site is already built using a combination of airtable and bubble.io. This is the last feature that I need. Work: I am open to ideas. What I know right now is that it can be done either with a Regex Formula or JavaScript Automation using the video id. Budget: Hopefully, under $200. But we can discuss it, based on your idea. 

hello, I have a small but may complicated issue. I have a data table, that lists several items to view over a website. the form for the table works well to populate the fields and add items. what is needed is another "contact form" that a visitor can use, to send inquiry, where the subject field is "prefilled" with the specific item number that the visitor "clicked-on" and expanded. like adding a button field, that will open that form, with the prefilled value from that exact column-row intersection. any ideas?

For a client, I am building a KPI dashboard in which some calculations need to be performed and some data should be summarised. If you are interested, please send me an email to cas@codigital.nl

Hello la communauté !Je viens tout juste de publier la formation Airtable 360°. (formation en Français uniquement, pour l'instant)Cette formation rentre dans le détail des astuces, limites et bonnes pratiques, qui sont vitales à comprendre lorsque tout un business repose dessus !Un condensé de toutes les choses importantes à savoir en une seule formation, en quelque sorte.La communauté Airtable bénéficie d’un tarif très avantageux à l’occasion de cette offre de lancement, profitez-en rapidement !https://nocodable.io/course/decouvrir-airtable-a-360---prix-limites-astuces-secrets-et-bonnes-pratiques?coupon=LIMITED-OFFER-LANCEMENT

Hello,  If I take the Pro plan and choose to limit editing &permissions for collaborators do they als need a Pro plan to input/change their data?They should'nt be able to adjust eachtohers data. Thanks

Hello, I want to use the view timeline with the utilization bar. My timeline view allows me to assign tasks to employees. Employees have unavailable days. So I can't assign them spots during this time. The Unavailable Days Utilization Bar only appears in black when the task is assigned to that date. Is it possible to make these days appear unavailable even if no task is assigned to this date.Thank you for your feedback Best regards Franck 

A formula field can be used to SWITCH a country name to it's corresponding flag emoji (full formula below)This can be handy to add a visual cue to a country and works nicely when added in record summaries like below/This formula will include your flag emoji and using \n you can list other record attributes with a new line"☑️ " &{SOME_OTHER_FIELD}&"\n"&"☑️ "&{YOUR_COUNTRY_FIELD}&" "&{FLAG} SWITCH for FlagSWITCH( {YOUR_COUNTRY_FIELD}, "Afghanistan", "🇦🇫", "Åland Islands", "🇦🇽", "Albania", "🇦🇱", "Algeria", "🇩🇿", "American Samoa", "🇦🇸", "Andorra", "🇦🇩", "Angola", "🇦🇴", "Anguilla", "🇦🇮", "Antarctica", "🇦🇶", "Antigua & Barbuda", "", "Argentina", "🇦🇷", "Armenia", "🇦🇲", "Aruba", "🇦🇼", "Ascension Island", "🇦🇨", "A

In this video tutorial, I have used natural language processing (NLP) to automate tasks in Airtable. We'll be using GPT-3 to do so.Leverage Airtable Automation lets you quickly and intuitively define the “logic” that compels Airtable to do something in the background.Code  

If you're looking for a formula field that translates an employee's start date or birthdate into the current year (for notifications or action items), here's a formula that does that for you.Requirements:Add a date field called DOB (You can change this later if you don't like it)Add a formula field and input the formula below:DATETIME_PARSE(DATETIME_FORMAT(DOB, 'MM') &"/" &DATETIME_FORMAT(DOB, 'DD') &"/" & IF(MONTH(NOW()) = DATETIME_FORMAT(DOB, 'MM'),IF(DAY(NOW()) <= DATETIME_FORMAT(DOB, 'DD'), YEAR(NOW()), YEAR(NOW())+1),IF(MONTH(NOW()) < DATETIME_FORMAT(DOB, 'MM'), YEAR(NOW()), YEAR(NOW())+1))) Now you can change the name of the DOB field if you want. Happy Airtabling!*Note: visit airtable.com/formulas for more info about formulas in Airtable 

I've been using Airtable for a while now, and while it's a fantastic platform for managing and organizing data, I've noticed that the lookup functionality can be quite limited at times. Specifically, I've experienced issues with having to create multiple lookup fields just to perform simple calculations or data lookups across different tables. So, I've started working on a new tool that aims to solve these lookup issues and enhance Airtable's functionality. With this tool, you'll be able to quickly reference data from other tables without having to create linked fields or complex formulas, and easily perform calculations across multiple tables . I'm curious to know if anyone else has experienced these lookup issues and would be interested in trying out my tool. It's still a work in progress, but I'm hoping to release it soon and make it available to the Airtable community. If this sounds like something you'd be interested in, let me know in the comments below. And if you

Hello, Is there a way to make a custom share link for my airtable form? The default one is quite convoluted, consisting of a string of random letters and numbers. Too hard to remember for my end users. D 

We are looking for developers to help automate our Airtable bases with Hubspot, Zapier and other programs. Please message me with details/rates/abilities etc.

Hi everyone!Around two weeks ago I released an Airtable extension that helps you save emails to Airtable. A lot of you were so kind to have tried it out and gave me many valuable feedback, thank you!I started working on snippets and blocks that can be set up in your Airtable base to log emails and act as an CRM like Salesforce does. I wrote an article here to show you some cool features and views you could create with Airtable and emails to use your base as a CRM.I am also in the process of creating a generalised Airtable CRM template and will make it available for free so more people can get started using Airtable as a CRM quickly. I thought that CRM systems are best customised to be most useful, but if you are interested in helping me by giving me some feedback, leave a response here. 

When I open the calendar workspace on mobile (android) and on days that I have an appointment and a blue dot it does not show the record. I have a message that says "this date has no record" if I click Done and re-open it the appointments are there. This is really frustrating - and happens EVERY SINGLE time on every day.Please help!

 Okay I believe I have finally solved this problem. Using a bunch of nested formulas and heaps of hints from these forums I managed to take the start date(/time) of an event in my table, and calculate the correct payroll date. If you've ever tried this before you may have come across several complications which generally come back to Airtable performing all calculations on a date field without considering the timezone that the displayed date field is in - it sometimes assumes date fields need to be translated back into GMT, and at others it just assumes they are already in GMT when they aren't... etc. Formulas like WEEKNUM() and SET_TIMEZONE() don't seem to work well together... etc.Anyway, I have tested this formula with a bunch of tricky dates around the start/end of a year and the start/end of a pay period and haven't come across any errors in the calculations yet. So my fingers are crossed that this formula is the solution that works for you too. Or, you know, someone better t

Looking for a way to get Airtable data into QGIS. Might be more of a custom QGIS plugin, but posting it here just in case.

Table A contains a list of products. The first column is the name of the product.Example product titles in Table A:White Long Sleeve T-ShirtBlue Short Sleeve HoodieTable B in the same base contains a list of product keywords.Example Keywords from Table B:WhiteLong SleeveT-ShirtBlueShort SleeveHoodieI would like help to create a script that automatically searches Table A's first column with the keywords in Table B, and "tags" them accordingly in a new column as linked records. The result of the script would look something like this:Table ANameTags (from Table B)White Long Sleeve T-ShirtWhite, Long Sleeve, T-ShirtTable A contains thousands of products. Products are added regularly and titles can also be modified occasionally. The list of keywords in Table B are added manually as a new product types or categories are created. This can continue.I am considering hiring an expert to help create this script and I would like to get a better sense of how complex this is and how much it might co

HiI have a script that needs building, or developing form existing scripts (I have two good references to pull from), to check for scheduling clashes in a system that timelines tasks. I need essentially the same script to be implemented three times to check against three different fields (tools, spaces and people).If this is of interest please get in touch and I will share a video that explains things in a little more detail.Thanks!Jon

This code is used in a “Duration” formula field in an Activity tracking database. The formula calculates the hours and minutes of a duration of time (for an activity), and maintains a two digit display for minutes (H:MM) when the minutes portion of a duration is between 1 & 9 minutes. Without this code, a duration with a value for minutes between 1 & 9, for example a duration of 1 hour and 3 minutes, would display incorrectly as “1:3”, instead of correctly as “1:03”. THE FIELDS IN THE CODE OF THE FORMULA ARE: Date & Time: A date field. The user enters the starting date and time of an activity. End Time: A date field. The user enters the ending date and time of an activity. Duration: The formula field. The the code of the formula will calculate the duration of the activity. The duration will be displayed in the format H:MM. If the duration is less than an hour, the H will display a zero. If the minutes are less than 10 (but greater than zero), the minutes ten’s place will d

Hey everyone!My name is Minas and I run a map-making website, where you click on a map, add your legend, and download it as an image.A few months ago, one of my users, who is also using Airtable every day, suggested creating an Airtable extension with similar functionality:So, I am excited to announce that MapChart for Airtable is now available on the Marketplace: https://airtable.com/marketplace/blkmypAlv8OyL9Wd3/mapchart  With MapChart, you can: 🗺️️ Create your own custom map from your base's data.📜 Display it next to your Airtable or download it as an image.📊 Use a variety of field types as the source of your map.  Save time and use the MapChart extension to:💰 Track sales statistics by state.🌎 Visualize your company's worldwide presence.🗳️ Show election results by county.✈️ Make your own visited countries world map.🏢 Display your organization's activities across a re

This may be a little tricky to describe, and I'm a little excited after discovering this feature, so I'll do my best! My post is about the Interface Record Picker element, but the Airtable Help doesn't discuss this functionality.Today, whilst I was creating a new Time/Task tracker to keep a tabs on my time, along with what tasks and projects that I'm working on - I've always had the complaint that as each of my tables links in deeper to one another, when viewing via an Interface it becomes a bit of a click-scroll-click-scroll to get to the data that I'm needing to update, then a click-back-click-back to get back to my main interface - repeat ad nauseum - and I start to wonder if Interfaces are really worth investing the time in building, knowing that data is obfuscated by several clicks and it's really just easier to edit directly within the base... or so I thought.As I was finishing up today's efforts on my new personal use interface (and again, frustrated by the way users need t