I’m recording sales orders by scanning barcodes of the products that are being sold. For eg: if I’m selling product A, I’d scan the barcode from my phone using the Airtable app and the barcode field would be populated.
Now, my aim is to automatically populate linked records using automation.
Check the image below, I have 2 tables - Inventory (test) and Sales Orders (test). I have scanned the barcodes of the actual products to record inventory in Inventory (test). You can see 10 units of each product with unique barcodes.
Now, let’s check the Sales Order table in the image below,
You can see that the Inventory (test) is linked to the Sales Order (test). So, when I scan the barcode from my phone of an item sold, the automation will be triggered and update the barcode in the linked record.
The images below are of automation,
The trigger would be “when a record is created” in sales order (test)
Action would be “Update the record” based on the record Id from step 1 and update the “Inventory test” field which is linked to Inventory Test.
Now check the below image once again,
record on 4th April was created while testing the automation and it was successful. You can see it was able to fetch the barcode to the linked record.
2nd record was created after turning on the automation and you can see the barcode data was not fetched from the barcode field.
Can someone help me, where did I go wrong? Also, suggest a better way to do this without having manually selected records from the linked table.