Hello dear Community,
I have a datatable where I would like to add an image column based on an URL path that I have in another column ("Path").
The URL column ("Path") is constructed based on previous column (name+number) in order to have correct URLs for each row. Path formula is in the toy dataset or here :
Char( "https://bulbapedia.bulbagarden.net/wiki/File:" ) || Char( :"#"n ) ||
Char( :Name ) || Char( ".png" )
where the beginning is the name of the website, then "#" is a number in the URL and "Name" the name of the Pokemon. All together, the URL enables to get redirected to the specific Pokemon image (example : https://bulbapedia.bulbagarden.net/wiki/File:002Ivysaur.png)
I have problems to create a column of images based on this URL, I tried with a formula but obviously my formula is not correct (I tried looking in the COmmunity and Index Scripting, but couldn't succeed).
I would like to have a column (like Column 2 in the screenshot or dataset) where the formula looks at the column Path and retrieves an image (and if possible, being able to control the size of this image !) from the website.
Is it possible and does someone know how to do it ?
Please find attached a subset of a toy dataset.
Thanks in advance for your answers !
