Builders Board

(So, since I’m a “New” user even though I’ve used airtable for years, I can only post 5 images per post, so I’m breaking this up into multiple responses. ) Hi guys! I encountered a need to have this solved, and the nature of the problem just doesn’t mesh well with creating a formula to fix it. Here’s a topic that was looking for a good answer on this, and one that gives an answer that I think can be improved upon: Rolling Customer Number Based On Year Base design I need to create a customer number that includes the year, and an accruing customer number. E.g. 2020-0001, 2020-0002, etc. The thing is, every year, the year has to change in the customer number, and the four numbers after it have to reset. So if the last number of 2020 is 2020-1234, the first number of 2021 will be 2021-0001 again. I can get the year from the Created Time field The problem is the numbers after the year… I figure I can’t use an autonumber because it won’t reset each year. …

Hello everyone 👋.FlexiPage extension is now live in Airtable Marketplace. It is created as an alternative for Page Designer. It comes with a rich text editor, tailor made for Airtable. You can easily bring in fields from Airtable and create document templates.Overcome limitations of Page DesginerCreate multi-page documents of any length Automate your document generation workflow, using FlexiPage and Airtable AutomationWhat can you do with FlexiPage?Create and automate business documents within Airtable extension Store the generated PDF in an attachment field Easily convert linked record items to table rows, display images from Airtable, with our built in componentsHow is it different from other providers?Zero learning curve. You don't have to learn any template syntax. It just works. Our rich text editor is deeply integrated with Airtable. Invoice design from scratch - Marketplace extension - https://airtable.com/marketplace/blkxiBhC4JLMwyIaZ/flexipageCheckout our Website - www.flexip

Hey all,Looking for an expert-level Airtable freelancer to work with on an ongoing basis, who has at least 5-10 hours/week available.I set up our ERP for manufacturing on Airtable (we are in alcohol/spirits/ready to drink), and it works really well.  Does lot tracking, bill of materials with revisions, batch manufacturing, production manufacturing, shipping/receiving, etc.  I'm looking for help in two areas:Automating workflows.  So when we receive an order, it automatically generates a PDF and sends it to the customer's email address - that type of thing.  I use Documint to automatically generate lot tags when we inbound items, and that has worked well, but I'm to anything (including Make to other things) for PDF generation ... has been a pain point.  Would love to have a template set up to auto-generate PDFs at various steps of the process that just looks clean and works.Interface setup.  Creating interfaces, likely view-only, that various teams in

If you’ve ever wanted to create an approval workflow using Airtable that includes electronig signatures and automatic creation of PDF files, you could always piece together different tools to make that happen.For example, you could piece together a solution that combines DocuMint or PDFFiller, along with DocuSign and Make. Or, you could combine eSignatures.io with Make.But I wanted to see if there was a way to combine everything together with just one platform, and it turns out that you can do all of the above with just one tool: Fillout’s advanced forms for Airtable!On this episode of the BuiltOnAir podcast, I show how to use Fillout to create the ultimate approval workflow for Airtable!Hope you enjoy! If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld 

May 2023 Update: AirToWoo is now Connect for WooCommerce. We have a demo Airtable base here which you can copy, and you can sign up here.Hi fellow Airtabler’s (and Woocommerce lovers!).I’m excited to share a brand new integration between Airtable and Woocommerce, which allows you to manage all your products, categories, tags, orders (and more) for Woocommece from within Airtable.We’ve shared it with a few of our contacts, and the average speed saving has been 10x. If you’ve ever used Woocommerce, you’ll know how slow it can be to go through and edit products one by one, so it was a no-brainer to tap into the ease and speed of Airtable, and make it possible to easily sync to Woocommerce.Withour further ado, I bring to you: Connect for WooCommerce!Any input would be greatly appreciated 🙂

