Best of 2 images in appsheet

[Rehabman]

I have a dynamic generated hyperlink which shows a google image., in a appsheet table.

I also have an image field where  I input images from a file or camera., when the generated hyperlink fails to get a good image.

QUESTION:

Is I possible to create a virtual field,  that would use the hyperlink image only if the image field is empty.

Any help here would be greatly appreciated.

[Rehabman · Accepted solution]

OK,  i  put it in the table column. added it as a image using this formula

if(isblank([Image1]),
[GoogleImage],
[Image1]
)

it does not seem to work.  maybe did something wrong

[graham_howe]

Yes, try the following as the formula for the VC

if(
  isblank([image_field]), 
  [hyperlink_image], 
  [image_field]
)

[Rehabman · Accepted solution]

OK,  i  put it in the table column. added it as a image using this formula

if(isblank([Image1]),
[GoogleImage],
[Image1]
)

it does not seem to work.  maybe did something wrong

[Rehabman · Accepted solution]

after i corrected my spelling error, it worked great.  now on to my  next problem

[Rehabman]

Not sure if i can ask Graham a question or need to post it elsewhere.  some guidance would be greatly appreciated.   

I have a virtual column that is suppose to find the average of 4 other fields.  i can do this just fine,  except when one or more of the fields are empty, they should not be in the average. 

is there an easy away to to this.

my formula adds the 4 fields, then divides by 4 got get the average.