Builders Board

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 s

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 qui

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

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 c

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 greate

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 yo

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

TLDR: keeping track of automations that live outside airtable is hard. I made a chrome extension that tells you what Make scenarios are connected to the base you are in.Hey all- I’ve been doing consulting work on airtable since I left back in October. One of the biggest pains making that transition was in working with automation tools like zap and make and understanding what bases they were connected to and documentation of what happens to hand off to customers.I developed www.baseinspector.com to address this issue through a chrome extension. For now it’s quite simple but plan to extend it to documentation, field flagging etcWould love anyone that’s Interested to try the beta when in launched at the end of the month and would be super grateful for feedback thoughts etcyou can watch a video and sign up for the beta at www.baseinspector.com

When trying to concatenate fields together, we always face the problem of either having too many commas (if some fields are blank), or not enough commas (if we are trying to concatenate a lookup field).  Not to mention the fact that some values show up as "Banana, Orange" while others show up as "Banana,Orange" without the space after the comma!To solve this problem, I have created a script extension that will help you to generate a formula that will concatenate all your selected fields!Once you have selected the table that contains the fields you want concatenated, you will be asked to select the fields you want concatenated.  After you have selected all the fields you want, you can click "Selection Complete" and the formula will be generated for you.  You can then copy and paste the formula into a formula field!The example bas

Hi Everyone, I am using Airtable as my CRM. I love it. However, the data vizualisation blocks are not enough and I would like to create comprehensive dashboards in Excel or Power BI. I am not a technical guy but I managed to connect the API for small tables. However, my 2 main tables have 25k and 8k rows… I do not know how to do it for these ones. I would like to have my data updated daily so I can share it with partaners. Is the API allow this task ? Anyone can help ? Thanks a lot, Hugo Le Morvan

Looking for airtable specialist to build some workflows/database for a small Arts and Culture presenting company, needs to be based in Melbourne and available for a face to face meeting. 

Our nonprofit organization (Post Carbon Institute) is looking for a contractor to make improvements to our Airtable as a contact relationship system (CMS) tool for a growing international network, integrated with Circle through Zapier.A very brief description of the network and our needs can be found here.  This is a short-term contract that can be done remotely. The organization is based in the US but the coordinating team is located in the US, UK, central Europe, and Africa.Thanks!Asher

Hi everyone, We're looking for Airtable experts and agencies to join Codemap - world's first and largest talent platform for no-code, with over 4,200+ clients and $14 million in project value in 2022.Our demand for Airtable expertise is growing, with new projects being frequently posted.If you are a Airtable expert or agency based in US/CA or EU/UK, we'd love to have you apply for Codemap here: https://codemap.io/sign-up-talent.Thank you and don't hesitate to DM me for any questions!Best,Goran

I am looking for someone ideally with knowledge of both the Airtable API and the Survey Monkey Apply API.  Note that this is for linking Survey Monkey Apply (SMA) - not standard Survey Monkey.  I need to automatically pull data from SMA for use in Airtable - and potentially the reverse as well.  I have built automations such as this in Integromat (Make) and Zapier, but SMA support is not available.  For reference the SMA API documentation is here.Thank you!Best regards,Matt

I need to build a quoting system in Airtable that I can publish to my website. I started the tables to collect the needed information but that's where I'm stuck. The price is based off a matrix of quantity range vs number of colours printed.  Not even sure if it can be done or it should be developed as an Wordpress app/plugin and pushed to Airtable.If anyone can build this solution, please reach out asap.

 Hi Everyone,Blue Ocean Barns is seeking an Airtable consultant to help us improve and manage our current database.  If you are interested, here is a link to the job postinghttps://jobs.lever.co/BlueOceanBarns/ff3bcaf6-202d-4c4f-a673-af37d0266261?lever-origin=applied&lever-source%5B%5D=Airtableor feel free to respond with any questions.Best,Michael

Hi Friends of Airtable! I'm experimenting with a new free format, in which I live solve your Airtable challenges on my Youtube channel. You can submit your challenge and email via the following link and I'll record the first episode very soon: Submit your challenge here  

This script was written to be used with the “Event planning” Airtable template, and can be adapted to any similarly structured base where the requirement to detect overlapping start and end times is pressing. When scheduling large Programs with many individual events at different locations, and across multiple days, it can be difficult to keep tabs on whether or not people have been double booked, and scheduling conflicts can cause chaos. This script is designed to help with that problem. It will check all events in the “Schedule” table for instances where an individual Speaker from the “Speaker & attendees” table has been scheduled to be in two places at the same time! For each speaker that has conflicting events scheduled, a table will be displayed under their name with a list of any offending events, so that they can be found and rescheduled.

I have been working on an extension called TaskRobin to send emails into Airtable. After almost 3 months of reviews with the Airtable marketplace team, my extension is finally published on the marketplace!You can now easily create a table with all columns needed to store emails in Airtable with one click, and start saving emails to Airtable. This allows you to make Airtable a hub for customer support requests and CRM. Let me know what you think?More info about TaskRobin

Hi there I was hoping to gather some feedback from the community regarding an integration we are looking at launching. We are exploring integrating our software with Airtable so that people who require more complex, offline data capture (digital forms with logic) can capture information which then automatically synchs up with Airtable when connectivity returns. More here on our solution for context: https://vimeo.com/422707172 In summary Formworks allows users to create complex forms (which work offline) link to remote databases and also can apply logic to inputs when information is typed in by a user (calculations, acceptance ranges, workflows, hide and reveal, mandatory fields etc). In short it’s a very effective way of controlling data quality at the front end. My questions is whether an integration between Airtable and Formworks would be of interest to Airtable users? Is offline data capture