If your Airtable base looks like a beautiful mess… or a chaotic disaster — let’s fix it.I’m offering FREE 30-minute Airtable Tech Tune-Up calls for nonprofit leaders who are stuck, stressed, or just tired of wrestling with their CRM setup.🎯 In 30 minutes, we’ll tackle one real Airtable problem — whether it’s:    •    Donor data that’s all over the place    •    A base that makes your head spin    •    Automation ideas you can’t quite build    •    Or just making Airtable actually work for your missionNo pressure. No long pitch. Just hands-on help and a chance to see if we’re a good fit to work together long-term.I’ve helped mission-driven teams clean up their systems, reclaim hundreds of hours, and finally feel in control of their backend again.📅 Book your FREE Airtable Tune-Up Call now: Airtable TuneUpLet’s clear the clutter so you can fundraise with ease and lead with focus. With purpose,Keyasha Petty KuykindallStrategic Fundraising & Nonprofit Growth ConsultantPlumage Envy Con

I’ve been at my company for about two years and our content team’s workflow has changed pretty drastically in that time. We decided we needed a new Airtable base and to switch to an Interface for ease of tracking projects with multiple components across multiple teams. We finally have the visibility we’ve been lacking for full team transparency. Whereas before each team has its own tab in the data layer that were linked but didn’t really talk to each other, all deliverables now live in one tab and each content piece (based on an Updates tab from the Content Calendar template) lives in a second tab and is automatically created based on content type. There is also (based on the template) a separate area for when external stakeholders request content so that we can vet it for all required information before pulling it into the team workflow. Using interfaces has also allowed us to better share calendars and status updates with external stakeholders, giving them only access to the informat

Hello Airtable Community! I am the Lead for the Business Intelligence Solutions team at FedTech, and we are looking to hire a Full-Time Business Intelligence Solutions Specialist.Right now, our main data stack is on Airtable, so we’re looking for someone who can come in with a substantial understanding and expertise of Airtable right off the bat. Fingers crossed that it is one of you! Additionally, we are currently considering how we can evolve our stack to include a big-data platform (Snowflake) and build out a more automated ETL pipeline in the near future.At this time, we are looking for someone in the Arlington, VA area who can work in a hybrid schedule. Please check out the job description for more details.If you have any questions, do not hesitate to ask. 

I am trying to sync the Ask/Bid prices of several cryptocurrency prices, along with their trading volumes, from different exchanges in real-time (Or at a maximum of every 2 minutes) into my Airtable via API or any possible alternate method.I have attached a screenshot of how I would like my table to look like.There will be a list of ~2000 cryptocurrencies that I need to be constantly updated. If the specific cryptocurrency is not traded on a specific exchange, it should leave the field empty.I was able to get the job done via DataFetcher, but unfortunately, it is not a cost-efficient approach.I am open to getting this done via Javascript scripting if possible.I am looking for something cost-efficient in the long run that will not require hundreds of dollars every month.If you can get this job done, please let me know. 

I am with a small consulting firm and we have built a database in Airtable that we would like to populate with data from our historical relational database that is in a tool called Knack and integrate it with a new project management tool we are using called Ruddr as well as with our Sharepoint file system. Please respond if you are interested and a highly capable Airtable developer who can integrate with other apps via APIs.

Hey I am working as a UX researcher for a large company, i created a base for my data and i want to learn how to create dependencies that can work for me later as a filtering system in my project. I need 2-3 of an expert, both for learning and supporting this specific needs.  

