Show and Tell

You can view or edit Google Docs, Google Sheets, or Google Slides files from Airtable with On2Air Forms.How to use the Google File Field in On2Air Forms for Airtable.

Made by a French Lego Master with reused pieces. The hole story and a picture of the artist here (sorry, this is in french)

TLDR 4 week accountability meetups to build automated CRM for myself Do hands-on assignment before each meetup During meetup on Zoom we discuss on our hands-on experiences and answer other’s questions $50 to join - which includes an expert Q&A to answer all our questions Hi everyone! I’m building automated CRM with Airtable. But I’m not that confident to push myself to finish it, so I’d like to organize a weekly accountability group with other B2B company sales persons or marketers where Do hands-on practices in the articles Meet on Zoom weekly for an hour Discuss on the obstacles and ask and answer questions to each other Every week participants need to do hands-on practices on one’s own. Then, during the meetup, we can share and discuss on our experiences and ask & answer to each other. I’ll collect $50 for each person who joins, and use part of that money to recruit an expert who can answer our questions if we have unanswered ones after meeting. Any one who wants to jo

You have all your data in Airtable and now you need to summarize and calculate all the information.Reporting on business information is a vital part of company operations. “How do I create a report in Airtable?” is one of the common questions we see from Airtable users.First, the answer is, “Yes, you can create reports!” You can create summary reports from your Airtable data, whether you need to summarize income, projects, sales, or information such as employee vacation hours or inventory totals.In this tutorial, you’ll learn how to create summary reports in Airtable, how to automate record links to a report, and how to create a dashboard to showcase the information for others.See the full tutorial here:How to Create a Summary Report in Airtable If you need automated documents for your reports, check out On2Air Docs, an app to automatically generate documents with your Airtable data. To allow others to view or edit documents or any other data in Airtable, use On2Air Forms, an

3/17/2020 Edit: updated the the ‘Create’ case to return the recordId's of the created records, rather than just a count of created records. Thanks @kuovonne for the idea. The updateRecordsAsync(), createRecordsAsync(), and deleteRecordsAsync() functions that Airtable provides in the Scripting Block only allow the action to perform on 50 records at a time at most. While Airtable does provide a helpful example of how to run a loop that batches a set of records greater than 50 for processing in the “Find & Replace” example of the Scripting Block documentation… // Only up to 50 updates are allowed at one time, so do it in batches while (updates.length > 0) { await table.updateRecordsAsync(updates.slice(0, 50)); updates = updates.slice(50); } I thought it might be nice to have a single function to drop into any script that would handle this for me, regardless of the action I want to take on the records. (Admittedly, it would be nice if this was in the Scripting Block’s SDK b

If you are looking to pull insights from your Airtable data, try connecting your Airtable base to Metabase to easily build interactive graphs and dashboards. Metabase is an open source BI tool where you can easily summarize and visualize your data. You can connect Airtable to Metabase using a tool I helped build, Sync Inc. We’ve been blown away by the kinds of dashboards people are building - so we wrote up a tutorial that walks through how to do it: docs.syncinc.so Metabase | Sync Inc Sync Inc replicates Airtable to a Postgres database, giving you the best of both worlds. Also - shout out to @Paul_Coates who showed us how you can then embed dashboards like these back in Airtable using the Embed app. Then your team will have all the information they need without ever leaving Airtable. Hope you find this useful :slightly_smiling_face:

https://www.askdottar.org Hello folks, I am Joseph, creator of The DOTTAR Project or The Database of Technology Training and Resources Project, an online database that is ad-free, with an easy to use interface. It is an online resource for sharing other resources. On DOTTAR a user can contribute to the project by adding a new resource, they can also use the project to search for resources in various categories, from online courses, micro degrees, or content creators and videos, to offline resources like books, textbooks, lecture notes, or colleges and local universities. It is a resource of resources. DOTTAR is built on Airtable and Softr and I am truly pleased with how the project turned out, if you have any feedback please let me know. :slightly_smiling_face: Sincerely, Joseph, DOTTAR, and the rest of the data monsters on the DOTTAR Project.

