Show and Tell

hey everyone! wanted to share a resource we put together. if anyone here’s thinking about using Airtable as a CMS - here’s how we did it. lmk if you have any questions! :slightly_smiling_face: https://www.whalesync.com/blog/using-airtable-as-a-cms

Does anyone have a super automated process for turning the data in a record into a formatted, multi-page document and then attaching it to the record? Using a button field in the flow would be fine, but I don’t want a new tab created. I don’t mind using Integromat, but want to avoid Google drive modules if possible.

Setting default values on fields has been a long-time request from Airtable users. Set defaults on fields Product Suggestions Simply the ability to set a default on fields other than numeric On a date, the obvious is Today On a string, just set a default value What are default values in fields? When you create new records (or update existing ones), you probably have multiple fields that need to have the same data every time. Default values allow you to add information to your field only 1 time. Then, each time a new record is created, that field automatically fills in with the data. You don’t have to go in and complete every single field that needs information. It’s done for you! :star: We created an easy way to set default values in your Airtable records with On2Air Amplify Here’s how: P.S. Amplify can also set defaults on previously created records! :star: Try it out by adding it to your Airtable base from the marketplace: A

So I’m a little bit “paranoid” and I wanted to backup my Airtable data into Google sheets, because… you never know :slightly_smiling_face: . I used Google Script Apps for this. The script allows you to define one or more tables and views to import along with possible attachments. The script is uploaded on GitHub: GitHub - robiningelbrecht/airtable-google-sheets-backup: This script allows you to backup your Airtable data to Google sheets.

Interfaces is an amazing Airtable feature! But, you’ve probably run into some limitations with permissions or other limitations. With On2Air Forms, you can build and share interactive forms, dashboards, and pages for your company to update or create Airtable data instantly. Get started free - https://on2air.com/forms/   On2Air Forms Features:Update existing Airtable recordsCreate new Airtable recordsCreate linked recordsEdit linked recordsView linked recordsDisplay data from your basePre-populate form fields with dataAdd SubForms inside of your form to update multiple tables and linked records from 1 formAllow editing and viewing of data even if not a User on your Airtable account (no need to purchase more Users)Create custom Dashboard/Portal pages for clients and your team with unique URLs (Login Options on long-term roadmap)Use basic and dynamic filters to limit record viewedUse URL prefills to display specific recordsAdd default values to fields per userDisplay, Hide,

Hi everyone, I have asked support for some guidance, perhaps some examples or white papers on how to deal with Purchase Orders, but so far, no response. So in the meantime, I am hoping to get information from the community. Besides of having couple (or more tables) to store the Purchase Orders and its PO Lines, I need to create the Input form to enter a PO and of course, a print out. I have played with Forms, but I don’t see how to display the master-slave tables so the user can enter as many items as they want. Is this possible in Airtable or does it need to done outside of the environment? Thanks in advance. Robert

Hello, An interesting use case for Airtable can be curating data for others and selling access to it. Curating data can save time for someone, and it might be valuable if the data serves a business goal such as lead generation. There are untapped niches in every kind of data that are still good ideas to pursue, if you make it focused on a specific audience. Airtable makes it very easy to curate and update such data with bases and views. An example to the above is this one, built with Airtable, and made specifically for agencies to find new clients. We’re not affiliated but found this to be a great example to the thesis. If you don’t have coding skills or access to developers, we’ve added a nocode embed capability to our tool SaaSBox, to launch such a curated data service as the above. Airtable does have some limitations for protecting data through a paywall, such that when you share an Airtable base, all the data in it are accessible. We solved this problem by creating views with diffe

Hey all :wave: , we’re really thrilled to be able to share this with you - we’ve just raised our 1st funding round at Codemap! We want to say a huge THANK YOU to the Airtable community for all the support over the past year since our launch - what a journey this has been! Our story so far is just another proof of how game-changing no-code is - keep on building! :raised_hands: With 2021 soon coming to an end, we also wanted to share a helpful resource and a showcase of what our community on Codemap has been working on over the past year and beyond - last week we released the largest curated database of 800+ no-code projects built by experts & teams on Codemap. The builds are categorized by types, stacks, and many more others key parameters, so you can discover what others are building with Airtable and how! Check out the showcase here to get ideas for your current or next build! Don’t hesitate to share any thoughts or feedback with us. Wishing everyone a great remainder of the y

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. :new: Improved Airtable Formatting We are always keeping a close eye on any new updates to Airtable’s API to bring Softr customers the best experience. Thankfully Airtable recently provided a number of formatting improvements so we jumped at the opportunity to bring you these changes asap. These improvements include: • Improved date and time formatting • Support for currency symbols and decimal places • Display of linked records without the need for lookup fields :page_facing_up: Reorder Pages Previously when adding new pages we stacked them in alphabetical order. However, over time, with larger applications, organising and navigating to your pages in the studio could become cumbersome. Starting from today you can now reorder your pages. It’s the small things in life that make a difference and this is no exception Simply gr

