I have three tables.
Table 1: Work Orders (Parent)
Table 2: Work Order Line Items (Child)
Table 3: Inventory
I currently have two bots working using webhooks.
Adds_Only - Whenever a work order line item is created, it adds the qty to the inventory table.
Deletes_Only - If that line item is deleted, it removes the qty from the inventory table.
Here is my JSON text, the Deletes_Only is the same except it subtracts from Qty Produced instead of adding.
“Timezone”: “Mountain Standard Time”
“Part ID”: “<<[Part ID]>>”,
“Qty Produced”: “<<[_THISROW].[Qty]+[Qty Produced]>>”
If I delete a Work Order, it deletes all child records in the Work Order Line Items Table, but the ‘Deletes_Only’ bot does not trigger when this happens.
How do I make a bot that triggers off of the Work Orders table that runs for each child record?
Any help would be much appreciated.