I’m using a ‘vlookup’ style script below as part of an automation triggered each time a new record is created.
//Substitute "Orders" for table name which contains values
//on which you want to run the vlookup
let mainTable = base.getTable("Litters");...