Can I choose images from drop-down filed

  • 0
  • 1
  • Question
  • Updated 6 months ago
  • Answered
Hello, I hope to add a multi-select drop-down field for my project table. The field allows me to choose multiple images, such as "Desk", "Chair", "Light" from the drop-down list. 

Is that possible? My goal is to see one image, or images show up on my project.

I have 7 images, Can I save or attach them to QuickBase? 

Any suggestions to realize this? Thank you very much!

  
Photo of Ning Li

Ning Li

  • 670 Points 500 badge 2x thumb

Posted 7 months ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
If you only have 7 images, and you don't mind doing the hard work on the setup side...

You could use a formula field to evaluate the selected options, and then display the images based on the Record ID# that you have in a separate "images" table.

Ideally if you have more images and the list of options can grow, it is best to create a joined table to add the desired record list.
Photo of Ning Li

Ning Li

  • 670 Points 500 badge 2x thumb
Hi Matthew, Thank you very much.

I don't mind doing the hard work on setting up 7 images. I will consider a images table later. 

Then, how to save/upload images? Thanks,

....Kind of new user to QB. 
Photo of Ning Li

Ning Li

  • 670 Points 500 badge 2x thumb

Thank you. 

I added a table and use the following formula. It worked. However, what if the [Pictogram] filed is a multi-select field? How can I show multiple images since [Pictogram] include multiple selects? 


Thank you. 


Case([Pictogram]],

"Corrosion",

"<img src=\"https://mycompany.quickbase.com/up/bnpaumwss/g/rb/eg/va/Corrosion.PNG\">";,

"Flame","<img src=\"https://mycompany.quickbase.com/up/bnpaumwss/g/rb/eg/va/Flame.PNG\">";

)