Builders Board

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

We are a health tech company, looking to hire a developer/ consultant with Airtable and integration expertise. The goal is to build a lightweight MVP for a clinical study. Here is the tech stack we plan to use: Jotform (forms data) Airtable (backend) Softr/Stacker (front end for admin views and read/write functionality) Twilio/Sendgrid/Gmail (email and text messages) Zapier (potential integration if native integrations do not suffice) Here are the broad specs: Participants are recruited into the study Participants complete a health assessment form (jotform) Data from form is captured in Airtable Clinical algorithms are run on above dataset (mostly if/ than or decision tree types nothing complex. Eg if your glucose is > XX, you have diabetes) Particpants meet with Dr to review data and discuss their care plan Dr can access data for each particpant and write notes of their discussion (Soft/Stacker). Participants get detailed report of their data and Dr’s recommendations We follow up v

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.

We have been looking for options for creating a product configurator on our website that will send us a request for quote when they are finished. We are very new to airtables but believe airtables has all of the capabilities we want. We are looking to hire a consultant to help us build the foundation of a product configurator and set us on the correct path.

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

If you’re concerned about the recent change in Attachment URLs that Airtable just announced, we want to hear from you. At On2Air, we’re exploring ways to overcome this. (We build apps for Airtable - on2air.com) Let us know if interested and your use-case by filling out this form. File Storage File Storage 📌 Status: Submitted

Joel here, founder of Paytable :wave: I’ve been busy working away in the background bootstrapping Paytable and have just dropped a pretty huge release of new features & improvements. Paytable is gradually becoming an all round membership management platform and an ideal way to sell gated content with the help of many users feedback helping to refine the product. ​ ​Here’s a super quick overview of some quick wins that have been going down at Paytable recently: :boom: Offer free info products to start building your audience Pay-nothing, sign-up-with-email only products have landed. Create a product, set it to 0 and start building your mailing lists with awesome info product give-aways that can help make it go viral. Head to your dashboard Add digital downloads exclusive for members On a mission to become the ultimate members only platform for makers & creators we've also added digital downloads for your subscribers. This means you can keep your members around lon

Hi! We’re looking for a consultant to work with our small but mighty remote team, Breakout Experiences. The ideal candidate is a proactive and self-sufficient worker who thrives in a fast-paced environment. Duties and Responsibilities: Build dashboards and bases to help stream line our information and data, such as financial dashboard, KPIs and sales tracking Build integrations to pull in live data from multiple data sources, including Hubspot and Quickbooks Help clean up old data and get it into our new systems If this sounds like you, visit our website to check out the full job description!

