The show and tell space is a place to showcase your work and have conversations about what you’ve been creating in Airtable.
Recently active
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
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
Hello, my clients use airtable forms on mobile all the time . but if they wait too much before validation, the form reloads and data are lost. i found ways to block reload but this is too complicated for my clients. any solutions ? waiting for an airtable offline solution… ?
Are you tired of juggling multiple Calendar views to look at your records across multiple tables? Check out this Custom Block which can display records from multiple tables in one calendar interface! Video Demo: Interested in gaining access? Use this form: https://airtable.com/shr8KDRmzY3LcLEw1
Hey everyone! My team at Unito just wrote a piece on how we use Airtable to create a competitor ecosystem, and I thought it might be useful to people here! Essentially we create a base with fields titled ‘name’,‘type’,‘description’,‘pricing model’, and so on. Additionally, there are some tips to building your own competitive landscape on Airtable. This really helps us keep an eye on the competition. Do you use Airtable for the same thing? Are there any other fields you use that helps you accomplish this? Let me know if you found this useful, our team uses Airtable for many things, and we’d love to share the other ways we use it!
Hey there, If you’re looking for a way to set up an educational platform on Airtable to share your knowledge and skills, here’s a brief guide explaining how that can be done using the Softr no-code platform. Cheers, Narek
I tend to work in the Kuiper belt of complex and challenging integration projects at scale but I’m not isolated from occasional simple problems where I can learn something while helping others. I also advise many investment groups and companies concerning the bets they place in no/low-code systems and vendors. With vast experience in fishing woefully architected systems from a cesspool of low/no-code Airtable Goldbergian buffoonery, I feel compelled to offer this advice if you are seeking the right person to lead the development of your future Airtable tech stack. An appeal to candidates who are low/no-code “experts” is risky because it will entice and attract people who have many skills that have done some amazing things with Integromat, Zapier, and other platforms. But there’s another side of no/low-code power-users that may result in the creation (or expansion) of costly, unreliable, and largely unsustainable processes. Some of these candidates seeking work will be ideal; most will
Using your Airtable bases, now you can easily create client portals, paid member-only community, sell digital services, content, courses, using Softr.io as the frontend! :rocket: Softr now supports: :money_with_wings: :bust_in_silhouette: :lock: Login / Signup functionality - Authenticate users using your Airtable bases :credit_card: Paid Content (Stripe Checkout) - Request users to pay recurring fee or one-time payment to get access to content from Airtable :eye: Conditional Visibility based on Payment, User Email & Domain - Restrict access to entire page or sections of a page, depending on user logged in status or payment conditions :robot: Dynamically connect Softr frontend to Airtable - now 10x easier :busts_in_silhouette: Manage registered users in your Softr application - no need to store passwords in Airtable :mag: Search, Sorting, Pagination on your Airtable data - all out of the box :arrows_counterclockwise: On the fly support of any Airtable changes (n
Hey there! I work for Unito, a company that creates integrations between tools, like Airtable. We recently wrote an article about how we use our own product to bridge Airtable and Asana! When we decide what our next integration will be, we keep track of information, like API availability and user demand, in an Airtable base. Then, to send this information to other teams, we track it in Asana. You can read about our use case, and learn how we’ve been loving Airtable, here! I’d love to hear everyone’s thoughts, and how your team is using Airtable. :slightly_smiling_face:
I’ve been collecting interesting AirTable plugins, integrations and helpul how-to articles. Enjoy! Airtable AirTable Research - Airtable Explore the "AirTable Research" view on Airtable. Feel free to add to this list! Airtable AirTable Add-ons - Airtable Fill out the "AirTable Add-ons" form quickly and securely on Airtable.
Hello, I am new to the community. I am trying to setup a database for our acquisition company. I have leads that own multiple products and need to be able to sum up all the products in one place. This works perfectly with grouping. However, my issue is assigning a caller to these leads. I want to link all the lead records with the same names to each other and my caller have a summary of all the products, values and one lead contact field. With grouping I can assign a collaborator but they have to be assigned to each one and it breaks the summary. Can anyone tell me how to complete this correctly? I was hoping another table named leads where it listed the owners once and rolled up the values of all the associated records to that owner.
Need to know what type of data is being returned to a formula from a field? What if that field is a lookup field? The common answer for the latter is, “It’s most likely an array,” but there are times when it’s a single value, and the correct type for certain fields is not always obvious. To help save myself (and, I hope, many others) a lot of desktop head-banging, I dove deep into every field type to figure out what’s what, and captured my findings in a table, naturally. :slightly_smiling_face: You can find the results of that effort here: Airtable Airtable Field Reference - Airtable Explore the "Airtable Field Reference" view on Airtable. I plan on updating this table regularly as new field types are added, so feel free to bookmark this shared view, as it’s gonna be around for the long haul. On a side note, this table is the first resource added to my brand new site: AllAboutThatBase.tips. It’s pretty bare-bones at the moment, but mor
All – I want to apologize for my extended absence from Airtable Community; let me assure you it was neither intentional nor enjoyed on my part.¹ I hope what I bring as a peace offering helps make up for all the unanswered questions and messages. Here is version 1.0 of my scheduling/calendaring framework for Airtable. It offers a template-driven solution to scheduling recurring processes, allowing process types to be defined as a set of interrelated events. Later, instances of these processes are created in a separate table, in turn spawning and scheduling component tasks and subtasks. The framework also allows for differentiation between tasks that can fall on any day of the week and those that must be scheduled only on workdays; workday-only tasks can be specified as falling on the nearest preceding or nearest following workday, as desired. Stand-alone templates — that is, a single event with no subtask — can also be created, allowing certain classes of events to be defined as workday
Loom Online Quote Requests: Quote Requests - Airtable Check out a video I made via Loom
Hello Airtable Community, Back in 2017, our team published news about Airtable Importer that since then has been helping lots of this community members synchronize data between Airtable and Google Sheets. Three years later, today I would like to say that we’ve launched Airtable Importer’s brother and called it Coupler.io 2 All in all, our add-on: pulls data from Airtable, Xero, Pipedrive, HubSpot, Jira, Google Sheets (replaces IMPORTRANGE) - and we are going to add more data sources to it; supports automatic data refreshes : every 1, 3, 6 and 12 hours, or daily, weekly, monthly; offers replace (rewrites all) and append (adds new rows only) import modes. possesses a more user-friendly UI will provide User Stats internal web page and more to help you manage your integrations And as always - we are focusing on the needs of entrepreneurs and small businesses. At this point, the product is free of charge. Once we release billing, we’ll be offering 50% off for all paid plans during a per
Happy 2021 everyone! A new year, brings new projects to manage. And where would project managers be without their handy burndown charts? Well, with a bit of scripting and the vega-lite app, you can now make a burndown chart in Airtable! For the uninitiated (aka me until two weeks ago), burndown charts “show the total effort against the amount of work for each iteration.” Meaning, they help you answer the question “are we completing our tasks on schedule?” They usually look something like this: The line represents the planned tasks remaining, and the bars represent actual tasks remaining. if your bars are below the line that means you’re getting things done on time. The X axis can be grouped by the cadence in which you’re tracking - which could be days, weeks, sprints, etc. Until recently, we couldn’t create burndown charts in Airtable because the native chart app doesn’t support combo/multi-field charts. But now with the Vega-Lite App (in beta), we have much more control over our char
Despite the fact that we work and develop apps in a climate of extreme security, the fear concerning Airtable API keys is growing and will likely worsen in the future; Airtable, after all, provides an all-or-nothing API key architecture. And we often leave security requirements until long after the solution is working, at times creating serious exposure to our customer’s data. In Google Apps Script there are a number of ways to separate API keys from the code, but this is typically not enough as far as security professionals are concerned. Separation from code, they argue, still makes it possible for developers to discover the keys. But even this accessibility can be eliminated by moving your API calls into a library and enforcing a basic principle - … only the methods in the library should be able to call methods that can access the keys which are stored in the script project properties. This is achieved with a simple enhancement to a library by setting the method such as getAirtabl
Hi there, TL;DR: Looking for people willing to share their bases with me. I’m Don: I work in marketing at Airtable. And I’m looking for a few volunteers (6-8) who’d be willing to share their bases with me. Specifically, I’m looking for anyone who educated themselves on Airtable and anyone who’s particularly proud of their base (this is your chance to show off a bit). If you’ve published a base to Airtable Universe feel free to share a link to your base there as well! These bases will only be shared with other Airtable employees and won’t be shared with any third or external parties. I’ll share them internally with other marketers to help define what makes a good base (and how we can better educate our customers on building great bases). Let me know if you have any questions!
Hey everyone, We have just launched membership functionality on Softr.io - the no-code platform to turn your Airtable bases into powerful web-apps. And now you can build anything from client portals, paid courses, membership communities, gated content/directories etc. using pre-built signin/signup functionality and assigning visibility conditions to your pages. Check out the video below to see how it’s done - https://bit.ly/3s7Z7b3 More details here - http://bit.ly/2K1qRN8 Would love to hear your feedback if you find it useful! :blush:
Dear Airtable community, Jake & Max here from Paylist :moneybag: :scroll: We are creating a new way for you to monetize Airtable databases. You will be able to charge a one-time access fee, a recurring subscription, or based on usage. Monetization of Airtable databases will open up an entirely new range of revenue-generating opportunities for people who curate great content online (or just curators as we call them). Use cases for database monetization include: Curation of art and collectibles Job boards and people to hire Curated lists of recipes or blogs Aggregated educational resources about a specific topic Geographical data about specific topics Music playlists Upcoming conferences, concerts and other events Lists of influencers / or people profiles in specific sectors This is not an exhaustive list, and we are excited to see what other use cases you all come up with. If you have a use case for Paylist or are working on something similar, let’s set up a 30-minute video cal
Getting the current date/time takes a bit of work Airtable NOW() and TODAY() will return values in Greenwich Mean Time (GMT). You will want, instead, to get your local time zone values, or your times will be off and for part of the day your dates will be off as well. One way to do this is create a Formula field that applies your local time zone to the current time along with the format you prefer. You can then reference it from any other formulas. {Right Now}= DATETIME_FORMAT(SET_TIMEZONE(NOW(), ‘America/Indiana/Indianapolis’), ‘M/D/YYYY hh:mm a’) The Airtable field reference page refers to additional articles on the details of this, here’s a helpful one: (https://Formulas and date fields) Just be sure, no matter how you use them, to wrap NOW() and TODAY() with code. Testing Time Formulas How do you create test cases for a base where the right answers will be different in 5 minutes? As time passes, any date formulas that depend in some part on the NOW() and TODAY() will change as t
Calendar Server This Base leverages Airtable’s Sync feature to provide a full rich calendar of recurring events to whichever base you need them in. Because you can sync the events you don’t need to do any coding; all of the complex date logic and arithmetic can stay in the Calendar Server base, the synced table holds all the important date information. Because it needs to be reusable and because it uses a LOT of date formulas this base has it’s own embedded test system (turned off by default in the the released base). The test system provides a way to assert the results of recurring events to ensure the base logic is working as expected. This test system discovered dozens of coding errors in the V1 product. No software is bug free, but the quality of this version of the base is much better than the original. This base is being shared in the hopes that the community will provide feedback on what’s still needed, what needs to be documented, what’s OK as is for now. My priorities curr
Hi everyone, :pray: First of all, wishing you a happy, healthy, and productive 2021 - hope everyone had a good rest over the holidays. I’d also like to give a massive thank you to the Airtable community for supporting our journey and using Codemap.io to find no-code & automation projects and hire experts - the response and positive/constructive feedback we’ve been receiving over the past 3 months are nothing short of amazing, and we are truly thankful for that and for our vision resonating with you. :nerd_face: If you still haven’t, feel free to join us and sign up to get matched and hired for the right no-code & automation projects - we will keep operating on the basis of our “no bidding” and “no commission” concept for both experts & agencies. :moneybag: With a total of $600.000+ in project value since launching Oct 2020, we are really content with the demand side so far. Over the coming months and going forward in general, our focus will be on expanding and solidif
Finta is an upcoming application that allows you to automatically import your bank account balances and transactions to Airtable. If you want to be notified as soon as it launches (or if you would like to sign up for early access), you can join the waiting list here -> Finta | Product Hunt
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.