Builders Board

Hi everyone - announcing the upcoming launch of my new project - Airguides Airguides offers step-by-step guides to building Airtable bases for common use cases - a CRM/sales pipeline base or a holiday/vacation “request and approval” base for your business for example. The aim with these guides is to get relative newcomers to Airtable from a basic app to one that is humming along :slightly_smiling_face: The first guide - Build a Sales Pipeline App with Airtable - will be released later this week. I’ll post again here when it is launched or sign up here to get a notification for this and other guides. Thanks!

Check out this guide by one of the top Airtable experts on creating client portals using Airtable and Softr:

So I absolutely LOVE using Airtable… but I’m finding that using the browser is a huge CPU + RAM sink. So I’ve been working with a small team of developers on a totally new way to get around this problem. We’re calling it “Fractal”, an it’s a streaming web browser. It looks and feels exactly like Chrome, but it runs on a private CPU in the cloud. Think of it as Netflix for web browsing — your computer is just receiving pixels and doing none of the work. It’s a super lightweight way to browse, and it also takes advantage of the fast internet speeds of cloud data centers. Now that Fractal is in its “beta” phase, I’d love to give out some demos to all the Airtable users who need their RAM back. Feel free to message me if you want to give it a try or chat about how it works.

Non-profit seeks Web developer with experience in Airtable API’s to help improve the look of two pages on our website that use Airtable databases to populate. Currently the site is hosted on Wordpress and ideally we would not change that, but if we need to switch in order to improve the functionality and design, I’m open to hearing about it. Please PM or comment below with a link to your portfolio of pages that display Airtable databases in some way. Thank you.

I’m creating a base for many manufacturers and their products and would like to have a consultant guide me along the way. Would like to see some user interfaces that I can model. My first thought is that I’d like buttons that take one to a category. Once in that category, a user should be able to filer on critera. They should then be able to filter across other categories and keep on filtering. Once done they can go to a kanban view. I am looking to get advice to proceed the right way from the start. The users will need to pay to have to this base, so I’ll need them to have a UN and PW. But I’m not sure how these passwords are managed. Do I need to manually assign them a PW? Do I just need to authorized their email address and they then go to a page and create their own password? What is the best way to manage user access with passwords? I will create a form for each manufacturer to fill out and would like their data to automatically get populated in airtable. I see the

We’re looking for a developer to improve our existing sales/royalty reporting airtable and build out a robust inventory management system. We’re small publishing company with 2 different imprints. We deal with physical products, B2B, B2C, many different sales channels, and several inventory locations. We also run our own warehousing and logistics so tying everything together with inventory management infrastructure is key. Our company has been quickly growing for several years so we’re also interested in long term partnerships with a developer to maintain growth and address new obstacles. Feel free to shoot me a PM or drop your contact info here. Best, Nolan

We’ve built a Project Management & Project Tracker Airtable database and maxed out our knowledge from the webinars and tutorials. Looking for expertise to review our work, find and implement efficiencies through scripting as we’ve maxed out our bases’ automation threshold. High level scope of work: 1 central intake base that acts as the ‘source of truth’ for collaboration projects/defined work packages External clients fill out the form to create records and trigger section leads for review Divides up work tasks and distributes amongst 6 different work area/sectional bases Bases and records need to talk back and forth to each other - eliminate manual PMing of records We have the defined workflow processes and triggers mapped. Approx. 30 collaborators across the bases

Hi Airtable Community :wave: I’m Engjell, I’m working on https://nocodechart.xyz/ to create an easier way for no-coders to create and export charts to their websites. An airtable user reached out to me and asked to build an airtable integration and now it’s live on my website. You can create charts and export them to your website with real time data from your airtable database. You paste some data in the required columns and the chart will be generated. You copy a link and paste it to your website and you’ll have the chart on your website. When you change data in airtable database it will automatically update on your website. A quick video Loom | Free Screen & Video Recording Software

