I am creating an AppSheet to do Purchase Order Monitoring where every Monday the app will email straight to the vendors regarding this weeks orders to remind them . I am done with the automation part and email but now vendor A has 2 Orders that week, he will receive 2 different emails. How can i set up so that it will collate all orders from the same vendor.
Current Bot set up is 'for every row ’ and the email task TO is “supplier email”
The link was specifically to the “Order template in table format”. That example illustrates how to create within a template an extensible table with a row for each data source record. The “Start” expression in the template needs to return the list of rows; to most easily accomplish that, you may need to ensure your automation is defined in the context of the Suppliers table --e.g., <<Start: [Related Orders]>>-- or reference a slice that filters the orders you want included --e.g., <<Start: Current Orders Slice[Order ID]>>.