Show and Tell

Introduction I’ve analysed and made the below “State of the Art” regarding the “Backup & Restoration” topic. This analysis has been done on December 8, 2020. I’ve also defined what are the “key points” that matters to me, for a reliable Backup & Restoration system. (You might have a different opinion/priorities) I’ve summarized my findings through an Executive Summary below, and then analysed all tools I could find that might help regarding either “Backup” or “Restoration”, and summarized their limitations. Also, I created a poll below regarding what you need/expect from such a tool. :bar_chart: Context I realized such analysis for my company’s interests first (Unly), but thought it could be useful to the Airtable community. We might release our internal CLI “Restore backup” tool as open-source tool, because I couldn’t come across any similar available tooling, despite its current limitations. I’m also considering creating an Airtable App dedicated to “backup/restoration”,

Hi everyone! I’m back with an update on our progress on Pory.io :grinning_face_with_smiling_eyes: We’ve been continuously improving our product over the last month and really excited to announce some new features: We now support existing Airtables! You can map your fields to our template to generate websites even faster. You can add different content blocks with embeddable Airtable forms You can add integrations like live chat and analytics to your site Keen to hear your thoughts :pray:

Script developers are quick to reach for the Switch() directive in javascript. This is considered better than IF() statements for many reasons, but this is not specific to Airtable scripting; Switch() is used in all flavours of javascript and it’s a bit faster than evaluating IF() statements. But just as Switch() is a better alternative to IF(), JSON may be a better alternative to Switch(). Consider the requirements of my Benford’s example. Traverse every record to capture the first digit in the values of a target numeric field. Count the instances where the first digit is 1 through 9. This is a simple aggregation and one might perform the classification of the counts using a Switch() statement - one case for each count. This requires - among other things, ten variables to accumulate the counts and a Switch() statement to perform the counts. No engineer could be blamed for concluding this approach. Alternative… The alternative is just one variable; a JSON object that will ultimately

Airtable, known for its low/no-code marketing posture is experiencing rapid growth and adoption by users who need to create code and by many who want to learn how to code to take full advantage of the platform. The irony does not escape me. About two years ago I predicted Airtable would soon enable users to create javascript code; seven months later, they did. I called it, but this was an easy prediction - it had to happen. A few weeks after Script Blocks was released, I made a similar prediction concerning code generators. I guessed aloud how long it would be before we might see some smart systems able to create complex scripts that perform some pretty useful automation and tasks. Mark that one off - today I got a preview from Dan @openside and I’m excited that he made this a reality. Watch for announcements on this soon from Openside. Imagine a tool where you point and click, make a few selections, and it displays the script action code needed to meet your objective. One might ask -

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 this article - download it and import it into a base. Then run the script block (included below) on these fields: hu_site_limit tiv_2011 tiv_2012 Here are the distributions of the numbers from the insurance tabl

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. Happy Holidays!

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 COVID19 Tracking - Airtable All Data Collected and Provided by [The COVID Tracking Project](https://covidtracking.com/) Airtable organization and charts created by the team at [Openside](https://openside.com)

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 free trial)

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 equipment. I also have an Asset Type table that tracks the basic information

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 keyXXXXXXXXXXXXXX”]])) You will be replacing “[PartialAddressToYourBase]”, “[NameOfYourTable]”, and the “keyXXXXXXXXXXXXXX” with your particular information at a later step. Now even if a query were created with its sole

We’re excited to announce that our Bulk Download Attachments app has been released on the Airtable Marketplace! Airtable Bulk Download Attachments - Apps - Airtable Marketplace Download your attachments with a single click on Airtable with the Bulk Download Attachments app. You can use this app as part of our existing miniExtensions subscription plan. This is our first app on the marketplace. In the next few months, we plan on releasing more apps that will bring some of our more powerful extensions into the marketplace. If you have any feedback or questions about the Bulk Download Attachments app, please leave a comment below.

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 “Macbook Pros”, 6 “Samsung 32-inch TVs”, etc.). This block will make day-to-day data entry for inventory managers, IT departments, librarians, equipment rental businesse

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 groovyx.net.http.HTTPBuilder import groovyx.net.http.Method import org.apache.log4j.Logger import org.apache.log4j.Level import groovyx.net.http.* /** Change these based on api.airtable.com */ This file has been truncated. show original

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 on the field “Current status = Previous status Check” if true then filtered out, if false then they appear in the view. When they enter the view it runs an automation that runs the following script (apologies not sure on correct formatting for the forum) //This is to track the time on the AE work, it covers both the Online and Prep, it compares the current and previous status if a mismatch it checks if anyth

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 hackathon block and you get the $10,000

# 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. :slightly_smiling_face:

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.