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
Hi All, Just wanted to share a formula I created to convert latitude and longitude into Google Maps Plus Codes. If you are not familiar with Plus Codes, check out this documentation. The benefits to the plus code are: Every location on earth can have a mailing address The encoding of 10 characters plus “+” character is much more efficient in terms of number of bytes than latitude and longitude, which to represent the same level of specificity would need to consist of two floating point decimal numbers of 10 or even more decimal places specificity, requiring more than double the number of bytes, and a tuple type representation instead of a simple string primitive. Plus codes can be used in filenames easily because they don’t use reserved characters. Plus codes are compressible—each additional character adds another level of specificity, similar to the decimal place system, so if you have millions of plus codes you are storing, and you remove two characters from the end, you sav
Hello Now you can create your own help center pages with same UI of Intercom using Airtable. Demo https://sites.hyperlyst.com/public/p01FhT1RGeepopO02nEyOjWmjTJ3/project/intercom/ Airtable Base https://airtable.com/shrCmTj7ma1whzk8h You can try it here https://app.hyperlyst.com/ Hope you like it.
Hello, I would like to know if there is any kind of template for scripts (not code) for my customer service rep to do outbound calling? She is calling customers right not to remind them of a bonus included with their purchase and I’d like to add the scripts so she knows what to say, as well as a follow up email and text. And then she can check off when she’s completed each task. I am hoping for some ideas.
Hello everyone, I just launched a new web application that lets you create a website or web app using an Airtable base without writing any code. Here is an article I published in linkedIn: Airvues: build web apps using Airtable databases without writing a line of code! If you’ll like to try it, you can sign up for a free account at Airvues If you have any questions about this new tool, please feel free to ask in the comments. Looking forward to some of your feedback!
Hello friends,I’m pleased to announce my beginner-level Airtable training course, “Learning Airtable”! 🥳It is available on LinkedIn Learning here:Learning AirtableLearn the basics of Airtable, a spreadsheet-database platform, including how to create tables, use different types of fields, leverage views, work with records, link tables, and more.For tracking data and creating custom business apps, Airtable, a spreadsheet-database hybrid platform, can be a powerful tool. Airtable expert Scott Rose starts this beginner course with the basics, presenting how to create a table and how fields work—including text and number fields, date/time fields, value list fields, attachment fields, and formula fields. Scott demonstrates how to work with records, including how to import external records; how to create, edit, and delete records; how to filter records; and how to sort and group records. Airtable gives you several different ways to view your data, and Scott walks through all the view options
Do you want to manually run a script on a record, but without opening a script app by clicking a button? True, a checkbox can act as an automation trigger, but if you have several automations that you want to manually trigger this way, you’ll end up cluttering your table with checkbox fields. This method lets you manually trigger one of several automations with a single field. I’ve done this in a couple of different use cases, and it works fairly cleanly. Make a single-select field named something like {Action} Add a choice in this single-select for the action you want to perform; e.g. “Generate Invoice” Make a new automation using the “When record matches conditions” trigger, setting the condition to be: When "Action" is "Generate Invoice" Add a script action that does what you want, passing the record ID and anything else you need from the triggering record Finish the automation with an “Update record” action to clear the {Action} field after the script runs Add more single-selec
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
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
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.