In my scenario, I have a trailer that may have multiple batteries assigned to it. When a battery needs to be removed, the client brings up the battery detail in an Interface and clicks 'Remove'. This launches an automation where multiple things occur...
For this retail example, I am importing sales data into a Sales table, which automatically updates the Inventory table. Here’s what I want to solve for:
As file is being imported into Sales table, check productID against Inventory table to see if pr...
@Ben_Young1 - you are exactly right! I got so bogged down looking at it from the trailer perspective, I didn't think about it from the battery perspective. Thanks!
