OVERVIEW
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
PROBLEM:
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.
