Builders Board

Hey all, We’re a small company selling a very wide range of products with very shallow depth of inventory. We have buying / production / ops teams based in different locations, and they all need to be able to upload / access / update information regarding products, inventory, etc. In the past, because so many people have been involved with that buying data, we’ve had issues “baked in” so we’re looking at setting up Airtable to validate and verify data, and prevent mistakes from being created. We also use Shopify as our main inventory management system, but their IMS (Stocky) is very limited in terms of functions, and doesn’t really support inventory movements very well. Ideally, we’d like to set up an integration where Airtable holds all inventory, and records all inventory movements (deliveries, transfers, write offs, etc.), as well as uploads and updates Shopify products (inventory quantity, out of stock, new product uploads, etc.). We’d like to find a consultant who can help us set

I have a cool table that collects all the trade opportunities that i get. I can also do a calender view on it. the only thing i need to figure out is how to showcase the calendar view by points missed instead of event. Any ideas? I am using the free version so far.

miniAppMaker is a tool that allows anyone to make a mobile app without coding by using Airtable as the backend. Here’s how it works: Design your app in Airtable Add your Airtable IDs (API, base, tables, fields) to miniAppMaker Test your app. Wa-lah! This project is inspired by Airtable’s mission to “democratize software creation”. People are already doing amazing things with Airtable. We believe its power can be magnified if we allow people to turn their creations into mobile apps to share with the world. Especially when an entire app can be made in 30 minutes! Examples of apps that can be made: Internal business tools: operations manager for workflows, processes, tasks, inventory, delivery tracking…etc. Appointment/event management: classes, workshops, RSVPs or employee scheduling. For salons, spas, gyms, clinics, catering, tourism, photography…etc. Catalog/directory: a community-curated list of restaurants, recipes, apps, events…etc. Marketplace: for anything where there is suppl

We were thrilled to work with James Q Quick to make a video to show how to easily write Airtable queries. Had to share it with this awesome community: In the video, James shows how to replace complicated filterBy statements with SQL using Sync Inc. It’s just another great way to work with your Airtable data in scripts and other apps.

Hey Everyone, Airtable date formulas is a powerful tool that lets you perform date-related calculations, set deadlines, apply timezones and locales, and much more. But sometimes dealing with formulas can be a bit intimidating. So, we’ve prepared a list of most commonly-used date formulas with concise explanations and examples that you can review and start using right away. Enjoy!

Hello everyone, I recently saw a topic in this section about the “Autonumber” field. Some of the problems mentioned are not relevant in my opinion. Here are my requirements : Auto-increment a field Always take the last generated number + 1 Never change a generated number It does NOT : Recalculate numbers when a record is deleted Recalculate any number when record is moved … I use this to generate invoice/quotation numbers. I made a very basic script to handle this, feel free to copy and use it on your Airtable base. /*********************************/ /* A better Autonumber */ /*********************************/ /* Author : Florian VERDONCK */ /* Website : airtablefacile.fr */ /* Version : 1.0 */ /*********************************/ let config = input.config(); // Script configuration const TABLE_NAME = config.TABLE_NAME; const INCREMENTED_FIELD_NAME = config.INCREMENTED_FIELD_NAME; // Query all records, sorted by number descending (biggest numbers

I’m working on a Squarespace site right now for a friend, and they want to collect information on the site. Squarespace’s abilities with forms are better than nothing, but not by much. Luckily, I’ve already turned my friend into a huge fan of Airtable, so he’s excited that we can collect the data in Airtable. Squarespace gives you the ability to embed code in a page/post, so this is incredibly easy. They give you an example of embedding a Wufoo form, but you can use the exact same strategy to embed an Airtable form. Create your form in Airtable. Click the button to get the Embed code (use the adjust height checkbox to make the form look better). Create a Code block in your Squarespace page/post. Copy the form’s Embed code into your Code block.

Working with a friend, and we are looking to build a project management type solution on-top of airtable. I am looking for the following: Someone to help me structure my base/tables in the best manner Someone who can visualize our data into a spider graph in real time (will provide an example of what I want it to look like). I have some specific use cases in mind. Please, just book some time in my calendar (calendly.com/booksam) so we can chat. I want to deliver this potentially by the 3rd week of May. Thanks!

I joined Aron on the Automate All The Things stream to show how no-coders & low-coders can get started with APIs by pulling any data into using https://datafetcher.io/.

