Load a few images from a URL based upon a matching field value

MrBosch — Thu, 13 Oct 2022 20:33:36 GMT

Hello mighty pools of wisdom 😉

I am stuck...

For each client we upload 4 images to a server.
Each client has a clientcode field.
All files on the server are labeled: [clientcode]_Product_1.png
(Example: S56H3M2_Product_1.png .. S56H3M2_Product_4.png)

What I am trying to do is: with only this one specific client [clientcode] selected, now on a 'reload' download the 4 images AS Product1 .. Product4.
If I reload without one specific client selected: memory can be cleared.

Something like:

LOAD
w3.example.com/images/[clientcode]_Product_1.png  AS Product1,
w3.example.com/images/[clientcode]_Product_2.png  AS Product2,
w3.example.com/images/[clientcode]_Product_3.png  AS Product3,
w3.example.com/images/[clientcode]_Product_4.png  AS Product4;

I will then display the product image as text object (with image representation) into a report.

Anyone with an idea? Thank you so much in advance.
Alex

topic Load a few images from a URL based upon a matching field value in App Development

Load a few images from a URL based upon a matching field value