Show and Tell

Hey folks! I use Airtable for literally everything. I’m constantly making new apps and automating processes for everything I do, whether it’s business or even just tracking personal stuff like gym progress. One thing that I had always wanted for a long while has been to have the ability to create some really customized views of my Airtable data on a website. Specifically, to bring some more interactivity to my tables and connect some of them to the outside world more easily. I wanted a way of hooking Airtable up to the web where I could use HTML/CSS to creatively display the data and let users interact with it. Basically, I wanted to be able to quickly prototype simple web apps utilizing Airtable as a backend, without the fuss of having to do a whole bunch of programming and maintaining a server for each new project I started. I checked out a handful of existing solutions, but none of them did exactly what I wanted. So now almost 6 months later… introducing: SheetDream! Check it out at

Hey Airtable community :wave: It’s time for this week’s updates at Softr. We have rolled out a number of new updates this week we would love to share with you. :new: Additional Sign-up Block Fields Starting from today you can now add additional fields to the Sign-up block. We have now created a powerful sign-up block that connects seamlessly with Airtable to fit all your needs. You can now capture additional fields, including: • Single line text • Long text • Dropdown • Phone number • URL • Files • Multi-select dropdown • Hidden Fields • Date • Date & Time • Checkbox But it doesn’t stop there. The next most anticipated feature which dovetails perfectly with this new functionality is waiting for you below :point_down: :bust_in_silhouette: Updated user Account Block This new functionality will allow you to create a richer user profile for users of your application. Better still, you can enable edit permissions and give your users the ability to add additional information to t

The question of how to extract the last name from a combined “first [middle][…] last [suffix]” name string – or the last word from a multi-word string – comes up from time to time. I offer a solution (with caveats) in a reply to a recent support post. My example is name-oriented but could easily be adapted to an arbitrary string. Hope this will save someone some time! Split First and Last Names That's a little more difficult… At heart, the formula would be something like this: REPLACE({Name},1,FIND("~",SUBSTITUTE({Name}," ","~",LEN({Name}) - LEN(SUBSTITUTE({Name}," ","")))),"") That's a little hard to suss out at first glance, so let me break it down, back to front: LEN({Name}) - LEN(SUBSTITUTE({Name}," ","")) gets the difference in length between {Name} and {Name} with all spaces stripped. This gives us the index of the last space in the name, which presumably prefaces the las…

Hello there, I discovered interfaces last week and I’ve been blown away by the opportunities they open. For months I’ve been frustrated by the lack of analytics in Stripe. When I saw Interfaces, I told myself that it could be a good solution to build relevant analytics. So, I’ve built a new database connected to Stripe and created an interface to display the metrics I need, the result is just great. I show it with test data in this video.

This base uses the Unsplash API to search for images and save them to your base for review. The base is published on the Airtable Universe here. To use this base, copy it from the Universe into your workspace. You will need an Airtable Pro account and access to the scripting block to make it work. To get going, go to the Unsplash Developer pages, create an account, then create an Unsplash application. This will create an access key and a secret key for the app (we only need the access key). Open the script block in Airtable, click on “Edit” and replace the access key default string with your access key: Close the script editor and run the script. You will be prompted to enter a search term: Enter your term and click on “Next”. The script will pull 10 images from Unsplash using their API based on your search term. These will be stored in the “Photos” table: For a nicer look, switch to the gallery view: The script saves the image, the image link, the photographer’s name and the searc

Whaaaaat?! :open_mouth:

I’m testing out making a few of my scripts available on my Gumroad Store. These scripts currently have a “Pay What You Want” pricing model, so you can get them for free if you like. Duplicate Record including Linked Records: Duplicate records, including making duplicates of linked records. The “Pay What You Want” version is minified code (not human editable), but the full editable version is available for a premium. Here are links to the script and video demo. Email automation helper scripts: These are small scripts to be used with email automations that follow a “Find records” action. One script helps you send an email to a different email address if there are no records. The other script calculates a sum for a field value in the found records. Both small scripts are fully editable and commented to help both no-coders and the code-curious understand the code. Here are links to the script and video demo Happy Coding!

