Show and Tell

 This system is used to keep track of the sales for a pharmacy business and provide stats and data such as number of items available, total sales both weekly and daily, and also sync the data between the different tables availableWe created a few tables to store the main data such as main inventory of all available items, daily sales, total sales and a sales summary table.With n8n, we unify this data to work as a single unit that can provide deeper insights on how the business is runningFun Parts:1. We can find the total number of items that are remaining after each sale2. Automatically find daily sumaries for each product sold based on sales3. Automaiclly calculate the profit ratio for each of the products sold in realtime4. Notifications for all orders below 20% in stock. 5. The dashboard displays quick stats that are easier to see and follow eg best sales, total items sold in a day etcWhat happens when we reach the free airtable limit?We will be integrating a nocodb backend for

I noticed there wasn't any native solutions for shortening URLs on Airtable, so I developed a block extension that does it for you: URL Shortener https://airtable.com/marketplace/blkGvhDb0ZsSfXpJv/url-shortener-by-silver-tazaHope this helps!Creating this tool was all about delivering value. It's designed to be user-friendly: generating links is super simple, and the analytics provide detailed insights on your link's performance. Plus, you can even create a QR code for any link directly within the app.I also created a tailored URL shortener service on the backend to avoid the steep costs of other services, ensuring you get the most bang for your buck. Even the free tier is meant to be generous and not limiting for most use cases. Drop me a line with your feedback or any features you'd like to see!

We are currently trying to move our hiring onboarding process to Airtable. In our company, we have a medical team (Nurses & Doctors), a health coaching team, a business/marketing team, and soon to be technology team. In a perfect world this is how I want the onboarding process to work:- First the prospect will fill a form out giving their basic information. (Phone number, address, email, desired job position, etc.)- Once the form is submitted, we can select hire or reject.- Once hired, Airtable will then take that prospect and insert them into the proper Job Specific/employment type onboarding checklist.- Onboarding a medical new hire will be vastly different than onboarding a new health coach as they require different technology and employment forms. Medical staff are typically full time and health coaches are part time. We also need to consider contractors who will fill out a W-9 instead of a W-4.In short, I want to build a process in airtable that will allow us to

I have been building TaskRobin to help Airtable users to save emails to Airtable. Now with new features to craft your very own custom and smart CRM in Airtable!Add the official TaskRobin Airtable extension to your base You can now automatically track and update all your email contacts to a separate contacts table. New contacts will be automatically added to this table with name, email address and first contacted date. Then, your last interaction date will automatically be updated whenever you save or log an email with these contacts in them.Here's a step by step guide to build your own Airtable CRM with TaskRobin.If you are not familiar with TaskRobin yet, it is an Airtable extension to save your emails to Airtable with a simple forward.You can now save emails to Airtable with a simple forward, while capturing all the important meta data such as subject, sender, attachment files for filtering.  Thanks to the awesome Airtable community members who have tried TaskRobin and gave

 In this guide, we'll show you how to automatically add profile pictures to your Airtable records based on phone numbers. This method leverages a simple yet effective integration.For a step-by-step walkthrough, check out this video on youtube. 

Inspired by this discussion, I wrote a script for the Scripting block that lets you instantly start and stop a virtual timer on any record, provided that the table is set up to work with this script. Aside from adding the script into a Scripting block, setup only requires three new fields: A single line text field, which will store the script’s timing data (used internally; may be hidden) A duration field, where the script will store the tracked time A button field, which must be set to trigger the Scripting block that contains the script. I suggest labeling this button “Start/Stop,” for reasons that you’ll see below. Use: Click the button once to start the “timer.” Click it again to stop it and see the duration. Need to continue timing on that same record? Click the button again to restart. The next click after that will tally the elapsed time from both timing “sessions” and put the total in the duration field. Start and stop the timer as much as you need. How it works: Each time yo

Hey all,Having a request from a client I found a way to add image in our signatures for email we send using Gmail action in Airtable. Due to the fact that the image element is not included in Airtable's markdown list we can add it by adding a piece of html code in our action. Below is the code and the explanation of using it. </td><td width=96 valign=top> <div class=t102 style="display:inline-table;text-align:initial;vertical-align:inherit;width:48.97959%;max-width:96px;"> <table role=presentation width=100% cellpadding=0 cellspacing=0 class=t104><tr> <td class=t105><div style="font-size:0px;"><img class=t106 style="display:block;border:0;height:auto;width:15%;Margin:0;max-width:25%;" width={image_width} height={image_height} src={image_public_url}></div></td>Comments about the code: {image_width}  & {image_height} are display settings for the image you want to add in your signature. Please keep in m

