Discussions

 View Only
Expand all | Collapse all

Icon in field depending on another field value

  • 1.  Icon in field depending on another field value

    Posted 04-05-2017 07:36
    HI all, newbie question here, and something i cannot figure out.
    I want to create a new field, but have it show a icon. But the icon will be different depending on another field for that entry. for example;

    Field1                        Field2              
    red                            shows image from example url1 https://images.url.com/red.png
    blue                            shows image from example url2 https://images.url.com/blue.png
    green                          shows image from example url3 https://images.url.com/green.png

    So when looking at the first line, the field2 will show a red icon, as the field1 text matches 'red'

    hope that makes sense, thanks.


  • 2.  RE: Icon in field depending on another field value

    Posted 04-05-2017 07:59
    HI Chris,

    Please create a formula text field and turn on the Allow some HTML tags to be inserted option in the field.

    Use this formula:

    Case([Field1],"red", "<img src=\"https://images.quickbase.com/si/16/227-rect_red.png\"; title=\"red\">", 
    "blue", "<img src=\"https://images.quickbase.com/si/16/230-rect_blue.png\"; title=\"blue\">",
    "green","<img src=\"https://images.quickbase.com/si/16/228-rect_green.png\"; title=\"green\">")

    Please let me know if you need any further help.

    Thanks,
    Gaurav


  • 3.  RE: Icon in field depending on another field value

    Posted 04-05-2017 08:25
    Get in the habit of putting formulas within a <pre> tag:
    Case([Field1],   "red", "<img src=\"https://images.quickbase.com/si/16/227-rect_red.png\"; title=\"red\">", 
    "blue", "<img src=\"https://images.quickbase.com/si/16/230-rect_blue.png\"; title=\"blue\">",
    "green","<img src=\"https://images.quickbase.com/si/16/228-rect_green.png\"; title=\"green\">" )


  • 4.  RE: Icon in field depending on another field value

    Posted 04-05-2017 08:28
    Thanks Dan, I'll make sure next time :)


  • 5.  RE: Icon in field depending on another field value

    Posted 04-05-2017 10:16
    The forum will not let me edit my prior post (this is really annoying) but I intended to replace the escaped double quotes with single quotes and remove the errant semicolon in the formula. Let me try again:
    Case([Field1],
      "red",  "<img src='https://images.quickbase.com/si/16/227-rect_red.png">https://images.quickbase.com/si/16/227-rect_red.png">https://images.quickbase.com/si/16/227-rect_red.png' title='red'>", 
      "blue", "<img src='https://images.quickbase.com/si/16/230-rect_blue.png' title='blue'>",
      "green","<img src='https://images.quickbase.com/si/16/228-rect_green.png' title='green'>"
    )
    As well as post a version that does not even use single quotes on the attributes:
    Case([Field1],
      "red",  "<img src=https://images.quickbase.com/si/16/227-rect_red.png title=red>", 
      "blue", "<img src=https://images.quickbase.com/si/16/230-rect_blue.png title=blue>",
      "green","<img src=https://images.quickbase.com/si/16/228-rect_green.png title=green>"
    )

    FWIW, because I placed these formulas within <pre> tags I have some scripts that can automatically extract formulas posted to the forum and place them into a formula corpus application. When you start looking at 1000s of QuickBase formulas in a table rather than working with formulas individually a lot of patterns emerge which helps understand the characteristics of good and bad formulas. Perhaps a byproduct of this effort will be to write up a best practices for constructing and formatting formulas.


  • 6.  RE: Icon in field depending on another field value

    Posted 04-05-2017 10:19
    Thanks Dan for this and I also tried to edit my previous post but could not able to do that. It is very annoying. Why have they done like this?


  • 7.  RE: Icon in field depending on another field value

    Posted 04-05-2017 10:23
    I think the ability to edit may depend if you are signed in?  It seems to me that if I click that sign in button then I am able to edit my posts.  But I'm not 100% sure of that theory that it's simply forgetting to maintain my sign-on and that an extra click to get re-signed on will allow edits. 


  • 8.  RE: Icon in field depending on another field value

    Posted 04-05-2017 10:24
    I think it is rather obvious that the forum managers are hellbent on thwarting our efforts and that they should be sent to re-education camps.


  • 9.  RE: Icon in field depending on another field value

    Posted 04-05-2017 10:30
    Mark: No, I am not able to edit my post if I am already signed in and Dan is right "they should be sent to re-education camps." :-D  :-D


  • 10.  RE: Icon in field depending on another field value

    Posted 04-05-2017 17:00
    I've noticed that once somebody else comments, your "Edit" ability goes away.  At least on my end.


  • 11.  RE: Icon in field depending on another field value

    Posted 04-05-2017 09:34
    thanks both, i will give that a try and update you. much appreciated.


  • 12.  RE: Icon in field depending on another field value

    Posted 04-05-2017 09:42
    worked brilliantly, thanks both.


  • 13.  RE: Icon in field depending on another field value

    Posted 04-05-2017 09:44
    Great :)