Dynamic table and picture gallery

[andrearuggeri]

Hi all, new user here 🙂

I have data like this

ActualStart	TargetName	ItemName	Foto 1	Foto 2	Foto 3
04/11/2020 10:00	Shop1	Item1	https://www.someurl.com/api/pictures/6f1da8c9-aa48-4bfb-880f-5c2be00f0b9c	https://www.someurl.com/api/pictures/91dc50d4-3d77-4b14-a000-9a6065aa0137
04/11/2020 10:00	Shop1	Item2	https://www.someurl.com/api/pictures/9fe55584-499a-4c81-89d7-37ad837399f7	https://www.someurl.com/api/pictures/93ff9ab2-2292-4dfb-a66e-7b568c2a81a5	https://www.someurl.com/api/pictures/a63ad8ac-0e7c-479e-b786-a358e546e7cc
04/11/2020 10:00	Shop1	Item3	https://www.someurl.com/api/pictures/0674474e-b9de-4f6a-a6b8-73d2bff726bb	https://www.someurl.com/api/pictures/ae223fec-a9b9-4a88-99cc-ef91a5e0774d
04/11/2020 10:00	Shop1	Item4	https://www.someurl.com/api/pictures/e00828c7-62cf-4bcd-b201-56864030a3e9
04/11/2020 10:00	Shop1	Item6	https://www.someurl.com/api/pictures/b7ef7a4d-e4e1-4c93-a923-64cac9a82098
02/11/2020 10:00	Shop2	Item1	https://www.someurl.com/api/pictures/f5fdff90-0f54-4fd4-bb54-b711f7ea7085	https://www.someurl.com/api/pictures/fad38f65-a67d-4759-bf2c-09010787b0bb	https://www.someurl.com/api/pictures/658c9a8e-1bf2-4bf8-83db-2f9ed7e02416
02/11/2020 10:00	Shop2	Item2	https://www.someurl.com/api/pictures/11601920-9675-4b2b-99d8-f9e66ee3c5e3	https://www.someurl.com/api/pictures/b1a3cdd3-4f00-458a-8e5a-1db99c18bb77	https://www.someurl.com/api/pictures/128e6b56-5ef3-411b-aff1-9f5fc2d5d136
02/11/2020 10:00	Shop2	Item5	https://www.someurl.com/api/pictures/0e129402-f075-4cd0-9589-8ea818944442
04/11/2020 10:35	Shop3	Item1	https://www.someurl.com/api/pictures/76272afc-39f7-404a-b4dd-dd1755a60a56
04/11/2020 10:35	Shop3	Item2	https://www.someurl.com/api/pictures/05dc4a32-669d-4076-a14b-2d32225451b4	https://www.someurl.com/api/pictures/76e12f08-ba39-467a-b373-096c7e6906f1
04/11/2020 10:35	Shop3	Item3	https://www.someurl.com/api/pictures/511d0f2c-eafa-41f9-b731-f67defefd79e
04/11/2020 10:35	Shop3	Item6	https://www.someurl.com/api/pictures/96c7e5a0-a404-4292-a7ab-8d8fc3aebb08
04/11/2020 10:35	Shop3	Item7	https://www.someurl.com/api/pictures/c56028a1-24aa-4b32-89c9-c7d8138cc87c

What I would like to do is to build a table visual where I can display all thumbnails for every target and items for each date. (and this is quite easy and already done by duplicating all URL and setting them as IMG URL)

Then if I click on any thumbnail, in another visual (HTML viewer or image viewer) I would like to get that very bigger picture.

For me this is the hard part, because everywhere I click I just get the first picture for that target, I can't find the way to display different pictures for the same target/date according to the selected/clicked item.

Thank you everybody in advance

[Icey · Accepted solution]

Hi @andrearuggeri ,

Is this what you want? The visual is Image Grid.

Best regards

Icey

If this post helps, then consider Accepting it as the solution to help other members find it faster.

[andrearuggeri]

Wow this is almost what I'm looking for!

Just a few additional things:

1. How did you make the matrix table with all the elements in row side by side? If I add elements I get them like in pivot tables "embedded" under the first element
2. Do you think it is possible to add a label under the pictures in the grid?
3. Do you think there is a way to add a link so that pictures are also opened externally in a browser?

Thanks a lot!!!

[Icey]

Hi @andrearuggeri ,

1. How did you make the matrix table with all the elements in row side by side? If I add elements I get them like in pivot tables "embedded" under the first element

---

Go to visual format field -> Row headers -> turn off "Stepped layout".

2. Do you think it is possible to add a label under the pictures in the grid?

---

Based on my test, no.

---

3. Do you think there is a way to add a link so that pictures are also opened externally in a browser?

---

To my knowledge, only "Web URL" data category can be opened externally in a browser.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[andrearuggeri]

To my knowledge, only "Web URL" data category can be opened externally in a browser.

---

True, I could add a "duplicated" column and format it to Web URL.

How about then creating the link/button/whatever to open it externally?

[Icey]

Hi @andrearuggeri ,

You can choose to display a hyperlink icon instead of a URL or format link text as a hyperlink.

Please refer to this document: Add hyperlinks (URLs) to a table or matrix

Best regards

Icey

If this post helps, then consider Accepting it as the solution to help other members find it faster.