Builders Board

I am working on a database, where I manage data of clients and their youtube channels. I am trying to develop a Finance report automation but for that facing challenges in setting up fields in my table.Currently I have theses tables:TABLE 1: YouTube Channels Table (attached to client table through client ID)Fields are:- Id (primary key, RECORDID())- Name of the channel- Channel id- Client id (foreign key)TABLE 2: YouTube Channel Earnings- Id (primary key, RECORDID())- Name of Channel (lookup field from YouTube Channels)- Channel id (lookup field from YouTube Channels)- client id (lookup field from YouTube Channels)- Date (Date field)- Month and Year (formula field, getting month and year from date field)- YouTube earnings for particular Month (currency field)- Tax Deduction (currency field)- Net Earnings (formula field, Earnings - tax)Now I have grouped the data first with the month and year, and then based on client id. Below is the table screenshot. Now here is my 3rd table: Fin

Hi everyone, I have an issue that randomly just started... Happening.Specifically, I use AT as a task manager for my team. Each team member's personal view is filtered like this:"{Owner is [name X]}OR{Status is Ready for QAAND QA is [name X]}"Both "Owner" and "QA" are user columns. Status is multiple choice.Now, this worked perfectly until last Friday. On Friday, the QA column started automatically populating all new records in the view. This means that as soon as I create a new record, my name is automatically added to the QA field, when I don't want it there. The Owner column works perfectly normally, i.e. not automatically populating with [name X].How do I fix this? It's important to keep the filter so everybody sees all their tasks and we don't miss stuff, and as I said, it worked well until last Friday. 😞 

Hello, all,Sort Stack, your prioritizing first mate, is a task management base that I released a little under a year ago. Since that initial launch, I've added several features to the base, a few of which I'd like to highlight below.Due to the somewhat ad hoc way that this base was developed, I don't have a formal change log, meaning that some of the highlighted features may be ones that you're already aware of, so apologies in advance for highlighting any features you've already heard of.New Feature HighlightsDay-of-the-Month Recurrence: For situations where you'd like a task to recur on a specific day of the month, such as the second-to-last day of the month. I added this feature because I needed support for such tasks when I was a team lead. More specifically, I needed the ability to create a task that repeated the second-to-last working day of each month. To implement this without introducing unnecessary complexity, I expanded the functionality of the "Eligible Weekdays"

Hi everyone!I recently created a step-by-step tutorial for building an Airtable extension that enriches leads with information from Versium's identity graph.The extension lets users:Add and save Versium API keysSet up the Airtable table and view for enrichmentChoose the field for enrichmentMap output fields like first name, last name, email, company domain, and business nameIf you're curious about building Airtable extensions or if you're interested in leveraging Versium to enrich lead information this tutorial gives insight into the processYou can follow the tutorial step-by-step or remix the extension and use it directly!I'd love to hear your thoughts if you try it out: Versium Extension for Airtable Lola

The Essential Guide to Backups for Your Airtable Bases | On2AirHaving a backup of the company information you’ve stored in Airtable is vital. Whether it’s in your client contracts, part of your company operating procedures, or gives you peace of mind, with this guide, you can always have a backup copy of your... If you consider your data in Airtable vital to run your business, you should consider backing it up to a secondary location.We’ve created a guide on how to implement best practices to backup your Airtable bases. We also show you how you can manually or automatically back up your bases.Automatic backups are done with our On2Air Backups extension. Did you know?The Cybersecurity and Infrastructure Security Agency deems data backup as an essential element for ensuring cybersecurity in businesses and organizations.The recommended backup structure by the US Computer Emergency Readiness Team is the 3-2-1 structure.3 copies of any important file: 1 primary and 2 backupsKeep t

