How do I have a list of all items on an email template. I figured out how to create an email template and some of the formulas (probably a longer formula than needed but none the less it works.) Currently when testing the email, I will get 10 emails with different products on each one instead of getting one email with all products.
I would like to have (1) email with all products instead of (10).
EX. I am ordering products from a vendor. They carry (10) products we need. I would like to have (1) email showing (on a purchase order template(all ready done)) instead of have (10) different emails.
Have you used scheduled report instead of Workflow? If you have used an option “ForEachRowInTable”, yes it will send email for every record. You are probably looking Workflow insted of Report. If you want to add more records from a table, you need to use Start: & End formulas for that purpose. Please check this article.
I am using scheduled report instead of work workflow. I read somewhere on one of the blogs or watched a video saying that was the better way. I still thank you for the suggestion. (I just checked to make to sure I was using reports not workflow.)
First of all, would I need that expression in every column I would want a list in?
Second, I used and expression <<Start:Products[Restock Needed]>> and the log says “should generate a List of Ref values. Please verify that it generates a List and that the contents of the List are Ref values. Ref values should come from the ‘Key’ column of the referenced table.” The only key column I have is ComputedKey and no Ref columns.
Sorry to be a pain but I am learning all this for the first time and I think I have all the simple things down but the really complicated things (i.e. expressions) are “Greek” to me.
When you want to send an email to your vendors, yes report with the option ForEachRowInTable is the correct answer, but you need to trigger it from the Vendors table. If you don’t have it, you should create it. Then you can send one email with all related products vendor by vendor.
@Aleksi is there any way you may be able to help me further on this subject. I am stuck and do not know what I can do. I have been working on this for now for (2) days and can not figure it out.
If at all possible can you look at the app and tell me what I am doing wrong with the email template?
This works great. Gave me just the vendor I want to email and the product I want to order without having every other product show up that does not need to be ordered.
But if I have more than one product to order then I will received multiple emails. Each containing a different product that needs to ordered by that vendor.
How can I get all the products into one email?
This was also made from a “slice”. Which is the only way I was able to get this to function properly. If I change any column valve in the app to “ref” then the values change or come up missing.
