I need to add a key to color type.
Don’t know if “static” i.e. in the pic below showing in detail and editing form view under the colors:
red: urgent
green: done
black: to assign
or dynamic, so when a color is selected show the key accordingly
how to do it ?
if understanding of your requirement is correct, please create a show type column of Category type text with a Content setting expression of
SWITCH([Static],“Green” , “Done”, “Red”, “Urgent”, “Black”, “To Assign”, “”)
where [Static] is the Color type column.
It should look like below.
The show column settings where you need to enter expression are as follows
Thanks, is it possible to show the text on the right and not below ?
The tooltip text of the color type hide the text, please see pic where “To assign” is hide in part by “black-selected”
Unfortunately, one cannot do away with tooltip. So workaround will be to have the column text display still below with an expression like
CONCATENATE(" “,”
“, “”,”
“,”“,”
",SWITCH([Status],“Green” , “Done”, “Red”, “Urgent”, “Black”, “To Assign”, “”)
)
Thank you so much.
And how to hide the “Check Virtable” (name of the virtual column) ?
In Display name i’ve inserted = " ", but - it’s odd - also the description “To assign” disappear …
Very last, please: no way to remove the tooltip from color type, isn’t it ?
Yes, unfortunately no way to delete tooltip.
I have suggested it to be a Show type virtual column. Please have a letter such as B etc in its app formula as well or else it will not let save.
Ehm sorry i don’t understand, where i’ve to insert letter ?
I’d like not to show the column virtual name “Check descrizione”
Please insert the letter or any simple digit in app formula because the app formula needs to be non blank for virtual columns.
Please insert the expression in "Content’ setting. I have mentioned all this earlier.
Thanks for your invaluable help.
Just to better understand, what if i choose Text Type instead of Show Type ?
Using Text Type seems to solve as well what i’m missing ?
Thanks, again
You are welcome.
If you are using virtual column, then there is really not much difference except that show columns by design do not show column heading in displays , so one does not have additional headache of configuring display name of the column to blank(“”) etc.
In case of real column, the text column will store the values in the backend table, Show columns as their name suggests, only “show” the text values, URLs, images in the apps . They do not repetitively store those values in the backend table.
