Hi all,
My apps have a EnumList column which values like this (3rd value):
I use the default delimiter.
I have a Enum column of text which have to use the split list as the suggestions for the Enum column. So I put this expression in suggested value:
split(
index(
select(ๅ
ฌๅธ[ๅฐ้ป], [ๅ
ฌๅธ] = [_THISROW].[ๅ
ฌๅธ]),
1
),
" , "
) + ๅฐ้ป[ๅฐ้ป]
However, the final result is that the list becomes one concatenated values instead. Am I doing something wrong?
Dart
Final result becomes:
If I understand correctly:
this field is an enumlist, correct?
And youโre wanting to pull in all the items entered into that column
right?
But when you do, all you get is a single large button of all the options concatenated together, yes?
Try the following:
SPLIT(select(ๅ
ฌๅธ[ๅฐ้ป], [ๅ
ฌๅธ] = [_THISROW].[ๅ
ฌๅธ]), ",")
+
ๅฐ้ป[ๅฐ้ป]
Yes, exactly!
Let me try, but I wonder if select() return a list of values?
Update:
It works.
At first I used " , " to split the value of enum list since I saw the values are separated by those 3 characters. But than I follow your suggestion to use โ,โ instead and make it.
Thanks a lot!
AppSheet is really good at trimming extra spaces off things intelligently; they know what weโre generally trying to do, and make it happen for us. Thatโs one of the reasons why I love the platform so much, itโs soooo intuitive on things that people are completely unaware of.
User | Count |
---|---|
34 | |
31 | |
30 | |
18 | |
17 |