hey,
I’m looking for some help please. I am trying to take a list of invoice items split by both delimiter // and separate lines. They are in the format of Item Description // Quantity // Cost per Item. I want to create separate arrays of Item Descriptions, Quantities and Costs to then loop through an items table via a google docs (.docx) template. Please see where I am at:
I need help getting this to loop into my invoice table.
I’ve made progress, I have now managed to create the dynamic table, as well as calculating each line item total cost. However I am now stuck with how to calculate the Total Cost of all Line Items.
This is how I achieved the dynamic table:
The Array Aggregator collects all the line item bundles from the text parser.
The Iterator then iterates through each line item.
The Tools set variables module calculates the total of each line as they are Iterated.
I then map the data into the Microsoft Word Template (fill batch). When I use the Google Drive Upload a File module after, I use advanced settings to convert back to google docs for ease of use phone, followed by creating a pdf and then sending a telegram update to myself.
Is anyone able to help in how I would calculate the total cost of the line items so i can enter 1 value in the document creation?
Thanks,
Matt
