Only Show Image if it Exists

Hi. I have a csv which has columns for 100 images, ie, Image1, Image2 etc through to 100. If I have only added 25 images then I only want to see the 25 images and hide the remaining columns unless I add more. Is this possible?

Solved Solved
0 7 1,150
  • UX
1 ACCEPTED SOLUTION

This worked:
ISNOTBLANK([Image1])
Always added to the next image, so as each image is added the image upload for the next image is not shown.

Thanks

View solution in original post

7 REPLIES 7

MultiTech
Participant V

Have you checked out isnotblank()?

Hey Matt, Iโ€™m sure this is in the Community somewhere, but how do we display a standard โ€œAdd Imageโ€ icon only when no image has yet been added? If a new member has not uploaded their profile image, I want something to show up, rather than have a blank slot. Thank you very much!

Hey @Stephen_Mattison, the way Iโ€™ve tackled this is to create an additional field: Display_Image.

The idea here is that you have one field for users to upload an image to, but you have another image field thatโ€™s the actual one thatโ€™s shown in the views, marked as the label (if applicable); it should have a formula of something like this:

if(isnotblank([Image_Upload]), [Image_Upload], OTHER_IMAGE_HERE)

For the other image there are a couple of options:

  1. You could upload an image somewhere in your app and call that image (using a LOOKUP() or something)

if(isnotblank([Image_Upload]), [Image_Upload], LOOKUP(โ€œPlaceHolderโ€, Images, ImageID, Image))

  1. You could use a URL of an image

if(isnotblank([Image_Upload]), [Image_Upload], โ€œhttps://www.dhresource.com/0x0s/f2-albu-g5-M00-80-24-rBVaJFko0bWAWxN2AAF2gOZhKqo309.jpg/winking-mirr...โ€)

  1. You can create a Text_Icon() from something in the record (I like this last one myself: typically doing TEXT_ICON(INITIALS([User_Name])) or something like that)

if(isnotblank([Image_Upload]), [Image_Upload], TEXT_ICON(INITIALS([User_Name])))


Finally I only show the upload in the form, everywhere else I show the Display_Image.

Hope it helps!

Thanks bro, youโ€™re the best! Just looking at this now, will digest and Reply again here with my results. I found another Post in this Community that I had a Comment on that ended up using a Virtual Column, but I have not gotten that figured out.

You could do that here as well, I just prefer to move any columns that hold data that doesnโ€™t need to update live into an actual physical column; but you could just as easily create a virtual column here with any of these methods for the other image.

This worked:
ISNOTBLANK([Image1])
Always added to the next image, so as each image is added the image upload for the next image is not shown.

Thanks

This is Fantastic. Thank you!

Top Labels in this Space