The show and tell space is a place to showcase your work and have conversations about what you’ve been creating in Airtable.
Recently active
Hey everyone, Founder of Pory here! Its been a while since I last posted and wanted to share a quick update on what’s possible for people looking for solutions to provide external users (not on Airtable) access to view and edit information from Airtable. With Pory, you can set up an app or portal (whatever you like to call it) in 5 steps with permissions for different user groups and pages. Excited to see if we can help or continue developing the platform to support a broad range of use cases. :slightly_smiling_face:
Imagine being able to train machine learning models from the data on Airtable and get the predictions and forecasts of the models directly on an Airtable base. No-Code-ML predictions. Check this issue on GitHub, where I am proposing MindsDB to create an integration to Airtable. If that resonates with you, please add a reaction to the issue on GitHub! github.com/mindsdb/mindsdb [New Integration]: MindsDB Airtable opened 03:59PM - 17 Jun 22 UTC Ricram2 enhancement integration ### Is there an existing integration? - [X] I have searched the existing integr…ations. ### Use Case Airtable has got plenty of structured data. Which means the use cases are milliards. It would be amazing if we could leverage MindsDB to get predictions materialized into bases. Also Airtable has multiple no
We wanted to share a free, open source template for building a completely custom client portal on Airtable. It comes with: :lock: Logins :paintbrush: A simple UI that you can customize :writing_hand: An example of how to write data back to Airtable We’ve written up a complete tutorial to walk you step-by-step though how to configure your Airtable base, set up logins, and get your portal working. hackernoon.com How To Create A User Portal On Airtable With Sync Inc And React | Hacker Noon In this tutorial, you’ll see how to build a scalable, secure, and flexible client portal on Airtable using Sync Inc, Cotter, and Next.js. The project uses some great new technologies to make this easy to build and deploy: Cotter for logins Sync Inc for easy Airtable data access Next.js for a fast, static website Vercel to deploy the portal to the web Here is the full repo. It comes pre-configured to work with Sync Inc - but you can
After months of development and testing the AirPower app is live in the Shopify app store. AirPower syncs Shopify store data bi-directionally with Airtable. A purpose-built app, it understands the Shopify data model and all its restrictions, can do things that generic sync services (e.g., Zapier) just can’t do, and can be deeply customized. So far we’ve been blown away by the use cases our beta stores have come up with. There is just so much that Shopify store owners can leverage Airtable to do, improving their productivity and lowering costs (you need fewer apps). Some of the Shopify-centric use cases that Airtable is perfect for include: You no longer need a separate app to modify metafields You can bulk update products, variants, collections, etc. You can link Shopify data with data from other services in one place (e.g., sync email marketing system data via zapier, or update orders in Shopify with tracking information) You can perform sales and customer analysis without needing a
We just launched an Ecommerce Store Airtable Template that you can add to your Airtable workspace for free. Use this Ecommerce Airtable Base Template, created by On2Air, to store all your product data, orders, sales reports, inventory, suppliers, accounts payable, and more. Check out all the features of the template :point_down: On2Air | Airtable Apps for Your Business Operations – 3 Jun 22 Download a Free Airtable Template – Ecommerce Store 🛒 | On2Air Download the Airtable Ecommerce Store Template for FREE today! Use this Ecommerce Airtable Base Template, created by On2Air, to store all your product data, orders, sales reports, inventory, suppliers, accounts payable, and more.
Airtable Group Voting / Ranking Tool - Airtable Universe We needed a quick ranking tool to evaluate artists for a music festival. In previous years we sifted through emails or attempted to use spreadsheets.... I just made my first contribution to Airtable Universe. This is a simple tool but could be very useful in many situations where a small group needs to review and rank a batch of submissions. I built this to rank our tweener artists for a festival but it could be used for any type of curation or voting process.
Hey everyone, Excited to share a new tool we just built for Airtable - Sync Inc (syncinc.so). With a couple clicks, we’ll setup a hosted Postgres database containing all your Airtable data. We keep your database in sync in real-time. All you have to do is connect to it with your favorite SQL client, programming language, or app. We used Airtable to power a volunteer organization we helped start at the beginning of this year. We loved how quick Airtable was to get up and running. But while we liked all the cool features for our volunteers, we missed the power of SQL on the back-end. And when we wanted to extend our base by building external apps on top of it, we ran into limitations with Airtable’s API (hello, filterBy). While Airtable looks like a database, you can’t query it like one. With Sync Inc, you get the best of both worlds. You can keep using Airtable exactly as you do now. But unlock the flexibility of a SQL database behind the scenes. You can try it out totally free here: h
A while ago, my boss asked if it was possible to set up an automated tip of the day. His idea was to have an Airtable base with a list of tips and use Make to grab one each day and post it into Slack. I’d already come up with my own auto-numbering system in Airtable, and I knew this would be key to getting what we wanted. I set about it with the following goals in mind. Post only one tip each day. Keep track of the tips posted. Keep track of the tips ready to post. Make it simple enough for anyone to add a new tip. Make it possible to re-order the tips. Make it possible to put a tip back in the queue for reuse. We’ll need two tables for our base, and a linked field between them. Table 1 - List, part 1 We’ll call our first table ‘List’, and our second table ‘Queue’. For the ‘List’ table, we need the following fields: Short Name (Single Line Text) Techtip Text (Long Text) Next (Rollup with a calculation) Posted (Checkbox) Timestamp (Formula) Queue (A link to a single record only) Tim
Hi all! I wrote this script a couple of weeks ago and it’s been extremely useful for me, so I thought I’d share it here :smiling_face_with_halo: The script will find any “broken” fields - the ones that have the little red triangle next to the name - in your base, then display the field name, table, and any applicable field description. There’s no need to change anything at all (unless you want to, of course). All you need to do is copy and paste the below into the scripting app, and click run :slightly_smiling_face: const config = input.config({ title: "🚨 Broken Field Report", description: "This script will find and display the table, field name, and description (if available) of all broken fields in the base.", }); let title = "🚨 Broken Field Report"; let baseName = base.name; /**********************************************************************************************************/ await main(); /**********************************************************************
On2Air Backups is now available in the Airtable marketplace. Add it directly to your Airtable base from the app menu! Airtable On2Air: Backups - Apps - Airtable Marketplace Automated External Backups of Your Data to Google Drive, Box, or Dropbox on Airtable with the On2Air: Backups app. On2Air Backups creates an automatic backup of your Airtable base data, including records and attachments, and exports it to Google Drive, Dropbox, and Box. You can set it on a regular schedule to ensure you have a duplicate copy of all your vital company information. Your 1st backup is free. If you want additional features, you can upgrade to a plan with our special limited-time launch pricing. Get 40% off for 6 months with the code LAUNCH40 for new app purchases. (Starter plan not included) Add it to your Airtable base On2Air Backups Features Automated Airtable Backups to Keep Your Data Safe and Secure Never worry about losing your company da
On2Air Schemas is now available in the Airtable marketplace. Add it directly to your Airtable base from the app menu! Airtable On2Air: Schemas - Apps - Airtable Marketplace Visualize your Airtable Base Structure & Track History over time on Airtable with the On2Air: Schemas app. On2Air: Schemas generates a diagram to visualize your Airtable base structure and keeps a history log of changes to meta information for all tables, views, fields, and relationships. Get an understanding of your base design and relationships with Schema. It’s free to use after the initial trial. If you want additional features, you can upgrade to a plan with our special limited-time launch pricing. Get 40% off for 6 months with the code LAUNCH40 for new app purchases. (Starter plan not included) Add it to your Airtable base On2Air Schema Features See the entire base design layout and relationships Create filters to view specific field types Und
A recurring question on the forum is how to change item pricing without corrupting existing data. With the Product Catalog & Orders base in Airtable templates, for instance, changing an item price changes the price shown in current and fulfilled orders – not necessarily what one wants should a refund be required. I made a quick-and-dirty mod of the Product Catalog and Orders base to make use of price schedules. This allows items to be repriced going forward while leaving existing data unchanged. To provide this functionality, I added the [Price Schedule] table; added two fields and modified a third in the [Furniture] table; and added two fields and modified a third in [Order Line Items]. It should be easy to find the little I changed: Any field with a description is one I added or modified, and the description explains why.
Hi everyone, Just wrote a tutorial on how to get linked records. It covers two scenarios Simple display linked record details on the same page as the “parent” e.g Products listing with their associated suppliers Filtering the parent records by a specific e.g Filtering the product listing by supplier Hope you find this useful. Chinara James – 3 Feb 19 How to get linked records using the Airtable API | Chinara James This post is part of a series all about working the Airtable API. If you’re not familiar with Airtable, you should definitely check it out and if you’re not sure about getting started with their API…
I spent a long time trying to figure a solution to this need, so now that I found something that works, I want to share it with other users. I don’t know scripting, but I can copy/paste other’s code. So here’s a non-technical solution to automatically deleting duplicates/deleting records using automations and scripts. In this case, I wanted to delete the oldest record, since the newest record is going to be the most up-to-date. Step 1. Mark duplicates: Create an automation that triggers when a new record is created. Then use the mark duplicate script provided by AirTable. Step 2. Separate the older duplicate records: Create a view that filters by duplicate status and date of record creation. In this case, I filter by Duplicate? = “yes” (or however you set up the previous step) and record creation date “is not” “today”. That way only the older duplicate enters into this view. Step 3. Delete the older duplicates: Create another automation that triggers whenever a record enters this view.
csvgetter.com allows you to turn your airtable base into a CSV api but now it supports a whole bunch of json types as well! (No need to worry about pagination). Check out this 2 min preview. As usual, send me feedback + suggestions!
This process is now VERY easy using www.csvgetter.com Checkout my demo video
Hey everyone, There’s a large open source intelligence (OSINT) community helping to document the invasion of Ukraine with many focused on geolocation: identifying exactly where an event took place or where certain media footage was recorded (here’s a recent article on the subject). Given the volume of information, it’s sometimes difficult to keep up so I’ve built a system that searches Twitter for tweets containing coordinates, extracts them and plots the locations onto a map. It’s all fully automated and built on top of Airtable. You can view the base here: Airtable - Simplescraper OSINT. I’ve shared it to some OSINT communities and it seems to be useful, and at the same time it’s a neat example of how Airtable makes it super easy to quickly prototype new ideas. For those interested in how it works: Simplescraper (disclaimer: this is a service I built) scrapes Twitter every 3 minutes and sends new tweets to a base using its Airtable integration In Airtable the base has two automati
GIF Maker is now available on the Marketplace! Install here
This tool is designed to allow a Salesforce Admin to quickly generate Admin Assist tickets following the standard format required by Salesforce. Admin Assist Ticker Creator You can read more about that here: https://help.salesforce.com/articleView?id=000316887&language=en_US&type=1&mode=1 View a tutorial for this base here: http://ior.ad/6WFb
I ran into a very interesting situation regarding a fairly complex multi-step Automation: One of the Action steps would not reliably execute properly. Turned out to be a timing problem for which I came up with a solution. Here is the situation: I have a first table ‘DC’ [Data Collector]; I have another table ‘RI’ [Reference Information]; and finally a ‘DD’ [Data Destination] table. I built an Automation, A1, triggered on new information arriving in table DC. The purpose of A1 is to analyze the incoming information, Look Up information in table RI, and then based on the results from RI, create a link to a specific record in table DD. But when Automation A1 executed, it would not reliably generate the Link. Big Problem. After way too much troubleshooting I finally realized that the problem seemed to be that the Lookup steps took too long to complete, and the Automation blasted right ahead to the Link step before the needed information had materialized from the the Lookup step, so t
Airtable is a powerful tool to use as a central source of information for your business and your team, but it can be overwhelming to get started. :white_check_mark: We’ve created this 15-point checklist guide of Airtable best practices for companies who want to ensure their Airtable bases are set up for better performance. Download the guide :arrow_down_small: On2Air | Airtable Apps for Your Business Operations – 1 Apr 22 15 Airtable Design Best Practices: What Companies Need to Know | On2Air Wondering where to start when designing your Airtable base? We’ve created this 15-point checklist of Airtable best practices to review when you’re ready to design your Airtable base.
Hi folks, A few weeks back we shared a show and tell about a custom zapier connector for automating the Airtable environment, and the feedback has been awesome so far. Today, as part of the Openside team, I wanted to share how you can use that connector to solve a long standing missing feature with airtable: external backups. The whole process of setting up automatic backups should take less than 20 minutes. But first, I want to verify that I’m on the right track. Who here needs/wants their Airtable backed up regularly? POLL: How critical are backups to your business? Need them daily (it would be bad if I lost even a day’s worth of changes) Need them weekly/monthly (I need it, but this would be sufficient) Not supercritical, I have my own way of backing up data manually Not important, I don’t have any use for an Airtable data backup 0 voters If you answered “yes” to either option above, or want backups to be set-up-and-automatic ever after, then give this a go: Here’s what
I’ve noticed a few people have used CSV Getter for Airtable to backup their Airtable data with Zapier so I have made a video to show how easy it is. (Apologies for my pronounciation of Zapier - I say it wrong at least once) Links: CSV Getter for Airtable Zapier
With the announcement of expiring external urls, many people need to migrate attachments out of airtable but want to keep a reference. Here’s one way to do it:
“We have so much vital company data in Airtable that we would lose mountains of data for our clients and even lose clients if something bad happened. All this work would be soul-crushing to lose." - Sara Ramaker, LKF Marketing Product On2Air Backups On2Air Backups is an automated backup solution for your Airtable bases. Create scheduled backups of your critical business data stored in Airtable and export your information to Dropbox, Box, or Google Drive. Features: Automated backups of Airtable data Include Attachments Create filters to choose what to backup Hourly, Daily, Weekly, Monthly Schedules Backed up to Google Drive, Dropbox, or Box Challenge The team at LKF Marketing uses Airtable bases to track client projects, content, tasks, articles, and other documents. Sara creates a base for each new client and shares the base with the client and other LKF staff to use as a central source of information. Using Airtable to coordinate all the projects and maintain data for their c
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.