I am creating a shopping list app. I have made a slice view that only shows items with a quantity. Now I want to create an email action to send the full shopping list to myself or my wife However I am struggling setting up the email body template, so it generates the full list of all items from my slice. I can get it to display info from multipe rows using a SELECT function, however I need the email to display both: Category, Item, Unit and Quantity for all items in the list i.e. information from 4 columns, but per row, so the email body would look like e.g.
Diary, Milk, 3 ltr.
Diary, Yoghurt, 2 ltr.
Non-food, toilet paper, 2 pcs.
Non-food, dishwasher tabs, 1 pack
Any help would be highly appreciated.