Hi all,
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
etc.
Any help would be highly appreciated.
Thx
Jannik
User | Count |
---|---|
40 | |
32 | |
30 | |
16 | |
16 |