How can I logically apply a “no image available” image?
I have a static image which I can reference in “Initial value” field from Google Drive.
It shows up as expected for the Image when creating a new item entry.
While this seems to just record on the record the URL to that static image,
each item saved in this manner will add to the size of the dataset - URL’s are typically longer (more text) than the relative file paths used when capturing images from the device.
Instead, what I’d like to do is have the view show the static image when the Image column is null/blank.
I did try using an IF() expression on the App Formula to use the URL for static image when ISBLANK() but I got a type mismatch ( I assume Image vs Text).
I have not found a way I can return the Image from the URL.
Is there a way I can do this?