Hi everyone! I have a column type EnumList (named "Demanda") that show several options (70+). For that reason, I use numbers before the "request", that works like codes, as follow:
01 - Request A
02 - Request B
I just want to see this "code" in the Form_view. So, I create a virtual colunm (named Extracted_Demanda) with the following formula:
After that, I insert on Detail_view only the column Extracted_Demanda that shows only the text (e.g. Request A).
The problem is: If I select more than one option in the column Demanda (EnumList), the results in the virtual column Extracted_Demanda will be present as follow:
As you can see, only the first part was converted to the formula MID.
User | Count |
---|---|
16 | |
7 | |
6 | |
5 | |
3 |