Builders Board

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

Hello :slightly_smiling_face: I am interested in hiring a consultant to create this flow. I have two bases, Base “A” and Base “B”. In base A I have records that include documents in the attachment field. There can be more than one document in the same attachment field. I want to accomplish that when a new document is uploaded in Base A, a new record is created in Base B including the document that has been uploaded in Base A. This would result in having a new record in Base B, each time there is a new document uploaded in Base A. Looking forward to your response. Thank you, Pjero

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

Hi, we are looking for help setting up an Airtable system that can help automate our workflow. Some of the tasks would help assign contractors to projects. Coming up with a system for our contractors to send in invoices, simplifying an invoice and payroll system, and moving a project through several different people and assignments.

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 dup

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

Hi - My company is seeking to speak with an (experienced) AirTable consultant/contractor who can help us with a few (custom or templatized) functions we’d like to add to our table: We are creating a "Deal Pipeline Mgmt System" We want a simple BBS function where a Deal is posted at the top and threaded discussions can follow below… we see there are comments available on document index pages, but we were looking for a template for easy, vertical threaded discussions in the format a bit like Kanban style or Trello’s UI I want to create a Dashboard of metrics as deal “objects” flow from 1 status to the next AND summations of data from the objects, e.g. if one deal is worth $100k and another $50k, I’d like a dashboard metric that tallies these and says total deals in the pipeline are work $150k and the average deal value = $150k / 2 deals = $75k/deal We want to create input forms in the form of surveys- that c

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

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

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

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

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)

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

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

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-

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!