Show and Tell

I’ve solved for how to use a list of ID numbers to highlight the rows with those ID’s. Search only lets you identify one row, and filters have to be chained together one after the other. When you have a table with 1,000 items, and an external source gives you a list of 50 ID’s that all need the same update how do you select them? My solution requires adding a formula field. By pasting all of your ID values as a string literal to search for that rows ID in you can create a flag that then lets you filter a view. Here is an example of the formula: SEARCH( Identifier, “12345 qwerty 292303 zx11k9i2”) In this case Identifier is the name of your ID field in the table. Each row of your string (you should be able to paste a column from excel) is one of the ID’s you wish to modify. The result of this will be a column with blank rows and arbitrary numbers. The number is the location in your pasted string where the ID was found but that isn

Hey everyone! I wanted to share a guide I wrote today on how to create a Slack reminder todo app. It takes advantage of Airtable’s neat Trello-style Kanban view for management, and as a bonus, you’ll catch a glimpse of the start (and probably end) of my poetry career. You can see all the code as well as fork and deploy your own working version onto Autocode from the link. Would love to hear what you all think! Build a Slack Reminder Todo App (slack/slack-airtable-reminders) · Autocode

I recently redesigned one of my personal Web sites - an art portfolio - using an Airtable base on the backend. If you’re interested, you can check it out here: http://art.timdietrich.me The site is PHP-based. It pulls all of the artwork (including the information about each piece and the images themselves) from the Airtable base via the Airtable API. It also uses Stripe to handle credit card payments, and saves the orders back to the Airtable base. And for email notifications and receipts, it uses Mandrill. More information is available on my blog: http://timdietrich.me/blog/airtable-based-art-portfolio-site-launched/ Thanks for checking it out - and let me know if you have any questions about it. – Tim

In response to a long-running post about needing a find and replace function here: Would love a find/replace option! Product Suggestions I am adding my own request to this list. Not sure why it is still missing, this is

As you may know, Airtable has direct integration with Slack ‘out of the box’. I have just published an article my blog which discusses how to use this to build an absence approval workflow, starting from an employee’s request through to notifying them of approval (or otherwise) - and with a little help from Zapier along the way. The blog post can be found here: Approval Workflows Article The article uses my KasPer Lite base which is available in theUniverse. I hope you find this useful and look forward to any comments…

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

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

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

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

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

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

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 qu

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

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

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