ICON FOR A FIELD (CHECKBOX)

Question

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.&nbsp;
Thanks!
------------------------------Renee Hansen------------------------------

markshnier__you · Answer

np,Try this as a formula Rich Text field.&nbsp;IF([Exclude from comp to 1st prod], "&lt;img src=https://images.quickbase.com/si/16/209-x.png&gt;")The img src means Image Source.&nbsp;------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

markshnier__you · Answer

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

markshnier__you · Answer

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

markshnier__you · Answer

Correct, the drop down choices offered to the user will be plain text only.------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

venkateshgandi · Answer

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

Forum Discussion

ICON FOR A FIELD (CHECKBOX)

7 Replies