Builders Board

Hey everyone!We just launched our latest tool, real-time 2-way syncing between Airtable & Webflow. We've been hard at work the past several months refining, testing and optimizing our two way sync with our beta users. Check it out here!Sync Airtable & WebflowOur real-time syncing tool allows you to keep your Airtable bases and Webflow sites in sync, without complicated no-code automation tools or custom code. Simply connect your Airtable account, connect Webflow and we'll walk you through the mapping process with our intuitive onboarding process. To make the process even easier we created an auto Airtable base configurator. We'll automatically create an Airtable base based on your Webflow CMS configuration. This means that you don't need to spend hours setting up a new base in Airtable, creating field types and matching fields. Our auto Airtable configurator and smart mapping allows you to get up and running in minutes. Key features of Airtable & Webflow syncing:Two-wa

Hi all,I'm trying to get the Calendar View to look a  little neater, only showing the headers of events without all this unhelpful and bloated extra data showing up. For instance, in Google Calendar the date will only show "David Out of Office", but in the synced airtable calendar view I'm getting this time range, and long link. How do I get rid of that extra stuff? Thanks!

I am using the service for my bachelor thesis, where I need to create a functioning, user-friendly database with music metadata. However before that the studies need a substantiation of why I have chosen this platform and people’s experience with it. So I wanted to ask you some questions about your time with Airtable. You can find it here: https://forms.gle/6TudYxkzwUEKNSbZ8 P.S I admire this community as I have already found a lot of useful information from people with various backgrounds and knowledge

Hey Airtable Community! 👋I've pooled my learnings about Airtable scripting and created something for us 'no'-coders: Airtable Script Helper. It's my first project since OpenAI launched custom ChatGPTs last week, and I'm excited to share it with you![REQUIRES CHATGPT SUBSCRIPTION]🔧 What It Does:DIY Scripts: Helps you create Airtable scripts or edit existing ones, whatever you need.It has been fed with some key considerations/best practices to be mindful for when creating scripts, so it should be better at helping you create scripts than vanilla ChatGPTEven if you have never written a line of code before, you may try it out. I too started using scripts only After ChatGPT was launched. 🙊🚀 Try It Out! Give Airtable Script Helper a spin and start building your custom scripts today. Let me know if you encounter issues and you think it is fixable. Any feedback is welcome.For anything more advanced, I'm just a click away: Vikas

Hello, I am trying to build a base for our vehicles and equipment fleet. This base will hold the maintenance log and the maintenance service schedule for each vehicle. I am stuck with how to move forward in the set up process. I initially started with three tables, Vehicles/Equipment, Maintenance Log, and Maintenance Schedule. I want to be able to plug in formulas that will calculate the next service dates for various types of services (oil changes, fluid checks, tire rotation, etc.) but because we are working with all different types of equipment (heavy duty, UTVs, cars, tractors) I am having a hard time finding a way to systematically implement the same formulas for each piece of equipment. I want this to be easy to maintain for the user and not too complicated, but I am having a hard time figuring out how to link dates versus mileage. I hope this makes sense, but I would love some advice for how to even set up each table and what my primary fields should be for each, I've included s

Every so often someone asks how to format numbers in a string the same way that they appear in a number or currency field. Various formulas have been created in the past (including some that I’ve posted in threads on this topic), but a recent thread prompted me to take another stab at the concept, and I came up with the most condensed formula that I know of for formatting whole numbers. The formula below will currently handle numbers—positive or negative—up to 21 digits long (<= 999 quintillion), though with a single change it could support higher values if needed. IF(Number < 0, "-") & REGEX_REPLACE( ABS(Number) & "", REPT("(\\d{3})", (ROUND((LEN(ABS(Number) & "") + 1) / 3)) - 1) & "$", LEFT(",$1,$2,$3,$4,$5,$6", 3 * ((ROUND((LEN(ABS(Number) & "") + 1) / 3)) - 1)) ) If you want this displayed as currency, change the first line of the above formula to this: IF(Number < 0, "-") & "$" & To change the separators to periods for some other

How can I add all the values inside a particular cell in the Revenue AVIDZ (in Amount) and then present as "Total Revenue" hence stating revenue for a particular client?Revenue field is a lookup field.Here is the screenshot of the table: @TheTimeSavingCo can you please help?

Hello everyone,I'm Erik Compton, a practicing lawyer in surface rights and expropriation based in Edmonton, Alberta. I'm reaching out to this community to find skilled developers familiar with Airtable and Microsoft 365 integration for a project aimed at significantly enhancing legal practice management.Project Overview: We are developing a legal practice portal designed to streamline the management of extensive data concerning land values, leases, and compensation related to surface rights and expropriation. This portal will integrate real-time data from Airtable and emails from Microsoft 365 to automatically update client profiles and site-specific information.Key Features:Interactive Dashboard: Tracks legal deadlines and provides alerts for upcoming rental reviews.Comparables Assistant: Utilizes Airtable data to suggest comparable compensation rates nearby.Email Integration: Scans incoming emails to update records and extract actionable data seamlessly.AI-Enhanced Drafting: Uses AI

