Discussions

Expand all | Collapse all

Show multiple pictures for multiple-select field

  • 1.  Show multiple pictures for multiple-select field

    Posted 05-17-2018 12:39
    Hello, I am trying to show pictures for a multiple-select field. 

    I know to do this for a single choice filed. As below. 

    However, [Pictogram] is a multiple-select filed. That means, I have three or more selects at the same time, and I hope to show three or more pictures accordingly. 

    Is there anyway to realize it? Thanks a lot. 



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

    )


  • 2.  RE: Show multiple pictures for multiple-select field

    Posted 05-17-2018 12:52
    Try this approach

    List (" ", 
    if(Contains([Pictogram], "Corrosion",
    "<img src=\"https://mycompany.quickbase.com/up/bnpaumwss/g/rb/eg/va/Corrosion.PNG\">"),
    if(Contains([Pictogram], "Flame","<img src=\"https://mycompany.quickbase.com/up/bnpaumwss/g/rb/eg/va/Flame.PNG\">")
    )
     


  • 3.  RE: Show multiple pictures for multiple-select field

    Posted 05-17-2018 12:53
    List (" ", 
    if(Contains([Pictogram], "Corrosion",
    "<img src=\"https://mycompany.quickbase.com/up/bnpaumwss/g/rb/eg/va/Corrosion.PNG\">"),
    if(Contains([Pictogram], "Flame", "<img src=\"https://mycompany.quickbase.com/up/bnpaumwss/g/rb/eg/va/Flame.PNG\">")
    )


  • 4.  RE: Show multiple pictures for multiple-select field

    Posted 05-17-2018 19:36
    Thank you so much! 

    It helps a lot! 

    By the way, Craig suggested me add ToText([Pictogram]). 


  • 5.  RE: Show multiple pictures for multiple-select field

    Posted 05-17-2018 19:37
    yes, it did need the ToText ...