I'm using Airtable as a main inventory of the products I sell. I have a table wherein a new record is created with an SKU whenever I scan a barcode of my product.
WHAT I WANT TO ACHIEVE The Main Inventory is located in another table. I just want to automatically link the MAIN INVENTORY whenever the StocktakeID ( or SKU) has a match.
Here's my automation
The test works but nothing happened. I also tried doing a direct automation like When a Record is created, update the Linked record using the exact name of the Main Inventory record but I am getting permissions error.