I have 3 get records: the order (process supplies the order id), order products (filtered on order id), and products (filtered on product id).
The order products and products are stored in seperate collection variables.
The order product fields that are stored are:
ID, quantity, ProductID
The product fields that are stored are:
ID, Code, Family, and Type (custom)
What I would like to do is create a formula variable that checks if the order contains any product with type service, and if so then checks if there are any other products with type software. If true then it takes the exact order product with type service's quantity and multiplies it by 365.
I'm not sure if this is possible and if so, how to write it.
2 respuestas
Hi Ashley,
You can't do this with a formula. Instead, use a loop step to iterate over each item in your collection, and if a match is found mark a variable as true.
