Hi all,
I have an enum field with 3 values from a table e.g.
- red
- green
- blue, yellow
The list is shown as 4 values:
- red
- green
- blue
- yellow
what can I do, that “blue, yellow” is shown as one value?
Thanks, Joachim
Instead of hard coding as “blue, yellow” as option for enum, try “blue or yellow”.
2 Likes
Thank you @Koichi_Tsuji , but I am not the one who is writing this table.
The colors are a simplified example, the text is in reality (see below) and I cannot instruct the people to not use comma in the column 
Hinweisschilder zu Straßeneinbauten Amaturen- oder Schieberschilder -bunte Schilder an Hauswänden oder Pfosten mit Strichen**,** Zahlen und Buchstaben
What expression are you using to generate the list? It looks to me you are not hard-coding those optional values.
1 Like
yes @Koichi_Tsuji the values are coming from a table (ROUTING) as I wrote above:
UNIQUE(ROUTING[Unterkategorie])
[Unterkategorie] column is text type I assume.
1 Like
[Unterkategorie] is an enum, I tried text instead with the same result
Unfortunately, I m not able to repro your problem… Based on my config s(to mirror your tables definitions), it is working as I expect.
3 Likes
Thank you very much, the selection list had a complex formula, which hat a unnecessary “split”.
Your suggestion, that it should work guided me to dive deeper into the formula.
Thank you @Koichi_Tsuji for your time, perfect help and patience
2 Likes