I'm searching for an Airtable expert who can assist me daily. My budget is $60/hr.We need support with designing interfaces, organizing our database, and creating formulas in Airtable.Typically, 80% of the work is already done, and I need help with the remaining 20%.Please share your email, and I'll reach out to you.I'm interested in a long-term partnership.

Hi everyone! We're excited to share our latest iOS Shortcut that simplifies the process of saving email attachments directly to your Airtable database.As avid Airtable users, we understand the importance of streamlining data management tasks, especially when it comes to organizing external files attachments. Our new iOS Shortcut bridges the gap between your email client and Airtable, making it easier than ever to store and access important files.Here's a quick overview of how this iOS Shortcut can help you:1. Seamlessly save email attachments – With just a few taps, you can save email attachments directly from your iOS email client to your designated Airtable table and field.2. Customize your data organization – Specify the target table and field names for each shortcut, ensuring your attachments are always stored in the right place and in the format you prefer.3. Save time and effort – Eliminate the need for manual downloads and uploads, as the shortcut automatically transfers email a

Hi, Below is my airtable base.I have grouped the records on basis of my product. I want to find the average of qty in each group. The average should be such that total of all qty in a group divided by no.of.rows in that group. How can i do this on Airtable? For eg - THe average of first group is 68/8 = 8.5 

I have 2 questions to ask:1st being this:I have 2 tables:1. Revelator Sheet Data2. Client InformationThe "Revelator Sheet Data" table holds the music assets of the clients belonging to our business. To map the assets to the clients (in the client information table) I will use the "payee_id" which is present in both "Revelator Sheet Data" and "Client Information" tables.But I can only link 2 tables with primary fields. The "Client Information" has "Client ID" while the "Revelator Sheet Data" has "Id" as the primary fields. So, when I linked the "Client Information" table to"Revelator Sheet Data" table using client_id, how do simultaneously match the payee_id?For example: Above is the Revelator Sheet Data table. I have linked the client information table using client_id. Now I want that if "Payee id" (in Revelator Sheet Data) and "Payee ID" (lookup field from client information) are similar, the client_id is mapped automatically ie I basically want to map client id based on pay

Hello,  HIRE me and get seamless and well organized boards displaying your sales workflows with a blend of automations for easy lead tracking, nurturing and conversion. Having created and automated workflows for different sectors including healthcare , real estate, sales, project management companies. You will get automation on repetitive tasks and notifications once a lead is generated or when the status of something changes. Kindly share the list of requirements with me. Here is my portfolio link;Airtable Projects Let's start your project. I am available for a call now, when is your earliest convenience for us to meet?Email ; oluwafemilove924@gmail.comlinkedin.com/in/ loveoluwafemiomobewaji924   Best, Love.

Hello, Airtable Community!We are a dynamic team currently gearing up for a major international event taking place in Paris and are in urgent need of skilled Airtable consultants/experts to join our operations. We are seeking professionals who are passionate about data organization, management, and optimization to help us develop innovative solutions that will streamline our inventory management and internal data reporting processes.What We're Looking For:Location: Ideal candidates will be based in Paris, France, but we are open to considering experts located anywhere within the country.Expertise: We need individuals with a strong background in utilizing Airtable for complex operational needs, especially those who have experience with inventory management systems and internal reporting.Technical Skills: Knowledge of ETL processes and experience integrating various data sources with Airtable are highly desirable. While not mandatory, familiarity with JavaScript and SQL would be beneficia

I am aware that you can pick and choose which fields you want visible in a synced base. However, if you already synced a base, but want to limit the fields that are visible is there a way to do that without having to reupload the base?

TL;DR: add a "hello world" script if you want a "condition not met" to end your automation instead of cause it to fail.I created a base for another team in which I'm collaborating with them, and for each record that is created in their base, if it is assigned to me, I want to create it in my personal base via automations.The Find Records approach of identifying the collaborative record that was created and re-creating it in my base was straightforward, but capturing updated collaborative records assigned to me and re-updating it in my base was a bit trickier, as "Find Record to Update" may return zero records, if the collaborative record is assigned to someone else, causing the automation to fail.To get around this failure, I added a Run Script step for the condition in which the length of Find Records = 0, and the script is simply:console.log("Hello, world!"); This way, the automation will always successfully run, even if the collaborative record is assigned to someone else.&nbsp

Check out the guideWe've just published our first of many technical Airtable guides on Mass. This one is our holy grail for automated field copying and building junctions.No scriptsNo duplicates everImpossible to break (you should try)Crack open the demo base in the article and try for yourself.   

