Show and Tell

It’s not likely many of you known about Benford’s Law, but it will surprise you especially if you happen to unwittingly bet against it. Imagine a scenario - you’re having lunch at a counter cafe and the old guy next to you (i.e., me) says out of the blue… I will give you 20 bucks if you open any page in that newspaper and the first number you see starts with a 7, 8, or 9. And as part of this little game, if the number starts with a 1, 2, or 3 - you have to give me just ten bucks. Would you play that game knowing that the odds are stacked against me? It’s a two-for-one bet after all and numbers, of course, occur in the wild in even distributions, right? Um, wrong. Here’s a 10,000 record [data se](https://download .csv file)t of insurance information that I randomly chose for thi

I’ve updated this show & tell to include a little better video that’s more complete and demonstrates many of the ways that MapBox and Vega-Lite can be blended to create a powerful visualization of data. And you can purchase this codebase as well.

Found this nifty tool on Product Hunt! Mantle supposedly allows you to turn your Airtable into custom internal tools with no code. You can natively integrate multiple SaaS apps too. Kinda cool and might be useful for someone :slightly_smiling_face: Link to PH: https://www.producthunt.com/posts/mantle

I know many people have been waiting for a HYPERLINK() function. This is not that, but its as close as we can get today. Check out how this simple script can create links that are dynamic and formatted with the text you want instead of the ugly full URL. Explainer Video: Loom | Free Screen & Video Recording Software Base: Better (Dynamic) Links - Airtable Universe Script: Create fully formatted links in Airtable · GitHub

Hi team, Many of us have large Org Charts aka Maps of our data - I have several that take me minutes to scroll from left to right. I’d like to see: A mini-map that allows us to quickly navigate to an area of the bigger map/org chart Mini map allows us to scroll, zoom, pan, or drag across the bigger map canvas / org chart. See attached picture. See attached link.

I have created a Synced table from Airtable updates Base that can be translated in french from Google Translate with a button. If you want to do the same table for an other language send me a DM I will happily send you the full table so you don’t have to make all the formulas again. Link to the table. J’ai créé une table de synchronisation à partir de la base de mises à jour Airtable qui peut être traduite en français à partir de Google Translate avec des boutons. Si vous voulez faire la même table pour une autre langue envoyez-moi un DM je serai heureux de vous envoyer la table complète afin que vous n’ayez pas à faire toutes les formules de nouveau.

I just launched a brand new app on Airtable’s app marketplace. Data Fetcher lets you run, save and schedule API requests without leaving Airtable: https://airtable.com/marke…/blkZrRSlxzhBlv6T9/data-fetcher Some of the features: • Use values from your base in the request URL/body/headers • GET/POST/PATCH/PUT/DELETE methods all supported • Save API requests securely • Import requests from cURL commands • JSON/ XML response to Airtable transformation • Response field types are inferred. e.g. dates in API response become Airtable date fields • Schedule requests to run hourly/daily/weekly • CORS proxy for all requests If you have any feedback or questions, feel free to comment or email (hello@datafetcher.io)

I came across a great resource from The Covid Tracking Project Once I saw they had an API, I decided it was the perfect use case to showcase the power of Airtable - charts, scripts, data grouping, etc. So, I spent an hour to build this tracking utility from the Tracking project. Feel free to share: Airtable

Hey there! We created a quick guide to backing up your Airtable bases. :point_down: The Essential Guide to Backups for Your Airtable Bases The most basic way is to set a regular time in your calendar every week and export each table in your base. If you need an automatic backup option with attachments included, try the On2Air: Backups solution. You can set backups to run on a schedule and automatically be uploaded to online storage. (plus, you get access to the other useful On2Air apps - you can try it out with the

This is how you can calculate the number of unique values in a field in a linked record. I couldn’t find a previous post on this when I was looking for help (apologies if I just missed it) so I thought I’d put one here for others to find. Short answer: you can create a Rollup field specifying the linked table and the field you want to count unique vales in, then define an aggregation formula as follows: COUNTA(ARRAYUNIQUE(values)) The tool tips for the aggregation formula don’t make it clear that you can do this. It may appear that you are limited to the simple formulas they suggest, but this is not the case. I haven’t tested it to see how far you can go, but nesting ARRAYUNIQUE() within COUNTA() definitely works. What is this used for? In my case, I have a table of Locations where we have equipment (e.g. Chicago Office, London Office, etc.), and I have a list of Assets that tracks all the individual pieces of eq

Hi all – I’ve been working on a project for quite a while now and am excited to show you all. It’s called Stacker, and it allows you to create portals on top of your Airtable with login for your users and private data. You can theoretically build any UI you like, but for now I’m trying to get it working well for simple user portals before going for anything too complex. Is there anyone out there who has a use case around giving your customers an authenticated web app where they can self serve? I’d love to chat to you if so, and maybe see if you’d like to take part in helping us test the product before I release it to the world. If so, email me at michael@stacker.app You can check out our landing page at stacker.app/portals Would love to hear your thoughts! :grinning:

Here is a way to automatically pull information from airtable into Excel via power-Query using a bit of coding. If you are looking to just copy and paste the code you need without much explanation, ignore the details :slightly_smiling_face: Details SECTION 1- CONNECTING EXCEL TO POWERQUERY- The first issue a user may run into while trying to get data to automatically feed into Excel is creating an authenticated connection to Airtable from Excel’s powerQuery. The following code will be used in a later step, but it is given here as a preview of the code that is chiefly responsible for the data connection to airtable’s api. Source = Json.Document(Web.Contents(“https://api.airtable.com/v0/[PartialAddressToYourBase]/[NameOfYourTable]”, [Headers=[Authorization=“Bearer keyXXXXXXXXXXX

We’re excited to announce that our Bulk Download Attachments app has been released on the Airtable Marketplace! Airtable

Now that the submission period for the Custom Blocks contest is over, I’d like to share my custom block for check-out/check-in systems! This block is a customizable wizard which, in its most basic form, allows users to select a Unit record and create a new linked record in a Log table detailing when that record was “checked out” with relevant fields pre-filled to save time. The wizard just as easily allows users to check that unit back in to close out the log and make that unit available for selection once more. Advanced features include tracking a unit’s condition over time (i.e. the unit was in “great” condition when it was checked out, but was in “poor” condition when it was checked back in), and the ability to enable an Items table for bases structured where each unit is an instance of a type of item (i.e. 5 “

I found myself in a spot where I wanted to get JIRA to post data to airtable without another service like Zapier in the middle. In fact, this does require ScriptRunner. However, if you’ve got airtable, scriptrunner and jira, then here is a link to a Gist that will get you off the ground. So, you can basically add a new ScriptRunner listener, paste in this code and setup the constants. gist.github.com https://gist.github.com/nafeger/dc754f59645120df3f5e030dd0166067 JiraScriptRunnerToAirtable.groovy import groovy.json.JsonBuilder import groovyx.net.http.ContentType import g

I’ve been working on a time tracker automation that allows my team to update a status field and kicks off a time tracker in the background so they don’t have to worry about tracking their hours. The solution I came up with works well for me, but I have read through a few options from @Justin_Barrett and @kuovonne here Record timer script and here Time Tracker Block + Button to start? The Setup I have 6 fields Current status Current status change time previous status Previous status change time total time Current status = Previous status Check A view is set up with a filter based

The latest update (4.1 as of 10/13/20) makes the date field almost unusable.

Now that the Custom Blocks have been publicly announced, I wanted to show a block that I have built. :new_moon_with_face: Name: API Connection It can fetch data from a JSON API and populate your table with the data. :mag: Where is the block? On github - https://github.com/saas-developer/airtable-api-connection :video_camera: Demo :studio_microphone: I also have a course on building custom blocks on Udemy (I hope its not against the rules to post this) :dollar: Hope this inspires your hackath

# Re; Dynamic reasons to reachout {your social signal} This is first of a series of Airtable Base templates that will make your sales outreach more effective by being relevant at Scale lean more in the Learning Center #1 - Create a simple but very effective reason to reach out , using the {action} ( a comment, a like , sharing post ) in a {Channel} ( Linkedin, FB, Quora, Medium …) and the {Keyword} ( what was it about) ​

I played around with Apps for the first time today. I built this (alpha) tool https://github.com/UnlyEd/airtable-app-bases-compare which basically prints out a Markdown text about the base configuration (all tables, fields, options, etc.) and can then be used through another Text Diff checker tool to figure out what the differences between two bases are. This is essential to us because we have bases that must be eventually sync (staging > production) and we were getting lost in changes until this. I hope you’ll like it as much as we do. Keep in mind it’s still an alpha version and subject to massive changes, but it does work and might help you today. :s

Hi I am a consultant working in pro sports and am keen to understand more about Airtable. My data/information services can possibly delivered via Airtable, where I am currently using Google Sheets and PDFs currently. Each client would require their own environment (workspace) and I would be refreshing their data daily/weekly (which is another question I will need answering). I have read plenty on here and watched YouTube videos, but I would really like to understand the more about the client UX for when Bases are shared externally, via links. Ideally, my clients will be ‘read only’, for the Bases, and I would be keen to see an example of their User Experience - can someone send me a link or provide a video that would present this? Furthermore, would they be able to manipulate the Kanbans, or would that require a different level of access? Thanks for your help.

It always surprises me when professed experts are unable to truly understand a market’s topology. How is it possible to claim to track the no-code sector with the list of tools and services referenced in this article? Seriously (trends.vc)!?! These are the “no-code players”? I can think of one that’s missing - rhymes with fair-label. :winking_face: Carrd Webflow Bildr Adalo Glide Softr Bubble Sha

Base -> HTML -> PDF This “show and tell” is based on a project I worked on for the Computer Museum of America (see this post: TimeLine of Computer History). Airtable Pro plans can make use of the Page Designer block, but if you don’t have a Pro plan or want something that is a bit more customisable, then this might work for you. Really, this is about outputting base data into a PDF, but uses HTML as an interim step. The benefit of HTML is that is hugely customisable and, by using CSS, you can pick from a huge range of colours, fonts, layouts and so on. Possible use cases for this might include product catalogues, invoices, brochures, data reports and so on. Or even large format wall displays 100ft long :slightly_smiling_face: The code I used in the CMOA project was very specific to that piece of work, so this is a more generic way to ge

Hi Airtable lovers! :rocket: I wanted to share a personal project I’ve been working on :slightly_smiling_face: I started my Youtube channel because I want to help more people build (and more importantly, UNDERSTAND) nocode databases because I know how challenging it can be to get started. The first tutorial series is on building a great CRM. Here’s the channel: https://www.youtube.com/airopsconsulting Here’s the most recent video: https://youtu.be/exIYtS4EdFA This video is great if you want to learn about how to link tables within your base and why using views is so important! Thanks!

Would love to share with the community here a UserStyle that modifies the display of Airtable’s Kanban view to make better use of available space and simplify the cards UI. It also applies thin scrollbars all over airtable.com (this block may be removed) and modifies a collaborator field with the title “Action of”, if it exists. Don’t get me wrong, the Airtable team is doing a great job, but the chrome is a bit on the heavy side with all those borders. Several design choices are “embedded” within the implementation, therefore impossible to modify. See here for the UserStyle and instructions on how to use it: https://github.com/Arty2/userstyles#airtablecom-neat-kanban