Looking for some help creating an email notification. I’ve created a Word template for an order in the app. I want the attachment to reflect the product code in the order. I’m not sure how to set it up properly.
I’ve set it up so that each item on the left side column is effectively a table on its own sheet in Excel. All the data pulled is from the [Orders] sheet. Should it be set up this way? Or is there a better way?
I thought about re-working the entire form so that all products are listed in one sheet but I then get stumped on how to filter items based on the category, e.g. Product category=tanker size, tanker size= 7-8 different options.
Any guidance is much appreciated!