Company DescriptionAt AirOps Consulting, we help our clients reach their potential through smarter database solutions using Airtable. We create bespoke Airtable solutions designed and built in collaboration with your organization, tailored to your needs. We work with your team to define organizational needs, objectives, and processes to identify areas where custom Airtable solutions can add value and save time for your organization.AirOps Consulting works with companies and non-profit organizations of all sizes. We’ve helped new entrepreneurs learn Airtable through coaching sessions and successfully completed large Airtable implementations for cross-team collaboration in large enterprises. Since our company started in 2019, we’ve worked with technology, entertainment, natural resources, professional services, real estate, and non-profit organizations worldwide in North America, Europe and Australia.Role DescriptionThis is a full-time remote role for a Senior Airtable Developer. As a Se

I am the Technology Manager for Companion Health. We are a medical practice currently utilizing Airtable. We recently had one of our employees accidentally remove one of our client records which resulted in me having to review a snapshot and pull the data back in.I would like some advice on what I could do to ensure this is prevented as much as possible.Also is there better backup methods for client data other than the snapshots taken in Airtable?

Hello, Airtable community!I'm excited to share a project we've been nurturing at Boltflow: AIRinsights. It's our humble attempt to enrich how we all interact with our Airtable databases by enabling quicker, smarter access to insights.About AIRinsightsWe understand the value of data in our daily decisions and operations. With AIRinsights, we aim to simplify accessing and analyzing Airtable data, offering a way to get immediate, actionable insights from your queries, without the need to even access Airtable.Questions like:"Which products sold the best last quarter?""Access Marketing Base and Finances Base and calculate which campaign holds the highest ROI this year.""What tasks are most overdue, including details on ownership and deadlines?"...can now be answered swiftly, as if you had an analytics manager by your side.Beta OpportunityWe're introducing AIRinsights in Beta and warmly invite this knowledgeable community to be among the first to explore its capabilities.Interested? Please j

Hi, I'm looking for a contractor that can build a integration into our Airtable that will automatically add tracking numbers from UPS for existing orders. We will have future follow on projects as well if we work well together, but this is a good first start.Thanks!

🚀 Exciting News for DareTable 2024! 🌟Join us in New York City on October 25-26, 2024, for DareTable 2024, the ultimate Airtable user conference. Come to NYC to be inspired by enterprise leaders, experience Airtable AI, and network with fellow Airtable users. Secure your spot today—only 300 tickets available!Highlights:🎟️ Ticket Information:Early Bird: $450 (Until May 31, 2024)Regular: $650 (Starting June 1, 2024)Door: $750 (Starting September 2024, if available)🤖 Special Features for 2024:AI-focused sessions and enterprise-level discussions.The introduction of the Consultant Program, enhancing networking and visibility for consultants. Learn more and sign up here!📢 Call for Speakers: Our speaker application is now open! Apply here to share your insights and stories. Multiple speakers are already announced on the website! New tracks for this year are:Enterprise & Business [NEW]Airtable AI [NEW]🤝 Join the Volunteer Program:Dive int

We needed a "quick" way to see that a calendar entry was canceled (in the label, which is a text field named "Short Name") without typing it. (We use a check box to "cancel" the event) Forgive me, I'm new. This may not be the most elegant way of doing this, and I may have missed something I built an automation that when the check box is modified, AND the value of the checkbox is checked (a FIND table with that conditional and the Airtable ID as the record output) THEN run a script to update the text field (because putting the text and the field was not working in the non-script format) I added input parameters of recordID (the airtable ID from the find field) and xText which is the existing text in the field "Short Name" the script looks like this:  let table = base.getTable("Productions_calendar");let config = input.config();let recordID = config.recordID;let xText = config.xText;var c = "Canceled: ";c += xText;let query = await table.selec

Are you in search of a seasoned implementation specialist with a knack for creating efficient automations and user-friendly interfaces? Look no furtherHere's what I bring to the table:Previous Experience at Airtable: As a former implementation specialist at Airtable, I had the privilege of contributing to numerous projects, gaining invaluable insights into the platform's capabilities and functionalities.Extensive Project Portfolio: Over the course of my career, I have collaborated with over 30 clients, spanning various industries and project scopes. This diverse experience has equipped me with a comprehensive understanding of client needs and preferences, enabling me to deliver tailored solutions that exceed expectations.Proficiency in Automation: I possess a keen aptitude for creating automations that streamline workflows and enhance operational efficiency. Whether it's simplifying data management processes or optimizing task allocation, I leverage Airtable's automation features to dr

We are seeking an experienced Airtable Developer to join our team on an hourly rate basis. The ideal candidate will assist us in automating supply chain processes and creating dashboards for key performance indicators (KPIs).We have working base and interfacesResponsibilities:-Automate supply chain processes including purchase requests, payment requests, and shipping plans.-Develop dashboards for monitoring supply chain KPIs such as inventory levels, overstock, and low stock.If you have the skills and experience required for this role, please let me knowHourly rate: USD 20-30Remote work, but preferably located in Eastern Europe.Thanks!