I work for a small non-profit and one of our programs is a homesharing effort. We try to match people with a spare room to rent with people who are looking to rent a room. I was hired about one year ago to "bring us into the 21st century." They had been tracking everything in Google Sheets and Forms and it was a mess.At first, we contemplated purchasing subscriptions to several types of data management companies, including something like Monday.com, a separate database for finances, another one for client/property management, and CRM. We got a tour of another homesharing group using Monday.com and the man who was leading the tour suggested that if he had it to do over again, he would just build his own using AirTable. I had never heard of AT at that point. But as soon as I began to explore it, I knew we'd be using AT for all of those things. In the last year, with a bit of paid help, I've built a base for our homeshare program, one for all of our contacts (that also handles payrol

We are looking for a consultant to work 1-2 days a week on our platform for at least the next 3 months, probably longer. Our business is a marketing agency and our quote-to-cash process is run on Airtable. It's outlined in the deck linked here.We're open to discussions with potential freelancers who would need to get to know our business processes quite well. I would need to see experience of wokring on similar bases and schemas and an appreciation of a servcies based business https://docs.google.com/presentation/d/15NWQMW5Zw96kKv74cwdnU1hoEqWIKbI1mc3jFQTzSrM/edit?usp=sharing

Hi, I am currently using Airtable to communicate with my team. We send them text messages (via a Twilio extension) direct from our database. I need help setting up Twilio to send the messages to email or another platform so our team can respond. I also need help integrating with Whatsapp. Thanks,Tom 

We're long user of Airtable, but the iOS application has long loading time, also there is no direct integration between Airtable and ChatGPT.To miss that gap, we made several iOS shortcuts.Save ChatGPT Answer to Airtable - Just start speaking out your question to the ChatGPT, our Shortcuts will send it to ChatGPT, and save both your question and GPT response to the Airtable. You can use it to ask GPT writing long marketing content and all of them will be saved into your base for post-process!Save AI Audio Notes – Our Shortcut will firstly transcribe your audio input, then post-process it with ChatGPT to let AI sort them into a well-formatted notes, both the note and original audio file will be saved to Airtable for your usage. You can use it to capture quick idea, meeting notes, etc.Every function in the demo works 100% well, and there is no any privacy issues. If you're eager to start using these shortcuts, please view our site to get them, thanks!  

We are looking to hire an Airtable developer to help us create an internal tool/application (not sure what to call it) for our customer base . The tool will connect Wholesale Inventory specialist to Retail end users. I will get on a call with anyone interested to discuss further . This will be a Full Time hourly position not looking for freelancers. 

One of the best features of Airtable is the ability to drag images, files, and even videos (i.e., digital artefacts) right into an attachment field. When you do this, Airtable makes a copy of your image and stores metadata about the image into your base. It also quietly moves the copy of your image to its content delivery network (CDN). The URL to your image has been openly accessible providing a wonderful way to share access to your assets For almost eight years, this has been possible but that’s going to change in significant ways later this fall. Long Time Coming I predicted this would happen in 2019. They warned us then and they are giving you almost a year to make plans. A lot of folks complained here, but this change is most certainly going to happen and it is in everyone’s best interest. Now that Airtable has officially announced new specifications for its CDN, any solutions that depend heavily on images that need to be accessed outside the Airtable UI will probably require tha

Hi we've made an 2 interactive MindMap to categorize all Airtable field types and API usage.Here's free access link:Airtable Field Type Mind MapAirtable REST API Mind MapThey're made when we're utilizing the Airtable API to develop our product - iOS Shortcuts Library which help effortlessly clip Web Pages/Image To Tables on iPhone, if you're interested, please have a look of it! Hope you find them as useful as we do! 😄 

Hey folk! 👋I'm working on a frontend UI generator you can use to get fully editable code to embed or use on any site builder, LMS or tech stack called basefront app. So basically input your airtable creds and the generator creates a frontend which you can apply custom css and all the good stuff like tweaking the code etc. Checkout the app if you fancy giving it a spin (currently in beta) -  https:basefront.appSome of the styling features:

Want to use ChatGPT in your Airtable? Integrate your Airtable data with OpenAI's powerful text-davinci-003 model using our new Airtable extension! Please note that you need to use your own OpenAI keyOur new Airtable extension connects your Airtable data to OpenAI's text-davinci-003, a powerful language model that can generate human-like text, answer questions, and even write code with incredible accuracy and fluency. In future versions, we're planning to add even more features, including the ability to choose which OpenAI model to use and the ability to select data from multiple records at once.Imagine being able to select a column containing multiple submissions of customer feedback and instantly gaining insights and sentiment analysis. Or selecting a view that contains your previous content ideas and asking OpenAI to generate new, relevant ideas for you. Maybe even submitting an image and asking for alt text!Please also contact us directly if you have any ideas and would wa

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