Show and Tell

Hey Airtable community, This week we are delighted to introduce our newest block - Maps :world_map: . Simply create a table in Airtable containing latitude and longitude coordinates and connect to Softr and the new map block will allow you to plot your locations in a matter of seconds on an interactive map. We added a number of additional custom options, including: :round_pushpin: Map default views, inc; Roadmap, Hybrid, Terrain and Satellite. :round_pushpin: Define default zoom window :round_pushpin: Customise pin colour :round_pushpin: Add pin details inc title, image and url :pen: Edit Linked Records Starting from today you can now edit linked records from directly within Softr. 🧑‍🏫 Live Workshop | Creating No-Code Apps with Softr & Airtable We would also love to invite you to a live workshop next week (29th September at 5pm CET)’. The webinar will outline the steps to building your own c

On Monday I’m launching an Airtable newsletter called Base Notes, where I’ll be sharing Airtable tips, news, and other info every week! Subscribe here if you’re interested: Airtable

Admittedly, an edge case, but in working with the Airpress WordPress-to-Airtable API and plugin, I ran into problems when attempting to display only the first image from an attachment field. After hours spent stepping my way through the plugin, I finally discovered I’d been debugging the wrong module entirely. Discouraged, I took a break, fed the cat, got another cup of coffee – and then wondered if I might not be able to goose Airtable into giving me the data directly. Five minutes later, I had it. The example assumes an Attachment field named ‘images’, but should work with attachments of any type. To extract the URL MID(images,FIND("(",images)+1,(FIND(")",images)-1)-(FIND("(",images))) To extract the file name LEFT(images,FIND(" ",images)-1) This works because Airtable will cast an Attachment field to a comma-delimited string of values when it is acted upon by a text functi

Hey Everyone, We have a lot of exciting updates on Softr we’d like to share with you. See below :point_down: :robot: Zapier & Integromat Apps Softr is now officially available to use on both Zapier and Integromat, unlocking an infinite amount of possibilities with your Softr application. Check out our Zapier and Integromat use cases for more details. :bird: Dynamic Twitter List Block We’ve upgraded our Twitter block to allow you to display a collection of tweets via your Airtable base. You can also add categories or tags in a separate column, so that users are able to filter the list. :construction_worker_man: Table Block Improvements

I took a bit of a break from a custom PIM mvp that I’m building for work to make a personal photo album for my girlfriend and myself to collaborate on together. I don’t use any social media, so this is a good bridge between the gap of trying to show someone more than just a photo, and refusing to suffer the noise that comes from an endless scroll app. Plus, my girlfriend and I are both kind of big nerds, and she absolutely loves that I built something like this for us that she can show off to her girlfriends from her phone :slightly_smiling_face:

Hello everyone! I created a 2-way Google Calendar realtime sync Airtable app for myself and thought that this might be helpful for others as well. Let me know if you would be interested in using it - happy to share.

I would like to see added a new condition that would allow an automation to stop at a certain point if conditions are met. Currently, I feel like I need to create a script to do that. Unless there is another method that I don’t see?

When an automation kicks in and creates records in a linked table, it seems as if the linked records in the interface doesn’t get refreshed. Am I the only one seeing this happen?

Hi, tried to script “show size of all attachments in all base”, and after debugging with “check null”, “check empty array”…“check array of nulls” still get unexpected result. Investigation discovered rare bug ( I checked several huge tables with tens thousands of attachments, and that’s just in one record) I suppose it’s an interupted upload result, but I surprised it exists there. Can’t be downloaded, guided to other storage. Link is not working. No problem, just to inform. I discovered that script is useless. Airtable detects similar docs and store once, with linking the same. Btw, it’s an answer to @itoldusoandso post

You no longer need to understand APIs to use the Data Fetcher app! Simply choose the application you want to import data from and select any options. You can install the latest Data Fetcher here. The following applications are available: Facebook Ads Google Analytics Google Search Console Webflow Adalo Binance Coingecko CoinMarketCap Alpha Vantage Clearbit Microlink (create screenshots, PDFs from URLs) ApiFlash (create screenshots from URLs) exchangerate.host Lots more applications will be added over the next few weeks. You can also request an application.

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