Hello! I have an app that coverts raw data from one google sheet to line items in our order system. The raw data contains two types of line items, production line items and stock line items. My action, “Import Order” is a group of two actions: “Import Production Items” and “Import Stock Items” that run on each row of the raw data. I set behavior restrictions on each sub action to determine if the row is a stock or production item and only run if it is the appropriate type. It functions great, stock items get copied to the stock line items sheet and production items get copied to the production queue sheet. HOWEVER, if only one type of line item is on an order, meaning the other action won’t actually get fired off, I get a popup saying:
Action Failed
Could not set value because column Qty would become blank and required.
Everything imports just fine despite the action… any way to fix this??
LinkedIn
Twitter
