Hi there,


What I’m trying to achieve around purchase orders.


I’d like to create a new record in PO’s table and on adding the Supplier in the new record, an automation is triggered.


This would “find records” in the Products table that have the matching Supplier.


Then, in the Purchase Orders Line Items table, new records would be added for each Product that was found and would including the PO# from Orders Table and the Product Name and SOH from Products table.

I can have the automation find the records but it seems to only output to a single record with multiple values. I need a way to create the multiple records.

If anyone has a basic script for such a thing, or could help in any way, that would be amazing.


Thanks in advance!


Jason