Hey awesome folk of Airtable!! For the last 5 months I’ve been working on a membership & subscription management tool to sell secure Airtable access directly to your audience. I had some bases I wanted to sell read-only access too but was struggling to find a tool to do this. I love Airtable’s UI and it’s sortable, searchable features. I didn’t want to use an Airtable to website type of builder, because let’s face it. It’s never as good as how your Airtable bases look fresh off the press. So I set out to build a tool that would basically ‘host’ your readable Airtable bases and build a membership platform around it. Super happy to announce it’s now live! Introducing Paytable An all-in-one tool to monetise your curated resources, checklists, lead magnets, research products, galleries, job boards + more. Hidden Airtable shared view urls Users don’t need Airtable accounts Add to your site in under a minute No additional Airtable fees Revoke access, grant access. Import sub

Well, after all this time, its finally here: my custom app Master Calendar. What it does: Master Calendar is an app for Airtable that allows you to display and even edit records from multiple tables in one calendar interface as labeled, color-coded events See it in action: Get it from the Marketplace: Airtable Master Calendar - Apps - Airtable Marketplace Manage events from multiple tables with ease on Airtable with the Master Calendar app. Register for a KamillionaireApps account to unlock all the features!

When you want to build custom tools or websites on your Airtable data - then you’ll be using the Airtable API and almost certainly some JavaScript (in this case Node.js) to work with your data. Soon you will probably start asking questions like: How do I paginate through the Airtable REST API? How do I manage the 5 calls / second rate limit in Airtable’s API? How can I find specific records using filterBy? How do I use the API to return linked data from several tables? TL;DR - the answers were just as tedious to build as we thought. So we built a tool and wrote a tutorial on how to skip the API and use Airtable as a database. You’ll find many iterations of answers to these same questions here in the Airtable community. Yes, all of this is possible using the REST API, but it takes a bit of wrangling and time :cowboy_hat_face: We wanted to simplify the problem and completely skip the tedium of working through the nuances of the API. So we wrote up a tutorial on how to easily read fro

Softr’s (a no-code platform for building web apps powered by Airtable) latest release has significantly improved the List & List Details blocks. Until recently, our List & List Details blocks that pulled data from Airtable had a fixed layout and a limited number of fields to choose from. You can now dynamically add as many fields as you like with as many types as you wish! We now support the following field types : Simple text Simple text (markdown & HTML formats) Email Heading 1 Heading 2 Heading 3 Tags File Video Audio Image Gallery Embed (e.g. Calendly) Google Maps Rating Button Divider Check out other updates and news here: https://softr.io/whats-new

We a are commercial construction subcontractor. We are looking for an Airtable Dashboard expert who can help us pull data based on certain criteria to create visual decision making tools.

Hey Everyone, Our latest article in the “Learn Airtable” series explains how date formulas work and how to use them. We’ve provided detailed explanations and practical examples, so it will be helpful for both beginners and those looking for a refresher. Cheers, Narek

Hey Airtable fanatics, We’ve made some big updates to On2Air: Amplify! Start a free 14-day trial We’ve revamped the layout and made it even easier to quickly create view types, change layouts, search records, and switch tables. Check out these new features! :boom: New Feature: Search Dashboard and Filtering Welcome to the brand new Search panel! Now when you search, every field and every value in the field will be searched automatically. Example: ‘in progress’ will find any record with the Status of ‘In Progress’ ‘quad’ will show any record containing ‘quad’ or ‘Quad’ ‘63’ will show any record with and amount containing ‘63’ or ‘63,000’ You can also configure your search to refine and search only specific fields. Then, you can choose you how you want the search displayed by choosing a primary display field, how many records are displayed, and how many fields to display. :boom: New Feature: Navigate between tables seamlessly You can now switch tables from the Amplify da

Part A – build one or more base(s) of 3rd party architectural product information (lighting and electrical equipment for commercial architectural projects) that we specify on a regular basis. This may have 10 to 20 data points for each entry. Part B – Create a template that allows my team to create a unique schedule for an individual project that will draw information from that master base. When we need to add something new, I want to add it into the project, but have that information propagate back into the master database also. we will have PDF files associated with each entry, but any PDF may be usable across several base data fields. ie product A has a PDF data sheet, and we carry 10 versions of that product in the master base, each entry needs to have that PDF tied to it. Initially, we should sync up on a zoom call for 15-20 minutes, I can demonstrate how we do this with Google Docs (and why it has serious faults). thanks Mark

