Discussions

Expand all | Collapse all

ICON FOR A FIELD (CHECKBOX)

  • 1.  ICON FOR A FIELD (CHECKBOX)

    Posted 18 days ago

    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
    ------------------------------



  • 2.  RE: ICON FOR A FIELD (CHECKBOX)

    Posted 18 days 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
    ------------------------------



  • 3.  RE: ICON FOR A FIELD (CHECKBOX)

    Posted 17 days 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
    ------------------------------



  • 4.  RE: ICON FOR A FIELD (CHECKBOX)

    Posted 17 days 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
    ------------------------------



  • 5.  RE: ICON FOR A FIELD (CHECKBOX)

    Posted 17 days ago
    Hi @Mark Shipman, Thanks for the replay. Can we have the icons in the options itself? Instead of creating a new formula Rich Text field?


    Thank you!



    ------------------------------
    Venkatesh Gandi
    ------------------------------



  • 6.  RE: ICON FOR A FIELD (CHECKBOX)

    Posted 17 days ago
    No, there is not a way to have the choices be rich text fields to show Rich Texr or icons.

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



  • 7.  RE: ICON FOR A FIELD (CHECKBOX)

    Posted 16 days ago
    Hi @Mark Shnier (YQC), Thanks for the reply, So it is not possible to include only icons or images as options as well. Am I correct?

     ​Thanks!

    ------------------------------
    Venkatesh Gandi
    ------------------------------



  • 8.  RE: ICON FOR A FIELD (CHECKBOX)

    Posted 16 days ago
    Correct, the drop down choices offered to the user will be plain text only.

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