Builders Board

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

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

I have been building out a database in Airtable to track the 199 countries of the world in regards to these kind of data points: strength of passport (visa free countries you can visit, whether you can go visa free to USA, Schengen countries and other top destinations, etc) plus a good number of other metrics. In each country record, I have started entering how each passport is treated in every other country. I’d like to scrape this data from wikipedia entries such as this: *Visa requirements for Slovak citizens - Wikipedia) and have it merged into my airtable. The end result is being able to pick any country and see the options for travel in some kind of simplified table or map. The other data consideration is how visa waivers work i.e. you get X number of days to start and can extend for another Y days for a total

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

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

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

We are a social impact driven consortium of international development consultants, and we are looking for the help of an advanced Airtable user, ideally one who is an independent consultant or aligned to our mission. As a consortium we are operated by members for members. We have an established base that we use for about 50% of what we want to use it for, starting with membership management, through sales/opportunity pipeline tracking, project management and sub-contract management. To facilitate peer updating we currently utilise Stacker to enable members to see and edit some of our Airtable data. The base works fine, but as we have grown it needs to be optimised to improve linkages between tables and probably eventually restructured to enable it to serve us better. We want to build a relationship with an independent consultant by starting small and expanding our ambitions with Airtab

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

Hi All, I hope this meets you well, I need an expert in Google API. We would like to have a professional paid service to automate and generate a TV grid in google sheets. So we have a specific structure in a weekly bases with time slots vertical and date horizontal. We have the episodes with the time slot and release date available in Airtable. We want a script to place those data in the right cell for each episode, I will share a snapshot of the grid and a snapshot of how we have it in Airtable . for your note : we have built something like this Airtable → On2air → Google Sheets a script with Json will read from the episodic view and place that to the right cell, and generate in PDF.

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 f

Hello everyone,I’m looking to build a matching engine that will compare records across two different tables (that have the same structured fields) and identify matches i.e. when there is a complete or partial overlap of the specified fields. The objective is to create relationships between records that are similar and then display these on a Softr page (similar to Amazon’s widget “customers who bought this item also looked at this”).Who has experience and short-term availability to support me? Please reach out directly.

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.

Hi everyone, We’re looking for freelance Airtable experts to join Codemap - world’s first and largest freelance marketplace for no-code/low-code & automation (3,000+ clients)! 🤓 You can access 1,000s of part-time and full-time projects with no public bidding and $0 commissions - get hired and keep your project pipeline full: :white_check_mark: Get accurately matched by your skills - no more searching through heaps of irrelevant jobs:white_check_mark: Work with vetted, innovative companies from across the globe:white_check_mark: Access new opportunities - daily Do what you do best, charge what you want, get paid and keep 100% of your earnings. 🚀 Sign up via the below link, and start getting client requests now! :point_down:

Hi everyone. I’m curious if anyone is interested or knows how to make visualisations (bar, line etc) from a record or a subset of records/linked records but not the whole table. Cheers,

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

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 for

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:

Hi, We’ve been using AT for a couple years and would like to see the total amount paid to vendors per job. Currently, we have the following tables within a Base: Orders (1 record per job) Clients Vendors On the Orders table, each job includes the following fields: DOS Client Name Vendor(s) [multiple select field] (each job can have 1 to many vendors depending on scope) Client Invoice # (manually entered) Vendor Invoice amount Paid (manually entered and separated by / if more than one vendor hired) I would like to have a field that adds up the total vendor payments per record/job. This can be done by entering Vendor Invoice info into a separate table (Vendor Payments) or some other way that is simple/effective. My goal is for our AR person view our Invoice No. and all vendors associated with that Invoice No. in separate records in order to enter their invoice amount per record/Job. Thanks in advance Jul

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

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