Hey awesome Airtable curators! I’ve spent the last 6 weeks working super hard to build my new tool - Curateable, which turns Airtable databases into products in seconds. I was struggling to find a platform to monetise databases securely, without having to custom build an integration with stripe, so I built one. You can now sell secure access to your databases with single payments or subscriptions and get total control of who and for who long customers can access your base. How does it work? 1) Connect your database 2) Customise your landing page 2) Set a price and promote It takes less than 10 seconds to auto-generate a secure landing page and you can start selling right away. We’re currently in public beta and offering free plans on all revenue up-to $150 then it’s $15 p/m to use ongoing. Here’s a detailed guide which explains how our product works and why we created this purpose built tool to help you sell secure access and monetise your databases. Thanks, any questions, we’re pret

I am a busy guy. We probably all are. If I share a dedicated workspace with just one table in it that is silo’d off from my real AT workspace, no one can see my other AT stuff, right? AT has PGP? I am asking here If there is a link in that table to a dedicated google sheet, no creator in the AT table can see the rest of my google sheets [or account], right? Cause I had to give permission for the google account. Of course I don’t think so, but it was bothering me. I tried to check by approaching it with a private window as a public view. Last question: is there anyway a creator in an AT base could install any malware into my Airtable? Like a bot that sends the data after the job is done I like Airtable. I really need a tutor. But I have an application to do now. I would like to improve a Google Form by syncing it to a new Airtable CRM. The sync would either happen w integromat or, I could move the form to Airtable. So I hire an Uphold programmer. First problem with using Airt

Here is my solution for tracking time in my job. Scenario - I’m an owner/field service technician. I use Airtable 90% of the time on an iPhone or iPad and need a way to track time per job and/or the same job with multiple visits. Obstacles - Airtable mobile app for IOS cannot run apps or scripts. Solution - Two check boxes (START JOB & STOP JOB) to trigger two ‘last modified’ columns(Start Time & Stop Time). Then a datetime_diff formula in TIME(MINS) to calculate the onsite job time in minutes. - DATETIME_DIFF({Stop Time},{Start Time},‘m’) There is an Automation for every time the STOP JOB is checked. It creates a new record in the TIME table and links it back to the original TASK #(job). Back on the TASKS table, I have TOTAL TIME rollup the sum of all the minutes. Finally the calculation of hours and minutes is completed in the TASK #, but only if the STOP JOB is checked.

