Show and Tell

I chose Airtable as one of my Top Productivity Tools for 2022. Please share if appropriate. Thank you for making such a great tool that is a big part of my success.

In this thread I demoed an API for exporting your base in CSV format. The main issue is that it requires credentials to be passed as visual parameters in the URL. I’ve overcome this by making a new endpoint which accepts a POST request to store the sensitive information securely. A successful POST request will return a link for downloading your base as CSV which does not show any keys in plain sight. This link will only need to be generated once and will always show the latest data of the chosen table when used. It will be great for analysis, scheduled backups, or sharing a specific table with a client who wants access to live data by CSV. Post requests can be done in terminal like so: curl -X POST -F 'base=your_base_id' -F 'apik=your_api_key' -F 'table=your_table_name_or_id' -F 'view=your_view_name_or_id' 'https://csv-getter-for-airtable.ew.r.appspot.com/v2/make-url' Or you can use a tool like https://www.postman.com (required parameters made clear in the doc). If there proves to be

Hi everyone. I have built out an endpoint for exporting base to CSV. Documentation can be found here Here is the api. https://csv-getter-for-airtable.ew.r.appspot.com/all-csv?bid=<your_base_id>&apik=<your_api_key>&tname=<your_table_name>&vname=<your_view_name> With the correct parameters it will give the latest version of your base as CSV and will be useful in python scripts etc. Any issues getting it working please check out the docs or reach out. Additionally, any questions or concerns about how keys or data is handled that are not addressed in the docs - i’ll be happy to answer :slightly_smiling_face:

I have done a big update on my app for exporting bases as CSVs via API. You can now visit this website in your browser to easily make secure CSV endpoints for your data. Demo:

Just wanted to share this I just found out about it. Didn’t know about it. There are buttons and menus to create new records but didn’t know there are keyboard shortcuts which quickly made the favorite way to add new records. In particular if you are on the top of the table, there is no new record button (as it is on the bottom) and you had to use the right click menu (too many steps). So this is nice time-saver. To add multiple records quickly, you can use the keyboard shortcut Shift + Enter. Start by clicking the primary field above the place where you want to insert new records. Then, press and hold Shift and then press Enter (holding Enter if you want to quickly add multiple new records). Airtable Support Adding a new record You can add a new record to a table if you have editor permissions or higher in the base you are working in. IN THIS ARTICLE OverviewRelated video content   Overview There are multiple ways to ad...

2021 was a transformational year for Softr. So, we wanted to look back at 2021 and highlight some of the new features and capabilities we made available through our users’ feedback, suggestions and requests. :fire: Softr Got Easier To Use - much easier to build apps with our redesigned studio :boom: Softr Got More Powerful - launched Softr 2.0 and made it one of the most powerful no-code platforms in the market :rocket: Softr Has Evolved - incorporated 27 new templates across different categories and evolved from a simple app building tool to a powerful no-code platform :heart: Community Initiatives - numerous community initiated launched by us and our users Find the complete review here: Softr 2021 Year in Review 🎉

Hi all, Had a bit of inspiration from this cool script shared by @Jeremy_Oglesby. My goal was to have an easy solution to categorize the transactions imported from all of my accounts/financial institutions. Here’s the scenario: There will be some frequently occurring transactions like Uber or your preferred supermarket that should have been categorised accordingly so the remaining ones can be categorised manually. Some personal finance apps might do it for you but I always find them lacking in some other areas hence I always built my own solution - previously in spreadsheets and now Airtable. This was surprisingly easy to achieve with a small modification of the script. Here’s how it works. The first table contains all the transactions data. The second table is a list of categories with a matching “keyword” separated by the pipe symbol ("|") that will be used to categorize the transactions in the first table. Here’s the script in action: Finally here’s the actual script: // BASE

At the suggestion of the Airtable support team, I am sharing this webinar recording. This is a recording from our “Amazing Things You Can Do With Airtable and PowerPoint” webinar where we explored using Airtable and PowerPoint for real-time dashboards, event promotion, reporting, and more. Happy to answer any questions about our approach and the plugin we used to connect Airtable and PowerPoint in real-time, DataPoint.

We went in-depth on how to turn Airtable into a content marketing pipeline with Hannah Wiginton of On2Air. Hope it’s helpful! whalesync.com Airtable for Bloggers How Hannah Wiginton, of On2Air, used Airtable to build a content marketing pipeline.

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 custom web app, including data structure and Softr integration. Learn more and

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 ✏️ Subscribe to Base Notes - Airtable Fill out the "✏️ Subscribe to Base Notes" form quickly and securely on Airtable. It’s only fitting that Airtable plays a pivotal role in the production of the newsletter, acting as the hub between Notion (writing) and MailChimp (list management and publishing). Eventually I’ll share more details about how I put everything together, and of course the best way to know when that’s available will be to subscribe. :slightly_smiling_face:

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 function. Each attachment value consists of two parts, separated by a space: the original file name (sans path) and th

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 The table block is getting better with new customization options. You can now adjust the row height and column width. More improvements coming soon! :bell: In-App What’s New? Updates We want to make sure that our users don’t miss any important update. So, starting in January you will notice a new popup on your dashboard when new 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 https://community.airtable.com/t/if-same-attached-document-image-in-two-tables-within-the-base-does-it-double-the-size-of-the-base/33770?u=alexey_gusev I’m gonna to rewrite my script using Map data type, with url as key, so it will display correct total size. Sadly, it can’t use recursion used in “sum” function In case someone interested, i can put the source here.

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