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
Hey everyone! I recently launched a tool for creating websites / web apps without coding using Airtable. We have templates for building sites: A discovery site like Product Hunt A job board like Indeed A service marketplace like Fiverr A gallery like Instagram An events site like Meetup A social networking site like LinkedIn You can create your own site with Airtable for free on Pory. Looking forward to getting some feedback and suggestions :pray:
The uploading of images in the airtable is slow. If I try to upload images in bulk, it shows uploading and if I check after 30 mins …no images are being uploaded. Each image is more than 6 mb. Can anyone please let me know what can be the problem and how I can make the process faster. thank you
Hello! We’ve seen a lot of great ideas come from the community forum. It’s a place where everyone helps each other learn and can share the great stuff they’ve made with Airtable. To keep the good ideas coming, we want to challenge you to create something that’ll benefit the community. As a bonus, the most interesting, creative, and useful creations will receive some fun prizes :slightly_smiling_face: First up, we want to see how you can use Airtable to help manage your finances. Of course, a great budget framework is versatile and can work in a professional context as well. We know the community wants to see templates in the personal finance category, but don’t feel you need to limit your idea to a single use-case. You could create a budgeting tool, an expense tracker, or even an anti-budget. Be creative and use your skills to come up with a unique base that others can use and benefit from! We’ve even put together a starter template and a brief guide to get the ball rolling. You
Hi folks, I’ve been working on getting all of the transactions from various accounts (different credit cards, debit, investments) into one base for YEARS. Up until now, it’s been a series of monthly CSV imports (using CSV import block) which was a huge pain. Frankly, most months I’d give up and not do it. That is until I discovered TillerMoney and Parabola. Tillermoney imports all of my transactions into a spreadsheet and Parabola lets me setup a nightly runs to sync transactions between the Tillermoney sheet and my airtable base. From there, I can easily map each transaction to a category using a linked record on the vendor (working on standardizing vendor names with a script!) Here’s a quick video on how I’ve set everything up including the Parabola run and a template base to start from A few Qs that I expect to come up: Why not use the sheet? I work at Airtable so it would be awkward… more seriously, mapping vendors to a category is a pain. Why not use Mint or another tracking app?
I represent the University of Colorado Denver - where I work - and the Digital Pedagogy Lab (DPL), where I am leading a workshop on Maker Education in late July. I am not spam or scam - this is a sincere introduction and invitation. We are hosting a virtual Maker Faire in the last week of July, and I was hoping Airtable – or an Airtable developer - might give just a bit of time and expertise – to essentially offer a ‘how it’s made’ style demonstration of what’s possible. Possibly even an Airtable for Educators type of demonstration. That’s the idea. The DPL event itself has about 500 participants registered this year, from universities around the country. Within DPL, we’re aiming for a mini-Maker Faire for a couple of hours during the week. All video virtual – folks tuning-in and browsing from home. I would really like to have Airtable at the table and demonstrated as a no-code maker platform. I am humbly fishing for an expert to give us 1 to 1.5 hours of your time on either July
Looking for ideas. We’ve implemented it for launching custom emails (mailto:) to single and multiple recipients, and for launching a form through a URL. What other cool applications are you doing?!
Having a Last Modified field sounds quite unimportant - but when combined with tools like Integromat it becomes very powerful - and this on top of the new Airtable / Integromat ‘app’ which makes Integromat so much more useful to us! I’ve written a blog post about this which will show how to use this new field type to drive processes - and it’s the first post which I’ve initially published on my new Blog / Forum site - Online Database Experts. This is a site aimed at users of Airtable and other similar platforms and all are welcome to join and collaborate about Airtable and other tools like Integromat. Here’s a link to the post: Using Last Modified Fields with Integromat
Hi Airtable Users! After reading @ScottWorld’s response, regarding a keyboard shortcut, I thought it would be a good idea to post a list of shortcuts. Mary Kay Airtable - Support Airtable keyboard shortcuts The following is a list of keyboard shortcuts that'll work within Airtable. If at any time you need to see this list of keyboard shortcuts again, you can hit / and it'll bring up the keyboard short...
here is a solution for efficiently backing-up your Airtable base using Integromat this solution uses only 5 operations per 100 records and can therefor manage many records and backup runs even with the frre plan of Integromat. It can also easily be expanded to include encryption and various types of triggers and the backups can also be done to various other medium i.e. gsheets, MySQL etc. See details for the solution here - https://5im.pl/airbac This image is for display purposes and does not represent the actual automation.
An extension of Example: Netflix-style UI with a script, here we use OMDB API in the Scripting Block, to grab the Runtime/Duration of a given film from a given Airtable: Could of course be used with any API service, with a bit of adapting. Todo: add a max_count so that it doesn’t hit the API’s rate limits e.g. simply change line 20 to for (let record of result.records.slice(0,1000)) { add error handling (currently, if film is not found, the script simply skips to the next row).
Hi Everyone! We’re announcing a major update to miniExtensions! Previously, we were offering each extension as an individual subscription. Starting from today, we are offering access to ALL of our extensions for a flat rate per month! (think Netflix model, for Airtable tools!). Our 30+ extensions and the new pricing plan can be found here: miniExtensions Tools and Integrations for Airtable - miniExtensions Tools that empower Airtable users to process unlimited records in bulk with scheduling and automation features. An alternative to Zapier and Integromat. We’re always looking to add more extensions. If you have an issue that you’d like us to build a solution for, please do not hesitate to reach out here!
I do not seem to find this anywhere on the community, so thought of sharing it. With the use of API key, we can easily integrate Airtable bases into power bi and design dashboards. In the PBI desktop got --> Get Data --> Web --> Advanced In the URL parts, enter the table URL here To authorize - select Authorization and enter this Bearer YOUR_API_KEY Click OK and your table will reflect here. This process has to be repeated for each table in the Base. Also, if a field is linked record type, this shows as a bunch of alphanumeric in the PBI. To avoid this, in the table create a new column next to linked record field and use ARRAYFLATTEN formula to overcome this alphanumeric and effectively present data in PBI. One thing I still did not figure out is how to set auto-refresh in PBI online as it shows to edit credentials to enable auto-refresh and I am not sure in what way/format I should enter them. If anyone has an idea please tip me.
For those of you needing to perform a Standard Deviation calc (STDEV() in Excel), here’s a template you can use for performing this calculation with values across a single row (record): SQRT( SUM( POWER({Value 1 Field} - {Avg of Values Field}, 2), POWER({Value 2 Field} - {Avg of Values Field}, 2), POWER({Value 3 Field} - {Avg of Values Field}, 2), ... ) / (n - 1) ) Where n = the number of fields SUM’d, ie, the number of POWER() statements. You do have to manually enter each field that holds a value which you want factored in to the StDev calculation, and you have to have a field that calculates the averages of those values, so this will not work well for a dynamic data set (new values are constantly being added to the list of values needing to be included in the calculation). I use it quite frequently in calibration specs, however, so I figured I’d post it here as a quick and easy reference for other people who were used to using the STDEV() function in Excel, bu
The inspiration for this script was the many posts that I saw where people wanted to setup default values when they create new records. In that way, it is similar to one of the scripts that has already been shared. However, I believe that there is no one right way of doing things, and I had ideas for a different workflow. This script fills in blank cells in a table based on a template record. It also requires no configuration of the script, and no changes to the existing table/field definitions. This script has the ability to make bulk updates to a lot of records very quickly, and it has several quirks and limitations. I only received access to the Scripting block when it was made public on Friday, so I didn’t have much time to get up to speed. I have many improvements in the works, but they will all take time to implement, and I need to sleep. Here is the base on the Airtable universe. Here is the gist. Here is a link to the walkthrough.
I’ve gotten Car fever and want to start doing research on used cars that fit my price range. I tried some of the consumer sites, but was really left wishing I had a place to look at all my research at once and compare things like average price and milage for a specific Make, Model, and Year. So I hooked Airtable up to the MarketCheck API via the scripting block and made a base that pulls in all available car listings within 50 miles of me within my specified Price and Mileage range. Then, made use of Page Designer and URL preview block. It’s pretty dank if I do say so myself. :star: :star: :star: :star: Overview of How it Works Here Copy of the Base Here Have fun y’all😃.
Have a look at the base here. We are a growing movement of volunteers who have been mobilized due to the current crisis to help the most vulnerable among us - the elderly, the refugees, the domestic abuse survivors, sex workers, single mothers, and others who are not getting their basic needs met. Who’s it relevant for? Mutual aid organizations and non-profits - tweak this base to suit your needs. Our process: We built an operations management system using Airtable. It works as a support ticketing system. Get the general idea by looking at this very high-level flowchart which also appears in the dashboards. We provide support in 4 ways: :phone: Matching people in need with phone volunteers that talk to them every week and check if they need anything :woman_cook: Matching with cooks to provide hot meals :shopping_cart: Sending food baskets :bulb: Helping with general requests - from clothing to fixing stuff at home Base features: Volunteers and people in need manageme
Shows the posts in English. I want to keep the posts in Bengali. How can I keep the posts in Bengali on the airtable?
When using a form, you can pre-fill linked fields in forms by using the Record ID for the record you want into a single line text field instead of the actual name, then use Zapier, IFTTT, or (my personal favorite) Integromat to update the linked field with that record ID. I realize it’s cumbersome, but you just have to have it, it works. I do this for several of my forms.
For anyone interested in Airtable scripting, I’ve added a few new posts to my blog: 3 ways to loop Getting the unique values for a field Creating a record Creating many records Enjoy!
To All The Volunteers: I would like to give a shoutout and a thank you to all the volunteers that go above and beyond, to help the Airtable members. Even with your busy lives, you still manage to find time to help. I, for one, am grateful for the many times that I received such great help. Thank you, Mary Kay
Hi all, Been using Airtable since 2018 and keep discovering awesome things everyday. One of my other ventures is building apps with no code web database tools. One of the new Airtable tools I found recently is a service called table2site (posted here before) which allows you to build websites using Airtable as your CMS. I built a site called NoCodeStudio and I’m really happy with how it turned out. Right now it’s focused mainly on Knack and Tadabase, and web design tools, but I’m planning to add Airtable resources as well. I’ll just stick this here to get it out of the way… NoCodeStudio is a community oriented collection of resources, tools, tutorials, builders, and more - specifically for no-code web database apps like Knack and Tadabase. Visitors can also submit new resources via an Airtable form. Thanks for checking it out - https://nocodestud.io And don’t forget to look at https://table2site.com No affiliations with table2site, just sharing.
I’m looking at learning more about Airtable and using it for my small business. This platform seems promising however a sales rep from another company (Quick Base) had pointed out the following limitations of Airtable. Airtable Limitations (according to a Quick Base rep) Limited Data Set Support: Airtable has a data limit of 50,000 records (rows) that organizations can quickly outgrow. Basic User Permissions Means Weak Data Security: Airtable has a basic user permissions security model that allows anyone invited to a workspace to view all of the info in that workspace. In addition, anyone needing to add or modify records requires Editor access which includes the ability to change and delete tables and views that may be needed by other users Lack of Reporting: Airtable lacks the ability to create reports that can be shared with management and others. Viewing tables with records grouped together provides very limited data summaries in the workspace. Are these statement accurate ab
I’ve seen a few posts in recent weeks from people asking about how to get started with Airtable scripts (e.g. here and here). I think people are, rightly, seeing the scripting block as a powerful piece of functionality and for non-coders it can be a struggle to know where to start (I know from bitter experience!). It is all there on MDN, but even the first sentence is putting up barriers: ==== JavaScript ( JS ) is a lightweight, interpreted, or just-in-time compiled programming language with first-class functions. ==== What?! My small contribution to this is to start an Airtable scripting blog with some practical walk-throughs of how to get to what you want to do with an Airtable script: Airscript Home An introduction to scripting on Airtable bases for new coders The aim is to provide an introduction to scripting on Airtable. It isn’t the definitive resource on JavaScript code and standards (not by a long shot) and, even within the Airt
With the recent launch of the Scripting Block, we’ve been excited to see all the handy things created with it (and cool to say that @openside won a contest with this nifty script also!). So we made a central resource to host ALL the user-created scripts (code + description + source) for the scripting block and put it here. It had to be done. :woman_mechanic: Here are a few screenshots: You were wishing for a central place to find all the script-block goodness, admit it. :slightly_smiling_face: See the Scripts Library Have a script to add? Click through on the link above to submit it. Hope it’s helpful!
I use tags to highlight some characteristics of records in my table. In this dataset I want to highlight whenever I have a “Stale Deal” and/or a “New Customer.” I want to use multi-select options because they’re easy to filter and chart. However, I don’t want to manually tag each select option, because there’s a formulaic way I can assess these characteristics: ‘New Customer’ = Deal Count is one ‘Stale Deal’ = Time since last inquiry is > 30 days. I’ve tried to do this via a formula and isn’t pretty to write, read, filter, or chart by. So, why not replace that formula with a script? Works like a charm: Link to the base here. Happy Scripting! /* Calculations: 'New Customer' = Deal Count == 1 'Stale Deal' = Times Since Last Inquiry > 30 */ // Load Records let table = base.getTable('Data'); let query = await table.selectRecordsAsync(); let records = query.records // Create an Array of tags when a record matches the criteria let check = records.map( c => ({id:c.id,t
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.