Builders Board

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.

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

Hey community, I am planning to do an integration with Airtable for our analytics software, but I can’t really retrieve column stats without using metadata API, or is there any other workarounds that I am not aware of? Here is what I want List of bases and tables within bases Fields (with types) of each tables Option values for Single Select/Multi select fields This is what I’ve been using and this is not really providing me the information I need GitHub - josephbestjames/airtable.py: Python interface to the Airtable's REST API Thanks :slightly_smiling_face:

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 up

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

Airtable

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

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 fol

Hi All, We’re migrating an ~25,000 item database and we’re having issues with the best set up for our needs. Once we get the structure, we’d also like to work with someone on how to maximize inetgration for notifications to customers, vendors, and integration with QuickBooks Online. Thanks!

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