Hey everyone! My team at Unito just wrote a Beginners Guide to Airtable! It covers the dashboard, workspaces, bases, and more. I thought it would be helpful to anyone who’s new to the community. Let me know if you found this useful, or if there’s anything to add :slightly_smiling_face:

Hello! We have recently created a base on Airtable to track the students our nonprofits serve. We also just added the Send SMS app so we could, for example, text all the students that hadn’t completed a particular milestone. We realized, however, that the app doesn’t support incoming messages. Airtable Support shared that it’s possible to get those messages back into Airtable either by using the public API or using an integration platform such as Zapier. We’re needing someone to help with this integration. Ideally, the outgoing and ingoing text messages could all be viewed by student record within Airtable. Additionally, we’ve created a few forms via Airtable and would like help switching the links out on our custom app. The previous forms were feeding into Salesforce which we were using before Airtable. Thanks!

I made this script which allows you to compare two lists based off a field value, then modify a checkbox when matches are found. My use case example: I create a custom list of contacts to email about a product by selecting a checkbox next to who I want to send to. I save this list of contacts as a view in Airtable by filtering where contacts have a ticked checkbox. I make another list of contacts to email about yet another product, however, I want to make sure that I’m not sending this to the previous contacts and their companies I sent to previously. In this case the script works as such: Table is my database Reference view is my first contact list view View to Modify is the second list I want to compare to the first Match field is the ‘Company’ field (string in airtable) - this could be anything Field to modify is the checkbox which is ticked for my second view Set cell as ‘unticked’ to remove the companies I have already contacted You can use this script to do anything however,

:speech_balloon: Actual Scenario: When a member of the team (there are 5 members) makes a question about a certain proyect (we have many at the same time, around 100) the related client receives the question automatically in its email. But in order to answer he has to go into our portal (we use miniextensions.com) log in, find the question and answer it. Which is quite a slow process. :star_struck: Desired Scensario: When a client receives a question he can directly reply the email, and his answer will be updated to the related record. Looking for quotes. If interested write me to t.vacanarvaja@andexgroup.com Thanks

I had an idea in mind for a while now. I would like to create a “hub”, a repository of science-backed studies on a specific topic. If you’re familiar with this website, examine.com does exactly what I intend to do on a broader scale. While examine is not specific to one “niche” but rather gathered studies on specific supplements, I intend to do the same for diabetes and everything related to insulin resistance. Ideally, the project would contain a Home page with a search bar and illustrations all around, with part of the Homepage linking directly to subcategories like: studies repository for the tag « Cinnamon » studies repository for the tag « Metformin » studies repository for the tag « chromium » etc. I imagine I’ll have to create a database regrouping every study about the subject; Ideally, I’d crawl/scrape the URLs of the major databases publishing studies: Pubmed, ScienceDirect, Google scholar/NCBI, and the likes. I’m also looking for guidance regarding the best practices here in

Hi there :wave: If you’re interested in learning how to create airtable charts with real-time data and add it to your website, I have created a quick tutorial for you. Main benefits include: Interactive charts, so your visitors can play with the chart. Real time data, whenever you update your airtable database it will automatically update the chart. Looks better than having an image chart on your website. Try for free, no sign-up required https://nocodechart.xyz/

https://jrosendesign.medium.com/10-days-til-launch-paytable-io-my-side-project-turned-labour-of-love-f8fbc49eb4fd

APPLY HERE: Data Fetcher Content Creator Background: Data Fetcher (https://datafetcher.io/) is an Airtable app that lets users run API requests in Airtable. The app is a low-code product, so you’ll need some experience with APIs. Hopefully, you’ll also have experience using Airtable. I will help you understand Data Fetcher’s features, handle the topic suggestions and high-level plan for each video. I’ve been making YouTube videos myself, but am looking to hire someone to help me do this more consistently and with a better production value. I’d also like you to write the blog posts that go along with the videos. The videos are quite simple. Just a walkthrough of using Data Fetcher with a particular third-party API. I’m open to suggestions on the format and keen to see what you can do to improve them. You can see an example video here: How to Import Binance API Data to Airtable & Build a Crypto Portfolio Tracker - YouTube The blog posts are simple walkthrough guides with a few screen