Check if image an image link give an image

Ask for Help
1

Hello , i have a gallery with product name and photo1 photo 2 to display image’s product.
I have an excel sheet with url link, but not all products have 2 images… so in case an image doesn’t exist, i have my colomn not empty but a “image not found”.

I’d like to know how to check if a photo is “not found”

thanks
img check1
img check2

2

add if then else column…

If photo 2 is empty then “Warning Photo Empty” else photo 2

In the data editor double click on photo1 and photo 2 and turn them into basic text… you can see the underlying URL’s

3

thanks for the reply, but my columns are filleds with link so they aren’t empty.

like
site/item1-img1.jpg for photo 1

site/item1-img2.jpg for photo 2

if the site/item1-img2.jpg don’t exist, it’s not empty !

4

So the urls are built out regardless if an image actually exists at that location or not?

5

You may try AI:

Screenshot 2024-04-14 at 22.00.40

6

Use conditional logic or even another AI Generate text column that decides if the url is an image url. If it is then output IMG if not output the image below.

Maybe you could try making a the image with text on it that says something like NULL. Or in the image give the AI a prompt.

Then you could use conditional filtering logic on the front end to filter out that reply where there is no Image or replace the image with another image all together.

I hope that makes sense.

7

thanks for your replies :slight_smile:
finally i changed the source : i just use a vba macro to check in my exel database if the url is a file , and if not i don’t display the url, so it will be an empty cell.

Problem solved :slight_smile:

3 Likes