Hi there! Apologies if this is obvious - or I’m using the wrong language - having a bit of trouble processing a bundle and wondered if anyone here can help?
I have a scenario which links to Unleashed for Sales Data. Once every day, I want it to output all the previous days Sales Orders into a Google Sheet, with a row for each line item and it’s qty.
Something to the effect of:
I’ve got the scenario mostly set up - but the problem I have is when multiple lines are ordered in a single order, I’m not sure how to get the 2nd line item out of the data and into Sheets;
Here’s some screenshots.
Bundle out of the Unleashed Module:
1 + 2 being the sales order lines I want to extract. Could have many multiples of line
And after the Product Code + Qty from this bundle:
My current set up can pull out the first line only - but not sure what I need to do to pull the 2nd or more lines if they exist.
This is what the Google Sheet module has set up:
Would basically like this to add a row for each line with “Sales Order Line” - but not sure of the logic I need to apply to it.
Anyone kindly have any suggestions?