I wrote a Tampermonkey script to allow us to customize the colors of the field headers!(Tampermonkey lets you install scripts in your browser to customize and add functionality to a site, in this case, Airtable! https://www.tampermonkey.net/)To use it, you'll need to set up the exact field IDs and colors that you want those fields to be in this bit:const colorMap = { "fldI5EIoOG25a85F7": { r: 255, g: 224, b: 204 }, "fldxj4ka7M2FwkJAP": { r: 207, g: 245, b: 209 }, "fldAPHkUW98PsaZV3": { r: 255, g: 234, b: 182 }}; For the colors, just google 'Color Picker' and a bunch of options will show up (when I did this Google actually popped up its own Color Picker actually)For the field IDs, right click the field header and click 'Copy URL' and then paste it somewhere, and it'll look something like this: https://airtable.com/appbvEVTtJoARHXPM/tblkT2pj3Ouz1wQRQ/viwKoIZQGVZEAfOap/fldI5EIoOG25a85F7That last bit is what we're looking for 'fldI5EIoOG25a85F7'---Let me know if you have any issue

Hello 🙂I am creating a scenario in Make(Integromat) to resize images, and compress if they exceed 5MB in size.Bellow is the screenshot of the scenario I have created, but it is not working as expected.   I use HTTP to check the resized image size in MB  From here on, I am no longer sure what I did wrong, but Get multiple variables does not give me the resizes and compressed image. If the scenario received two images, one being resized and other compressed, I get two same compressed images.  I would really appreciate help.Thank you, Pjero 🙂

I’d love to see an integration or extension for Airtable that enables automated image generation using data from records. Many teams—especially in marketing, eCommerce, and sales—often need to create social media posts, banners, product visuals, or branded creatives. Doing this manually is time-consuming, especially when the content changes frequently.Use Case Examples: Marketing Teams – Automatically generate social media graphics or ad creatives based on campaign details in Airtable. E-commerce Businesses – Create product banners that update dynamically with new prices, SKUs, or images from Airtable records. Sales Teams – Generate personalized outreach banners using client-specific fields (like name, company, or offer). HR & Internal Comms – Design recruitment creatives, event posters, or announcement banners based on internal data. How It Could Work: Users design image templates with placeholders for text, images, and colors. Airtable data fills in these placeholders dyn

I am looking for a developer within this community forum to provide a quote of how much it would cost to build a Airtable that integrates with Quickbooks Desktop (2021 contracter edition), not Quickbooks Online. Anyone have any qualified recommendations that you have used and have experience?

Hello everyone! Shooting my shot here since I’ve been looking for work in various places the past few weeks and still no leads 🙏🏻 I’m Det, an Airtable Specialist with experience on project management for talents/creators. I also have experience in creating, managing, and optimizing databases on Airtable for over 5+ years focused on merchandising and retail, marketing, events, and talent management. Some work I've done:- order tracking/pipeline for a printing business- order tracking/pipeline for an Etsy shop- ticketing for local community events- specialized Xero account transaction data dashboard for a talent agency- customized CRM for a talent agency- tour management tracker for a talent agency- event invitation and brand deal quotation tracker for a talent agency  My main tools are Airtable, Make, Fillout Forms, Slack, and platforms under the Google Workspace umbrella like Docs and Sheets. I am also familiar with using Zapier for automations and Softr for front end/customer facing

Currently, when typing an entry into a select or multiselect field, anything is accepted when user hits enter.  I.e., if the user makes a typo or uses an alt spelling for an existing entry, a new entry is created.  This creates a task of cleaning and normalizing options and data after the fact. Wouldn’t it be nice to have a “Confirm New Entry” toggle for [multi]select fields?  If set, then a user is prompted to confirm before entering a new option.

I saw this post from the r/Airtable subreddit and was interested to get our Community’s thoughts on Airtable as a solution to the goal identified by the user.From the Reddit post: Hey guys, I have been using Notion for well over 6 years and I have toted its amazingness for all of those years. However, it has come to the point that I simply need to be able to print a Gantt chart or timeline view straight from the software and it just does not do that. I have asked Notion support 15+ times over those 6 years and I get the same response every time.I have 10 users and we manage around 30 projects in the construction industry at any given time. In Notion I have a database of our projects with properties for information regarding those projects as well as a separate database for just task tracking. The task database has a relation back to those projects so if something is added anywhere its always included in the one database. I've stuck with this format of task tracking purely because the m

Hey Y'all! My name is Louis Piotti from Philadelphia. I work as the CEO of the nonprofit AfterShock Fam (aftershockfam.org) and the CTO & Co-Founder for Polaris Pathways (polarispathways.com) and I also do custom builds for businesses from large manufacturers, festivals, workshops, and schools.I just spend hours banging my head against a wall trying to find how to merge records similar to the De-Dupe Extension but would just do it automatically and just built it.I shared the template for everyone to use along with all the code / prompt history in hopes that less people have to goes through 1000 records 1 by 1 on the De-Dupe extension haha AIRTABLE TEMPLATE: https://airtable.com/appdymmnNJo098vJG/shrssRCuFQcrla1Rc FINAL SCRIPT:// Initialize the table and fieldslet table = base.getTable("Contacts");let query = await table.selectRecordsAsync();let records = query.records; // Define specific field names for non-single-line, single-select, checkbox, or attachment fie

This blog post by Airtable recommends using Airtable as a DAM (digital asset management) tool.My company uses Airtable as a DAM, and when I was a consultant, I worked on projects involving using Airtable as a DAM. Airtable's blog article leaves out a few concepts that you should consider if you want to use Airtable as a DAM.- Most DAMs also provide CDN (content delivery network) services. Airtable has stated that it is not designed to be a CDN. The loss of permanent attachment URLs matches the idea of Airtable not being a CDN. If you want to use Airtable as a DAM, make sure that you don't also need it to be a CDN.- Most of the systems that I have built for using Airtable as a DAM involved at least one third-party service, and some use multiple third-party services. Due to their nature, digital assets tend to be consumed outside of Airtable. Think through how you will integrate your Airtable content with where the content will be consumed. Make sure that wherever is recei

Hi friends we have just launched an iOS app named AirKit on App Store which is just made for Airtable user. The problem it solves is straightforward: it takes so many steps to create a single record in the current Airtable iOS app, why not we let Siri to do it? Just say “Hi Siri, AirKit add Tasks” (e.g. Tasks is one of your table name), you could light fast save important data to your base, check it out on App Store if you’re interested! Download link: https://apps.apple.com/us/app/airkit/id6737947295A detailed introduction of why you will need AirKit:The traditional Airtable mobile experience can be frustrating. Navigating through multiple databases and tables takes time, and adding new records feels like a chore. AirKit solves these pain points with two powerful features that transform how you interact with your Airtable data.Lightning-Fast Record Creation- Add new records instantly through Siri- Use Spotlight search to quickly locate your target table- Skip the lengthy loading

Hi all,As some of you know, CSV Getter is a data export tool designed to work with Airtable.A prime use case is the Airtable/Excel sync. Ensuring your workbooks are easily refreshed with live Airtable data. I wanted to make a 2025 update of how straightforward this is. The platform has come a long way thanks to great feedback from Airtable users on this forum.Check it out on YoutubeAnd if you have any questions, fire me a message or check out the CSV Getter docs.

We’re excited to announce our first Airtable App → :sparkles: SQL Console :sparkles: Install the app in your base and you’ll be able to query your Airtable base using all the power of SQL - right inside Airtable. Backed by a Postgres database and featuring complete syntax highlighting with autocomplete - no query is too complex. You can JOIN, UNION, and SELECT without ever leaving Airtable. If you are coming to Airtable from Microsoft Access or looking to quickly create views or calculate metrics from across your base using SQL, then this app is for you. Use the SQL syntax you already know to work with your Airtable data. You can install the app and start using it for free right in the Airtable Marketplace: SQL Console If you’re curious about how it all works, check out our docs: Airtable App - Sync Inc Docs It’s our first Airtable App release, so we’d love to hear what you think.

*Original post has been updated to include a few more notes and screenshots*If you prefer working in the Airtable desktop app and wish you could create shortcuts that opened a base or interface in the desktop app instead of a browser window... I have somewhat of a workaround.The desktop app is essentially a web app. You'll be creating your own web app(s) using Safari 17 or higher. This method will require a Mac running Sonoma or Sequoia. Log into Airtable on Safari and navigate to the desired base or interface page that you want your web app to open to. (You'll be creating as many of these as you need, each opening to a specific base & table view or interface page)Copy the full URL in the address barIn the menu bar, navigate to File>Add to Dock... In the dialog box that appears, enter the name of your web app in the upper space and paste the full URL into the lower space. Click "Add" to add a shortcut to the web app to your dock. (It will also be added to Launchpa

Hello :wave: Over the years I’ve discovered you can do all sorts of amazing things with Webhooks. …and with Airtable introducing their native Webhooks feature, it just removed a bunch of “hoop jumping” pain that was required for me to get my data into Airtable :star_struck: With this post I wanted to do a quick walk through of how I use the new Airtable Webhooks feature with native Webflow forms. Now, I can submit my Webflow forms directly into Airtable without using services like Make, Integromat, or Zapier :exploding_head: Let’s build! Setup Airtable Standard stuff here. New Airtable base with a “name” column in it. Automations Flip over to the “Automations” tab. The Magic Here’s the magic :star_struck: Our new Webhook trigger. I copy the new Webhook URL to my clipboard. Webflow Form I create a generic Webflow form. Nothing special here. With the default form block I get a name and email field. For this quickie run through, I blow them away and just leave the forms submi