In my last gig, my team used Airtable extensively as our database. Our content editors wanted to collect user testimonials in Airtable, where we managed all of our existing data. If you or your team has this kind of setup, Open Testimonials is perfect for you. Open Testimonials stands out from the plethora of testimonial collection SAAS’s in a couple of ways: :heart: 100% Open Source (self-hosting coming soon!) :heart: Small bundle size (https://bundlephobia.com/package… reports 3kb min + gzipped) - this means that Open Testimonials won’t slow your website down! :heart: Server-side rendering (works with React, comment other frameworks you’d like to see) Try it out at https://opentestimonials.com! For a limited time, you can get a lifetime plan for a $150, which includes unlimited testimonials on unlimited websites, and personal support. Regardless, the free plan is very generous. If you have any questions (or need help setting anything up), please DM me on Twitter (or Reddit!) @l

I wanted to share what I figured out looking for a way to run an automation at a scheduled time. First, create a helper table named Automation Trigger with 3 columns: Name (type: Single line text) Run At (type: Date, with time field included) Record (type: Formula, expression: RECORD_ID()) For each automation you want to schedule: Add a row with a unique descriptive name Add a view with a filter matching only the one record added above (Name is …) Add an automation: Choose trigger: When record updated Select table: Automation Trigger Select view: the one matching your automation intent Select the Run At field. Run test Add an action according to your needs Finally, the scheduling piece. You’ll need Integromat or Zapier. Zapier allows to schedule a task only at a selected hour. Whereas Integromat is much more flexible. For example, you can schedule an action at regular intervals. Connect Integromat to your Airtable account Select Update a record action Select your base and t

Do you have an Airtable workspace with multiple important company bases? You can backup up multiple Airtable bases at once with On2Air Backups - without having to add the On2Air Backups extension to every single base. Every On2Air Backups plan (except Starter) can back up multiple Airtable bases. Check out this 3 minute video on how to create a Backup Project :small_red_triangle_down: You can also read our knowledgebase article: How to Back Up Multiple Airtable Bases with a Backups Project

No words. Just visuals.

Data Fetcher is a free Airtable extension that lets import data from anywhere into Airtable with no-code. And you can now run Data Fetcher requests using webhooks! This means you can run a request when a form is submitted, e.g. to enrich the record with Clearbit info, when a record is updated or created and lots more. Install the Data Fetcher extension here: Data Fetcher - Apps - Airtable Marketplace Check our the webhook guide here: Run request using webhook - Data Fetcher Help Center

There’s a sound doing the rounds on TikTok of American comedian, Steve Harvey, laying out his formula for success in the realm of mens’ suits. He claims that from 5 colours of suits (matching jacket and trousers) and 3 colours of shirts, you could make 75 combinations because everything goes with everything else (subjective and outside the scope of this post). Thought I’d see if he pulled this number out of thin air or not and test my JavaScript at the same time. Here’s the base I made, using the web search function on attachments to pull in some pics and a scripting block to iterate through all the options and create the matching outfits. Here’s my little script for those interested / want to grimace at my code; let articlesTable = base.getTable('Articles') let outfitsTable = base.getTable('Outfits') let allArticles = await articlesTable.selectRecordsAsync() let jackets = allArticles.records.filter((article) => article.getCellValueAsString('Item') === 'Jacket') let trousers = all

We’re about to launch a brand new version of On2Air Forms made specifically to work with your Airtable data. :star2: Available in just a few weeks! (If you’ve ever used our previous Forms version, the new one will be easier to use and does not require Jotform) Create an On2Air account to be notified when it launches Form Features: Create new Airtable records with a form Update Airtable records from a form Create new select field options Create new linked records Display images, text, and other data from your Airtable base Prefill the fields with default information per form user Display secondary fields based on answers to a primary field (Car Make > Model) Automatically hide or show questions to users based on previous answers using conditional field logic Insert a form value previously entered by the user into another location in your form Generate personalized forms based on user data Want to see a certain feature in Forms? You can vote or upvote a feature request - Request

Can’t find anything about it, so research lead to this. Airtable iOS app use url-scheme like: airtable:///tableID/recID You can use it in iOS Shortcut app for custom scenario, just open link with “Open x-callback URL” For example, I copy contacts from airtable to “google contacts” via Zapier and sync it with iPhone. I add recID to every contact, so I can quickly find any in spotlight and open in airtable app

If you’re using the Google Docs automation, but discovered you need more customization and features, check out On2Air Docs.You can use Google Docs, Google Sheets, or Google Slides to create any kind of document.Use the power of Google to customize your document and it will export as a PDF back into an Attachment field.Here’s a full breakdown of On2Air Documents vs Airtable Google DocsOn2Air Documents vs. Airtable Documents  

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:

Ranks your data in descending order based on a field you select, and updates a field you select with the ranking number. Here’s a link to an example base which you can copy and try for yourself: https://airtable.com/shr1Ymp6Z39jsN1Pq //This script will grab the rows from the chosen table, rank them, and then update the chosen column output.text("This code will let you pick a field you want your rows ranked by, and then rank it in descending order."); //Allow the user to choose the table they want to manipulate let table = await input.tableAsync('Select the table'); //You can replace the above line with the following if you know what table you're going to be using //let table = base.getTable("[TABLE NAME]") //For the purposes of this example base, it would be: //let table = base.getTable("Sales"); //Allow the user to choose the field they want to rank let fieldToRank = await input.fieldAsync("Select the field you want to rank by. Please pick a number, percent, or currency field.",

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