Default image if not Image URL

[StephS]

Hello,

The data in AppSheet comes from a Google Sheet page, I have a column where there is the URL with an image which displays well in my AppSheet application.

How do I display a default image when there is no URL in a row of my Google Sheet table ?

I tried this IF(ISBLANK([Image]), "https://urlimage/image.jpg", [Image]) in the "Formula" column or in the "Initial Value" column but it doesn't work. How to do it, is there a solution?

Thank you in advance for your help.

Steph

[lynchk21]

You can make a 'Default Image' column in your Google Sheet and then upload the image you want to use as your default to it, after which you can add the file path for the image as the initial value. Then you can use your IF(ISBLANK([Image],[Default Image],[Image]) in a virtual column to display the two images based on context.