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
If you’re concerned about the recent change in Attachment URLs that Airtable just announced, we want to hear from you. At On2Air, we’re exploring ways to overcome this. (We build apps for Airtable - on2air.com) Let us know if interested and your use-case by filling out this form. File Storage File Storage 📌 Status: Submitted
Joel here, founder of Paytable :wave: I’ve been busy working away in the background bootstrapping Paytable and have just dropped a pretty huge release of new features & improvements. Paytable is gradually becoming an all round membership management platform and an ideal way to sell gated content with the help of many users feedback helping to refine the product. Here’s a super quick overview of some quick wins that have been going down at Paytable recently: :boom: Offer free info products to start building your audience Pay-nothing, sign-up-with-email only products have landed. Create a product, set it to 0 and start building your mailing lists with awesome info product give-aways that can help make it go viral. Head to your dashboard Add digital downloads exclusive for members On a mission to become the ultimate members only platform for makers & creators we've also added digital downloads for your subscribers. This means you can keep your members around lon
This question caught my eye on OpenSide’s Slack channel this morning. It’s a common question for anyone doing anything serious with Airtable. I’ve written about this subject many times including here and here. Does anyone know if Airtable can support more than 100k records per base on enterprise? I generally try to reframe this topic to suggest a more important question you should be asking - Is there a way to optimize the data model to accommodate the equivalent of at least a years worth of transactions? High-volume record requirements are generally indicative of transactions; data flows that are increasingly less relevant as time passes. And there is at least one trick you can use to expand the capacity of small transaction records by not storing individual records in a linked (relational) table; rather, store them as JSON objects in a long text field. This is, of course, a sanctioned approach as evidenced by this Airtable feature . To pull this off, a button (in the client recor
I created a script that takes data from a table to perform a mail merge using the Lob.com service. Airtable Mail Merge with Lob.com - Airtable Universe This shared base demonstrates how you can perform a mail merge using Airtable and the Lob.com service. Instructional video:... The share on Airtable Universe includes the scripting block code as well as an instructional video. -Bill
Hi everyone I’ve posted previously about making a simple “to do” list that generates a new task with the same name, due a week later, whenever you tick the task complete. Here’s a slightly more sophisticated version of the same idea, where you can specify when you want the task to repeat, e.g. 1 week later, 2 weeks later, etc. Hope this is useful to someone out there. I’m just getting started on making simple instructional Airtable videos, so appreciate any feedback. Cheers!
Hey there,If you’re looking for a dashboard layout to view multiple tables in your Airtable base at one time or to edit and create records and Linked records, check out On2Air Forms for Airtable.You can create sections with your various Airtable fields and what’s most useful for you to see. We have a free plan, so you can try it out. Get started hereOn2Air Forms Features:Update existing Airtable recordsCreate new Airtable recordsCreate linked recordsEdit linked recordsView linked recordsDisplay data from your basePre-populate form fields with dataAdd SubForms inside of your form to update multiple tables and linked records from 1 formAllow editing and viewing of data even if not a User on your Airtable account (no need to purchase more Users)Create custom Dashboard/Portal pages for clients and your team with unique URLs (Login Options on long-term roadmap)Use basic and dynamic filters to limit record viewedUse URL prefills to display specific recordsAdd default values to fields per use
Hi everyone. It just occurred to me that you could use a formula and a couple of automations to make yourself a simple recurring tasks list. All you need is a date field to set the initial due date of your task, a checkbox field for when you mark the task as “Done” and a formula field that adds a specified length of time to the due date using DATEADD when “Done” is ticked. Then your automation will take the date generated in the formula field and replace the original date in {Due date}. A second automation then takes a last modified field set to monitor when “Done” was ticked, and a formula that shows how much time has passed since “Done” was last ticked, and unchecks “Done” after that length of time has passed (I set this to 2 minutes, i.e. 120 seconds). This final step is to ensure the two automations do not interrupt each other (so to speak). Here’s the full set up… Fields {Name} - Primary field, single line text. The name of your task. {Due date} - Date field, indicating whe
Memorializing this since I spent entirely too much time and bugged @Justin_Barrett @Bill.French and @openside to get this output. I needed to output the US date format into an email, but I needed “tomorrow’s date” to be output. The use case was an email that goes out through automations every Wednesday, but they needed a reminder in the email to follow up by Thursday, (Tomorrow’s Date). Here’s the outcome. It works, so we don’t try to make it more elegant in these parts :slightly_smiling_face: let someDate = new Date(); someDate.setDate(someDate.getDate() + 1); let dateFormatted = someDate.toLocaleString('en-US', { year: 'numeric', month: '2-digit', day: '2-digit'}); output.set('thisDate', dateFormatted); You can add whatever number to the second line to add, haven’t tried subtracting. Also, the toLocaleString() without any modifiers outputs a date and time.
Generate random users in an Airtable base Simple workflow: Input required number of random user records. Push Go! 22 pieces of random information per record: Full name, Gender, Title, First name, Last name, Street, City, State, Country, Postcode, Timezone offset, Timezone description, email, UUID, Username, Password, Date of birth, Age, Phone, Picture large, Picture medium & Picture thumbnail Custom script gets randomuser.me data and creates records Works with free Airtable plan Full instructions with videos https://marcfletcher.gumroad.com/l/ixmfa
We are happy to announce the Java Client for Airtable. We created for educational purposes. Have a look at GitHub: https://github.com/Sybit-Education/airtable.java The client supports automatically object mapping. All CRUD-Operations (including Attachments) are already supported. But it is a very first version. Any feedback or pull requests are welcome.
These are static tables I find myself using frequently when building bases for clients, so I keep a copy of them on their own in my account so I can easily copy-paste them into bases when needed. I’m creating this wiki to share them in case other people might want to use them, or contribute their own reusable pre-mades. To make use of these, open the base through the links below, then use the “Copy base” button (top right corner) to add a copy of it to your own workspace. Then, you can copy (⌘/ctrl + a → ⌘/ctrl + c) and paste the table desired into other bases as needed. US & CA States/Districts/Territories Includes Country, Capital City, and Postal Abbreviation. Airtable US/CA States/Districts/Territories - Airtable Explore the "US/CA States/Districts/Territories" base on Airtable. Airtable Keyboard Shortcuts The same list you can access from the “Help” menu, but will be hit by global searches from the Search Block if includ
Hey Everyone, We at Softr.io have prepared a simple how-to article about creating a job board on Airtable. As we see more and more niche job boards popping up, we wanted to share this with a wider audience so that more people without tech skills can build projects like this. The article covers the following steps: How to create a job board from a template; Setting up a form to receive job posting submissions from users; Restricting submissions to logged in users only. Check it out here. Would love to hear your feedback and ideas! Cheers, Narek
Airtable has just released my latest app: My One Record. I wrote this app because I wanted a quick way to access linked records in a grid view without the distractions of other unrelated records. I have been personally using this app in my own bases every day ever since I wrote it, and it is such a mental timesaver when you need to jump between parent and child records. Here are some links: watch a video demo install the app from the marketplace purchase a premium license. To setup this app, your base needs … a collaborators field (that allows adding multiple collaborators) in the parent table a button field in the parent table to call the app a lookup field of that collaborators field in the child table a filtered view in the child table based on the lookup The video demo has more details on how to setup and use the app. Note that you can test out the app before purchasing a premium license. A premium license simply removes the delay before changing the active view. Some notes:
I wasn’t entirely surprised today to learn about the carnage over on the “Make” Facebook group, soon to be the former Integromat group. When Cleonis acquired Integromat I predicted there may be turbulence in its future. I tried to tell you. This is what big companies that get bigger through acquisition do best. There are some really angry customers because they apparently rototilled the framework, adjusted the terms and pricing, modified some long-understood concepts, and gave it a new name that even a Google PhD couldn’t find using the most advanced search queries imaginable. Try to search for this new flagship product - it’s laughable. I definitely want to have coffee with the marketing MBA who spent perhaps $250,000 renaming and rebranding this product. “Make”? Seriously!?! Was “Do” taken? Did “Go” not make the shortlist? And what were these people doing when this brilliant plan was hatched? It backfired. But cheer up; it’s likely to get worse.
Thought I’d show off a project that I use very often in my life as an Airtable administrator. GitHub GitHub - nafeger/airtable_collaborators: A way to track collaborators in an... A way to track collaborators in an airtable enterprise account - GitHub - nafeger/airtable_collaborators: A way to track collaborators in an airtable enterprise account This tool will allow you to manage a Base that can be synced with all the collaborators within your organization. I often found it difficult to determine who had access to which bases, and who was assigned to workspace vs individual permissions. So, here’s a fun tool. It currently requires access to the enterprise api, so keep that in mind if you want to use it. Any questions feel free to ask here or hit me up on the twitter: @nafeger
Hey everyone, Sharing an article I wrote on how we mange our entire community on Airtable and how it powers our community site. I’ve tried to keep the article short and sweet, hope you enjoy reading it as much as I enjoyed writing it! :grinning_face_with_smiling_eyes:
Have you ever wanted to display the information you have stored in an Airtable field on a form? Maybe you want to display an image from your base on your form? Your Airtable base :point_down: Your Form :point_down: Or maybe you want the form user to choose a specific record from your Airtable base in the form? Then, once they choose the record, you show them information from 4 - 5 fields in that record? You can do all this with the On2Air Forms app for Airtable. On2Air | Accomplish Anything with Airtable – 3 Jun 20 On2Air: Forms | On2Air On2Air: Forms allows you to create and configure advanced forms using your Airtable data completely integrated with the powerful features of third-party form builders. Enhance your Airtable forms with more options, such as prefilled data, custom... Here’s an example using an Airtable base that contains Companies who are in the Pilots Club :flight_departure: :flight_departure:
I knew that title would grab your attention. People often ask me to help them with Airtable projects and I agree to help them from time-to-time, but not always. And I don’t even post much about my work because - well - it’s a bit boring and obscure to most onlookers. Some of my architectures require data in Airtable to magically sync to Google Sheets at the cell level - literally the data in a cell in Airtable must update to a target cell in Google Sheets in near real-time. While possible, not many people require this level of integration let alone in less than 1 second. As such, my work tends to be very behind-the-scenes sort’a like the city waste managers - workers who deal with stuff you need to work reliably but whose names are never known unless something failed. :winking_face: The title of this post relates to a very specialized role in the NFL (and increasingly College football). The “long snapper” is a specialist whose craft is not really known by even the most ardent footbal
Airtable - what have you done to the look of expanded records. It’s AWFUL. I’ve had a whole morning of my colleagues ringing me and asking what I’ve done to the look and begging me to change it back. Does anyone else share their revulsion?
If you need a way to create documents automatically with your Airtable data 📃 📁 , whether it’s an invoice, a contract, a flyer handout, a label, or other types, you can use Google Docs with the On2Air app.The On2Air Docs app allows you to automatically generate documents from your Airtable base into a Google Doc, Slide, or Sheet. Then, adds it back into your base as a PDF and Google URL.You click a checkbox ✅ in your base or schedule automated times and your document is created. It's then uploaded back into your base as a PDF and/or a Google Docs file.Here’s how AirOps Consulting, Founder and CEO Cherry Yang, uses it to generate Quotes and equipment lists from an Airtable base.(There’s also a free Quote template for Docs and a Project Budget Airtable base template you can grab)How On2Air Helped a Consulting Company Automatically Generate Documents using...With clients who needed automated documents using data stored in Airtable, AirOps Consulting knew they needed
Two of these terms are increasingly familiar to you; the third one – low-effort-code – is new, but you’ll be hearing about it more and the engineers at Airtable are likely very familiar with it. I just wish they’d bake the underlying AI into the Airtable code editors. Maybe the folks at SeaTable will listen because they support javascript and Python and GPT-3 supports both. :winking_face: When I’m writing code, I have another programmer with me every day all the time. It’s an AI model that is constantly scanning my source code and making really fast lookups into about a trillion lines of code written by other programmers. It’s powered by GPT-3 and delivered as a plugin to VS Studio Code. I typically use the VS Studio code editor to create Airtable scripts and as a result, my paired programmer has already learned how to write Airtable SDK scripts. As such, my low-code activities with Airtable have become more optimized - truly low-effort-code. Here’s a little video demonstrating that
You may be in a situation where you have a dataset with a lot of numbers, and you can’t find any meaning in it. (It’s me. I’m in this situation :raising_hand_woman:t5: ) If I could only break those numbers up into smaller groups, maybe I’d be able to better digest and distill some meaning. As a first start, I figured why not group these numbers into a nice set of four quartiles: Low, Below Median, Above Median, and High. That way I can use Airtable’s grouping to get a better sense of what I’m dealing with. I’ll preface by saying that I majored in English and I do not stand behind any mathematical concepts I’m using. If they’re wrong, call me out, I seriously don’t know better. Until recently, the only way you could run calculations on the content of an entire field was through rollups, which was pretty inconvenient and took some mental gymnastics to understand. But, with the scripting block you can do this analysis pretty neatly. I found this nice script over on Stack Exchange and bui
Hi @Jordan_Scott1 & @Rose_K , Some links from the Forum that deserve a little UP because they don’t seem to be often quoted neither by the Askers, nor by some Helpers: Airtable Team : To maintain (in my opinion) because they are sometimes gold mines of finds, quickly found in case of need! Featured Resources One of the best initiatives of AIRTABLE’s Communicants, not to be overshadowed by numerous subjects covered since! Airtable: The Featured Resources category contains collections of resources created by both Community users and Airtable to; answer common questions, provide use case examples, and showcase awesome workflows. Featured Resources - Airtable Community Forum Maybe those who seek the forum through indexed search techniques (such as those taught in some sections by @Bill.French) don’t really need it, but not everyone does R&D in this exciting field. Formula Foundations Essential resource to be consulted, consulted again about the formulas available in Airtabl
I chose Airtable as one of my Top Productivity Tools for 2022. Please share if appropriate. Thank you for making such a great tool that is a big part of my success.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.