What I’m trying to do
I want to manage the items I purchased from online stores.
I record them by receipt, and sometimes I buy multiple items at once, while other times I purchase only one item.
To display pictures, I include the image URLs as one of the fields
For example, I document them as follows.
- first file
## Amazon shopping
### ink1
- store:: Amazon
- date:: 2025-02-05
- name:: ink1
- imgurl:: (https://m.media-amazon.com/images/I/71pZUCdL6eL._AC_SX679_.jpg)
### ink2
- store:: Amazon
- date:: 2025-02-05
- name:: ink2
- imgurl:: (https://m.media-amazon.com/images/I/61pz-1sJnLL._AC_SX679_.jpg)
### ink3
- store:: Amazon
- date:: 2025-02-05
- name:: ink3
- imgurl:: (https://m.media-amazon.com/images/I/51XoIy6XFBL._AC_SX522_.jpg)
- second file
## ebay camera
- store:: ebay
- date:: 2025-03-31
- name:: camera1
- imgurl:: (https://i.ebayimg.com/images/g/Mv4AAOSwPPtj7Ao0/s-l1600.webp)
I want to display them using Dataview as shown below.
Things I have tried
I use the following Dataview script on my management page.
TABLE WITHOUT ID store, dateformat(date, "yyyy-MM-dd") AS Date, name, "![|50]"+imgurl AS image
FROM "1. daily"
WHERE store
… and I got this result.
And This is my second try …
TABLE WITHOUT ID store, dateformat(date, "yyyy-MM-dd") AS Date, name, map(imgurl, (x) => "![|50]"+x) As image
FROM "1. daily"
where store
… I got this result. This time ebay receipt has gone.
I don’t know how to split Amazon items into rows (FLATTEN was useless …)
Please help me !