Discussions

Expand all | Collapse all

Can I choose images from drop-down filed

  • 1.  Can I choose images from drop-down filed

    Posted 05-04-2018 16:50
    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!

      


  • 2.  RE: Can I choose images from drop-down filed

    Posted 05-04-2018 21:55
    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.


  • 3.  RE: Can I choose images from drop-down filed

    Posted 05-08-2018 18:40
    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. 


  • 4.  RE: Can I choose images from drop-down filed

    Posted 05-10-2018 16:39

    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\">";

    )