Formulas in Airtable can be as simple or as complex as you need them to be. When writing a formula with many conditions it can get particularly difficult. You may have run into the case yourself where you have written a complex formula and somewhere in that formula a part of it isn’t working as expected. It can be hard to find that part. For example, I had in mind an Event Planning formula that could: Give me the number of days, based on {Start} and {End} dates, that an event is occurring (returned as the value “x days”) If the event is only one day, give me the number of hours instead (returned as the value “x hours”) If the event is only for 1 hour, I don’t want the value to read “1 hours” - I want “1 hour”. This is the formula I ended up writing: IF(DATETIME_DIFF(End,Start,'days')+1 > "1", "📅 "&SUM(DATETIME_DIFF(End,Start,'days')+1)&' days', IF(AND(DATETIME_DIFF(End,Start,'days')+1 = "1",DATETIME_DIFF(End,Start,'hours') = "1"), "🕒 "&DATETIME_DIFF(End,Star

I am using airtable to store research data and am needing help getting my records to talk with each other. I’m sure the solution is relatively simple, as some of them are already set up correctly, but I can’t seem to replicate the settings properly. Any help would be greatly appreciated.

I am looking for someone who can help me customize or create a project manager that can handle multiple projects and contributors. Looking to be able to create up to date listing of projects by contributor and status among other things.

Hi, I’m part of a health system that is helping lead COVID-19 vaccinations for the state of Illinois. We use Airtable as a waitlist/notification system when vaccinations are available. We can text and email with the system but would like to add the ability to send a simple robocall using Twilio, also. We have the Twilio licensing in place and can handle the Twilio setup and scripting. We need assistance creating the app within Airtable. The app would be almost identical to the existing Send SMS and SendGrid apps with similar inputs. Thanks, Jeff Carroll

I wanted to share our new Airtable app with you - On2Air: Amplify On2Air: Amplify is a brand new way to view your Airtable data. With custom views, a full-screen viewer, record customizer, and editor, On2Air: Amplify will change the way you use Airtable! :new: New users start with a free 14-day trial, so you can install the app directly from the marketplace today ! For the first 25 new customers, you can use the code AMPLIFY100 to get a $100 discount on any monthly or annual plan for either a bundled plan or a single app. If you’re a current On2Air customer on a bundled plan, you have Amplify already ! Go to your base in Airtable and install the app directly from the marketplace. How Amplify can help you No more scrolling through long tables of records or having to individually open and close each record Create and customize your record views in your Airtable base by displaying or hiding fields, so you see only what matters most View documents, images, text fields, or website

Hi, We have an existing Airtable CRM that is based upon last catchup template…Mostly it has developed as we gained customers. Problems: Inventory Management sucks Budget and revenue generated is absent Can someone help by being available? Thank You, Arsalan

Hi community, we’re in our project management suite, we need asistance inmediatly.

We are shifting from Salesforce to a much simpler and easier system on Airtable. We have 75 member companies in our small association. I want to have a way to add a member company (with a key contact) Then, let that person add up to 100 or so more contacts - with a password or unique url. And, let the key contact look at their list of contacts - at any time - and add or delete names. Can someone point me to resources to help?

Hi! I want to create database (in google spreadsheet) of vendors (seller) who can add their product data (email, photo, quantity and price) from some form or bot

A bunch of new features we’ve just released on Softr.io: :mag: ‘Search By’ - control which list fields are searchable :paperclip: Embeddable Blocks :writing_hand:t2: New & Better Rich Text Editor :heart_eyes: New - Community News! :rocket: 100DaysOfNoCode by Max Haining :headphones: Softr Tutorials by Gareth Pronovost More details here: http://bit.ly/3q6Z0tZ

I work for a non-profit and have begun using Air Table … could really use another support source other than AirTable. I can’t seem to get much attention there. Looking for someone who is willing to help fellow user out … we do not have a budget for consultant fees at this time. Perhaps in the future. I have old school database creation experience - been a challenge with how Airtable works. What I have created is not really all that complex but I know there are some quirks that need to be tweaked to get the consistent functionality. Thanks Darlene

As I’m browsing through all of these “Hire a consultant” topics, I couldn’t help but think that maybe I can help in some small way to those who really need it (and need it now!). So, for this week, I am going to respond to any no-code related questions you have if you simply send them here and it will be 100% free. No limit on the amount of questions. You will get a response from me as soon as I see it but that may be a bit late somedays (keep that in mind!). In the meantime you can see our old site here, our semi-new site here, our newsletter here, the blog here, and just as a reminder, you can submit any question here and I will help you solve the problem! Hope this brings value to some of you!! Best, Jonathan

Airtable Turn ugly formulas into pretty ones - Airtable Universe If you write formulas for Airtable Bases you might want to check out this tool, packaged as an Airtable Base. ‘Orc’, a formula ‘Pretty Printer’ will format... This is the second release of Orc – V0.2 – prettier and greener. If you write formulas for Airtable Bases you might want to check out this tool, packaged as an Airtable Base. ‘Orc’ , a formula ‘Pretty Printer’ will format a complex Airtable formula into a standard set of uniformly spaced code. Orc changes this: DATEADD({NextMonWeekMonth(2)}, IF({OnWeekdayDOW}<WEEKDAY({NextMonWeekMonth(2)}), SWITCH({RecurrenceType}, ““Weekly””, {WeeklyDate(2)} , ““Monthly:ondayofthemonth””, {Monthlyondayofmonth(2)} , ““Monthly:onacertainweekday””, {Monthly,certainweekdayDate(2)} , ““Monthly:onlastweekday””, {Monthly,lastweekdayDate(2)}, 1+{OnWeekdayDOW}-WEEKDAY({NextMonWeekMonth(2)}) ) +7*({WhichWeekas#}-1)-1, ‘days’) I

Some nice additions to Softr.io that I’d like to share with you: :mailbox_closed: Personalized Lists (aka Conditional Filters) ↔️ Automatically Sync Softr Users to Airtable :crystal_ball: Multiselect field type in forms :heavy_check_mark: New template - Paid Online Courses Platform :heavy_check_mark: New template - Travel Destinations More detailed overview available here: http://bit.ly/3sphpUz Cheers, Narek