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 obv

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:

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 w

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

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 tha

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.

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

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:

I’m surprised I am the first to reference this comprehensive and noteworthy effort by the folks over at Sync Inc. blog.syncinc.so

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.

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… in

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 enab

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 l

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.

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 editab

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

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

: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

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