We created an open-source project that you can clone and build off of to add a custom Airtable dashboard to your website: You can clone the repo and start customizing right away. This project uses Next.js, ChartJS, and Sequin to quickly display metrics on a website. You’ll see some revenue metrics in there from Stripe, but you can remove those if you’d prefer. At the very least, we hope it can be an example to get you going :slightly_smiling_face: GitHub GitHub - sequin-io/open: Add an open page to your website in a few minutes. Add an open page to your website in a few minutes. - GitHub - sequin-io/open: Add an open page to your website in a few minutes. If you are looking to use Airtable more as a CMS - check out this great dev.to tutorial . Or, if a dashboard is more what you need, we have a great guide on how to use Google Data Studio with Airtable .

Hey Airtable community :wave: It’s time for this weeks updates at Softr. We have rolled out a number of new updates this week we would love to share with you. :busts_in_silhouette: User Dashboard Redesign We have completely redesigned the ‘users’ tab as part of our ongoing studio 2.0 redesign. It includes a number of user experience improvements centred around adding users and managing users within your application. We have also added the ability to send an email invite to new users added to your application. :closed_lock_with_key: Google only Sign-up/Sign-in Block We’ve supported Google Sign-up and Sign-in for a while now, however, starting today we have a dedicated new block for those of you who only want Google as an authentication option for your application. :yellow_circle: Roadmap Template This week we have a new template on the block, say hello to Roadly, the new roadmap template. Some of you may have already noticed a similar page on our website where we share our pu

:wave: Hi all! Table2Site allows you to create no-code websites and uses Airtable as a CMS. You just have to add settings and content to your Airtable base and Table2site takes care of the rest :rocket: . :ok_hand: It’s perfect for: “Curated list for X” websites like NomadList Small landing pages Coming soon pages :gift: Some notable features: Add newsletter signups (via Mailchimp) Add dynamic lists/cards Add contact forms Connect your own domain Examples: Demo 1 Demo 2 Demo 3 Demo 4 :mega: Let me know what you think :mega:

Create a Day column : DATETIME_FORMAT(Date, "d") Formula for days names : IF(Day="1","Lundi", IF(Day="2","Mardi", IF(Day="3","Mercredi", IF(Day="4","Jeudi", IF(Day="5","Vendredi", IF(Day="6","Samedi", IF(Day="0","Dimanche","Erreur" ))))))) Create a Month column : DATETIME_FORMAT(Date, "M") Formula for months names : IF(Month="1","janvier", IF(Month="2","février", IF(Month="3","mars", IF(Month="4","avril", IF(Month="5","mai", IF(Month="6","juin", IF(Month="7","juillet", IF(Month="8","août", IF(Month="9","septembre", IF(Month="10","octobre", IF(Month="11","novembre", IF(Month="12","décembre","Erreur" ))))))))))))

Recently, a member contacted me directly asking for help … I am have been searching desperately to find a clean way to break apart an address like this… 123 anywhere st, San Diego, CA, 90001 Unfortunately, there is no “clean” way to do this without a Split() method as described in detail here. And rather than jumping to the end by showing a unified working formula (that even I would be unable to read), I approached this question by providing a framework for tackling almost any parsing challenges. Without Split() we are forced to fabricate rather complex formulas and like many of you, my brain is incapable of juggling a lot of string pointers to create that perfect [single] formula. And therein lay the issue - we often assume we must build a single formula from the beginning. This is neither necessary nor likely to be helpful. Sure, you want to use the fewest number of fields and create concise formulas for simplicity. However, there’s plenty of time to polish the code once you have s

Hey Airtable community, It’s time for this weeks updates at Softr. We have rolled out a number of new updates this week we would love to share with you. :yellow_square: Kanban Board Block Starting from today our new Kanban block is available. With the Kanban block you can visualise your workflow in a board view with stacked cards and sync any changes across from Softr to Airtable. :straight_ruler: Horizontal List Details Block This new List Details block is centred around a horizontal layout. This new block is perfect for reducing the amount of scrolling and aligns your fields horizontally across a column of 3 instead of vertically. :mag_right: New Hidden Fields We have added two new hidden field types, including Page and Full Name. These field types allow the sending of hidden data that you can use to identify users and pass the data across to third-party tools or integrations. :art: Softr Design workshop We are running a 1-hour live webinar today - hosted by our in-house