This question caught my eye on OpenSide’s Slack channel this morning. It’s a common question for anyone doing anything serious with Airtable. I’ve written about this subject many times including here and here. Does anyone know if Airtable can support more than 100k records per base on enterprise? I generally try to reframe this topic to suggest a more important question you should be asking - Is there a way to optimize the data model to accommodate the equivalent of at least a years worth of transactions? High-volume record requirements are generally indicative of transactions; data flows that are increasingly less relevant as time passes. And there is at least one trick you can use to expand the capacity of small transaction records by not storing individual records in a linked (relational) table; rather, store them as JSON objects in a long text field. This is, of course, a sanctioned approach as evidenced by this Airtable feature . To pull this off, a button (in the client recor

I created a script that takes data from a table to perform a mail merge using the Lob.com service. Airtable Mail Merge with Lob.com - Airtable Universe This shared base demonstrates how you can perform a mail merge using Airtable and the Lob.com service. ​ Instructional video:... The share on Airtable Universe includes the scripting block code as well as an instructional video. -Bill

Hello! I’m a part of a volunteer mutual aid group called Mutual Aid LA and we organize a free produce giveaway in a park every Thursday where we hand out produce to the community and also stock several LA Community Fridges (Login • Instagram). We need someone to help us build a base and sign-up form to sign-up to deliver to specific fridges each week. I’ve spent hours trying to do this myself but really just need someone proficient in airtable and automations to help me out by building it or even just giving me some pointers. Please let me know if you are available and interested in doing this. This would impact so many people because it would allow us to get food to so many more people. Thank you for considering!

Hello! I’m consulting with a nonprofit and this is the requirement: Use Maddie’s University LMS (No API possible - proprietary) - export data in .xls Certifications are managed through BadgeCert - API is accessible. Less than 25 columns of data. Three test rows of data. I’m interested in knowing how much a custom-build API would cost for Airtable to BadgeCert. I can be reached at awwdorablepets@gmail.com Thank you, Julia

Hi everyone I’ve posted previously about making a simple “to do” list that generates a new task with the same name, due a week later, whenever you tick the task complete. Here’s a slightly more sophisticated version of the same idea, where you can specify when you want the task to repeat, e.g. 1 week later, 2 weeks later, etc. Hope this is useful to someone out there. I’m just getting started on making simple instructional Airtable videos, so appreciate any feedback. Cheers!

Hey there,If you’re looking for a dashboard layout to view multiple tables in your Airtable base at one time or to edit and create records and Linked records, check out On2Air Forms for Airtable.You can create sections with your various Airtable fields and what’s most useful for you to see. We have a free plan, so you can try it out. Get started hereOn2Air 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 use

Hi everyone. It just occurred to me that you could use a formula and a couple of automations to make yourself a simple recurring tasks list. All you need is a date field to set the initial due date of your task, a checkbox field for when you mark the task as “Done” and a formula field that adds a specified length of time to the due date using DATEADD when “Done” is ticked. Then your automation will take the date generated in the formula field and replace the original date in {Due date}. A second automation then takes a last modified field set to monitor when “Done” was ticked, and a formula that shows how much time has passed since “Done” was last ticked, and unchecks “Done” after that length of time has passed (I set this to 2 minutes, i.e. 120 seconds). This final step is to ensure the two automations do not interrupt each other (so to speak). Here’s the full set up… Fields {Name} - Primary field, single line text. The name of your task. {Due date} - Date field, indicating whe

Memorializing this since I spent entirely too much time and bugged @Justin_Barrett @Bill.French and @openside to get this output. I needed to output the US date format into an email, but I needed “tomorrow’s date” to be output. The use case was an email that goes out through automations every Wednesday, but they needed a reminder in the email to follow up by Thursday, (Tomorrow’s Date). Here’s the outcome. It works, so we don’t try to make it more elegant in these parts :slightly_smiling_face: let someDate = new Date(); someDate.setDate(someDate.getDate() + 1); let dateFormatted = someDate.toLocaleString('en-US', { year: 'numeric', month: '2-digit', day: '2-digit'}); output.set('thisDate', dateFormatted); You can add whatever number to the second line to add, haven’t tried subtracting. Also, the toLocaleString() without any modifiers outputs a date and time.

Generate random users in an Airtable base Simple workflow: Input required number of random user records. Push Go! 22 pieces of random information per record: Full name, Gender, Title, First name, Last name, Street, City, State, Country, Postcode, Timezone offset, Timezone description, email, UUID, Username, Password, Date of birth, Age, Phone, Picture large, Picture medium & Picture thumbnail Custom script gets randomuser.me data and creates records Works with free Airtable plan Full instructions with videos https://marcfletcher.gumroad.com/l/ixmfa

We are happy to announce the Java Client for Airtable. We created for educational purposes. Have a look at GitHub: https://github.com/Sybit-Education/airtable.java The client supports automatically object mapping. All CRUD-Operations (including Attachments) are already supported. But it is a very first version. Any feedback or pull requests are welcome.

What is Data Fetcher? A tool people use to import data into Airtable (Airtable is similar to Google Sheets). Used by hundreds of customers globally to automate their businesses. 100% remote. Profitable & fast-growing. What will you do? You’ll write blog posts for the Data Fetcher blog like this one and record YouTube videos like this one. You’ll learn to write search engine optimized marketing content for Google & YouTube. You’ll also learn how to use Airtable & Data Fetcher. You’ll be given the topics, e.g. ‘How to Import Google Analytics Data to Airtable’ and high-level instructions on how to do that using Data Fetcher. You’re also welcome to suggest your own topics as you get a feel for Data Fetcher’s possible use cases. About You This role is perfect for a student or graduate who wants to gain experience at a fast-growing tech company. You do not need any relevant experience, just a willingness to learn and: Excellent written communication skills. Attention to detail