Hi there! We would like to show a Page Designer clone called Cumulo Docs. It’s awesome but we are biased. Here are the main features: :smiling_face_with_sunglasses: Drag and Drop editor for creating stunning layouts for your Airtable data :sparkles: Multiple Records supported in a single page :books: Multiple Pages supported too :confetti_ball: API support for PDF Creation :zap: Works with Free Airtable accounts also (because Cumulo Docs uses your API key) It’s available at https://www.cumulodocs.com Here’s a screenshot of an Invoice created by CumuloDocs: Prefer a video? Here’s a short video (~5 mins) where I create the same invoice from scratch. https://www.youtube.com/watch?v=ZeJR9n3JW0M Do check it out and leave us know your comments and feature requests. Cheers!

Hi all, As I’ve noticed on the community forum it’s a common issue so I decided to share with you our solution on “ How to add a card to a filtered Kanban view for staff member ”. We use Airtable as a project management tool that consolidates financial and operational data. It means we work project based and one or more people work on a project. For planning our work we use Kanban views to followup tasks. For management and time-tracking reasons we want to bundle all tasks from all staff in one database. This results in a filtered Kanban view per staff member. Unfortunately, when you simply filter on a staff member (linked to another table) and try to add a card to the Kanban view, the card will disappear because the staff member is not automagically linked to the card when you add it. Solution Instead of filtering on a linked value, filter on a “Created by” field. Because this is an automated field, the card will remain visible in the filtered Kanban view. Hope this helps! Any feedb

Hi all, As I’ve noticed on the community forum it’s a common issue so I decided to share with you our solution on “How to add a new record in a view filtered on a lookup value”. We use Airtable as a project management tool that consolidates financial and operational data. It means we work project based and one or more people work on a project. It results in big tables where for example financial data is filtered per project (which is a lookup value from another field). Because this filter is applied on a lookup value, the record disappears when you add a record because it fails to fill in the field automagically. Solution Thanks to the recently introduced nested filtering, we have found a solution which makes use of some kind of “timer”. By filtering on the timer and an automated “Created by” field, this record will stay visible for the user who inputs it. The following steps should be followed: Add a “Created by” field Add a “Created” field Add a “Last modified” field Add a formula w

I’m surprised I am the first to reference this comprehensive and noteworthy effort by the folks over at Sync Inc. blog.syncinc.so The Complete Developer's Guide to Airtable A deep dive into all the ways to build on Airtable. But even more impressive - the authors entirely resisted plugging their own SQL technology until a very brief mention of it at the end of this very lengthy and detailed blog post - true professionals who value and appreciate content over cash. Take a read - you’ll probably bookmark this and use it as a reference until they make it into a book. :winking_face:

It’s time for holiday shopping :santa: and you have to figure out what gifts to get the Airtable, database-loving fanatic in your life! Or maybe you’re the Airtable buff and you need to get yourself something special! _ We’ve got your list of best gifts for the Airtable enthusiast in your life. From the latest tech gear to unique fun gifts to the best Airtable apps, here’s your gift guide for all those who love Airtable. On2Air | Accomplish Anything with Airtable – 1 Dec 21 Gift Guide for the Airtable Fanatic | On2Air Here's your gift guide for the Airtable database-loving fanatic in your life! From the latest tech gear to unique fun gifts to the best Airtable apps, here's a list of the best gift ideas. BIG thank you to these folks for being part of the list - @Grow_With_Jen - @ScottWorld - @kuovonne - @BenGreen - @Mariusz_S - @Alli_Alosa - @Baseweave_Developers - Matt Bourn - @Benito_Abraham - @Seamus_Campbell

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" ))))))))))))