Forum Discussion

ReneeHansen's avatar
ReneeHansen
Qrew Member
4 years ago

ICON FOR A FIELD (CHECKBOX)

hi, Sometimes we need to exclude wells from our timeline if it was acquired after production started on it.

So I've created a field checkbox that says "Exclude from comp to 1st prod" and it's a checkbox, so yes or no.

1. I want this icon to come up, on the record if that box is checked (the URL is images.quickbase.com/si/16/209-x.png)

2. it would also be nice to have a formula that does that. If acquired date is after completion date, then show then check that box and show the icon

Not sure what's possible, or even how to do it. 

Thanks!



------------------------------
Renee Hansen
------------------------------

Formulas and functions
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    4 years ago
    np,
    Try this as a formula Rich Text field. 


    IF([Exclude from comp to 1st prod], "<img src=https://images.quickbase.com/si/16/209-x.png>")


    The img src means Image Source. 

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------
    • VenkateshGandi's avatar
      VenkateshGandi
      Qrew Trainee
      4 years ago
      Hi @Mark Shnier (YQC), Is it possible to include the icons in the text Multi-choice options/ Multi- Select text options as well?​ Please help. Thank you!

      ------------------------------
      Venkatesh Gandi
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        4 years ago
        Yes, you will just have a formula to determine if the multi select field contains some value and if so, calculate an icon.

        in pseudo code it would be like

        List(" ",
        IF(Contains(ToText([my multi select field]), "choice 1"), image 1),
        IF(Contains(ToText([my multi select field]), "choice 2"), image 2),
        IF(Contains(ToText([my multi select field]), "choice 3,) image 3))


        ------------------------------
        Mark Shnier (YQC)
        mark.shnier@gmail.com
        ------------------------------