Hello everyone,I would like to build an automated job board in WP (Job pages > Airtable > WordPress). See attached architecture slide:https://www.dropbox.com/scl/fi/d9ftp9zanahokjusrp6a9/AutomatedJobBoard_Wordpress.pdf?rlkey=rf0g80txtb8r81y1c0tsvm87f&st=gymto6cf&dl=0 I have tried different plugins and applications like WP Job Manager for the Job board in WP, Make.com or Zapier for the integration Airtable in WP and/or Indeed Integration for the integration of Job page into Airtable. But nothing works fully:The biggest problem is that I can only post/update the variables in bulk for the jobs from Airtable into WP in the WP content section of a page/post.Does anyone have any ideas how to post/update different variables (cells) in Airtable to specific elements or blocks on a WP page/post? Is it dynamic content, customer fields, advanced customer fields for the integration of content from Airtable to WP with Make.com?Thanks,Victoria

Hello Airtable community! Let's talk about integrations. You need them because your business runs on too many different software systems that don't communicate with each other, so people end up working in data silos without a reliable source of truth (except of course, for Airtable). So each team ends up dealing with incomplete data or relying on inefficient and unreliable manual processes.So you're faced with either learning how to automate yourself in limited trigger/action recipes, or outsourcing complex and costly solutions to external consultants. In either case it's a bit like building an IKEA bedroom set without instructions. Or a dining room set, your preference! Anyway, there actually is another solution in the form of a code-free integration solution that lets you set up a flow in 10 minutes that can:Create new Airtable records based on data from your other apps;Create items (tasks, tickets, issues, events, etc.) in other tools based on your Airt

Hi everyone,When using DocsAutomator, you can now group line items similarly to how records can be grouped inside of Airtable. Example for line items are grouped according to status: To learn more, please watch the demo here: https://youtu.be/rqxfuXcZuEw?si=AlN7fh8vyDEYvF3UWould love to hear your feedback and what you think!

My CEO opened up her account settings and is only able to change her password. The setup two-factor authentication setting is not displayed on her end.

I've saved myself countless hours repurposing helper data from other projects; so I've decided to start publishing them.Countries and Timezones in particular are great for adding some helpful context to a list of companies or staff – or just to help you time your email triggers better.I recommend using them as a synced view so that the timezones update through daylight savings.Enjoy!

Hey Airtable users 👋I've been working with clients as an Airtable consultant for the past few years (mostly in the European market) and this is a very common request I get.Therefore I built the following 3 "plugins" for my platform AirPluginsBackup base as XLSX - receive a full base backup as xlsx daily via email or webhookExport table or view as XLSX - gives you a link to click (& store somewhere) so you can export data anytimeExport linked records as XLSX - gives a link that allows to export linked records as xlsxThere are also other Airtable plugins available.Feel free to PM me if you have any question, suggestion or request on these plugins.Florian

HiI'm trying to create a script for a ticketing machine. However, it looks like this (See screenshot below)Here's the script that I used: // Define the orders tablelet ordersTable = base.getTable("Orders");// Fetch all order recordslet ordersQuery = await ordersTable.selectRecordsAsync({    fields: ["Order Number", "Customer ID", "Name", "Email", "Phone Number", "Address", "Selected Meals", "Order Date", "Delivery Date", "Order Type", "Order Status"]});// Loop through each order and generate the ticketfor (let orderRecord of ordersQuery.records) {    // Fetch order details    let orderNumber = orderRecord.getCellValue("Order Number");   &nbsp

Background information: We are a 25 person medical clinic. We are using Airtable to manage the business operations which consist of a medical team, health coaching team, marketing team, operations/sales team, and eventually a bigger technology team.As my company is growing, I am constantly looking for ways to structure my Airtable database more efficiently. This leads me to two questions.Should I build interfaces for employees to work out of instead of having them in the backend of Airtable?My next question is what are some tips to make Airtable more efficient in terms of keeping things user friendly and simple? Or things I should avoid?Overall, as we bring more people on the team, I want to limit the amount of confusion and overwhelming emotion that any new hires might experience in Airtable training.

I've been designing my own tabletop role-playing game for some time and have been using Airtable as the backbone for all the information in it.One particular element I've been enjoying is the ability to embed an Airtable into a flipbook. It makes for a very effective delivery of information in a modern way: Arq RPG Core Rules  

 Exciting news from Softr! Now, you can connect your Airtable data to instantly generate a ready-to-customizable app. Just link your data, choose the relevant app pages! Your customized app is ready to go in seconds.How it works:Step 1: Connect your data source Step 2: Select the base/document for which you want to generate an application. Step 3: Select which tables/sheets to create pages in your application.Step 5: Generate the app! 🖇️More here 

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'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!  

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