Hey Everyone, Softr is doing a free design workshop on Oct 21. :tada: :bulb: We will outline the best practices when designing your Softr website or application, demo the design options within the Softr studio, design resources, tips and tricks and time for a Q&A at the end to answer any questions you might have. :bangbang: More details and registration form here: https://softrdesignworkshop.softr.app/

Here’s a simple yet powerful base I built to manage a community books library. You can use it to manage the borrowing of any physical items - books, wheelchairs, tools, etc. It includes: Automatic reminder emails a week before the designated return date Automatic borrowing and return dates Automatic borrowing statuses Library dashboard Feel free to use and tweak it for your own purposes.

The sheer amount of whitespace in Airtable has always bugged me a little, so I’ve been making little edits to the stylesheet here and there to get more data on-screen. Below you’ll find some screenshots of what I’ve done and the code required to make it look that ugly. You can use something like the Stylus extension/plug-in to apply the CSS to Airtable. Note: I’ve come up with this code mostly through trial and error, so use at your own risk. (Let me know if something breaks spectacularly and I’ll try to help, but there’s a possibility I won’t be able to figure out what’s going on on your end.) Also, the actual structure of the HTML is changing all the time, so don’t be surprised if the code stops working suddenly. EDIT: fixed code line-wrapping In this first example, I’ve removed the row number and expand record button from the grid view – I’ve always found them superfluous. (There’s also a header hack that reduces the vertical space quite a lot and smushes everything together which

The Problem: A common workflow in Airtable is the gathering of Surveys or Forms, and often we want to link multiple surveys or forms submitted by the same person back to a single Contact record for that person. However, exposing Linked Record fields to do this in the public form itself is undesirable because we don’t want form users to see all the names of existing contacts in our base, and it also precludes form users that don’t yet exist in our Contacts table. This leaves us using manual processes to establish the link between a form submittal and a Contact, where the form user is just entering their name or email address. My Solution: I’ve written a script for the Scripting Block that aims to solve this problem and automatically establish links between submitted forms and existing contacts. In addition, this particular version also logs a survey/form submittal as an “Interaction” in the Interactions table. The Script in Use: Here’s a short video demo:

Last week I launched my FREE (unofficial) Airtable manual in French, “Airtable à z”. It is mostly for novice users, but I tried to make it interesting even for people with good knowledge of our favorite no-code platform. Sorry if you don’t speak French :winking_face: . The guide is 100% made with Airtable. The PDF was built with Page designer with the same layout for all the pages but 2… It was a bit of a challenge and I even made two versions, Landscape and Portrait (both on A4). I used Softr to build the website from the base. If you wonder why the hassle to make this manual it’s because there is no other supported language than English. La semaine dernière, j’ai lancé mon petit guide illustré, en français bien évidemment. Avec des centaines de liens d’aides Airtable traduits via Google Translate automatiquement. Le manuel est entièrement construit sur Airtable.Tout le contenu du site est gratuit !

Hey Airtable community, It’s time for this weeks updates at Softr. We have rolled out a number of new updates this week we would love to share with you. :gear: Editing Table Blocks In addition to our recently released ability to edit List Details and List Blocks, starting from today you can now allow editing of Table Blocks :control_knobs: Conditional Chart Filters This new functionality allows you to apply specific conditions to your chart blocks. For example, say you want to show specific data in a chart block to a particular role you have defined within your application, allowing some users to see one set of data and the other another set. :yellow_square: New Blocks We are continuing to bring you more functionality and design layouts to take your Softr application to the next level. • Today we have launched a stunning new mosaic image blocks allow you to show multiple images in a beautiful new staggered layout. • Full-width image block which will take the entire width of th

With the upcoming upgrade tomorrow, now is a good time to think about your Airtable Backups Strategy. Of course, we all hope and expect the upgrade to go smoothly, but having a backup of your data outside of Airtable is always an Industry Best Practice. It’s an insurance piece of mind to know your have an external backup of your data in case of outages, accidental (or intentional) deletion of data/attachments, etc. Don’t worry if you’re not performing backups - you’re not alone! But today is the day to start. On2Air has you covered if you’re ready to start! For the fist 20 signups to our Backups solution, you can get a 20% off your initial subscription period (bigger savings on annual plan!) Check out the service: https://on2air.com/on2air-backups and on checkout use promo code: BACKUPNOW Oh and don’t forget to turn off any external automations (zapier, integromat, on2air, etc) you have running to avoid the error messages that will come while the Airtable database is down tomorrow!

Disclaimer: self promotion Hi folks! We’re looking for users for the upcoming beta launch for Shoptable, a Shopify <> Airtable integration. Shoptable brings the power of the Airtable platform to Shopify merchants by creating a live, bidirectional sync between Airtable and Shopify. Using Airtable to run your shop means you can leverage custom tailored views, automations, and reporting tools to run your shop, all within Airtable. There are almost 2 million Shopify merchants and they all use the same Shopify Admin interface. We’re going to fix that. You can check us out and get on our waitlist here: https://shoptable.app/ Feel free to comment below if you have any questions.

Formula: IF( LEN(TODO_REPLACE_WITH_IBAN) > 0, IF( REGEX_MATCH( SUBSTITUTE(TODO_REPLACE_WITH_IBAN, ' ', ''), '^(?:((?:IT|SM)\d{2}[A-Z]{1}\d{22})|(NL\d{2}[A-Z]{4}\d{10})|(LV\d{2}[A-Z]{4}\d{13})|((?:BG|GB|IE)\d{2}[A-Z]{4}\d{14})|(GI\d{2}[A-Z]{4}\d{15})|(RO\d{2}[A-Z]{4}\d{16})|(MT\d{2}[A-Z]{4}\d{23})|(NO\d{13})|((?:DK|FI)\d{16})|((?:SI)\d{17})|((?:AT|EE|LU|LT)\d{18})|((?:HR|LI|CH)\d{19})|((?:DE|VA)\d{20})|((?:AD|CZ|ES|MD|SK|SE)\d{22})|(PT\d{23})|((?:IS)\d{24})|((?:BE)\d{14})|((?:FR|MC|GR)\d{25})|((?:PL|HU|CY)\d{26}))$' ), 1, -1 ), 0 ) Documentation: This formula checks if the structure of TODO_REPLACE_WITH_IBAN is correct (each country has its own specification). It only considers countries that are within the SEPA area. Specifications: IBAN Examples, Structure and Length SEPA countries and IBAN length - Google Sheets Google Sheet based on the above data structure, easier to work with Outputs: 1: Has a valid SEPA IBAN structure 0: Is empty -1

Hey there!Do you use both Airtable and Google Drive?Yep, every single dayEh, sometimesNopeI wanted to show you how you can automatically create invoices (or any document) in Google Docs using data from your Airtable base.https://www.youtube.com/watch?v=lg_h6kDAak0 This uses the On2Air Docs. It allows you to automatically generate documents in Docs from any data you have in Airtable.Copy the free Invoice Google Docs template and the Sales Base Airtable templateSet up the automation in On2Air Docs using the settings from the article/video (you only have to do this part 1 time)Click Generate Invoice in your baseView your newly created invoice in Google Drive and a PDF version in your attachments field in your Airtable base! Automated Invoice Templates in Google Docs and Airtable (+Free Template) |...In this guide, we’ll show you how to generate invoices using Google Docs plus how your can use your customer data in Airtable to automatically generate an invoice in Google Docs.&nbs

Coming from the Salesforce world, I am used to the concept of converting a lead to an account/contact/opportunity record. I’ve been blogging about creating a CRM in Airtable and I just blogged about implementing a Lead Conversion process behind a Button field. Let me know what you think. Scott Hemmeter – 30 Sep 21 Airtable: Creating a CRM (Part 4) – Convert the Web Lead This is part of a multi-part series on creating a CRM in Airtable. In our previous posts in this series, we started our base with a data model of Organizations, Contacts, and Interactions, then fol…

Hey Airtable community, It’s time for this weeks updates at Softr. We have rolled out a number of new updates this week we would love to share with you. Timeline Block With the new timeline block you can create a slick-looking vertical list with a timeline, complete with large image tiles, title, description, tag and filtering with your Airtable base. Perfect for creating changelogs and what’s new pages, portfolios and much more. Small List Block Introducing the new list block mini. No, it’s not a new iPhone but instead, a slimmed-down version of the list block. Perfect for when you want to fit more in a row or have a large number of items to list. Editing List Block In addition to our recently released List Details block edit functionality, starting from today you can now edit List Blocks. To put it simply, it allows users of your application to update list detail records directly via your Softr application. It’s a game changer. Passwordless sign-in/sign-up Using this sign-in block, y