justinsbarrett

const settings = input.config({
    title: "Mark Matching Records",
    description: `Searches an incoming data table for records matching those in a \"master\" table.
    Any matching records are marked via a checkbox field.`,
    items: [
        input.config.table("masterTable", {
            label: "Master table",
            description: "The table containing the master list."
        }),
        input.config.field("masterField", {

theomichel

/*
* This script attempts to automatically create back-links for an Airtable linked record
* that references the same table. It supports an arbitrary number of links per record. 
* It is susceptible to race conditions if multiple changes are made in quick succession.
*
* To use this, one would add it as an automation on the table, trigged by record updates
* to the "parents" or "children" columns. 
*
* NOTE: some efficiency could be gained by having two scripts, one for parents and 
* one for children, and triggering each one when appropriate.

gregonarash

//Substitute "Orders" for table name which contains values
//on which you want to run the vlookup
let mainTable = base.getTable("Orders");
let mainTableRecords = await mainTable.selectRecordsAsync({fields:["Item.barcode"]});

//Substitute "Product" for table which contains range to search in
let lookupTable = base.getTable("Products");
let lookupRangeRecords = await lookupTable.selectRecordsAsync({fields:["Barcode"]});

//Replace "Item.barcode" with column name which has the values you want to look up 

on2air

/*****
 * Title: Same Table Backlinks
 * License: MIT
 * Author: Openside (Team behind On2Air products and BuiltOnAir community)
 * Sites:
 * https://openside.com - Openside Consulting Services
 * https://openside.com/#products - On2Air Products
 * https://builtonair.com - All things Airtable Community
 * 
 * Reach out for all your Airtable needs